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
- 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
- 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
- 03
Inserting & Modifying Data
INSERT, UPDATE and DELETE safely.
- INSERT
- UPDATE
- DELETE
- Quiz + challenge
≈ 60 min
- 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
- 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
- 06
Grouping Data
GROUP BY, HAVING and building summary reports.
- GROUP BY
- HAVING
- Multi-column grouping and rollups
- Quiz + challenge
≈ 60 min
- 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
- 08
Subqueries & CTEs
Queries inside queries, EXISTS and WITH clauses.
- Subqueries
- Correlated subqueries and EXISTS
- Common Table Expressions (WITH)
- Quiz + challenge
≈ 60 min
- 09
Set Operations & Views
UNION, INTERSECT, EXCEPT and reusable views.
- UNION and UNION ALL
- INTERSECT and EXCEPT
- Views
- Quiz + challenge
≈ 60 min
- 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
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
Advanced SQL
Window functions, stored procedures, triggers and SQL security.
- Window functions
- Stored procedures and triggers
- Security and SQL injection
- Quiz + challenge
≈ 60 min
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