Learning Path
-
Beginner Level
-
Setting up a database locally
-
Understanding databases, tables, and SQL basics
-
Writing first commands:
-
Querying data
-
Filtering data
-
Using
GROUP BY
-
-
-
Intermediate Level
-
Learning functions & conditional expressions
-
Joining tables
-
Building a solid foundation in SQL
-
-
Advanced Level
-
Subqueries, unions, managing tables
-
Creating, altering, and managing database objects
-
Views & data manipulation (
UPDATE,INSERT) -
A course project to practice what’s learned so far
-
-
Pro Level (Optional Extra Mile)
-
Complex topics that even experienced SQL users might not know:
-
Window functions
-
Grouping sets
-
Transactions
-
User-defined functions
-
Stored procedures
-
-
A challenging project at this stage
-
Key Points in the Design
-
Daily structure: Learn a bit more each day
-
Plenty of practice: Exercises after every topic
-
Flexibility: Students can stop at intermediate or advanced level if they want, and come back later to learn pro topics
-
Lifelong access: You can revisit the material any time