← Back to training
Training plan · Development · Beginner to Intermediate
Database Management (MySQL / SQL)
Complete training on relational databases: modeling, SQL, administration and application connectivity.
Duration
3 jours (21h)
Format
On-site
Prerequisites
Basic programming concepts (variables, logic)
Audience
Developers, analysts, IT interns
1
Intro to Relational Databases
0,5j- Concepts: tables, keys, indexes
- Modeling: ER diagram, normalization
- MySQL installation: server, phpMyAdmin, Workbench
- Types: VARCHAR, INT, DATE, TEXT, JSON
- Lab: create customer-orders database
2
SQL Fundamentals
1j- DDL: CREATE, ALTER, DROP, constraints
- DML: SELECT, INSERT, UPDATE, DELETE, joins
- Filtering: WHERE, GROUP BY, HAVING, LIKE, IN
- Functions: COUNT, SUM, AVG, MIN, MAX
- Subqueries: simple, correlated, EXISTS
- Lab: 20 queries with joins and aggregations
3
MySQL Administration
0,5j- Users: CREATE USER, GRANT, REVOKE
- Backup: mysqldump, import, scheduling
- Optimization: indexes, EXPLAIN, slow query
- Lab: automated backup and perf analysis
4
Advanced SQL
0,5j- Views: creation, updates
- Stored procedures: variables, cursors
- Triggers: BEFORE/AFTER, INSERT/UPDATE/DELETE
- Transactions: COMMIT, ROLLBACK, SAVEPOINT
- Lab: stored procedure for monthly report
5
App Connectivity
0,5j- PHP + MySQL: PDO, prepared statements
- Python + MySQL: mysql-connector, pandas
- RESTful API: create a simple API
- Lab: CRUD web app with MySQL
This plan is customizable
Adaptable to your environment (MySQL, MariaDB, PostgreSQL).