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.
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
Jon Ingram is taking this course right now, spending 10 hours a week on it and found the course difficulty to be medium.
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 frequent...
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 frequent quizzes which ask you to create your own queries to interact with the database.
Unlike some other online courses, I didn't feel at any point that I was being left to go read all the online documentation for something on my own, as it wasn't explained properly. Neither did I feel that I was only being asked to construct trivial queries that wouldn't actually develop my understanding.
Here's an example problem set, from the GROUP BY section of the third chapter:
1. For each account, determine the average amount of each type of paper they purchased across their orders. Your result should have four columns - one for the account name and one for the average quantity purchased for each of the paper types for each account.
2. For each account, determine the average amount spent per order on each paper type. Your result should have four columns - one for the account name and one for the average amount spent on each paper type.
3. Determine the number of times a particular channel was used in the web_events table for each sales rep. Your final table should have three columns - the name of the sales rep, the channel, and the number of occurrences. Order your table with the highest number of occurrences first.
4. Determine the number of times a particular channel was used in the web_events table for each region. Your final table should have three columns - the region name, the channel, and the number of occurrences. Order your table with the highest number of occurrences first.
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.
Zoltan Illes 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.
Awesome. Concise and geared directly towards my learning needs. Would recommend this course to anyone any day. Thanks Derek; Thanks Udacity