Home

All courses

15 Days of SQL: The Complete SQL Masterclass 2024

Business

Business Analytics & Intelligence

SQL

15 Days of SQL: The Complete SQL Masterclass 2024

Master SQL in just 15 days from Basics to Pro by working daily on real-life projects

4.7

(15005)

90592 enrolled on this course

Last updated 11/2021

Nikolai Schuler

₹ 3499.0

₹ 4999.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

Learn SQL with the world’s best SQL course in just 15 days!
1 hour per day, for just 15 days and you will be fluent in SQL!
That’s the only course you need to completely master SQL.
You will be guided step-by-step from beginner to absolute expert in SQL.
Why is this the best course you can take?
The most comprehensive course
that teaches you everthing from beginner to expert
Much more challenges
& hands-on coding exercises than other courses
Much more real-life advanced topics
that other courses don’t cover
By the end of this guided experience you will be
so fluent in SQL to

get a job and work professionally
and with a lot of confidence with SQL!
This is the
most comprehensive & most modern course
you can find on SQL.
Here is why:
Most comprehenisve course
with 14 hours video lectures and most topics
Master SQL by working on
real-life challenges
Learn PostgreSQL – the
most modern SQL system
& easy to transfer to all other SQL dialects
We will set up two modern databases and learn everything with realistic data, so you can do everything hands-on!
Learn from a real expert - crystal clear & straight-forward
Understand everything step by step from the absolute basics to the advanced topics
Learn the practical to upskill your career or find a job with SQL
We cover every single important topic you will need including the advanced topics other courses do not cover!
Including...
GROUP BY
JOINs
Functions
UNIONs
Data manipulation & Data Definition
Views
Window functions
Grouping sets
Rollups
Transactions
Subqueries
Query optimization
Indexes and much more!
Plus, tons of practical challenges and
2 complete course projects
and much more challenges than you can find anywhere else!
This course will take you all the way from beginner to being able to
upskill your career and make you ready to get a job with SQL!
Check out the free video previews and enroll now!
See you inside the course!
Who this course is for:
Anyone interested in SQL or PostgreSQL
Anyone that is interested in data analysis, data science and data analytics
Anyone that wants to improve their IT skills in any profession

What you'll learn

Become an SQL Expert in Just 15 Days!

Master SQL with real-life challenges and projects!

Work with 2 complex real-world databases for real skills

Achieve Expertise in SQL in structured & hands-on way

Write complex and advanced SQL queries

Create & manage your own databases

Master joins, group by, advanced functions & conditional expressions

Master stored procedures, grouping sets, transactions, indexes and much more!

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-Day 1 - Getting started with SQL!

1.1-Welcome!

1.2-How to get the most out of the course

1.3-How this course works

1.4-Why learning SQL?

1.5-Let the Joruney Begin!

1.6-Let's get started!

1.7-What is a database?

1.8-Databases

1.9-Different dialects of SQL

1.10-Dialects of SQL

1.11-Installing PostgreSQL & pgAdmin (Windows)

1.12-Common problems: Set binary paths

1.13-Installing PostgreSQL & pgAdmin (MacOS)

1.14-Setting up the database

1.15-Common problems: Slow performance

1.16-The Project

1.17-SELECT

1.18-SELECT

1.19-Challenge: SELECT

1.20-Solution: SELECT

1.21-ORDER BY

1.22-SELECT & ORDER BY

1.23-Challenge: ORDER BY

1.24-Solution: ORDER BY

1.25-SELECT DISTINCT

1.26-Challenge: SELECT DISTINCT

1.27-Solution: SELECT DISTINCT

1.28-LIMIT

1.29-SELECT DISTINCT & LIMIT

1.30-COUNT()

1.31-COUNT()

1.32-Today's challenges

1.33-Today's summary

2-Day 2 - Basics: Filtering

2.1-WHERE

2.2-WHERE

2.3-Challenge: WHERE

2.4-Solution: WHERE

2.5-WHERE operators

2.6-WHERE operators

2.7-Challenge: WHERE operators

2.8-Solution: WHERE operators

2.9-WHERE with AND/OR

2.10-WHERE with AND/OR

2.11-Challenge: WHERE with AND/OR

2.12-Solution: WHERE with AND/OR

2.13-Quick note on time zones

2.14-BETWEEN

2.15-BETWEEN

2.16-Challenge: BETWEEN

2.17-Solution: BETWEEN

2.18-IN

2.19-IN operator

2.20-Challenge: IN

2.21-Solution: IN

2.22-LIKE

2.23-LIKE

2.24-Challenge: LIKE

2.25-Solution: LIKE

2.26-Comments & Aliases

2.27-Today's summary

2.28-Today's challenges

3-Day 3 - Basics: Grouping

3.1-Today's plan

3.2-Aggregate functions

3.3-Aggregate functions

3.4-Challenge: Aggregate function

3.5-GROUP BY

3.6-GROUP BY

3.7-Challenge: GROUP BY

3.8-Solution: GROUP BY

3.9-GROUP BY multiple columns

3.10-GROUP BY multiple columns

3.11-Challenge: GROUP BY multiple columns

3.12-Solution: GROUP BY multiple columns

3.13-HAVING

3.14-HAVING

3.15-Challenge: HAVING

3.16-Solution: HAVING

3.17-Introducing the second project

3.18-Note for Mac users

3.19-Important: Problems & solutions of setting up the database

3.20-Today's summary

4-Day 4 - Intermediate: Functions

4.1-Today's plan

4.2-LENGTH, LOWER & UPPER

4.3-LENGTH, LOWER & UPPER

4.4-Challenge: LENGTH, LOWER & UPPER

4.5-Solution: LENGTH, LOWER & UPPER

4.6-LEFT & RIGHT

4.7-Challenge: LEFT & RIGHT

4.8-Solution: LEFT & RIGHT

4.9-Concatenate

4.10-Concatenate

4.11-Challenge: Concatenate

4.12-Solution: Concatenate

4.13-POSITION

4.14-Challenge: POSITION

4.15-Solution: POSITION

4.16-SUBSTRING

4.17-Challenge: SUBSTRING

4.18-Solution: SUBSTRING

4.19-EXTRACT

4.20-Challenge: EXTRACT

4.21-Solution: EXTRACT

4.22-TO_CHAR

4.23-Challenge: TO_CHAR

4.24-Solution: TO_CHAR

4.25-Intervals & Timestamps

4.26-Challenge: Intervals & Timestamps

4.27-Solution: Intervals & Timestamps

4.28-Today's slides

5-Day 5 - Intermediate: Conditional Expressions

5.1-Mathematical functions and operators

5.2-Mathematical functions and operators

5.3-Challenge: Mathematical functions and operators

5.4-Solution: Mathematical functions and operators

5.5-CASE WHEN - Theory

5.6-CASE WHEN - Hands-on

5.7-CASE WHEN

5.8-3 Challenge: CASE WHEN

5.9-Solutions

5.10-Solution: CASE WHEN

5.11-CASE WHEN & SUM

5.12-CASE WHEN & SUM

5.13-COALESCE

5.14-COALESCE

5.15-CAST

5.16-Challenge: CAST & COALESCE

5.17-Solution: CAST & COALESCE

5.18-REPLACE

5.19-Today's slides

6-Day 6 - Intermediate: Joins

6.1-What are joins?

6.2-INNER JOIN - Theory

6.3-INNER JOIN - Practice

6.4-Challenge: INNER JOIN

6.5-Solution: INNER JOIN

6.6-FULL OUTER JOIN

6.7-JOIN & WHERE

6.8-LEFT OUTER JOIN

6.9-Challenge: LEFT OUTER JOIN

6.10-Solution: LEFT OUTER JOIN

6.11-RIGHT OUTER JOIN

6.12-Challenge: Joins

6.13-Solution: Joins

6.14-Joins on multiple conditions

6.15-Solution: Joins on multiple conditions

6.16-Joining multiple tables

6.17-Joining multiple tables - Practice

6.18-Challenge: Joining multiple tables

6.19-Solution: Joining multiple tables

6.20-More challenges

6.21-Solutions

6.22-Today's slides

7-Day 7 - Advanced: UNION & Subqueries

7.1-UNION

7.2-UNION - Practice

7.3-Subqueries in WHERE

7.4-Challenge: Subqueries in WHERE

7.5-Solution: Subqueries in WHERE

7.6-More challenges: Subqueries in WHERE

7.7-Solution: More challenges

7.8-Subqueries in FROM

7.9-Challenge: Subqueries in FROM

7.10-Solution: Subqueries in FROM

7.11-Subqueries in SELECT

7.12-Challenge: Subqueries in SELECT

7.13-Solution: Subqueries in SELECT

7.14-Correlated Subqueries in WHERE

7.15-Challenge: Correlated subqueries in WHERE

7.16-Solution: Correlated subqueries in WHERE

7.17-Correlated Subquery in SELECT

7.18-More challenges: Correlated subqueres

7.19-Solution: More challenges

7.20-Today's slides

8-Day 8 - Advanced: Course project

8.1-Project Introduction

8.2-Challenges

8.3-Solutions

8.4-Solution 1

8.5-Solution 2

8.6-Solution 3

8.7-Solution 4

8.8-Solution 5

8.9-Solution 6

8.10-Solution 7

8.11-Solution 8

8.12-Solution 9

8.13-Solution 10

8.14-Solution 11

8.15-Solution 12

8.16-Solution 13

8.17-Solution 14

9-Day 9 - Advanced: Managing tables & databases

9.1-Managing databases & tables

9.2-CREATE DATABASE

9.3-CREATE & DROP DATABASE

9.4-Data Types

9.5-Data Types

9.6-Constraints

9.7-Constraints

9.8-Primary Key & Foreign Key

9.9-Primary & Foreign Key

9.10-CREATE TABLE

9.11-CREATE TABLE

9.12-INSERT

9.13-INSERT

9.14-ALTER TABLE

9.15-Challenge: ALTER TABLE

9.16-Solution: ALTER TABLE

9.17-TRUNCATE & DROP TABLE

9.18-CHECK

9.19-Challenge: CHECK

9.20-Solution: CHECK

9.21-Today's slides

10-Day 10 - Advanced: Views & Data Manipulation

10.1-UPDATE

10.2-Challenge: UPDATE

10.3-Solution: UPDATE

10.4-DELETE

10.5-Challenge: DELETE

10.6-Solution: DELETE

10.7-CREATE TABLE AS

10.8-Challenge: CREATE TABLE AS

10.9-Solution: CREATE TABLE AS

10.10-CREATE VIEW

10.11-Challenge: CREATE VIEW

10.12-Solution: CREATE VIEW

10.13-CREATE MATERIALIZED VIEW

10.14-Managing views

10.15-Challenge: Managing views

10.16-Solution: Managing views

10.17-Import & Export

10.18-Today's slides

11-Day 11 - Pro: Window Functions

11.1-OVER() with PARTITION BY

11.2-Challenge: OVER() with PARTITION BY

11.3-Solution: OVER() with PARTITION BY

11.4-OVER() with ORDER BY

11.5-Challenge: OVER() with ORDER BY

11.6-Solution: OVER() with ORDER BY

11.7-RANK()

11.8-Challenge: RANK()

11.9-Solution: RANK()

11.10-FIRST_VALUE()

11.11-LEAD & LAG

11.12-Challenge: LEAD & LAG

11.13-Solution: LEAD & LAG

11.14-Today's slides

12-Day 12 - Pro: Grouping sets, rollups, self-joins

12.1-GROUPING SETS

12.2-Challenge: GROUPING SETS

12.3-Solution: GROUPING SETS

12.4-Additional challenge

12.5-Solution: Additional Challenge

12.6-ROLLUP

12.7-Challenge: ROLLUP

12.8-Solution: ROLLUP

12.9-CUBE

12.10-Challenge: CUBE

12.11-Solution: CUBE

12.12-Self joins

12.13-Challenge: Self joins

12.14-Solution: Self joins

12.15-CROSS JOIN

12.16-NATURAL JOIN

12.17-Today's slides

13-Day 13 - Pro: Course project

13.1-Project introduction

13.2-The challenges

13.3-Solutions

14-Day 14 - Pro: Stored procedures, transactions & user-defined functions

14.1-User-defined functions

14.2-User-defined functions - Example

14.3-Challenge: User-defined functions

14.4-Solution

14.5-Transactions

14.6-Challenge: Transactions

14.7-Solution: Transactions

14.8-Rollbacks

14.9-Stored procedures

14.10-Challenge: Stored procedures

14.11-Solution: Stored procedure

14.12-Today's slides

15-Day 15 - Pro: Indexes, Partitining & Query Optimization

15.1-User management

15.2-CREATE USER

ROLE;15.3-GRANT & REVOKE privileges;15.4-Privileges - Hands-on;15.5-Challenge: Privileges;15.6-Solution: Privileges;15.7-What are indexes?;15.8-B-Tree index;15.9-Bitmap index;15.10-Indexes - Guidelines;15.11-Creating indexes;15.12-Creating indexes;15.13-Execution plan & query performance;15.14-Today's slides

16-Extra Day: CTEs (Common Table Expressions)

16.1-Why an extra day?;16.2-Common Table Expressions (CTEs) - First Example;16.3-Common Table Expressions - More Complex Example;16.4-Challenge 1: Create a simple CTE;16.5-Solution 1: Create a simple CTE;16.6-Common Table Expressions - Using Multiple CTEs;16.7-Challenge 2: Using Multiple CTEs;16.8-Solution 2: Using Multiple CTEs;16.9-Recursive CTEs - Concept;16.10-Recursive CTEs - Hierarchical Data;16.11-Recursive CTEs - Termination Condition;16.12-Challenge 3: Recursive CTE;16.13-Solution 3: Recursive CTE

17-Bonus

17.1-Bonus

Course Categories

Popular Courses

15 Days of SQL: The Complete SQL Masterclass 2024

Description

What you'll learn

Requirements

Course Content

You May Like