SQL
Query, aggregate, join, and analyze relational data with confidence.
Master structured querying: SELECT, WHERE, JOINs, GROUP BY, subqueries, window functions, and data manipulation.
45 days
Beginner to Intermediate
Live online · One-to-one available · Group batches when scheduled
1-on-1 & small cohorts
Course overview
SQL is the universal language of data. This hands-on course teaches querying from simple filters to complex multi-table JOINs, aggregations, nested subqueries, CASE statements, and data modification (INSERT, UPDATE, DELETE). Essential for developers and data analysts alike.
Try a SQL starter exercise
A practical first task you can try independently, without registration or payment. These instructions are for self-study; they are not a free live class or a downloadable project.
Your task
Write a query that filters completed orders.
- Imagine an orders table with id, status and total columns.
- Write SELECT with a WHERE clause for completed status.
- Add ORDER BY total DESC to show largest orders first.
Check your result: The query filters before ordering and returns the expected columns.
Free projects to practice this course
Open a hands-on starter kit with runnable example code, project milestones and a downloadable checklist. No signup or tuition is required for the guide.
- SQL Library Database: Tables, Keys & JOINs
Beginner · Databases & SQL
- PostgreSQL Orders: Reporting & Query Plans
Intermediate · Databases & SQL
- Python Tkinter Student Registration Form
Beginner · Desktop Applications
What you'll achieve
Core competencies developed through practical implementation and project work.
- Write efficient SQL queries to extract and filter large datasets
- Combine data across multiple tables using INNER, LEFT, RIGHT, and FULL JOINs
- Perform aggregations and group-level calculations with GROUP BY and HAVING
- Use subqueries, CTEs (Common Table Expressions), and window functions
Chapters, Core Topics & Guided Tasks
Every chapter closes with a guided implementation task. The complete course ends with one portfolio-ready capstone project.
Curriculum Validation Basis
Core chapters are cross-checked against current official technology documentation and authoritative standards or academic references.
- Chapter 01
Relational Query Foundations
Core topics
- SELECT and aliases
- WHERE and operators
- ORDER BY and LIMIT
Guided chapter task
Answer a set of filtered business questions from one table.
- Chapter 02
Aggregation & Grouping
Core topics
- Aggregate functions
- GROUP BY
- HAVING and conditional aggregation
Guided chapter task
Produce a KPI summary by category, month, or customer segment.
- Chapter 03
Multi-Table Queries
Core topics
- INNER and OUTER JOINs
- Self and many-to-many joins
- NULL-safe reasoning
Guided chapter task
Combine a normalized sales or admissions dataset into one report.
- Chapter 04
Subqueries, CTEs & Set Operations
Core topics
- Scalar and correlated subqueries
- Common table expressions
- UNION, INTERSECT, and EXCEPT
Guided chapter task
Refactor a complex report into readable CTE steps.
- Chapter 05
Window Functions
Core topics
- ROW_NUMBER and RANK
- Running totals
- Partitioned comparisons
Guided chapter task
Build customer ranking and period-over-period analysis queries.
- Chapter 06
Data Definition & Transactions
Core topics
- CREATE and ALTER
- INSERT, UPDATE, and DELETE
- Constraints and transaction control
Guided chapter task
Create a small schema and execute a safe multi-step update transaction.
Complete Course Capstone
Portfolio Project
Complete an e-commerce or academy SQL case study with schema, analytical queries, and a business findings report.
Prerequisites & Prior Knowledge
Recommended background before starting this course. Mentors adapt pacing to your current level.
Who is this course for?
Aspiring developers, data analysts, students, and professionals working with data.
Hands-on Learning Format
- Live interactive screen-sharing
- 1-on-1 personalized instruction
- Practical, portfolio-ready code
Contact admissions for current fee and available learning formats
Enrol in SQL
Start with a 1-on-1 trial session to discuss your technical goals with an instructor.
- Duration: 45 days
- Level: Beginner to Intermediate
- Delivery: Live online · One-to-one available · Group batches when scheduled
- Format: 1-on-1 & small cohorts
* Free Demo is a 1-on-1 trial session, not the complete course.
Related Technical Courses
Database Fundamentals
Normalization, ACID properties & relational design
Learn relational database concepts, entity-relationship diagrams (ERDs), normalization, primary/foreign keys, and data integrity.
- database fundamentals course
- learn database design
- erd normalization
PostgreSQL
Advanced indexing, JSONB queries & query optimization
Learn the world's most advanced open-source database: PostgreSQL schema design, indexing, transactions, and JSON data.
- postgresql course
- learn postgres
- advanced postgresql jsonb
MySQL
Engine architecture, transactions & replication
Learn MySQL database configuration, relational table creation, indexing, stored queries, and backup/restore workflows.
- mysql course
- learn mysql database
- mysql workbench tutorial
Ready to start your learning journey?
Apply today and our admissions team will review your application and guide you through the next steps.