ByteTrail

Level 6 · Module 26

SQL

A structured module covering the essential ideas of sql.

Difficulty
intermediate
Published path
10 lessons · 100 min

What you will learn

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • JOIN
  • GROUP BY
  • Subqueries
  • CTE
  • Window functions
  • Transactions
Prerequisites:Database Fundamentals

Start here

Lessons · 100 min

  1. SELECTPlanned

    Planned lesson: SELECT. This lesson has not been written yet.

    10 min · intermediate

  2. INSERTPlanned

    Planned lesson: INSERT. This lesson has not been written yet.

    10 min · intermediate

  3. UPDATEPlanned

    Planned lesson: UPDATE. This lesson has not been written yet.

    10 min · intermediate

  4. DELETEPlanned

    Planned lesson: DELETE. This lesson has not been written yet.

    10 min · intermediate

  5. JOINPlanned

    Planned lesson: JOIN. This lesson has not been written yet.

    10 min · intermediate

  6. GROUP BYPlanned

    Planned lesson: GROUP BY. This lesson has not been written yet.

    10 min · intermediate

  7. SubqueriesPlanned

    Planned lesson: Subqueries. This lesson has not been written yet.

    10 min · intermediate

  8. CTEPlanned

    Planned lesson: CTE. This lesson has not been written yet.

    10 min · intermediate

  9. Window functionsPlanned

    Planned lesson: Window functions. This lesson has not been written yet.

    10 min · intermediate

  10. TransactionsPlanned

    Planned lesson: Transactions. This lesson has not been written yet.

    10 min · intermediate

What you will cover

Module units

  1. SELECT

    A planned unit covering SELECT.

  2. INSERT

    A planned unit covering INSERT.

  3. UPDATE

    A planned unit covering UPDATE.

  4. DELETE

    A planned unit covering DELETE.

  5. JOIN

    A planned unit covering JOIN.

  6. GROUP BY

    A planned unit covering GROUP BY.

  7. Subqueries

    A planned unit covering Subqueries.

  8. CTE

    A planned unit covering CTE.

  9. Window functions

    A planned unit covering Window functions.

  10. Transactions

    A planned unit covering Transactions.