Introduction and getting started
- Versions, overview of features and tools.
- Resources and documentation.
- Installation procedure.
- Post-installation settings and first tests.
- The mysql command line client tool.
- The MySQL Query Browser graphical tool.
Relational model, designing and creating a database
- Design elements of a database schema
- Integrity constraints.
- MySQL data types (digital, chains, dates, specific types, etc.).
- Integrated MySQL functions.
- Types of tables (MyISAM, MEMORY, MERGE, InnoDB, etc.).
- Creating databases and tables.
- The INFORMATION_SCHEMA database.
- Character sets, internationalization.
Hands-on work
Designing and creating a database with MylSAM tables.
Using SQL with MySQL
- Single selections, comparisons, sorts.
- Multitable selections, different types of joins.
- Embedded queries, prepared queries.
- Changes and view management.
Hands-on work
Single selections, Multiple selections, internal and external joins, embedded requests. Data changes and deletions.
InnoDB transactional tables
- Notion of a transaction, isolation levels.
- Physical structure of tables.
- Transaction programming (START TRANSACTION, COMMIT, ROLLBACK).
Hands-on work
Implementing transactions
Procedural SQL
- Stored procedures and functions.
- Defining procedures Triggers.
- Managing errors.
Hands-on work
Writing stored procedures. Retrieving results using cursors. Creating and using triggers.
Connections, access rights, security
- Privilege levels and verifying rights.
- Managing users and their privileges.
- Making stored procedures and views secure.
Hands-on work
Managing privileges and passwords.
Introduction to administration
- Exporting data.
- Back-ups, the mysqldump command.
- Overview of MySQL installation.
Hands-on work
Exporting data.
3d
- 21h00 
