Get started with custom lists to organize and share courses.

Sign up

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

SQL for Data Analysis

via Udacity

1 Review 2179 students interested

Taken this course? Share your experience with other students. Write review

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.



Why Take This Course?

SQL is the most commonly used data analysis tool for data analysts and data scientists. The majority of the world’s data is stored in databases, and learning SQL will enable you to access and analyze this data with ease. SQL is a valuable tool for a wide array of roles across diverse industries—digital marketers, engineers, product managers, and more, use SQL every day. The ability to do important data work yourself with SQL enhances the value you'll bring to any organization.

Syllabus

Lesson 1: SQL Basics




  • Learn to write common SQL commands including SELECT, FROM, and WHERE

  • Learn to use logical operators in SQL
    ## Lesson 2: SQL Joins

  • Learn to write INNER JOINs to combine data from multiple tables

  • Learn to write LEFT JOINs to combine data from multiple tables
    ## Lesson 3: 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
    ## Lesson 4: 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
    ## Lesson 5: SQL Data Cleaning

  • Learn how to perform data cleaning using SQL
    ## Lesson 6: Window Functions

  • Learn to use window functions to tackle more analysis tasks
    ## Lesson 7: Advanced Joins and Performance Tuning

  • Learn to use advanced joins

  • Learn to write queries that run quickly across giant datasets

Taught by

Derek Steer

Help Center

Most commonly asked questions about Udacity Udacity

Review for Udacity's SQL for Data Analysis
5.0 Based on 1 reviews

  • 5 star 100%
  • 4 star 0%
  • 3 star 0%
  • 2 star 0%
  • 1 star 0%

Did you take this course? Share your experience with other students.

Write a review
  • 1
Zoltan I
5.0 11 months ago
Zoltan completed this course, spending 3 hours a week on it and found the course difficulty to be easy.
The system is fully customizable: I can manage my data the way I want to and modify the application any time I need to reflect each and every detail important in my business. The data analyse provides unlimited records, unlimited storage, unlimited support, stable rates.
Was this review helpful to you? Yes
  • 1

Class Central

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.