Master SQL: Unlock the Power of Databases

About Course

Structured Query Language (SQL) is the cornerstone of data management and analysis. Whether you’re analyzing trends, building applications, or managing data pipelines, SQL is a must-have skill. This course is designed to take you from the basics of SQL to advanced techniques, making you proficient in handling complex data operations.

Learn how to write efficient queries, design and manage databases, and build custom functions. From understanding the fundamentals to mastering advanced concepts like views, procedures, and joins, this course has everything you need to succeed in today’s data-driven world.

Course Content

SQL Theory

SQL Intro

03:53
Database Introduction

02:56
SQL Syntax

02:01
SQL Object

01:20
DDL Introduction

01:04

DDL Theory

TCL Theory

DML

DCL

Database Terminologies

Creating Database

Data Type

Constraints

Constraints Intro

01:18
Auto Increment

00:52
Primary Key

05:01
Foreign Key

08:19
Foreign Key on Delete Cascade

05:22
Unique Key

03:32
Index in Unique Key

01:06
Default Constraint

02:43
Not Null Constraint

02:20
Drop Primary & Foreign Key

02:58
Drop Unique Key

00:49
Using Database

03:31

SQL Best Practice

Sales DDL Exercise

Employees Database

DDL

Select Intro

01:59
Where conditions

01:36
Where Exercise

00:16
Where Solution

00:28
Multiple Filter Operator

00:38
And Clause

01:24
Or Clause

02:47
Operator Precedence

09:47
Operator Precedence Exercise

00:12
Operator Precedence Solution

01:07
In Filter

02:22
Not in

00:49
In Solution

00:41
Like Not Like

03:32
Between Not Between

02:31
Is Null Not Null

01:21
Other Comparison Operators

02:42
Select Exercise

00:23
Select Solution

01:12
Select Distinct

01:26

Aggregate Functions

Intro to Aggregate Functions

00:53
Count()

03:09
Count Distinct

03:20
Count Exercise

00:30
Count Exercise Solution

02:13
Group by

04:48
Alias

00:41
Order by

02:35
Having

01:12
Where vs Having

07:00
Where vs Having Exercise

00:29
Where vs Having Exercise Sol

03:31
Limit

01:37

The Insert Statement

TCL Statements

Aggregate Functions in Detail

Count Function in detail

04:01
Sum Function in detail

01:14
Sum Solution

00:43
Min & Max

01:12
Min & Max Solution

00:58
Avg Function

01:26
Round Function

01:09
Coalesce & If Null Task

00:57
Coalesce & If Null Solution

03:20
Coalesce

05:45
If Null

01:43

SQL Joins

Joins Intro

01:30
Joins Preamble

01:06
Joins Preamble Solution

05:48
Inner Join

07:04
Inner Join Solution

03:06
Handle Duplicate Records in Joins

06:36
Left Join

04:38
Right Join

02:26
Join Exercise

00:32
Join Exercise Solution

02:08
Join & Where Together

02:55
Join & Aggregate functions

02:05
Joins with Multiple Tables

04:34
Joins Exercise

00:37
Joins Multiple Table Exercise Solution

05:00

Union vs Union all

Sub Query

Sub Query Introduction

02:57
Sub Query Nested in

04:30
Sub Query Self Join

09:39
Sub Query Nested Task

00:18
Sub Query Nested Solution

01:08
Sub Query & Union Task

01:13
Sub Query & Union Solution

06:45
Sub Query Latest Salary Task

00:28
Sub Query Latest Salary Solution

02:17
Sub Query Create Table Task

01:21
Sub Query Create Table Solution

07:36

SQL Views

Stored Routines

Triggers

Windows Functions

Final Exercise

Student Ratings & Reviews

No Review Yet

About Course

Course Content

SQL Theory

SQL Intro

Database Introduction

SQL Syntax

SQL Object

DDL Introduction

DDL Theory

The Create Statement

The Alter Statement

The Drop Statement

The Rename Statement

The Truncate Statement

DDL Recap

TCL Theory

TCL Theory

TCL Commit

TCL Rollback

TCL Recap

SQL Syntax Recap

DML

DML Intro

Select Statement

Insert Statement

Update Statement

Delete Statement

DML Recap

DCL

DCL Grant

DCL Revoke

SQL Keyword

Database Terminologies

Database Terminologies

Database Design

Relationships

Primary Key

Foreign Key

Unique Key

Primary Key vs Unique Key

Creating Database

SQL Interface

Create Database

Create Table

Data Type

Data Type Intro

Text Data Type

Numbers Int

Float Numeric

Floating Double Data Type

Date Time

Date Type Recap

Other Useful Data Type

Constraints

Constraints Intro

Auto Increment

Primary Key

Foreign Key

Foreign Key on Delete Cascade

Unique Key

Index in Unique Key

Default Constraint

Not Null Constraint

Drop Primary & Foreign Key

Drop Unique Key

Using Database

SQL Best Practice

SQL Best Practice

Sales DDL Exercise

DDL Sales Exercise

DDL Sales Exercise Solution

Employees Database

Employees Script

Employee Schema

DDL

Select Intro

Where conditions

Where Exercise

Where Solution

Multiple Filter Operator