← Back
SUMMARY
SQL (Core) - SQL Course Completion & Review
Prereq: None | Progress: 0%
Course Syllabus
Lesson 0 📖 What is SQL? Lesson 1 📖 SELECT queries 101 Lesson 2 📖 Queries with constraints (Pt. 1) Lesson 3 📖 Queries with constraints (Pt. 2) Lesson 4 📖 Filtering & sorting results Review 1 📖 Simple SELECT Queries Lesson 6 📖 Multi-table queries with JOINs Lesson 7 📖 OUTER JOINs Lesson 8 📖 A short note on NULLs Lesson 9 📖 Queries with expressions Lesson 10 📖 Queries with aggregates (Pt. 1) Lesson 11 📖 Queries with aggregates (Pt. 2) Lesson 12 📖 Order of execution of a Query Lesson 13 📖 Inserting rows Lesson 14 📖 Updating rows Lesson 15 📖 Deleting rows Lesson 16 📖 Creating tables Lesson 17 📖 Altering tables Lesson 18 📖 Dropping tables Lesson 19 📖 Subqueries & Nested Queries Lesson 20 📖 Set Operations Summary 🎓 Course Completion
🎓 SQL Course Completed!
Congratulations! You have successfully completed all interactive SQL lessons on SQLancer. You have mastered data retrieval, filtering, multi-table JOINs, aggregations, NULL handling, schema DDL, DML data manipulation, subqueries, and set operations.
🏆
SQL Core Proficiency Unlocked
Ready to practice real-world database scenarios? Test your skills with production queries in our SQL Practice Console or conquer top tech company SQL interview challenges!
🗄️ Schema Explorer SELECTABLE
› movies
|
🎯 Exercises Checklist:
☐ 1. Run your final graduation query: SELECT * FROM movies ORDER BY year DESC;
⚡ Practice Console
💡 Hint:
Loading hint...
🔑 Solution SQL:
SELECT * FROM movies;Data Output
No results. Run query to fetch data.