Courses

SQL for Data Professionals

Learn SQL the way data professionals actually use it: to ask questions of real data, combine tables, summarise results and prepare data for reporting and analysis.

Enquire about this course

About this course

Learn SQL the way data professionals actually use it: to ask questions of real data, combine tables, summarise results and prepare data for reporting and analysis. Starting from the basics, you progress to joins, subqueries and window functions through hands-on exercises. The skills transfer across MySQL, PostgreSQL and SQL Server. Suitable for analysts, testers, developers and anyone who works with data; no prior SQL is needed.

Course content

1Relational database basics
  • Tables, rows, keys and relationships
  • Installing a database and a query tool
  • Reading a schema and an ER diagram
2Querying data
  • SELECT, WHERE, ORDER BY and LIMIT
  • Operators, pattern matching, NULL handling
  • Functions for text, numbers and dates
3Summarising data
  • Aggregate functions, GROUP BY and HAVING
  • Counting, distinct values and conditional aggregation
4Combining tables
  • Inner, left, right and full joins
  • Self joins and cross joins
  • UNION and set operations
5Subqueries and CTEs
  • Subqueries in WHERE, FROM and SELECT
  • Common table expressions and readable queries
  • Choosing between a join and a subquery
6Window functions
  • ROW_NUMBER, RANK and DENSE_RANK
  • Running totals, moving averages, LAG and LEAD
  • Top-N per group and period-over-period analysis
7Changing data and structure
  • INSERT, UPDATE and DELETE; transactions
  • Creating tables, constraints and keys
  • Views and basic data-quality checks
8Performance and good practice
  • Indexes and reading an execution plan (introduction)
  • Writing efficient, maintainable queries
9Capstone project
  • Answer a set of business questions on a realistic database and present the findings

Upcoming batches

Loading upcoming batches…

Frequently asked questions

Do I need any prior SQL knowledge?

No. The course starts from relational database basics and is suitable for analysts, testers, developers and anyone who works with data.

Which database does the course use?

The skills you learn transfer across MySQL, PostgreSQL and SQL Server, so you can use them on whichever database your work uses.

What topics does the course cover?

You learn querying and filtering, aggregation with GROUP BY, joins, subqueries and common table expressions, window functions, changing data and structure, and an introduction to indexes and query performance.

Will I practise on realistic data?

Yes. The course is taught through hands-on exercises and ends with a capstone where you answer a set of business questions on a realistic database and present your findings.

How long is the course and will I get a certificate?

The course is 24 hours across 9 modules, taught through live, trainer-led, hands-on sessions. Eligible students receive an Omega Academy certificate with a verification code that anyone can check online.

How to join

  1. Enquire: send a short enquiry for this course or a specific batch.
  2. Talk to us: our team calls you to confirm the batch, timing and fees.
  3. Learn: attend live, hands-on sessions with practical exercises.
  4. Get certified: eligible students receive a certificate that can be verified online.