
SQL
SQL is the language for asking questions of data in a database. Learn to read, filter, combine and summarise data with confidence.
SQL is the language for asking questions of data in a database. Learn to read, filter, combine and summarise data with confidence.
What You Will Learn
- Tables, rows, columns and keys
- SELECT, WHERE, ORDER BY and LIMIT
- Joins that combine tables correctly
- Grouping, counting and summarising with aggregate functions
- Subqueries, CTEs and window functions
- Creating, inserting, updating and designing tables
What You Will Build
- Answers to real business questions from a sample shop database
- A sales summary report
- A small database you design yourself
Who This Course Is For
Analysts, marketers, developers and anyone who works with data in spreadsheets and wants to go further.
What You Need
No programming needed. Comfort with spreadsheets helps.
How The Course Works
Every course on Skills in Minutes is free and follows the same five sections: Beginner, Intermediate, Advanced, Projects and Go pro. Each lesson is short, ends with a quick quiz and a summary, and builds on the one before. You can stop and return at any time.
Where It Can Lead
- Data analyst
- Business intelligence analyst
- Back-end developer
Results depend on your practice, your goals and your market. This course gives you the skills and a portfolio of practical work to show for it.
Course Outline
Beginner10 lessons
1What a Database Is and Your First SELECT2Choosing Columns, Calculations and Aliases3Filtering Rows with WHERE4NULL: Missing Values and Three-Valued Logic5Sorting and Limiting Results6Counting and Summarising with Aggregate Functions7Grouping Rows with GROUP BY and HAVING8Joining Tables: INNER and LEFT JOIN9Changing Data Safely: INSERT, UPDATE, DELETE and Parameters10Beginner Project: Answering Business QuestionsIntermediate10 lessons
11Subqueries: Queries Inside Queries12Common Table Expressions: Queries in Named Steps13CASE: Decisions Inside a Query14Dates and Text: Functions and Where Databases Differ15Set Operations: UNION, INTERSECT and EXCEPT16Window Functions: Ranking Without Losing Rows17Window Functions: Running Totals, LAG and Moving Averages18Creating Tables: Constraints and Good Design19Indexes and Views: Speed and Reuse20Intermediate Project: A Monthly Sales ReportAdvanced10 lessons
21How Databases Choose a Path: Composite Indexes22Transactions: ACID, Isolation and Locks23Cleaning Messy Data with SQL24Designing a Whole Database25Star Schemas: Fact and Dimension Tables for Reporting26Joins That Multiply: Fan-Out and Double Counting27Backups, Restores and Least Privilege28Professional Life: Selling SQL Work Honestly29Handling SQL Projects: Scope, Critical Path and Change30Capstone: From Messy Export to Trusted ReportQuestions
Which database does the course use?
The examples use standard SQL that works in most databases, with notes where MySQL, PostgreSQL or SQLite differ.
Is SQL still worth learning?
Yes. It has been used for decades and remains a core skill for data and software roles.
Do I need to install anything?
The lessons point you to free tools and online playgrounds so you can practise straight away.
