COURSE DESCRIPTION: MySQL is one of the most popular systems for managing databases. This course covers SQL language syntaxes as well as advanced functionalities of servers. MySQL is a flexible, open code system available to everyone. This system enables data specialists to manage daily tasks quickly and efficiently.

Learning Objectives:

- Introduction to databases

- Installation

- Database design

- MySql Workbench

- Creating the first database

- MySQL - Data Types

- Primary and foreign keys

- Introduction to SQL

- Variables & Operators in MySQL

- Connecting data

- Indexes and Views

- Stored routines

- Built-in functions

- Cursors and triggers

- Transactions

- Users and access

- MySql Security

- Connections

- Replication

- Backup and Migration

AVERAGE STUDY TIME: 5-6 HOURS

Completion of this course delivers a 4PRO+ CERTIFICATE OF PROFICIENCY and includes a BADGE/SEAL for the Certificate of MySQL Database Proficiency (4CBEDP) course which has been reviewed and approved by the 4ProPlus Educational and Technical Advisory Boards.