ProgramGuru

SQL

Learn SQL. See what changes.

Follow familiar school data from your first query to joins, reliable updates and database design. See the rows, columns and values that each example uses.

Choose your starting point

New to SQL? Start with Foundations. You can switch anytime.

Foundations

Start learning →

Examples remain visible. Use a disposable database for practice. Your course progress stays on this device.

Srinivas Namala, author
About the author

Srinivas Namala

Software Engineer

Srinivas focuses on backend development, databases, systems, and the technologies used to build reliable server-side applications.

View LinkedIn profile ↗

Your learning path

All lessons

55 lessons527 code examples67 quiz questions

Your progress is saved on this device.

Estimated time includes reading, exploring code and answering quizzes. Learn at your own pace.

Basics of SQL

8 lessons · 125 min
  1. What Is SQL?3code examples1quiz questions10minutes estimated learning time
  2. Set Up SQL Tools3code examples1quiz questions8minutes estimated learning time
  3. SQL Syntax5code examples1quiz questions11minutes estimated learning time
  4. SQL Data Types7code examples1quiz questions13minutes estimated learning time
  5. Create Tables6code examples1quiz questions11minutes estimated learning time
  6. Insert Rows16code examples1quiz questions22minutes estimated learning time
  7. Update Rows16code examples2quiz questions24minutes estimated learning time
  8. Delete Rows17code examples2quiz questions26minutes estimated learning time

Querying Data

10 lessons · 201 min
  1. Select Data13code examples1quiz questions24minutes estimated learning time
  2. Filter with WHERE14code examples1quiz questions26minutes estimated learning time
  3. Sort Results12code examples1quiz questions23minutes estimated learning time
  4. Group and Summarize11code examples2quiz questions24minutes estimated learning time
  5. Filter Groups with HAVING10code examples1quiz questions21minutes estimated learning time
  6. Limit Result Rows10code examples1quiz questions15minutes estimated learning time
  7. Remove Duplicate Results9code examples1quiz questions16minutes estimated learning time
  8. Combine SQL Conditions11code examples1quiz questions21minutes estimated learning time
  9. Name Result Columns12code examples1quiz questions17minutes estimated learning time
  10. Choose Values with CASE9code examples1quiz questions14minutes estimated learning time

SQL Joins

6 lessons · 89 min
  1. INNER JOIN10code examples1quiz questions15minutes estimated learning time
  2. LEFT JOIN10code examples2quiz questions17minutes estimated learning time
  3. RIGHT JOIN10code examples1quiz questions15minutes estimated learning time
  4. FULL OUTER JOIN9code examples2quiz questions16minutes estimated learning time
  5. Join a Table to Itself8code examples1quiz questions13minutes estimated learning time
  6. CROSS JOIN8code examples1quiz questions13minutes estimated learning time

Intermediate SQL

6 lessons · 100 min
  1. Subqueries9code examples1quiz questions14minutes estimated learning time
  2. Views11code examples1quiz questions16minutes estimated learning time
  3. Indexes10code examples1quiz questions15minutes estimated learning time
  4. Data Constraints12code examples1quiz questions17minutes estimated learning time
  5. SQL Functions17code examples1quiz questions22minutes estimated learning time
  6. Missing Values and NULL10code examples2quiz questions16minutes estimated learning time

Advanced SQL

7 lessons · 110 min
  1. Stored Procedures13code examples1quiz questions18minutes estimated learning time
  2. User-Defined Functions11code examples1quiz questions16minutes estimated learning time
  3. Triggers11code examples1quiz questions16minutes estimated learning time
  4. Transactions9code examples2quiz questions16minutes estimated learning time
  5. Cursors10code examples1quiz questions15minutes estimated learning time
  6. Handle SQL Errors10code examples1quiz questions15minutes estimated learning time
  7. Dynamic SQL8code examples2quiz questions14minutes estimated learning time

Database Design

5 lessons · 67 min
  1. Normalize Data11code examples2quiz questions19minutes estimated learning time
  2. Denormalize Carefully7code examples1quiz questions12minutes estimated learning time
  3. Design Tables and Relationships6code examples1quiz questions11minutes estimated learning time
  4. Primary and Unique Keys5code examples1quiz questions10minutes estimated learning time
  5. Foreign Keys9code examples1quiz questions15minutes estimated learning time

Optimization

3 lessons · 47 min
  1. Tune SQL Performance12code examples1quiz questions18minutes estimated learning time
  2. Read Execution Plans7code examples1quiz questions13minutes estimated learning time
  3. Choose Effective Indexes11code examples1quiz questions16minutes estimated learning time

Security

2 lessons · 31 min
  1. Prevent SQL Injection9code examples2quiz questions16minutes estimated learning time
  2. Users and Permissions10code examples1quiz questions15minutes estimated learning time

Advanced Querying

4 lessons · 55 min
  1. Common Table Expressions8code examples1quiz questions13minutes estimated learning time
  2. Window Functions10code examples2quiz questions17minutes estimated learning time
  3. Pivot and Unpivot7code examples1quiz questions12minutes estimated learning time
  4. Recursive Queries7code examples2quiz questions13minutes estimated learning time

Integrations

4 lessons · 49 min
  1. SQL with Python12code examples1quiz questions17minutes estimated learning time
  2. SQL with Java6code examples1quiz questions11minutes estimated learning time
  3. SQL and Excel Reports5code examples1quiz questions11minutes estimated learning time
  4. Connect with JDBC and ODBC5code examples1quiz questions10minutes estimated learning time