MySQL DBA Foundation

Name: MySQL DBA Foundation
Price: 8000 INR

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.

92 STUDENTS ENROLLED

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

Course Curriculum

Introduction
	DBA A. Introduction to DBMS and RDBMS	02:00:00
In this Unit you will know about the basics of DBMS and RDBMS.
	DBA B. Schema Normalization	02:00: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 DBA 3. New Features in MySQL 5.6	24 hours
	MySQL DBA 4. MySQL 8.0 Features	24 hours
Getting Started with MySQL
	MySQL DBA 5. MySQL Architecture	24 hours
	MySQL DBA 6. Installing, configuring, stopping and starting	24 hours
This unit will make you familiar about OS Setting and Installation.
	MySQL Lab 1 – Installing MySQL on CentOS/RHEL 7	10, 00:00
	MySQL Lab 2. Creating Multiple Instances of MySQL on CentOS 7	10, 00:00
	MySQL Lab 3. Getting Started with MySQL 8.0	10, 00:00
	MySQL DBA 7. Interpreting Error and Diagnostic Information	24 hours
	MySQL DBA 8. Storage Engines	24 hours
	MySQL DBA 9. The Innodb Engine	24 hours
	MySQL Lab 4. Innodb Table Space Management	10, 00:00
Data Management in MySQL
	MySQL DBA 10. Obtaining Metadata	24 hours
	MySQL DBA 11. Locking Concepts in MySQL	24 hours
	MySQL Lab 5. Transactions, Savepoints and Isolation Levels	10, 00:00
	MySQL DBA 12. MySQL Table Maintenance	24 hours
	MySQL Lab 6 Performing Table Maintenance Operations	10, 00:00
	MySQL DBA 13. Backup and Recovery in MySQL	24 hours
	MySQL Lab 7 Performing Backup and Restore	10, 00:00
	MySQL DBA 14. User Management in MySQL	24 hours
	MySQL Lab 8 User Management	10, 00:00
	MySQL DBA 15. Privileges in MySQL	24 hours

Course Reviews

4.8

4.8

ratings

5 stars0
4 stars0
3 stars0
2 stars0
1 stars0

No Reviews found for this course.