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

Oracle Training


Had a great time and learned a lot, as I always do with your courses.
Comment from Employment and Social Development 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