This course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and SQL commands. The course provides practical experience in setting up and maintaining a MySQL server, including backing up, recovery, configuration and optimization.
For any Clarification Call at 09312406920

MySQL DBA Online Training

The MySQL DBA Online Training course includes Installation to advanced performance tuning.  Most noteworthy, the course have been delivered by the Instruction for many corporate clients. Therefore, with our MySQL DBA Online Training you’ll learn concepts in detailed and with hands on examples.

About This course

MySQL DBA Online Training designed for freshers and experienced professionals. MySQL, an open-source relational database management system (RDBMS) is the most trusted. It is used by the Banking sectors, Health Insurance companies and several other companies including Facebook. Companies whose business is based on complex transactions, payroll processes opt for Mysql. And Mysql Enterprise Version comes with Oracle Support. In addition the MySQL DBA Online Training has evolved over the years.

Course Objectives

First of all, this course is designed to give administrators the knowledge and skills. The Skills needed to maintain successful and efficient day-to-day operations of MySQL databases and services.  Consequently, Administrators will gain practical experience in setting up, administering and troubleshooting MySQL databases.  They will have in depth knowledge on Replication, High availability features of MySQL and in depth knowledge Security.

Practical Includes:

  • MySQL Installation on RHEL 7
  • Starting, Stopping and Configuring MySQL
  • Security-Related Configuration
  • Database Creation
  • Using Client Programs for DBA Work
  • Setting up Character Set Support
  • Transactions and Locking
  • Using Storage Engines
  • Table Maintenance
  • Obtaining Data from the Information_Schema Database
  • Backup and Recovery
  • Using Stored Procedures for Database Administration Tasks
  • User Management
  • Securing the Server
  • Upgrade-Related Security Issues
  • Optimizing Queries
  • Optimizing Schemas
  • Optimizing the Server
  • The Event Scheduler
  • Partitioned Tables
  • Interpreting Error Messages
  • Optimizing the Environment
  • MySQL Replication
  • MySQL Cluster

Course Curriculum

Introduction
MySQL Unit 1. Introduction to DBMS and RDBMS 00:15:00
In this Unit you will know about the basics of DBMS and RDBMS.
MySQL Unit 2. Data Models and RDBMS Definition 00:30:00
After the completion of the unit you will be able to explain: Flat File Databases, Drawbacks of Flat File Databases, Database Management System, Usage of DBMS, Functionalities of  database system, Data models, RDBMS and 12 Rules, Properties of Relations, Keys and Referential Integrity
MySQL Unit 3. Schema Normalization 00:45:00
Schema Normalization-The session is a walk through for the normalization of a sample database. You will learn how to apply 1NF, 2NF and 3NF to your own database.
MySQL Unit 4. New Features in MySQL 5.6 FREE 00:45:00
Sugar plum muffin cake cheesecake topping soufflé muffin brownie. Carrot cake ice cream apple pie. Applicake jujubes wafer brownie lollipop toffee muffin sweet.
MySQL 8.0 Features 00:20:00
Getting Started with MySQL
MySQL Architecture 00:40:00
Installing, configuring, stopping and starting 00:20:00
This unit will make you familiar about OS Setting and Installation.
Interpreting Error and Diagnostic Information 00:20:00
Storage Engines 00:15:00
The Innodb Engine 00:30:00
Data Management in MySQL
Locking Concepts in MySQL 00:15:00
MySQL Table Maintenance 00:20:00
Obtaining Metadata 00:15:00
Backup and Recovery in MySQL 00:20:00
Variables and Stored Routines
User Variables and Prepared Statements 00:20:00
Stored Procedures and Functions in MySQL 00:20:00
Triggers in MySQL 00:15:00
MySQL Security
User Management in MySQL 00:15:00
Privileges in MySQL 00:20:00
Securing MySQL Server 00:20:00
Optimization and Performance Tuning
Partitioned Tables in MySQL 00:15:00
Optimizing MySQL Queries 00:20:00
Optimization and Indexes in MySQL 00:20:00
Optimizing MySQL Schemas 00:20:00
Optimizing MySQL Server 00:20:00
Optimizing MySQL Environment 00:20:00
Scaling and High Availability
Understanding Replication Concepts 00:20:00
MySQL Clusters Introduction 00:15:00
GTID Based Replication in MySQL 00:20:00
MySQL Cluster Unit 1 00:30:00
MySQL Cluster Unit 2 00:20:00

Course Reviews

4.8

4.8
24 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • 24,900.00 22,499.00 per 90 days
  • 2 Days
  • Course Badge
  • Course Certificate
60 STUDENTS ENROLLED

Instructor Details

More Courses by Ram Niwas Sangwan

    Advanced Course Search Widget

    Recent Posts

    Featured Testimonial

    I recommend The Skill Pedia to all those who are looking for a career in Information Technology as...Read more

    Michael John

    Certified Engineer

    Certificate Code

    Who’s Online

    There are no users currently online

    Last Tweets

    top
    X