← Back to courses
Data Science and AI
Comprehensive MySQL
From basics to advanced
From CRUD to indexing, stored procedures, triggers, views and performance tuning — the database knowledge any developer role expects.
8Modules
BeginnerLevel
3 monthsDuration
What you will be able to do
Relational database concepts and MySQL setup
SELECT, INSERT, UPDATE, DELETE — every kind of query
JOINs, subqueries and aggregation
Speed up queries with indexes
Stored procedures, functions and triggers
Backup, recovery and performance tuning
Course outline
01
Introduction to databases and MySQL
02
Basic SQL
03
Data types and constraints
04
Data manipulation and advanced queries
05
Transactions
06
Indexing and query optimisation
07
Stored procedures, triggers and views
08
Backup, recovery and the final project
Tools you will use
MySQLMySQL WorkbenchSQL
What you need
General computer use
