TypeClassroom Training
Time4 Days
REGISTER

Contact Us

Fields marked with an * are required
MySQL Training Course & Certification

MySQL Training Course & Certification

Description

Audience & Prerequisites

Certification

MySQL Training Course Overview

The MySQL Quickstart Fundamentals Self-Study Course will teach you about core MySQL Server Technologies. You’ll learn how to perform basic installation, navigate to system and data file locations, use administration and performance management tools and more.

  • Install and start MySQL.
  • Identify the MySQL architecture.
  • Develop a basic understanding of relational databases.
  • Gain familiarity with administrative tools for MySQL

Objectives of MySQL Training

  • Understand MySQL storage engines, transactions and features of the common engines
  • Understand the features and benefits of MySQL
  • Gain the experience to install and start the MySQL server
  • Understand the basics of Relational Databases
  • Acquire the ability to use Data/Column types with regard to efficient database design
  • View a database design structure/content
  • Gain familiarity with Administration Tools for MySQL
  • Gain understanding of the Backup Recovery concepts
  • Introduction to High Availability

Prerequisites for MySQL Certification

  • Basic computer literacy is required.
  • Previous experience with any command-line program.
  • Knowledge of database concepts.

Intended Audience of MySQL Course

Section 1Introduction to MySQL
Lecture 1MySQL Course Overview
Lecture 2MySQL Products and Service
Lecture 3MySQL Community Edition vs. MySQL Enterprise Edition
Lecture 4MySQL Product Releases
Section 2MySQL Architecture
Lecture 5My SQL Architecture Overview
Lecture 6Storage Engine Concept
Lecture 7Locks
Lecture 8MySQL Architecure Summary
Section 3MySQL Server
Lecture 9My SQL Binary Distributions
Lecture 10MySQL Source Distributions
Lecture 11Loading Time Zone Tables
Lecture 12MySQL and Windows
Lecture 13MySQL and Linux
Lecture 14Improve MySQL Installation Security
Section 4Configuring MySQL Server
Lecture 15MySQL Configuration
Lecture 16Option Files
Lecture 17Dynamic Server Variables
Lecture 18SQL Mode
Lecture 19Log and Status Files
Lecture 20Binary Log
Section 5Schema Design
Lecture 21Database Modeling
Lecture 22Normalization
Lecture 23Denormalization
Lecture 24Data Types
Lecture 25Partitioning
Section 66. Metadata Data and NEW_PERFORMANCE Schema
Lecture 26Metadata Access Methods
Lecture 27The INFORMATION_SCHEMA and MySQLDatabases
Lecture 28New PERFORMANCE_Schema
Lecture 29Using SHOW and DESCRIBE
Lecture 30The mysqlshow Client
Section 77. Introduction to Storage Engines
Lecture 31Storage Engine Overview
Lecture 32MyISAM, InnoDB, and MEMORY Storage Engines
Lecture 33Other Storage Engines
Lecture 34Choosing Appropriate Storage Engines
Lecture 35Using Multiple Storage Engines
Lecture 36Storage Engine Comparison Chart
Section 8MySQL Clients and Administrative Tools for MySQL
Lecture 37Overview of Administrative Clients
Lecture 38Invoking MySQL Client Programs
Lecture 39Using the Mysql Client
Lecture 40The mysqladmin Client
Lecture 41MySQL Administration tools
Section 99. Backup and Recovery Concepts and Tools
Lecture 42Backup Recovery Concept
Lecture 43Row and Statement level Logging
Lecture 44Types of Backups
Lecture 45Backup Tools
Lecture 46Data Recovery
Section 10Replication
Lecture 47MySQL Replication in Action on the Web
Lecture 48Designing for High Availability
Lecture 49MySQL Replication Overview
Lecture 50MySQL Replication features
Lecture 51Getting started with Replication