Aller au contenu principal
Pouyam Pouyam
S'inscrire Connexion
Académie
Débutant Quartier du code

SQL

Posez n'importe quelle question à vos données.

SQL is the language of databases. Every post, like and game score in an app like Nova lives in database tables, and SQL is how you ask those tables questions. This track starts from zero: reading tables with SELECT, filtering and sorting, counting and grouping, joining tables, changing data safely, designing your own tables, and finally subqueries, CTEs and window functions.

Every lesson works with the same small dataset from Nova, a made-up social app (users, posts, likes and scores) and shows the exact result of every query, so you always know what answer to expect.

Leçons
25
Durée
3 h
Niveau
Débutant
Commencer le parcours · What is a database?

Les leçons de ce parcours sont en anglais pour le moment.

  • Bronze disponible
  • Argent disponible
  • Or verrouillé

Envie de faire vos preuves ?

Trois examens vous attendent : Bronze, Argent et Or.

Aller aux examens

Ce que vous saurez faire

  • Read and filter any table with SELECT and WHERE
  • Summarize data with COUNT, SUM, AVG, GROUP BY and HAVING
  • Combine tables with INNER JOIN and LEFT JOIN
  • Insert, update and delete rows safely inside transactions
  • Design tables with keys, constraints and indexes
  • Build a leaderboard with subqueries, CTEs and window functions

L'itinéraire

  1. 1
    Module 1

    Databases and tables

    What a relational database is, how tables are built, and your first SELECT.

    0 / 3
    2. Your first SELECT Leçon · 7 min · +20 XP
    3. Practice: first queries Entraînement · 5 min · +20 XP
  2. 2
    Module 2

    Filtering and sorting

    Keep only the rows you want, handle NULL correctly and put results in order.

    0 / 4
    1. Filtering with WHERE Leçon · 7 min · +20 XP
    2. Patterns and NULL Leçon · 7 min · +20 XP
    3. Sorting and paging Leçon · 6 min · +20 XP
    4. Boss: filter and sort Combat de boss · 7 min · +40 XP
  3. 3
    Module 3

    Aggregation

    Turn many rows into answers: counts, totals, averages and groups.

    0 / 3
    1. Counting and totals Leçon · 7 min · +20 XP
    2. GROUP BY and HAVING Leçon · 8 min · +25 XP
    3. Practice: the numbers Entraînement · 6 min · +25 XP
  4. 4
    Module 4

    Joins

    Combine tables: match rows, keep the unmatched ones and find what is missing.

    0 / 3
    1. Inner joins Leçon · 8 min · +25 XP
    2. Left joins and missing rows Leçon · 8 min · +25 XP
    3. Boss: joins Combat de boss · 8 min · +45 XP
  5. 5
    Module 5

    Changing data

    Add, change and remove rows, and use transactions so mistakes can be undone.

    0 / 4
    1. Adding rows with INSERT Leçon · 7 min · +20 XP
    2. UPDATE and DELETE Leçon · 7 min · +20 XP
    3. Transactions Leçon · 7 min · +25 XP
    4. Practice: changing data Entraînement · 6 min · +25 XP
  6. 6
    Module 6

    Designing tables

    Create tables with the right types, protect them with constraints and speed them up with indexes.

    0 / 4
    1. Creating tables Leçon · 7 min · +20 XP
    2. Constraints and foreign keys Leçon · 8 min · +25 XP
    3. Indexes Leçon · 7 min · +20 XP
    4. Boss: table design Combat de boss · 7 min · +45 XP
  7. 7
    Module 7

    Powerful queries

    Subqueries, EXISTS, CTEs, CASE and window functions for real leaderboards.

    0 / 4
    1. Subqueries and EXISTS Leçon · 8 min · +25 XP
    2. WITH and CASE Leçon · 7 min · +25 XP
    3. Window functions Leçon · 8 min · +25 XP
    4. Final boss Combat de boss · 10 min · +50 XP

Navigation rapide

ExplorerAcadémieExamensActualitésVidéosReelsMusiqueJeuxAIStudioTraduireChatSalonClassementParrainagePortefeuilleAidez une pattePoke WorldBlogBoutiqueParamètres