SQL — Mandragore Academy

Python JavaScript & TypeScript SQL API Cybersecurity Fundamentals Cloud Fundamentals Data Modeling & Pipelines

SQL — Catalog

Choisissez un cours ou un pack pour commencer.

Each course brings together 8 interactive lessons in a Learning Workspace designed to turn knowledge into operational skills. Guided lessons, practical cases, dynamic quizzes, conversational support, and progress tracking let you learn effectively, at your own pace. The 15 courses follow a level-by-level progression, from discovering relational databases to designing and optimizing professional SQL queries.

🎓 15 courses • 📘 120 interactive lessons • ⏱️ 45 to 75 hours of conversational training

5 levels: Level 1 — 9,90 € excl. VAT Level 2 — 12,90 € excl. VAT Level 3 — 15,90 € excl. VAT Level 4 — 18,90 € excl. VAT Level 5 — 24,90 € excl. VAT

Best offer

Complete Pack — SQL Path

🎓 Certificate : "SQL — Complete Professional Path" 247,50 €

📚 15 courses 📖 120 lessons ⏱ 45 to 75 h ⚡ 1800 credits included

142,90 € excl. VAT

Savings : 104,60 €

Foundations SQL Pack 3 courses

🎓 Certificate : SQL — Foundations

📚 3 courses 📖 24 lessons ⏱ 9 to 15 h ⚡ 240 credits included

29,70 €

22,90 excl. VAT

Savings : 6,80 €

01 Level 1

Understanding Relational Databases and the SQL Environment

understanding how a relational database structures data and how SQL is used to query it

Understanding what a relational database is Identifying tables, rows, columns, and schemas Distinguishing primary keys from foreign keys Understanding relationships and cardinalities between tables Choosing the main data types Differentiating SQL, DBMS, and SQL client tools Connecting to and exploring an existing database Workshop: mapping a relational database

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 80 credits included

02 Level 1

Writing Your First SELECT Queries

cleanly extracting the useful information from a table with SELECT

Understanding the SELECT … FROM structure Selecting only the columns you need Understanding the risks of SELECT * Renaming columns and expressions with AS Removing duplicates with DISTINCT Creating expressions and calculations in SELECT Limiting results and understanding variations across engines Workshop: building a clean first SQL extraction

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 80 credits included

03 Level 1

Filtering, Searching, and Sorting Data

precisely retrieving the rows you need with conditions, searches, and sorting

Filtering rows with WHERE Using comparison operators Combining AND, OR, NOT, and parentheses Filtering with IN and BETWEEN Searching for patterns with LIKE Correctly handling NULL values Sorting by one or more criteria with ORDER BY Workshop: building a complete business search

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 80 credits included

Data Handling and Transformation Pack 3 courses

🎓 Certificate : SQL — Data Handling and Transformation

📚 3 courses 📖 24 lessons ⏱ 9 to 15 h ⚡ 300 credits included

38,70 €

28,90 excl. VAT

Savings : 9,80 €

04 Level 2

Linking Tables with Joins

correctly combining several tables without creating cardinality errors or duplicates

Understanding why and how to join tables Building an INNER JOIN Keeping rows with LEFT JOIN Understanding RIGHT JOIN, FULL JOIN, and their portability Chaining several joins Performing a self join Detecting incorrect cardinalities and accidental duplicates Workshop: answering a business question with several tables

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 100 credits included

05 Level 2

Aggregating and Summarizing Data

turning detailed rows into usable indicators and summaries

Calculating COUNT, SUM, and AVG Using MIN and MAX Grouping data with GROUP BY Grouping across several dimensions Filtering groups with HAVING Choosing between WHERE and HAVING Combining joins, aggregations, and distinct counts Workshop: producing a controlled business summary

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 100 credits included

06 Level 2

Transforming Data with SQL Functions

cleaning, enriching, and combining data directly within SQL queries

Transforming text with SQL functions Using common numeric functions Working with dates and times Creating business rules with CASE Handling missing values with COALESCE and NULLIF Converting types with CAST Combining results with UNION, INTERSECT, and EXCEPT Workshop: preparing and normalizing a dataset in SQL

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 100 credits included

Advanced Queries Pack 3 courses

🎓 Certificate : SQL — Advanced Queries

📚 3 courses 📖 24 lessons ⏱ 9 to 15 h ⚡ 360 credits included

47,70 €

35,90 excl. VAT

Savings : 11,80 €

07 Level 3

Mastering Subqueries and Existence Checks

solving complex needs with subqueries, EXISTS, and the right query strategy

Understanding the principle of a subquery Using a scalar subquery Filtering with IN and a subquery Testing existence with EXISTS and NOT EXISTS Creating a derived table in FROM Understanding correlated subqueries Choosing between JOIN, subquery, and EXISTS Workshop: solving a business need with the right strategy

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 120 credits included

08 Level 3

Structuring Complex Queries with CTEs

breaking a complex query into readable, maintainable steps with WITH

Understanding the role of a Common Table Expression Writing a first CTE with WITH Chaining several CTEs Breaking a complex calculation into steps Building a recursive CTE Traversing a hierarchy with a recursive CTE Choosing between a CTE, a subquery, and an intermediate object Workshop: refactoring a complex query with CTEs

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 120 credits included

09 Level 3

Analyzing Data with Window Functions

calculating rankings, running totals, and comparisons without losing row-level detail

Understanding the principle of a window function Mastering OVER, PARTITION BY, and ORDER BY Numbering and ranking with ROW_NUMBER, RANK, and DENSE_RANK Calculating running totals and averages with windows Comparing rows with LAG and LEAD Using FIRST_VALUE and LAST_VALUE Choosing between GROUP BY and window functions Workshop: building a ranking and trend analysis

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 120 credits included

Design and Performance Pack 3 courses

🎓 Certificate : SQL — Design and Performance

📚 3 courses 📖 24 lessons ⏱ 9 to 15 h ⚡ 420 credits included

56,70 €

42,90 excl. VAT

Savings : 13,80 €

10 Level 4

Designing and Creating a Relational Database

going from a business need to a relational schema actually built in SQL

Going from a business need to entities Defining relationships and cardinalities Normalizing data up to the common normal forms Designing primary keys, foreign keys, and junction tables Creating tables with CREATE TABLE Defining NOT NULL, UNIQUE, CHECK, and DEFAULT Evolving a schema with ALTER TABLE Workshop: designing then creating a complete relational database

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 140 credits included

11 Level 4

Modifying Data and Securing Transactions

writing to a database without compromising data integrity or consistency

Inserting one or more rows with INSERT Safely modifying data with UPDATE Deleting data and distinguishing DELETE from TRUNCATE Previewing and controlling a write operation Wrapping operations with COMMIT and ROLLBACK Understanding ACID and isolation levels Understanding concurrency, locks, and deadlocks Workshop: securing a complete transactional process

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 140 credits included

12 Level 4

Indexing and Optimizing SQL Queries

diagnosing and improving query performance on large volumes of data

Identifying why a query becomes slow Understanding how an index works Creating and using a simple index Designing a composite index and reasoning about selectivity Reading an execution plan with EXPLAIN Writing predicates that indexes can actually use Optimizing joins, aggregations, and access to large volumes Workshop: diagnosing then optimizing a slow query

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 140 credits included

Professional SQL Mastery Pack 3 courses

🎓 Certificate : SQL — Professional Mastery

📚 3 courses 📖 24 lessons ⏱ 9 to 15 h ⚡ 480 credits included

74,70 €

48,90 excl. VAT

Savings : 25,80 €

13 Level 5

Building Reusable, Secure, and Integrable SQL

organizing reusable, secure data access for applications and teams

Creating and using SQL views Using temporary tables and intermediate objects Organizing reusable, documented queries Discovering functions and stored procedures across engines Managing users, roles, and privileges Understanding how SQL injection works Using parameterized queries from an application Workshop: building reliable, secure data access

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 160 credits included

14 Level 5

SQL for Data, BI, and Analytics

building datasets and SQL indicators ready for analysis and visualization

Turning a business question into an analytical dataset Building KPIs with SQL Comparing periods and handling analysis dates Calculating growth rates and variations Building Top N lists, rankings, and running totals Segmenting and categorizing populations Preparing a controlled dataset for Power BI or BI tools Workshop: producing an indicator set ready for a dashboard

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 160 credits included

15 Level 5

Complete Professional SQL Project

mobilizing the full range of SQL skills on an end-to-end professional case

Scoping the need and the rules of the professional case Modeling the project's database Creating the schema, tables, and constraints Loading and modifying data in a controlled way Building queries, joins, and aggregations Using CTEs and window functions Optimizing, securing, and preparing the analytical dataset Final workshop: presenting and defending the SQL solution

📚 8 lessons ⏱ 3 to 5 h 🎯 Quiz included ⚡ 160 credits included