Home

All courses

Master SQL For Data Science

Business

Business Analytics & Intelligence

SQL

Master SQL For Data Science

Become a SQL query wizard and never be afraid to look at a large SQL query again!

4.6

(15117)

63051 enrolled on this course

Last updated 11/2021

Job Ready Programmer

₹ 3999.0

₹ 5499.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

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 u
nderstand 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

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

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Database Basics

1.1-Course Overview

1.2-What is a Database

1.3-How to Proceed in this Course

1.4-Dedicated TA Support

1.5-Join our Online Community (Discord)

1.6-Install Postgres Database on Mac

1.7-Troubleshoot Connection

1.8-Install Postgres on Windows

1.9-Create Table and Insert Statements

1.10-Data file that will be used in the course (IMPORTANT)

1.11-Prepare the Database

1.12-Assignment 1: Create More Tables and Populate Data

2-SQL Query Basics

2.1-Introducing the SELECT Statement

2.2-Filter Data Using the WHERE Clause + AND & OR

2.3-Filtering Operators - IN, NOT IN, IS NULL, BETWEEN

2.4-[EXERCISES]: WHERE Clause and Operators

2.5-ORDER BY, LIMIT, DISTINCT and Renaming Columns

2.6-Assignment 2: Practice Writing Basic Queries (5 Problems)

3-Using Functions

3.1-UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation

3.2-Career Advice

3.3-String Functions: SUBSTRING(), REPLACE(), POSITION() and COALESCE()

3.4-Grouping Functions: MIN(), MAX(), AVG(), SUM(), COUNT()

3.5-Assignment 3: Practice with Functions, Conditional Expressions and Concatenation

4-Grouping Data and Computing Aggregates

4.1-Understanding Grouping

4.2-GROUP BY & HAVING Clauses

4.3-[EXERCISES]: Using GROUP BY and HAVING Clauses

4.4-Assignment 4: Practice Aggregation Queries

5-Using Subqueries

5.1-Aliasing Sources of Data

5.2-Introducing Subqueries

5.3-Subqueries Continued + [EXERCISES]

5.4-Subqueries with ANY and ALL Operators + [EXERCISES]

5.5-[EXERCISES]: More Practice with Subqueries

5.6-Assignment 5: Practice with Subqueries

6-Using the CASE Clause in Interesting Ways

6.1-Conditional Expressions Using CASE Clause + [EXERCISES]

6.2-Transposing Data using the CASE Clause + [EXERCISES]

6.3-Assignment 6: Practice Using Case and Transposing Data

7-Advanced Query Techniques using Correlated Subqueries

7.1-Understanding Correlated Subqueries

7.2-[EXERCISES]: Correlated Subqueries Continued

8-Working with Multiple Tables

8.1-Introducing Table Joins

8.2-INNER and OUTER Joins + [EXERCISES]

8.3-Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES]

8.4-Cartesian Product with the CROSS JOIN

8.5-[EXERCISES]: Joins and Subqueries Continued

8.6-Creating Views vs. Inline Views

8.7-Assignment 7: ADVANCED Problems using Joins, Grouping and Subqueries

9-Window Functions for Analytics

9.1-Window Functions using the OVER() Clause

9.2-Ordering Data in Window Frames

9.3-RANK, FIRST_VALUE and NTILE Functions

9.4-Working with LEAD and LAG Functions

9.5-Working with Rollups and Cubes

10-Difficult Query Challenges

10.1-Challenging Puzzles For the Brave

11-Course Extras!

11.1-Bonus Lecture

Course Categories

Popular Courses

Master SQL For Data Science

Description

What you'll learn

Requirements

Course Content

You May Like