Back to Courses
SQL
SQL & Database Management
Master the language of data with our comprehensive SQL course. Learn to design, query, and optimize relational databases from the ground up. This hands-on program covers everything from basic CRUD operations to advanced joins, subqueries, and performance tuning. You'll gain practical skills in database administration, security, and transaction management, culminating in a real-world database project. Perfect for aspiring data analysts, backend developers, and anyone who works with data systems.
$70000
Course Content
Module 1: Module 1: SQL Fundamentals & Database Design
1
Lesson 1: Introduction to Databases & Relational Models
2
Lesson 2: SQL Basics (SELECT, INSERT, UPDATE, DELETE)
3
Lesson 3: Filtering & Sorting Data (WHERE, ORDER BY, DISTINCT)
4
Lesson 4: Table Creation & Data Types (CREATE, ALTER, DROP)
5
Lesson 5: Understanding Primary Keys, Foreign Keys & Constraints
Module 2: Module 2: Querying & Data Manipulation
1
Lesson 1: Joins (INNER, LEFT, RIGHT, FULL, CROSS)
2
Lesson 2: Aggregation & Grouping (GROUP BY, HAVING, Aggregate Functions)
3
Lesson 3: Subqueries & Common Table Expressions (CTEs)
4
Lesson 4: Advanced Filtering (CASE WHEN, IN, EXISTS, LIKE)
5
Lesson 5: Working with Views & Indexes
Module 3: Module 3: Database Administration & Optimization
1
Lesson 1: Transaction Control (COMMIT, ROLLBACK, ACID Properties)
2
Lesson 2: Stored Procedures & Functions
3
Lesson 3: Database Security & User Permissions
4
Lesson 4: Performance Tuning & Query Optimization
5
Lesson 5: Capstone Project – Designing & Querying a Real-World Database
Instructor
Shar
Instructor
All she cares about is databases