I am a beginner
SQL Foundations
From your first query to a complete business analysis: filters, calculations, dates, aggregations, joins and CTEs.
20 structured lessonsView the path →SQL.tn courses and training
Learn SQL through a progressive path, focused micro-courses, solved exercises and business projects. Start without installing anything and follow your goal.
Three starting points
I am a beginner
From your first query to a complete business analysis: filters, calculations, dates, aggregations, joins and CTEs.
20 structured lessonsView the path →I want to analyse data
Prepare metrics with aggregations, dates, CTEs and window functions.
10 structured lessonsView the path →I want to go further
Transactions, performance, automation and security in a real PostgreSQL environment.
8 structured lessonsView the path →Included practice paths
These focused paths reuse the existing catalogue and keep one shared progression.
Course explorer
25 results
25 resources currently available
From your first query to a complete business analysis: filters, calculations, dates, aggregations, joins and CTEs.
Understand why companies use databases, then write your first query to solve a real problem.
Build revenue indicators from fictitious sales spread across multiple cities and channels.
Prepare metrics with aggregations, dates, CTEs and window functions.
Transactions, performance, automation and security in a real PostgreSQL environment.
Understand the principles behind preparing a reliable SQL source for a Power BI model.
Practise common questions and realistic hands-on cases.
Understand the language, systems and dialects so you can choose the right documentation and write portable SQL with judgement.
Stop invalid data in the right place with types, keys and constraints.
Make several related changes succeed or fail together.
React to a data event without hiding business logic unnecessarily.
Reuse query logic and decide when its result should be materialized.
Read a simple plan and add an index only when it solves a measured problem.
Encapsulate database-side logic while understanding its cost and alternatives.
Grant only the access required and understand row-level security.
Understand how to prepare clean data at the right grain before working in Power BI.
Compare, rank and calculate changes without losing row-level detail.
Turn data-quality suspicions into repeatable, prioritised checks.
Link orders, lines and products to distinguish revenue, costs and margin by category.
Prepare inventory, revenue and coverage indicators for an operational team.
Transform order history into useful segments for a marketing team.
Connect queues, contacts, intervals and schedule to measure volume, abandonment, DMT and SLA without logging agents.
Calculate MRR, revenue movements, logo churn, retention and cohorts from verifiable events.
Measure lead time, promise fulfillment, carriers, warehouses and time evolution.
Calculate durations, trends and aggregated rates by department without exposing individual data.