MySQL Core Administration Skills
(MYSQLC, Live Instructor-Led Training, 4 days)


Description

This SETC Certified database course introduces the MySQL Relational Database Management System. Every aspect of MySQL database administration is covered from the creation of relational databases and their tables to the development of powerful SQL scripts to automate primary administrative tasks. This complete course discusses the various security mechanisms that are provided by the MySQL database engine. This course also includes coverage of performance optimization, backup and recovery and indexing amongst others. If you want to implement a MySQL database in your organization, this is the course for you.

Dates and Pricing


Nov 21 to Nov 24, 2017$3,000/person Jan 30 to Feb 2, 2018$3,000/person Feb 27 to Mar 2, 2018$3,000/person Mar 27 to Mar 30, 2018$3,000/person

Outline

RDBMS Essentials
MySQL Relational Database Management System
MySQL Terminology
MySQL Database Terminology
Application Development and MySQL
MySQL OLAP and OLTP
MySQL Tools
The Role of MySQL in the Enterprise
Other MySQL Services
Installing MySQL
MySQL 5.0 Installation Overview
The Server Hardware
Installing MySQL
Configuring MySQL Server
Creating the Database
Data Storage Architecture
Creating/Deleting Database Files
Optimizing Data Storage
Importing Data
SQL Programming for MySQL Administrators
MySQL Data Types
Creating Tables
Retrieving Data: The Basic SELECT Statement
Executing SQL Scripts
Using Built-In Database Functions
System Databases/Tables
MySQL Security/User Account Administration
MySQL Security Overview
Planning Security
Configuring MySQL Server Accounts
Securing the Server
Optimizing Database Integrity
Implementing Database Integrity
Domain Integrity
Entity Integrity: Primary Keys
Referential Integrity: Foreign Keys
Retrieving Table and Database Information
Optimizing Database Maintenance and Performance
Combining/Retrieving Top N Table Data
Table Maintenance
Retrieving Aggregate Data Values
Modifying Data: Inserting/Updating/Deleting
Join Strategies: Selecting From Multiple Tables
Sub-Queries
Creating and Using Functions
User Variables
Stored Procedures
Transactions and Performance
Using Transactions
Transactional Locks and Deadlocks
Indexes
Index Architecture
Planning Indexes
Logging, Backup and Recovery
MySQL Server Logging
Fault Tolerance and MySQL Database Backups
Topic 3: Database Recovery