This core SQL course covers querying, filtering, joins, aggregations, and writing efficient queries for relational databases. You’ll practise SELECT queries, multi-table joins, group and aggregate functions, and basic optimisation patterns to handle medium-sized datasets. The curriculum includes sample databases and exercises useful for analysts and developers alike.
- Skills you’ll learn: SELECT queries, joins, aggregations, GROUP BY usage, query optimisation basics.
Certificate: Certificate of completion provided upon finishing the course.
Requirements
- Access to a SQL environment or sample database; basic comfort with command lines or query editors.
Who this course is for
- Data analysts; BI professionals; developers; students.
Benefits
- Write SELECT queries with filters; join multiple tables correctly; aggregate and group data; optimize simple queries; understand indexes at a basic level.
Programming Foundations Databases
PHP with MySQL Essential Training 1 The Basics
MySQL for Non-Programmers