Intermediate SQL

Master JOINs, subqueries, CTEs, set operations, indexing, views, transactions, and query optimization for real-world database work.

Intermediate4 Weeks10 LessonsNuniversity
Start

Course Content

  1. 01INNER JOINs and Equi-Joins
  2. 02OUTER JOINs and CROSS JOINs
  3. 03Subqueries
  4. 04Common Table Expressions (CTEs)
  5. 05UNION, INTERSECT, and EXCEPT
  6. 06Indexing Strategies
  7. 07Query Execution Plans
  8. 08Views and Materialized Views
  9. 09Transactions and ACID
  10. 10Intermediate Capstone: E-Commerce Analytics

Lessons: 10 · 4 Weeks