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
Program
Basic SQL commands: DDL, DML
Principle of transactions
Triggers (trigger)
Stored procedures
Views
Workshop: simple exercises
Installation and configuration
Basic security
Workshop: practical examples
PHP functions associated with MySQL, and particular relationship between the two
Installation and configuration
Basic security
Workshop: practical examples
PHP functions associated with PostgreSQL, and other languages
Comparison based on the elements noted
Other interesting differences
Presentation of other database systems for UNIX, Linux, OSX
Passing of the certification (if foreseen in the financing)
Duration
3 days
Price
£ 1193
Audience
Everyone
Prerequisites
Knowledge of Unix
Reference
BAS42-F
Sessions
Contact us for more informations about session date