Course
SQL Essentials
By Wanderson Leandro de Oliveira
SQL is the language of relational databases — the skill nearly every developer, analyst and engineer needs. This course teaches it hands-on using a real movies dataset (films, people, reviews and roles): you will write real queries from your very first SELECT, filter and aggregate data, join tables, change records safely, and finally design your own schema with keys and constraints.
Course content
Relational databases and setup
- 🔒 What is a relational database text
- 🔒 The films dataset (tables and relationships) text
- 🔒 Creating the database and tables text
Querying data
- 🔒 SELECT basics text
- 🔒 LIMIT and ORDER BY text
- 🔒 Filtering with WHERE text
Filtering and aggregating
- 🔒 LIKE and DISTINCT text
- 🔒 Aggregate functions (COUNT, SUM, AVG...) text
- 🔒 GROUP BY and HAVING text
Relating tables
- 🔒 Introduction to JOINs text
- 🔒 INNER JOIN and LEFT JOIN text
- 🔒 Joining films, roles and people text
Modifying data
- 🔒 Inserting data with INSERT text
- 🔒 UPDATE and DELETE (safely) text
- 🔒 Transactions: COMMIT and ROLLBACK text
Modeling a schema
- 🔒 CREATE TABLE and data types text
- 🔒 Keys and constraints (PK, FK) text
- 🔒 ER modeling and normalization basics text