MySQL DBA Training Self Paced
About MySQL DBA Training (Self Paced):
MySQL DBAs is one of the best RDBMS being used for developing web based software applications. It’s an arranged set of data stored electronically. MySQL is the most popular open source relational SQL database management system. With the availability of huge documentation, implementing an application within MySQL is something many developers familiar with MySQL can do. MySQL DBA training will skilled you in most demanding job in the database.
What is MySQL DBA Self Paced Course?
MySQL DBA self paced course includes a list of video sessions of complete modules. All sessions are explained by the real time professional from a reputed organization. It also includes study material and interview question. All study materials you can access any number of times until you get the complete knowledge of the subject. If you get any doubts, you can get clear with our real time trainers by following some additional procedure.
MySQL DBA Course Target:
- Installing and upgrading MySQL.
- Understanding MySQL Architecture.
- Illustrating character sets and data types for performance related concerns.
- Learn and understand the effective way of MySQL installation.
- Using INFORMATION_SCHEMA database for accessing metadata.
- Using triggers for management tasks.
- Performing backup and recovery activities.
- Performing start and end operations of MySQL.
- Understanding views.
- Illustrate tuning techniques concern to introductory performance.
MySQL DBA course audience:
- Freshers, who is seeking a career in database skills.
- Database Administrators.
MySQL DBA Prerequisite:
- Basic knowledge of MySQL database and relational database.
- Basic knowledge of IT concepts.
MySQL DBA Course Curriculum:
Module: 1. Database Basics
Goal set: This MySQL training module covers- Basics of database, MySQL Database commands, MySQL architecture,History of MySQL, ACID properties and versions and architecture of MySQL.
Topics: Basics of Database / RDBMS, MySQL Database commands, Database ACID Properties, Isolation Levels, MySQL History, Different versions of MySQL, Architecture of MySQL, (Physical, Logical).
Module: 2. Installation and Configuration
Goal set: This MySQL training module covers- MySQL database installation, error handling, MySQL objects, MySQl physical architecture, pluggable engines and MySQl configuration file.
Topics: Installation of MySQL: Windows, Linux (Using RPM, Using Binary), MySQL physical architecture in detail, Working with mysql objects: (Tables, Views, Stored procedure, Events), Error handling, Pluggable engines: (MyISAM, InnoDB, Memory, CSV, Federated, Blackhole, Merge), Working with MySQL configuration file.
Module: 3. Configuration
Goal set: This MySQL training module covers- Parameters of MyISAM and InnoDB.
Topics: Configuration: parameters for MyISAM, Parameters for InnoDB in detail.
Module: 4. Users and security
Goal set: This MySQL training module covers- understand about granting and revoking privileges, my SQL courses, security best practices, change of password and how to take backup.
Topics: Creating Users, Granting and revoking privileges, Taking user backup, changing password and security best practices.
Module: 5. MySQL Backup
Goal set: This MySQL training module covers- backup requirements, binary lag architecture and backup techniques.
Topics: Backup requirement, Physical and logical backup, Cold and hot backup, Enabling and disabling binary logging, Understanding the binary log architecture, Different backup techniques in mysql (MySQL dump, Full backup, Transactional backup, Xtrabackup), Restoring mysql backup, Purging old logs, Performance tuning the backup and Restoring point in time backup.
Module: 6. Troubleshooting
Goal set: This MySQL training module covers- general and connection problems and basics of error log.
Topics: General Problems and their resolution, Connection problems, and understanding the error log.
Module: 7. Performance Tuning
Goal set: This MySQL DBA tutorial module covers- performance problems, operating system utility, indexing and different storage’s.
Topics: Discussing the different area of performance problems, (Operating system, application, database instance, queries), Instance tuning, Threading, Swapping and Scale up vs Scale out.
Module: 8. Replication and High Availability
Goal set: This MySQL DBA tutorial module covers- High availability and Single point of failure.
Topics: Discussion over High Availability, Single point of failure, Replication walk through and discussion over DRBD.
Module: 9. Monitoring and Security Practices
Goal set: This MySQL DBA tutorial module covers- different aspects of MySQL, monitoring the load and third party tools.
Topics: Monitoring the availability of MySQL, Monitoring different aspects of MySQL, Monitoring the load and monitoring MySQL using third party tools.
No Reviews found for this course.