Description

Course Duration: 6 Day(s)

Objectives

The MySQL for Database Administrators course is for MySQL DBAs and other professionals who want to install and optimize MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases.

Highlights

  • MySQL Architecture
  • MySQL Clients and Tools
  • Database Basics
  • Database Design
  • Data Types
  • Database And Table Creation
  • Manipulating Table Data
  • Querying Table Data
  • Database And Table Maintenance
  • Joins
  • Sub-Queries
  • Function
  • Exporting And Importing Data
  • Creating And Managing Views
  • Prepared Statements
  • Stored Routines
  • Managing Stored Routines
  • Handling Exceptions And Errors
  • Creating And Managing Triggers
  • Data Security In MySQL
  • Best Practices

Who Should Attend

Participants attending this course must have:

  • Concepts of Relational Database Design & Implementation
  • Working Experience/Knowledge of SQL

Target Audience

Developers