Search
Cancel
Sign In

SQL for Data Analysis

Go to class
Write Review

Free Online Course: SQL for Data Analysis provided by Udacity is a comprehensive online course, which lasts for 4 weeks long. The course is taught in English and is free of charge. SQL for Data Analysis is taught by Derek Steer.

via Udacity
4 weeks long
Self Paced
Overview

  • In this course, you’ll learn to use Structured Query Language (SQL) to extract and analyze data stored in databases. You’ll first learn to extract data, join tables together, and perform aggregations. Then you’ll learn to do more complex analysis and manipulations using subqueries, temp tables, and window functions. By the end of the course, you’ll be able to write efficient SQL queries to successfully handle a variety of data analysis tasks.

Syllabus

    • SQL Basics
      • Learn to write common SQL commands including SELECT, FROM, and WHERE,Learn to use logical operators in SQL
    • SQL Joins
      • Learn to write INNER JOINs to combine data from multiple tables,Learn to write LEFT JOINs to combine data from multiple tables
    • SQL Aggregations
      • Learn to write common aggregations in SQL including COUNT, SUM, MIN, and MAX,Learn to write CASE and DATE functions, as well as work with NULL values
    • Subqueries and Temp Tables
      • Learn to write subqueries to run multiple queries together,Learn to use temp tables to access a table with more than one query
    • SQL Data Cleaning
      • Learn how to perform data cleaning using SQL
    • Window Functions
      • Learn to use window functions to tackle more analysis tasks

← Prev Next →
4.8, based on 5 Course votes at GetYourEducation

Start your review of SQL for Data Analysis

Add review ->
Related courses by Rating

ANIMATIONs

Provider: Swayam
Language: English

A Circular Economy of Metals: Towards a Sustainable Societal Metabolism

Provider: Coursera
Language: English

A Life of Happiness and Fulfillment

Provider: Coursera
Language: English

Academic Writing

Provider: Swayam
Language: English

Academic Writing Made Easy

Provider: edX
Language: English

ADHD: Everyday Strategies for Elementary Students

Provider: Coursera
Language: English
Related courses by Level

3D Wooden Textiles for Beginners

Beginner
Provider: Domestika
Language: English

Digital Brand Strategy: Elevate The User Experience

Beginner
Provider: Domestika
Language: English

Flavorful Food Illustration with Watercolor

Beginner
Provider: Domestika
Language: English

FPGA computing systems: Background knowledge and introductory materials

Beginner
Provider: Coursera
Language: English

Freehand Sketching with Acrylic and Watercolor

Beginner
Provider: Domestika
Language: English

Fundamentals of the Chinese character writing. Part 2

Beginner
Provider: Coursera
Language: English
Browse by subject
Browse by provider
Browse by university
Browse by institution
College Rankings