SQL Essentials

A clear path through the material

Build your understanding one focused lesson at a time, from core ideas to practical programming.

Enroll free to unlock the lessons.

1. 01
   SQL Foundations and Queries0/48 topics · 0%

   • 1SQL Tutorial
   • 2SQL HOME
   • 3SQL Intro
   • 4SQL Syntax
   • 5SQL Select
   • 6SQL Select Distinct
   • 7SQL Where
   • 8SQL Order By
   • 9SQL And
   • 10SQL Or
   • 11SQL Not
   • 12SQL Insert Into

   Show all 48 topics (+36)
2. 02
   SQL Database Design and Safety0/23 topics · 0%

   • 49SQL Create DB
   • 50SQL Drop DB
   • 51SQL Backup DB
   • 52SQL Create Table
   • 53SQL Drop Table
   • 54SQL Alter Table
   • 55SQL Constraints
   • 56SQL Not Null
   • 57SQL Unique
   • 58SQL Primary Key
   • 59SQL Foreign Key
   • 60SQL Check

   Show all 23 topics (+11)
3. 03
   SQL Advanced Queries and Operations0/14 topics · 0%

   • 72SQL Common Table Expressions
   • 73SQL Recursive CTEs
   • 74SQL Window Functions
   • 75SQL ROW_NUMBER()
   • 76SQL RANK() and DENSE_RANK()
   • 77SQL Partitioning Results
   • 78SQL Correlated Subqueries
   • 79SQL Conditional Aggregation
   • 80SQL Composite Indexes
   • 81SQL EXPLAIN Query Plans
   • 82SQL Transaction Isolation
   • 83SQL Locks and Concurrency

   Show all 14 topics (+2)
4. 04
   SQL Projects and Practice0/12 topics · 0%

   • 86SQL Hosting
   • 87SQL Certificate
   • 88SQL Examples
   • 89SQL Editor
   • 90SQL Quiz
   • 91SQL Exercises
   • 92SQL Server
   • 93SQL Syllabus
   • 94SQL Study Plan
   • 95SQL Training
   • 96SQL Reporting Project
   • 97SQL Database Project
5. 05
   SQL References0/8 topics · 0%

   • 98SQL Data Types
   • 99SQL Keywords
   • 100MySQL Functions
   • 101SQL Server Functions
   • 102MS Access Functions
   • 103SQL Quick Ref
   • 104SQL Date Functions
   • 105SQL String Functions