Our Online Continuing Education programs include the final exam and deliver a dated certificate and professional seal. Optional CE / CME credit for select titles is also included. Browse categories or use the Search products box.
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.