SETC Training844-434-7382
 Find a Course: 
 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

Oracle Training


The group discussions were helpful and kept me engaged. Instructor was very knowledgeable about many topics. Great course!
Comment from Service Canada

1. Title

  • MySQL Core Administration Skills (MYSQLC, 4 days)
    View PDF

2. Course Pre-requisites

  • Previous database administration experience

3. Target Audience

  • Database administators who want to administer a MySQL database server

4. Dates and Pricing


Nov 21 to Nov 24, 2017$3,350.00/person

5. Outline

Module 1: RDBMS Essentials

Topic 1: MySQL Relational Database Management System

Topic 2: MySQL Terminology

Topic 3: MySQL Database Terminology

Topic 4: Application Development and MySQL

Topic 5: MySQL OLAP and OLTP

Topic 6: MySQL Tools

Topic 7: The Role of MySQL in the Enterprise

Topic 8: Other MySQL Services

Module 2: Installing MySQL

Topic 1: MySQL 5.0 Installation Overview

Topic 2: The Server Hardware

Topic 3: Installing MySQL

Topic 4: Configuring MySQL Server

Module 3: Creating the Database

Topic 1: Data Storage Architecture

Topic 2: Creating/Deleting Database Files

Topic 3: Optimizing Data Storage

Topic 4: Importing Data

Module 4: SQL Programming for MySQL Administrators

Topic 1: MySQL Data Types

Topic 2: Creating Tables

Topic 3: Retrieving Data: The Basic SELECT Statement

Topic 4: Executing SQL Scripts

Topic 5: Using Built-In Database Functions

Topic 6: System Databases/Tables

Module 5: MySQL Security/User Account Administration

Topic 1: MySQL Security Overview

Topic 2: Planning Security

Topic 3: Configuring MySQL Server Accounts

Topic 4: Securing the Server

Module 6: Optimizing Database Integrity

Topic 1: Implementing Database Integrity

Topic 2: Domain Integrity

Topic 3: Entity Integrity: Primary Keys

Topic 4: Referential Integrity: Foreign Keys

Topic 5: Retrieving Table and Database Information

Module 7: Optimizing Database Maintenance and Performance

Topic 1: Combining/Retrieving Top N Table Data

Topic 2: Table Maintenance

Topic 3: Retrieving Aggregate Data Values

Topic 4: Modifying Data: Inserting/Updating/Deleting

Topic 5: Join Strategies: Selecting From Multiple Tables

Topic 6: Sub-Queries

Topic 7: Creating and Using Functions

Topic 8: User Variables

Topic 9: Stored Procedures

Module 8: Transactions and Performance

Topic 1: Using Transactions

Topic 2: Transactional Locks and Deadlocks

Module 9: Indexes

Topic 1: Index Architecture

Topic 2: Planning Indexes

Module 10: Logging, Backup and Recovery

Topic 1: MySQL Server Logging

Topic 2: Fault Tolerance and MySQL Database Backups

Topic 3: Topic 3: Database Recovery

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette