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
56 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

55 hours of valuable material

26 sections • 166 lectures • 55h 54m 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 the Module • 01:53
Introduction to the Module • 01:53
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
3 lectures • 5min
Review • 03:13
Outro • 01:05
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
crossmenuchevron-downarrow-right linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram