Course outline
What you will learn
1
Databases and tables
Understand how data is organised in tables, rows and columns, and how databases are structured.
2
Querying data
Write SELECT queries with filtering, sorting and limits to find exactly what you need.
3
Joining tables
Combine data from several tables with INNER, LEFT and other joins.
4
Aggregations and grouping
Count, sum and average data with GROUP BY and HAVING to produce summary reports.
5
Subqueries, CTEs and window functions
Solve more complex problems such as rankings and running totals.
6
Capstone project
Answer a set of real business questions using a multi-table database.
Who it is for
- Aspiring data analysts and business intelligence professionals
- Excel and Power BI users who want to work with larger data
- Developers and students who need database skills
- Anyone whose work depends on getting data out of systems
Before you start
- Basic computer skills
- No coding experience needed
- A laptop; we will guide you through free software setup
Course fee
[PRICE] per learner
Group and corporate rates are available on request.
Explore our other courses