Unlock all SQL lessons and 4,242+ more with a single membership. Start Learning Now

SQL

Unlock the Full Potential of Data Management with the Ultimate SQL Mastery Course

Start Learning Now

60 hours of video learning material

Certificate of completion

What you'll learn:

Understand the fundamental concepts of SQL

Overview of the history of SQL and its architecture and understand what a RDBMS is and how it works

SQL commands and expressions, including creating tables, dropping tables, selecting data, inserting data, updating data, and more

Explore string and date/time functions in SQL and how to use them to manipulate data

The different databases commonly used in SQL, and how to choose and work with the appropriate database for your project

Explore the different attributes and concepts in SQL, including data types, operators, keys, NULL values, and data integrity

Understand aggregate functions, the HAVING clause, and how to use them to summarize data

How to use advanced SQL features such as views, indexes, and windows functions

Who this course is for:

Anyone who wants to learn SQL from scratch - no prior experience required!

Professionals who want to enhance their productivity and efficiency with data management and automation

Anyone who is currently working with data and wants to expand their knowledge of SQL to optimize database performance and streamline their workflow

Students who are interested in pursuing a career in data management, business intelligence, or data analytics

Curriculum for SQL

60 hours of valuable material

28 sections • 204 lectures • 60h 8m total length

Overview

6 lectures • 25min

Introduction • 03:30

What is SQL • 00:55

What is a RDBMS • 02:00

What is a Table • 01:40

Common Rules • 09:28

List of Databases • 07:48

SQL Attributes and Concepts

7 lectures • 49min

Data Types • 08:43

Operators in Detail • 07:48

Records vs. Rows • 00:44

Fields vs. Columns • 00:52

Keys • 07:07

SQL Constraints • 07:39

SQL Structure Overview • 15:43

SQL Commands and Expressions

6 lectures • 1hr 44min

Create New Database • 16:28

Create Tables • 15:41

Insert Data • 17:32

The SELECT Statement • 18:48

The WHERE Clause • 13:36

Conjunctive Operators • 21:34

More with SQL

7 lectures • 1hr 23min

Updated Queries • 16:04

The LIKE Clause • 13:18

The TOP Clause • 16:11

More Keys • 13:27

Get Unique Records • 06:13

Sorted Order • 04:29

Normal Forms • 13:09

SQL Exercises Section I

11 lectures • 4hr 42min

Exercises Introduction • 02:50

Exercise Area 1-1 • 28:31

Exercise Area 1-2 • 27:54

Exercise Area 1-3 • 28:58

Exercise Area 1-4 • 18:00

Exercise Area 1-5 • 29:34

Exercise Area 1-6 • 29:31

Exercise Area 1-7 • 24:06

Exercise Area 1-8 • 29:35

Exercise Area 1-9 • 31:32

Exercise Area 1-10 • 31:51

SQL Exercises Section II

10 lectures • 4hr 29min

Exercises Area 2-1 • 24:47

Exercises Area 2-2 • 26:47

Exercises Area 2-3 • 31:04

Exercises Area 2-4 • 23:52

Exercises Area 2-5 • 30:01

Exercises Area 2-6 • 24:11

Exercises Area 2-7 • 27:45

Exercises Area 2-8 • 28:52

Exercises Area 2-9 • 24:22

Exercises Area 2-10 • 26:54

SQL Exercises Section III

10 lectures • 4hr 51min

Exercises Area 3-1 • 25:08

Exercises Area 3-2 • 40:32

Exercises Area 3-3 • 22:56

Exercises Area 3-4 • 24:33

Exercises Area 3-5 • 25:40

Exercises Area 3-6 • 34:51

Exercises Area 3-7 • 27:15

Exercises Area 3-8 • 33:49

Exercises Area 3-9 • 27:56

Exercises Area 3-10 • 28:15

SQL Exercises Section IV

10 lectures • 4hr 26min

Exercises Area 4-1 • 28:25

Exercises Area 4-2 • 28:21

Exercises Area 4-3 • 27:47

Exercises Area 4-4 • 23:28

Exercises Area 4-5 • 25:00

Exercises Area 4-6 • 29:30

Exercises Area 4-7 • 24:49

Exercises Area 4-8 • 25:24

Exercises Area 4-9 • 24:37

Exercises Area 4-10 • 28:54

SQL Exercises Section V

10 lectures • 4hr 14min

Exercises Area 5-1 • 28:13

Exercises Area 5-2 • 24:39

Exercises Area 5-3 • 24:10

Exercises Area 5-4 • 23:37

Exercises Area 5-5 • 28:23

Exercises Area 5-6 • 22:22

Exercises Area 5-7 • 22:19

Exercises Area 5-8 • 32:29

Exercises Area 5-9 • 22:58

Exercises Area 5-10 • 24:35

SQL Beginner Outro

2 lectures • 7min

Review • 06:19

Outro • 00:41

Introduction to SQL Advanced

6 lectures • 1hr 24 min

Introduction • 02:46

Course Focus • 00:54

Review SQL Objects • 15:59

Wildcard Operators • 18:44

Wildcard Operators Exercises Pt. 1 • 21:59

Wildcard Operators Exercises Pt. 2 • 23:20

SQL JOIN Syntax and Practice

3 lectures • 1hr 18min

SQL JOINS Syntax • 22:51

SQL JOINS Exercises Pt. 1 • 27:20

SQL JOINS Exercises Pt. 2 • 28:03

Aggregate Functions

3 lectures • 1hr 24min

Aggregate Functions • 27:05

The HAVING Clause • 32:18

Aggregate Functions Exercises • 24:58

String and DATE/TIME Functions

8 lectures • 2hr 59min

String Functions Area I • 21:14

String Functions Area II • 22:46

String Functions Area III • 19:45

String Functions Area IV • 22:27

DATE/TIME Functions Area I • 19:58

DATE/TIME Functions Area II • 27:52

DATE/TIME Functions Area III • 21:46

DATE/TIME Functions Area IV • 22:51

Advanced JOINS

3 lectures • 1hr 5min

Advanced JOINS Syntax • 19:29

Advanced JOINS Exercises Pt. 1 • 20:38

Advanced JOINS Exercises Pt. 2 • 25:19

SQL Programming

4 lectures • 1hr 30min

SQL Programming Pt. 1 • 20:27

SQL Programming Pt. 2 • 17:52

Stored Procedures Pt. 1 • 21:41

Stored Procedures Pt. 2 • 30:19

Introduction to Tables

2 lectures • 40 min

Tables • 22:26

Demonstration Exercises • 17:28

Cursors and Transactions

4 lectures • 1hr 41min

Cursors • 20:41

SQL Transactions Area I • 29:07

SQL Transactions Area II • 21:11

SQL Transactions Area III • 29:52

SAL Triggers

3 lectures • 1hr 15min

SQL Triggers Area I • 20:57

SQL Triggers Area II • 28:29

SQL Triggers Area III • 25:34

View and Subqueries

6 lectures • 2hr 55min

Views Area I • 20:03

Views Area II • 32:08

Subqueries Area I • 28:42

Subqueries Area II • 27:18

Advanced Subqueries Area I • 27:46

Advanced Subqueries Area II • 39:18

View and Subqueries

6 lectures • 2hr 55min

Indexes Area I • 06:25

Indexes Area II • 05:43

Indexes Area III • 06:00

Indexes Area Demo • 14:11

Schema Structures Area I • 13:49

Schema Structures Area II • 21:55

Indexes and Schema Structures

6 lectures • 1hr 8min

Indexes Area I • 06:25

Indexes Area II • 05:43

Indexes Area III • 06:00

Indexes Area Demo • 14:11

Schema Structures Area I • 13:49

Schema Structures Area II • 21:55

Windows Functions

6 lectures • 1hr 56min

Windows Functions Area I • 17:49

Windows Functions Area II • 26:50

Windows Functions Area III • 16:18

Windows Functions Area IV • 17:15

Windows Functions Area V • 33:10

Windows Functions Area VI • 04:58

Advanced SQL Programming

6 lectures • 2hr 27 min

Introduction to the Module • 01:53

Introduction to Website Development with ChatGPT • 02:02

Understanding HTML, CSS, and JavaScript • 02:09

SQL Advanced Exercises Section I

12 lectures • 3hr 48min

Exercises Area 1-1 • 26:18

Exercises Area 1-2 • 25:01

Exercises Area 1-3 • 27:28

Exercises Area 1-4 • 11:42

Exercises Area 1-5 • 11:06

Exercises Area 1-6 • 34:48

Exercises Area 1-7 • 16:00

Exercises Area 1-8 • 11:13

Exercises Area 1-9 • 14:35

Exercises Area 1-10 • 18:42

Exercises Area 1-11 • 12:46

Exercises Area 1-12 • 18:17

SQL Advanced Exercises Section II

12 lectures • 3hr 9min

Exercises Area 2-1 • 17:21

Exercises Area 2-2 • 14:56

Exercises Area 2-3 • 16:14

Exercises Area 2-4 • 15:53

Exercises Area 2-5 • 17:15

Exercises Area 2-6 • 18:58

Exercises Area 2-7 • 18:12

Exercises Area 2-8 • 07:41

Exercises Area 2-9 • 11:17

Exercises Area 2-10 • 18:19

Exercises Area 2-11 • 13:35

Exercises Area 2-12 • 19:39

SQL Advanced Outro

2 lectures • 4min

Review • 03:13

Outro • 01:05

SQL Additional Topics Section I

18 lectures • 1hr 45min

Welcome to the Additional Topics • 00:53

Introduction • 03:40

Data Modeling Pt. I • 05:28

Data Modeling Pt. II • 03:20

Data Modeling Pt. III • 02:09

Oracle DB Pt. I • 06:42

Oracle DB Pt. II • 07:30

Oracle DB Pt. III • 13:38

Oracle DB Pt. IV • 02:15

Keys Pt. I • 06:06

Keys Pt. II • 05:53

Keys Pt. III • 01:35

Data Normalization Pt. I • 06:43

Data Normalization Pt. II • 06:35

Data Normalization Pt. III • 24:46

Data Normalization Pt. IV • 02:26

Exercises Pt. I • 00:54

Exercises Pt. II • 04:56

SQL Additional Topics Section II

21 lectures • 2hr 28min

Concurrency Control Pt. I • 12:13

Concurrency Control Pt. II • 01:13

Exercises Pt. I • 01:18

Exercises Pt. II • 04:19

Transaction Management Pt. I • 08:03

Transaction Management Pt. II • 09:51

Transaction Management Pt. III• 11:55

Transaction Management Pt. IV • 02:01

SQL Security Pt. I • 12:42

SQL Security Pt. II • 15:27

SQL Security Pt. III • 19:21

SQL Security Pt. IV • 02:42

SQL Security Exercises Pt. I • 00:50

SQL Security Exercises Pt. II • 01:25

Data Dictionary Pt. I • 09:33

Data Dictionary Pt. II • 01:49

Getting Ready for the Exam • 02:26

Final Project Pt. I • 02:13

Final Project Pt. II • 13:21

Final Project Pt. III • 14:28

Last Words • 00:37

Advance your skills with thousands of professional classes made by experts

4,242+

Lessons

2,351+

Hours of video content

56+

Different skills