About this Course

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.

Course Cost
Free
Timeline
Approx. 4 weeks
Skill Level
Beginner
Included in Course
  • Rich Learning Content

  • Interactive Quizzes

  • Taught by Industry Pros

  • Self-Paced Learning

  • Student Support Community

Join the Path to Greatness

This free course is your first step towards a new career with the Data Analyst Nanodegree Program.

Free Course

SQL for Data Analyst

by Mode

Enhance your skill set and boost your hirability through innovative, independent learning.

Icon steps

Course Leads

  • Derek Steer
    Derek Steer

    Instructor

What You Will Learn

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

Prerequisites and Requirements

Students should have general familiarity working with data in spreadsheets.

See the Technology Requirements for using Udacity.

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.

What do I get?
  • Instructor videos
  • Learn by doing exercises
  • Taught by industry professionals
Icon globe

Udacity 现已提供中文版本! A Udacity tem uma página em português para você! There's a local version of Udacity for you! Sprechen Sie Deutsch?

Besuchen Sie de.udacity.com und entdecken Sie lokale Angebote, unsere Partnerunternehmen und Udacitys deutschsprachigen Blog.

前往优达学城中文网站 Ir para a página brasileira Go to Indian Site Icon flag de Zu de.udacity.com continue in English