Overview
Course Description
The Complete SQL Course: Design, Queries, and Optimization course is designed to take you from foundational knowledge to mastery of SQL, giving you the skills needed to manage and manipulate databases effectively.This course will provide you with both the theoretical understanding and practical skills required to work with databases in real-world applications.
Whether you’re starting your journey with SQL or looking to advance your existing knowledge, this course offers a comprehensive approach to data modeling, database design, querying, optimization, security, and working with advanced SQL objects.
Through hands-on projects, practical demonstrations, and structured lessons, you’ll gain a deep understanding of SQL, learning how to use it to design, manage, and optimize databases. By the end of the course, you'll be confident in your ability to build scalable, efficient, and secure databases.
What you'll learn
- Data Modeling and Design
- Model data through conceptual, logical, and physical stages.
- Design relational databases with keys and integrity rules.
- Build and Manage Databases (DDL)
- Use DDL to create and manage tables, schemas, and constraints.
- SQL Queries (DQL & DML)
- Master SELECT, INSERT, UPDATE, DELETE, and JOIN operations.
- Write advanced queries with subqueries and aggregate functions.
- SQL Objects
- Work with indexes, views, triggers, procedures, and functions.
- Database Security (DCL)
- Control user access with GRANT and REVOKE statements.
- Real-World Applications
- Build scalable, efficient, and secure databases for practical use.
Free
$100
Includes
Engaging Instructor
Full lifetime access
Access on mobile and TV
Certificate of Completion
Course Content
28 Lectures 14h 40min
Getting Started 2 Lectures 06min
-
Course OverviewPreview 02:24 -
SQL Server Installation Guide04:22
Structured Query Language (SQL) 26 Lectures 14h 33min
-
Introduction to Databases: Concepts, Types, and Relational Models01:01:55
-
NormalizationPreview 13:55
-
Data Modeling01:13:11
-
Data Definition Language (DDL): Creating and Structuring Databases01:07:15
-
Data Manipulation Language (DML): Inserting, Updating, and Deleting Data16:35
-
Data Query Language (DQL): SELECT Queries47:40
-
Data Query Language (DQL): Working with Joins in SQL50:53
-
Data Query Language (DQL): Practicing SQL JOIN Queries41:07
-
Data Query Language (DQL): Using SQL Functions01:10:03
-
Data Query Language (DQL): Practicing SQL Functions17:51
-
SQL Practice: Part 1 - Writing and Executing SQL Queries38:30
-
SQL Practice: Part 2 - Writing and Executing SQL Queries
59:35
-
SQL Objects: Indexes16:22
-
SQL Objects: Views13:31
-
SQL Objects: Stored Procedures23:56
-
SQL Objects: Functions33:53
-
SQL Objects: Triggers46:30
-
Data Control Language (DCL): Managing Access and Permissions in SQL15:38
-
Clinic Task: Overview12:01
-
Clinic Task: Conceptual Model12:31
-
Clinic Task: Logical Model10:40
-
Clinic Task: Physical Model07:44
-
Clinic Task: Creating Database Structures27:19
-
Clinic Task: Inserting, Updating, and Deleting Data10:58
-
Clinic Task: Part 1 - Retrieving Data22:44
-
Clinic Task: Part 2 - Retrieving Data01:01:07
About the instructor
Osama Shnaikat
.NET Developer
A .NET Developer with 14+ years of experience in web development, I have developed and led numerous successful software projects and helped countless individuals master web development and build successful careers.
I specialize in both front-end and back-end technologies, including HTML, CSS, JavaScript, .NET, .NET Core, Angular, Bootstrap, SQL, APIs, cloud services, and more.
My goal is to ensure students understand how to manage, execute, and deliver successful projects in real-world environments, preparing them for success in the tech industry.