SQL — Catalog
Choose a course or a pack to get started.
SQL skills are essential for Data Analysts, Business Analysts, developers, BI consultants, advanced controllers, Data Engineers and professionals who query or validate business data. In real projects, knowing SELECT is not enough: you must understand table relationships, avoid join errors, produce reliable indicators, secure write operations and diagnose performance issues.
The 15 courses cover the full professional progression: relational foundations, SELECT, filters, joins, aggregations, functions, subqueries, CTEs, window functions, database design, transactions, indexes and execution plans, security, BI/Analytics datasets and a complete SQL project. By the end of the pathway, you will be able to design, query, transform, optimize and secure relational databases for application, Data and BI needs.
🎓 15 courses • 📘 120 interactive lessons • ⏱️ 45 to 75 hours of conversational training
Best offer
Complete Pack — SQL Path
142,90 € excl. VAT
Savings : 104,60 €
29,70 €
22,90 excl. VAT
Savings : 6,80 €
Understanding Relational Databases and the SQL Environment
understanding how a relational database structures data and how SQL is used to query it
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
No advanced technical prerequisite. Everyday computer skills and the ability to follow technical instructions are sufficient to start.
- Understanding what a relational database is
- Distinguishing primary keys from foreign keys
- Differentiating SQL, DBMS, and SQL client tools
- Workshop: mapping a relational database
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: mapping a relational database
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
9,90 € excl. VAT
Writing Your First SELECT Queries
cleanly extracting the useful information from a table with SELECT
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
No advanced technical prerequisite. Everyday computer skills and the ability to follow technical instructions are sufficient to start.
- Understanding the SELECT … FROM structure
- Understanding the risks of SELECT *
- Creating expressions and calculations in SELECT
- Workshop: building a clean first SQL extraction
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: building a clean first SQL extraction
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
9,90 € excl. VAT
Filtering, Searching, and Sorting Data
precisely retrieving the rows you need with conditions, searches, and sorting
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
No advanced technical prerequisite. Everyday computer skills and the ability to follow technical instructions are sufficient to start.
- Filtering rows with WHERE
- Combining AND, OR, NOT, and parentheses
- Correctly handling NULL values
- Workshop: building a complete business search
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: building a complete business search
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
9,90 € excl. VAT
38,70 €
28,90 excl. VAT
Savings : 9,80 €
Linking Tables with Joins
correctly combining several tables without creating cardinality errors or duplicates
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
A working knowledge of the foundations introduced in the first courses, or equivalent practical experience, is recommended.
- Understanding why and how to join tables
- Keeping rows with LEFT JOIN
- Performing a self join
- Workshop: answering a business question with several tables
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: answering a business question with several tables
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
12,90 € excl. VAT
Aggregating and Summarizing Data
turning detailed rows into usable indicators and summaries
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
A working knowledge of the foundations introduced in the first courses, or equivalent practical experience, is recommended.
- Calculating COUNT, SUM, and AVG
- Grouping data with GROUP BY
- Choosing between WHERE and HAVING
- Workshop: producing a controlled business summary
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: producing a controlled business summary
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
12,90 € excl. VAT
Transforming Data with SQL Functions
cleaning, enriching, and combining data directly within SQL queries
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
A working knowledge of the foundations introduced in the first courses, or equivalent practical experience, is recommended.
- Transforming text with SQL functions
- Working with dates and times
- Converting types with CAST
- Workshop: preparing and normalizing a dataset in SQL
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: preparing and normalizing a dataset in SQL
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
12,90 € excl. VAT
47,70 €
35,90 excl. VAT
Savings : 11,80 €
Mastering Subqueries and Existence Checks
solving complex needs with subqueries, EXISTS, and the right query strategy
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
A working knowledge of the foundations introduced in the first courses, or equivalent practical experience, is recommended.
- Understanding the principle of a subquery
- Filtering with IN and a subquery
- Understanding correlated subqueries
- Workshop: solving a business need with the right strategy
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: solving a business need with the right strategy
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
15,90 € excl. VAT
Structuring Complex Queries with CTEs
breaking a complex query into readable, maintainable steps with WITH
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Understanding the role of a Common Table Expression
- Chaining several CTEs
- Traversing a hierarchy with a recursive CTE
- Workshop: refactoring a complex query with CTEs
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: refactoring a complex query with CTEs
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
15,90 € excl. VAT
Analyzing Data with Window Functions
calculating rankings, running totals, and comparisons without losing row-level detail
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Understanding the principle of a window function
- Numbering and ranking with ROW_NUMBER, RANK, and DENSE_RANK
- Using FIRST_VALUE and LAST_VALUE
- Workshop: building a ranking and trend analysis
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: building a ranking and trend analysis
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
15,90 € excl. VAT
56,70 €
42,90 excl. VAT
Savings : 13,80 €
Designing and Creating a Relational Database
going from a business need to a relational schema actually built in SQL
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Going from a business need to entities
- Normalizing data up to the common normal forms
- Defining NOT NULL, UNIQUE, CHECK, and DEFAULT
- Workshop: designing then creating a complete relational database
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: designing then creating a complete relational database
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
18,90 € excl. VAT
Modifying Data and Securing Transactions
writing to a database without compromising data integrity or consistency
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Inserting one or more rows with INSERT
- Deleting data and distinguishing DELETE from TRUNCATE
- Understanding ACID and isolation levels
- Workshop: securing a complete transactional process
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: securing a complete transactional process
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
18,90 € excl. VAT
Indexing and Optimizing SQL Queries
diagnosing and improving query performance on large volumes of data
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Identifying why a query becomes slow
- Creating and using a simple index
- Writing predicates that indexes can actually use
- Workshop: diagnosing then optimizing a slow query
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: diagnosing then optimizing a slow query
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
18,90 € excl. VAT
74,70 €
48,90 excl. VAT
Savings : 25,80 €
Building Reusable, Secure, and Integrable SQL
organizing reusable, secure data access for applications and teams
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Creating and using SQL views
- Organizing reusable, documented queries
- Understanding how SQL injection works
- Workshop: building reliable, secure data access
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: building reliable, secure data access
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
24,90 € excl. VAT
SQL for Data, BI, and Analytics
building datasets and SQL indicators ready for analysis and visualization
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Turning a business question into an analytical dataset
- Comparing periods and handling analysis dates
- Segmenting and categorizing populations
- Workshop: producing an indicator set ready for a dashboard
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: producing an indicator set ready for a dashboard
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
24,90 € excl. VAT
Complete Professional SQL Project
mobilizing the full range of SQL skills on an end-to-end professional case
Course information
Data Analysts, Business Analysts, developers, BI consultants and professionals who need to query, structure, validate or optimize relational data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Scoping the need and the rules of the professional case
- Creating the schema, tables, and constraints
- Using CTEs and window functions
- Final workshop: presenting and defending the SQL solution
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: presenting and defending the SQL solution
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
24,90 € excl. VAT