Open Source mySQL and PostGreSQL databases have become essential today and compete legitimately with proprietary Oracle and SQL Server databases.
PostgreSQL, created in 1995, but whose foundations date back to 1985, ranks among the heavyweights in the world of databases. Supporting most of the functionalities expected from a DBMS (and in particular support for XML, JSON, etc.), PostgreSQL has been able to evolve at the same rate as its competitors, and is today essential, especially in the world of geographic information systems (GIS), with its PostGIS extensions. The community is delivering version 9.3 of its software to us today, and it’s tough:
- Validating data pages (detecting disk errors)
- Fast hot switch between master and slave (less than a second
- New management functions for the JSON format
- Management of automatically updating views
- Parallelization of backups with pg_dump
- Side joints
MySQL / MariaDB : Administration
Duration : 3 days
Goals :
- Master the administration of a MySQL / MariaDB database serverMySQL Use : database creation, queries and optimizations
Duration : 3 days
Goals :
- To be able to create optimized MySQL databases
- To master data query with SQLMySQL : implementation and administration
Duration : 3 days
Goals :
- Master the administration of a MySQL database serverPostgreSQL : Administration
Duration : 4 days
Goals :
- Master the current administration actions of PostgreSQLPostgreSQL : Advanced administration
Duration : 3 days
Goals :
- Master the advanced administration actions of PostgreSQLMySQL and PostgreSQL
Duration : 3 days
Goals :
- Knowing how to program in SQL
- Knowing how to install and configure MySQL and PostgreSQL
- Knowing how to use these daemons via PHP
- Knowing when to use one or the other of the daemons