Skip to content

100% free · Certificate included

Learn SQL & Databases. Step by step in 12 hours.

Query, design and optimise relational databases — the skill every developer and analyst needs. Short lessons, a quiz after every module and real coding challenges. Stop anytime — your progress is saved and resumes exactly where you left off.

of guided learning
12 hrs
of guided learning
modules
12
modules
quiz questions
75
quiz questions
coding challenges
12
coding challenges

Syllabus

What you'll learn

  1. 01

    Introduction to Databases

    What databases are, how relational tables work and what SQL does.

    • What is a database?
    • Tables, rows, columns and keys
    • What SQL does
    • Quiz + challenge

    ≈ 60 min

  2. 02

    Creating Tables

    CREATE TABLE, data types, constraints, ALTER and DROP.

    • CREATE TABLE and data types
    • Constraints
    • ALTER, DROP and TRUNCATE
    • Quiz + challenge

    ≈ 60 min

  3. 03

    Inserting & Modifying Data

    INSERT, UPDATE and DELETE safely.

    • INSERT
    • UPDATE
    • DELETE
    • Quiz + challenge

    ≈ 60 min

  4. 04

    Querying with SELECT

    Filter, sort and limit results.

    • SELECT and WHERE
    • IN, BETWEEN, LIKE and NULL
    • ORDER BY, LIMIT and DISTINCT
    • Quiz + challenge

    ≈ 60 min

  5. 05

    Functions & CASE

    Aggregate, string, numeric and date functions plus conditional logic.

    • Aggregate functions
    • String, number and date functions
    • CASE expressions
    • Quiz + challenge

    ≈ 60 min

  6. 06

    Grouping Data

    GROUP BY, HAVING and building summary reports.

    • GROUP BY
    • HAVING
    • Multi-column grouping and rollups
    • Quiz + challenge

    ≈ 60 min

  7. 07

    Joins

    Combine tables with INNER, LEFT, RIGHT, FULL, self and cross joins.

    • INNER JOIN
    • LEFT, RIGHT and FULL OUTER JOIN
    • Multiple, self and cross joins
    • Quiz + challenge

    ≈ 60 min

  8. 08

    Subqueries & CTEs

    Queries inside queries, EXISTS and WITH clauses.

    • Subqueries
    • Correlated subqueries and EXISTS
    • Common Table Expressions (WITH)
    • Quiz + challenge

    ≈ 60 min

  9. 09

    Set Operations & Views

    UNION, INTERSECT, EXCEPT and reusable views.

    • UNION and UNION ALL
    • INTERSECT and EXCEPT
    • Views
    • Quiz + challenge

    ≈ 60 min

  10. 10

    Database Design & Normalization

    Model data with ER diagrams, relationships and normal forms.

    • Relationships and ER modelling
    • Normalization: 1NF, 2NF, 3NF
    • Anomalies, denormalization and good naming
    • Quiz + challenge

    ≈ 60 min

  11. 11

    Transactions & Indexes

    ACID transactions, isolation and making queries fast.

    • Transactions and ACID
    • Concurrency and isolation levels
    • Indexes and query performance
    • Quiz + challenge

    ≈ 60 min

  12. 12

    Advanced SQL

    Window functions, stored procedures, triggers and SQL security.

    • Window functions
    • Stored procedures and triggers
    • Security and SQL injection
    • Quiz + challenge

    ≈ 60 min

  13. Final exam & certificate

    15 questions across the whole course. Score 70% or more to download your certificate of completion from Journify Technologies — and add it to LinkedIn.

Your certificate

Finish the course. Get certified.

Pass the final exam and download a certificate of completion from Journify Technologies — with your name, college, score and a unique certificate ID.

  • Download as image (PNG) or PDF
  • Add it to your LinkedIn profile in one click
  • Free — no hidden charges

Enroll for free

Start the course in 30 seconds

Enter your details once. They're printed on your certificate, and your progress is saved automatically — close the tab anytime and continue exactly where you left off.

  • No sign-up or password
  • Auto-saves after every lesson
  • Free certificate from Journify Technologies