MySQL Training
MySQL
MySQL is a relational database management system based on SQL Structured Query Language.
French / English
Certificate
Overview
MySQL is an Oracle-backed open source relational database management system (RDBMS) based on Structured Query Language (SQL). MySQL runs on virtually all platforms, including Linux, UNIX and Windows. MySQL is an important component of an open source enterprise stack called LAMP.
Prerequisites
Have basic knowledge of relational databases
Goals
Identify the characteristics of a well-designed database.
Build a relational database.
Training Program
1- Design a Database
- Design the tables and fields that will constitute a database
- Choose the right data types for the data
- Data integrity: prevent the database from collapsing
- Optimize data recovery time through indexing
- Choose the right data types for the data
- Data integrity: prevent the database from collapsing
- Optimize data recovery time through indexing
2- Build an Maintain your DataBase
- Communicate with your database using basic SQL
- Fill and manage your tables
- Modify data: INSERT, UPDATE, DELETE
- Practice creating an employee database
- Fill and manage your tables
- Modify data: INSERT, UPDATE, DELETE
- Practice creating an employee database
Project
The implementation of a relational database intended to support a messaging application
