Tell us what you'd like to learn

Takes under a minute. Our team will call or WhatsApp you with upcoming batch dates that suit your schedule.

About you
What are you interested in?
About this course · 24 hours

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