postgre sql

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