Goals
- To be able to create optimized MySQL databases
- To master data query with SQL
Program
Relational databases (BDD)
Comparison of
MySQL database management systems : presentation, versions
MySQL storage engines: MyISAM, InnoDB, …
Basic configuration of the MySQL server
Administration tools: heavy or light client (web ))
Workshop: installation of the MySQL server, configuration, choice of the administration tool
MySQL objects: table, view, procedure, keys, index, trigger, … Relations between tables Partitioning of a table: horizontal, vertical Optimization of the structure
Workshop: multiple database schemas
Queries to create / modify a database, character encoding
Data types: standards, MySQL specific
Creation and modification of tables
Constraints, default values
Key management: primary, foreign
Setting up index
Triggers
Insertion of data, modifications , deletion
Transaction management
Import, export (dump) of data
Workshop: creation of a complete database and data manipulation
Data selection, restriction, projection, calculations
Subqueries
Union of queries
Multiple joins
Queries on temporary tables
Pivot
Creating views
Creating and using functions
Stored procedures
Optimizing queries
Workshop: multiple interrogation requests, creation of stored procedures
Duration
3 days
Price
£ 1634
Audience
Junior Database Administrators, Developers
Prerequisites
None
Reference
BAS1021-F
Sessions
Contact us for more informations about session date