Master SQL For Data Science
4.6 (5,903 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24,316 students enrolled

Master SQL For Data Science

Become a SQL query wizard and never be afraid to look at a large SQL query again!
4.6 (5,903 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24,316 students enrolled
Created by Imtiaz Ahmad
Last updated 8/2019
English
English [Auto], Indonesian [Auto], 3 more
  • Polish [Auto]
  • Romanian [Auto]
  • Thai [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9 hours on-demand video
  • 3 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Write complex SQL statements to query the database and gain critical insight on data
  • Practice Every Step of the Way by Working Through 100+ Puzzles (with solutions)
  • Transition from the Very Basics to a Point Where You can Effortlessly Work with Large SQL Queries
  • Learn Advanced Querying Techniques
  • Become a Master SQL Developer
Requirements
  • No prerequisites needed for this course
Description

LAST UPDATED: JAN 2020

This course will turn you into a SQL query wizard. You'll learn the skills you need to extract critical insight from data sitting in a database. There are over 100 puzzles scattered throughout the course with in-depth solutions providing plenty of opportunity for you to practice. After completing the course and all of it's assignments, I promise you, you'll never be afraid to look at a large SQL query again. 

Just like my other courses, I follow the no-student-left behind principle; which means that I start from the very basics. You do not need any prerequisites to take this course. We move step by step into more advanced topics as we delve into the world of advanced querying techniques using subqueries, aggregations, joins, rollups and cubes, window functions, transposing & ranking data and using conditional expressions in very interesting ways. 


With over 17,000 students and a 4.6 rating, you won't find a better source to learn SQL for Data Science elsewhere.

Don’t just take it from me, take it from other students that have taken this course.


★★★★★ Here’s reviews from real students that took this course ★★★★★


★★★★★ You really can't beat this course for the value. The instructor is excellent (clear explanations, easy to understand, extremely knowledgeable), and his style of constantly requiring the student to apply what they've just learned with practice queries proves to be a very effective method of learning. He covers an amazing amount of ground in just 9 hours. It was just the refresher course I needed after not having done much SQL in the past year.


★★★★★ Just one word - Exceptional!! Don't give a second thought, just go for it. Thanks a lot Mr.Imtiaz Ahmad. The way concepts are explained in the lectures are quite good. The assignments gave me so much confidence and I feel so happy that I am quite well versed in SQL now. Watch the videos, try out the assignments on your own and practice as much as you can with different problems.


★★★★★ It's a brilliant course that can help to understand SQL from easy concepts to difficult tasks. Besides, the explanations are always clear, so they let me learn a lot without searching for additional information in Internet. The course contains lots of practical tasks that allowed me not only to understand queries, but to also use them correctly.


★★★★★ Great! I really like the exercises that are included. They are essential to learning the course content.


★★★★★ After attending the course and doing most of the exercises, I feel very confident in SQL world. The course is designed well and every lesson gives you good amount of knowledge. Explanation and exercises are worth learning and practicing.



Topics covered in this course:

  • What is a Database

  • Installing Postgres

  • Creating Tables

  • SELECT Statement

  • WHERE Clause

  • AND & OR

  • Filtering Operators

  • ORDER BY

  • LIMIT

  • DISTINCT

  • Renaming Columns

  • Functions

  • GROUP BY & HAVING Clauses

  • Aggregation Queries

  • Subqueries

  • CASE Clause

  • Correlated Subqueries

  • Table Joins

  • INNER and OUTER Joins

  • UNION, UNION ALL and EXCEPT Clauses

  • Window Functions for Analytics

  • + over 100 puzzles distributed throughout the course


Enroll today to become a Master SQL Data Science Developer. As always, I offer a 30 day money back guarantee if you're not satisfied, but you won't need it.

Who this course is for:
  • Anyone who wants to break into the data analyst or data scientist role
  • Anyone interested in become a SQL query wizard
Course content
Expand all 40 lectures 09:01:03
+ Database Basics
7 lectures 01:01:54
What is a Database
10:03
Install Postgres Database on Mac
07:24
Troubleshoot Connection
00:40
Install Postgres on Windows
07:22
Create Table and Insert Statements
21:57
Data file that will be used in the course (IMPORTANT)
00:10
Prepare the Database
14:18
In this assignment, you'll be preparing the data needed for the many puzzles that follow in this course. This is an important assignment so do not skip it!
Create More Tables and Populate Data
4 questions
+ SQL Query Basics
5 lectures 01:20:09
Filter Data Using the WHERE Clause + AND & OR
23:33
[EXERCISES]: WHERE Clause and Operators
11:35
Using ORDER BY, LIMIT, DISTINCT and Renaming Columns
11:54
In this assignment, you'll get practice writing basic SQL queries involving just a single table. Recall the students table you created in assignment 1. You'll be querying against that table to solve the problems that follow.
Practice Writing Basic Queries (5 Problems)
6 questions
+ Using Functions
3 lectures 42:24
UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation
15:56
String Functions: SUBSTRING(), REPLACE(), POSITION() and COALESCE()
16:08
Grouping Functions: MIN(), MAX(), AVG(), SUM(), COUNT()
10:20
In this assignment you'll get practice writing queries with functions. Recall the tables you created in assignment 1. Those tables will be involved to solve the problems that follow.
Practice with Functions, Conditional Expressions and Concatenation
5 questions
+ Grouping Data and Computing Aggregates
3 lectures 40:17
Understanding Grouping
06:28
GROUP BY & HAVING Clauses
17:22
[EXERCISES]: Using GROUP BY and HAVING Clauses
16:27
Take your time with this assignment. Some questions are meant to be challenging. For this assignment you'll first need to execute a script to load data into a table called fruit_imports. Then you'll have to complete a variety of aggregation query puzzles and get insight into the data.
Practice Aggregation Queries
6 questions
+ Using Subqueries
5 lectures 01:14:12
Aliasing Sources of Data
06:20
Introducing Subqueries
14:09
Subqueries Continued + [EXERCISES]
18:34
Subqueries with ANY and ALL Operators + [EXERCISES]
19:40
[EXERCISES]: More Practice with Subqueries
15:29
The puzzles in this assignment will involve the tables you prepared in assignment 1. You'll be using subqueries to retrieve information to solve the problems in this assignment.
Practice with Subqueries
5 questions
+ Using the CASE Clause in Interesting Ways
2 lectures 38:40
Conditional Expressions Using CASE Clause + [EXERCISES]
20:53
Transposing Data using the CASE Clause + [EXERCISES]
17:47
This assignment involves using the table you created in Assignment 4. We'll be getting practice using the CASE statement in interesting ways and transposing data.
Practice Using Case and Transposing Data
2 questions
+ Advanced Query Techniques using Correlated Subqueries
2 lectures 37:23
Understanding Correlated Subqueries
21:16
[EXERCISES]: Correlated Subqueries Continued
16:07
+ Working with Multiple Tables
6 lectures 01:29:44
Introducing Table Joins
16:29
INNER and OUTER Joins + [EXERCISES]
25:43
Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES]
14:22
Cartesian Product with the CROSS JOIN
07:04
[EXERCISES]: Joins and Subqueries Continued
17:27
Creating Views vs. Inline Views
08:39
The problems in this assignment section get even more challenging. You'll acquire practice using Joins and working with subqueries. You will also be tested on your knowledge of correlated subqueries. Take as long as you need to work through this section.
ADVANCED Problems using Joins, Grouping and Subqueries
7 questions
+ Window Functions for Analytics
5 lectures 01:11:12
Window Functions using the OVER() Clause
18:32
Ordering Data in Window Frames
21:17
RANK, FIRST_VALUE and NTILE Functions
12:00
LEAD and LAG Functions
07:42
Working with Rollups and Cubes
11:41