🗄️
Course Overview
Data runs the world. Learn how to design databases and write powerful SQL queries with MySQL — a must-have skill for developers, analysts and IT professionals.
What You Will Learn
- Design well-structured databases
- Write SQL queries with confidence
- Join and analyse large datasets
- Manage data in MySQL
Course Curriculum
- Database ConceptsTables, keys, relationships and normalisation.
- SQL BasicsSELECT, INSERT, UPDATE and DELETE.
- Filtering & SortingWHERE, ORDER BY, LIMIT and operators.
- Joins & RelationshipsINNER, LEFT, RIGHT joins and subqueries.
- Functions & GroupingAggregate functions, GROUP BY and HAVING.
- Project & OptimisationIndexes, views and a database project.
Who Is This Course For?
Developers, data analysts and IT students.