From relational modelling to MySQL/MariaDB administration. Master design, complex queries and running a database in production.
What is a database? The relational model, conceptual/logical data models, normal forms.
Data types, constraints (primary key, foreign key, NOT NULL, UNIQUE), referential integrity.
CREATE, ALTER, DROP — SELECT, WHERE, ORDER BY, LIMIT and data projection.
INSERT, UPDATE, DELETE — best practices, transactions and safe writes.
INNER JOIN, LEFT/RIGHT JOIN, correlated and non-correlated subqueries.
Aggregate functions: COUNT, SUM, AVG, GROUP BY, HAVING, window functions.
Installing and fully mastering the phpMyAdmin interface.
Managing users and privileges, export/import, backups, stored routines.
Designing a complete database (shop, blog, stock management) end to end.
Indexes, query optimisation, execution plans, presentation and certificate.
Ready to master databases?