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

Udacity

SQL for Data Analysis

via Udacity

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

Taught by

Derek Steer

Reviews

4.6 rating, based on 5 Class Central reviews

Start your review of SQL for Data Analysis

  • Data Analysis is the most method used by engineers to determine most engineering analysis. From this course, i have read and understand different skills that are used in data analysis.
  • Jon Ingram
    This is a very well put together introduction to SQL, using one consistent toy data example throughout (the database of orders and accounts for a fictional paper company). New features of SQL are introduced at a sensible pace, and there are frequen…
  • Hi I just completed this course and found it to be very relevant in my line of work. I would however like to know if there is a free certificate for course completion.
  • its a nice way to gain knowledge and expertise .What I like most about MySQL is it provides a clean and easy interface, easy to creates schema and can draw entity relationship diagrams. We can import and export all the queries in an easy manner. I like the integrity of MySQL on mutliple popular IDE's like Springboot, Eclipse, and many more. It also provides the features of backup and restore the data and database.
  • Anonymous
    Awesome. Concise and geared directly towards my learning needs. Would recommend this course to anyone any day. Thanks Derek; Thanks Udacity

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.