TypeClassroom Training
Time4 Days
REGISTER

Contact Us

Fields marked with an * are required


Upcoming Trainings

There are no upcoming events at this time.

MySQL Training Course & Certification

MySQL Training Course & Certification

Description

Audience & Prerequisites

Course Outline

Schedule & Fees

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

Course Outline                                                  Duration: 4 Days

  1. Introduction to MySQL
    • MySQL Course Overview
    • MySQL Products and Service
    • MySQL Community Edition vs. MySQL Enterprise Edition
    • 4MySQL Product Releases
  2. MySQL Architecture
    • My SQL Architecture Overview
    • Storage Engine Concept
    • Locks
    • MySQL Architecure Summary
  3. MySQL Server
    • My SQL Binary Distributions
    • MySQL Source Distributions
    • Loading Time Zone Tables
    • MySQL and Windows
    • MySQL and Linux
    • Improve MySQL Installation Security
  4. Configuring MySQL Server
    • MySQL Configuration
    • Option Files
    • Dynamic Server Variables
    • SQL Mode
    • Log and Status Files
    • Binary Log
  5. Schema Design
    • Database Modeling
    • Normalization
    • Denormalization
    • Data Types
    • Partitioning
  6. Metadata Data and NEW_PERFORMANCE Schema
    • Metadata Access Methods
    • The INFORMATION_SCHEMA and MySQLDatabases
    • New PERFORMANCE_Schema
    • Using SHOW and DESCRIBE
    • The mysqlshow Client
  7. Introduction to Storage Engines
    • Storage Engine Overview
    • MyISAM, InnoDB, and MEMORY Storage Engines
    • Other Storage Engines
    • Choosing Appropriate Storage Engines
    • Using Multiple Storage Engines
    • Storage Engine Comparison Chart
  8. MySQL Clients and Administrative Tools for MySQL
    • Overview of Administrative Clients
    • Invoking MySQL Client Programs
    • Using the Mysql Client
    • The mysqladmin Client
    • MySQL Administration tools
  9. Backup and Recovery Concepts and Tools
    • Backup Recovery Concept
    • Row and Statement level Logging
    • Types of Backups
    • Backup Tools
    • Data Recovery
  10. Replication
    • MySQL Replication in Action on the Web
    • Designing for High Availability
    • MySQL Replication Overview
    • MySQL Replication features
    • Getting started with Replication

Please write to us at info@itstechschool.com & contact us at +91-9870480053 for the course price & certification cost, schedule & location

Drop Us a Query

For more info kindly Contact Us.


Give Your Reviews on this Course


72 + 2 =