About course
This course teaches you SQL step by step. You will learn how to read data with SELECT, filter with WHERE, sort with ORDER BY, and group with GROUP BY and HAVING. You will join tables, use subqueries, write simple window functions, and create views and CTEs. You will also learn to insert, update, and delete data safely, understand keys and indexes, and read query plans at a basic level. The focus is on clear, simple queries that solve real problems.
Course format: Self-paced recorded sessions
Language: English
Projects included: 3 hands-on projects — Online Store Sales Report, Marketing Campaign Analysis, Customer Orders Dashboard
Duration: ~15 hours of video + practice files
Level: Beginner to Intermediate
Key Skills
- Core querying: SELECT, WHERE, ORDER BY, LIMIT/OFFSET
- Grouping and totals: GROUP BY, HAVING, aggregates (SUM, COUNT, AVG, MIN, MAX)
- Joins: INNER, LEFT, RIGHT, FULL (with examples)
- Subqueries and CTEs (WITH) for cleaner logic
- Window functions basics: ROW_NUMBER, RANK, PARTITION BY, ORDER BY
- Text, number, and date functions (CASE, COALESCE, TRIM, CONCAT, DATE functions)
- Data changes: INSERT, UPDATE, DELETE (with safeguards)
- Table design basics: keys, constraints, normalization
- Views, indexes, and simple performance tips (EXPLAIN, avoid SELECT *)
- Works with popular SQL flavors: PostgreSQL, MySQL, SQL Server (notes on syntax differences)
