AvailableFree
Why does SQL exist?
Understand why companies use databases, then write your first query to solve a real problem.
- Level
- Complete beginner
- Duration
- 35 to 45 min
- Syllabus
- 5 micro-lessons · 5 activities
- Account required
- No, to start
One skill · One concrete result
Progress in SQL, one skill at a time.
Start for free by understanding what SQL is for. Advanced training will open only when its exercises are ready and verified.
Available now
Your first result, for free.
Discover the problem databases solve, then run your first query.
Coming next
Choose the skill you want to develop.
Review the planned syllabus or join the waiting list. No purchase is offered until the training is ready.
In preparationPrice not published
SQL, PostgreSQL, MySQL and SQL Server: what is the difference?
What you will be able to do: Distinguish language, database, DBMS, server and dialect, then recognise the differences that matter.
- Level
- Beginner
- Planned duration
- 45 to 60 min
- Planned syllabus
- 5 micro-lessons · 6 exercises
- Prerequisites
- Know what a table is
In preparationPrice not published
Keep data reliable with constraints
What you will be able to do: Choose and write the right constraint for a simple business rule.
- Level
- Beginner / intermediate
- Planned duration
- 60 min
- Planned syllabus
- 6 micro-lessons · 8 exercises
- Prerequisites
- Tables, columns and primary keys
In preparationPrice not published
Secure an operation with transactions
What you will be able to do: Use COMMIT, ROLLBACK and SAVEPOINT while understanding errors and concurrency.
- Level
- Intermediate
- Planned duration
- 60 to 75 min
- Planned syllabus
- 6 micro-lessons · 8 exercises
- Prerequisites
- INSERT, UPDATE and DELETE
View 8 more planned courses
In preparationPrice not published
Automate PostgreSQL with triggers
What you will be able to do: Create and test an audit trigger with OLD, NEW, BEFORE, AFTER, ROW and STATEMENT.
- Level
- Intermediate
- Planned duration
- 75 to 90 min
- Planned syllabus
- 6 micro-lessons · 10 exercises
- Prerequisites
- Constraints · INSERT, UPDATE, DELETE · Transactions
In preparationPrice not published
Create views and materialized views
What you will be able to do: Create a view, explain its limits and refresh a PostgreSQL materialized view.
- Level
- Intermediate
- Planned duration
- 60 to 75 min
- Planned syllabus
- 5 micro-lessons · 7 exercises
- Prerequisites
- SELECT, JOIN and aggregations
In preparationPrice not published
Speed up a query with indexes and EXPLAIN
What you will be able to do: Compare a plan before and after an index, and explain the index's cost.
- Level
- Intermediate
- Planned duration
- 75 to 90 min
- Planned syllabus
- 6 micro-lessons · 9 exercises
- Prerequisites
- SELECT, filters and joins
In preparationPrice not published
PostgreSQL functions and procedures
What you will be able to do: Choose a function or procedure, define parameters and test effects.
- Level
- Intermediate / advanced
- Planned duration
- 90 min
- Planned syllabus
- 6 micro-lessons · 9 exercises
- Prerequisites
- SQL queries · Transactions · Basic types
In preparationPrice not published
Roles, permissions and data security
What you will be able to do: Design roles, apply GRANT and REVOKE, and explain row-level security.
- Level
- Intermediate
- Planned duration
- 60 to 75 min
- Planned syllabus
- 5 micro-lessons · 7 exercises
- Prerequisites
- Tables and views
In preparationPrice not published
Prepare SQL data for Power BI
What you will be able to do: Produce a documented source query suited to a Power BI model.
- Level
- Intermediate
- Planned duration
- 75 to 90 min
- Planned syllabus
- 6 micro-lessons · 8 exercises
- Prerequisites
- JOIN and aggregations · Basic Power BI modelling
In preparationPrice not published
Window functions for business analysis
What you will be able to do: Use OVER, PARTITION BY, ranking functions, LAG and running totals.
- Level
- Intermediate
- Planned duration
- 90 min
- Planned syllabus
- 6 micro-lessons · 10 exercises
- Prerequisites
- Aggregations, GROUP BY and CTEs
In preparationPrice not published
Control data quality with SQL
What you will be able to do: Write a suite of checks and produce an actionable anomaly report.
- Level
- Intermediate
- Planned duration
- 60 to 90 min
- Planned syllabus
- 6 micro-lessons · 9 exercises
- Prerequisites
- Filters, aggregations and joins