MySQL DBA Course LVC

This course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and SQL commands.

All Levels

Created by Ram Niwas Sangwan Last Updated 17/04/2023 08:58

₹14,000.00 ₹37,990.00 63.15% off

What's Included

  • 0 Lectures
  • Access on tablet and phone
  • Certificate of completion

Preview

What you'll learn

  • Introduction to DBMS and RDBMS
  • MySQL Architecture
  • Installing, Configuring, Stopping and Starting
  • Interpreting Error and Diagnostic Information
  • Storage Engines
  • Innodb Table Space Management
  • Transactions, Savepoints and Isolation Levels
  • Performing Table Maintenance Operations
  • Working with Numeric and Temporal Data
  • Backup and Recovery in MySQL
  • User Management in MySQL
  • User Variables and Prepared Statements
  • Stored Procedures and Functions in MySQL
  • Stored Routines
  • Partitioned Tables in MySQL
  • Query Execution Plan and Optimization
  • Understanding Replication Concepts
  • Replication in MySQL
  • MySQL Clusters Introduction
  • MySQL Cluster Setup on CentOS
  • JSON Data Handling in MySQL

Requirements

  • Basic introductory knowledge of Linux - Check our Linux Essentials Course
  • Knowledge of File Systems, Operating System and Databases

Description

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 CentOS 7 or 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

Online Class Schedule

  • 9th May 2023 8:59 am - 9:29 am Class over
  • 12th May 2023 9:29 am - 9:29 am Class over
  • 15th May 2023 9:29 am - 9:29 am Class over
  • 19th May 2023 9:29 am - 9:29 am Class over
  • 22nd May 2023 9:29 am - 9:29 am Class over
  • 26th May 2023 9:29 am - 9:29 am Class over
  • 29th May 2023 9:29 am - 9:29 am Class over
  • 2nd Jun 2023 9:29 am - 9:29 am Class over
  • 5th Jun 2023 9:29 am - 9:29 am Class over
  • 9th Jun 2023 9:29 am - 9:29 am Class over
  • 12th Jun 2023 9:29 am - 9:29 am Class over
  • 16th Jun 2023 9:29 am - 9:29 am Class over
  • 19th Jun 2023 9:29 am - 9:29 am Class over
  • 23rd Jun 2023 9:29 am - 9:29 am Class over
  • 26th Jun 2023 9:29 am - 9:29 am Class over
  • 30th Jun 2023 9:29 am - 9:29 am Class over
  • 3rd Jul 2023 9:29 am - 9:29 am Class over
  • 7th Jul 2023 9:29 am - 9:29 am Class over
  • 10th Jul 2023 9:29 am - 9:29 am Class over
  • 14th Jul 2023 9:29 am - 9:29 am Class over
  • 17th Jul 2023 9:29 am - 9:29 am Class over
  • 21st Jul 2023 9:29 am - 9:29 am Class over
  • 24th Jul 2023 9:29 am - 9:29 am Class over
  • 28th Jul 2023 9:29 am - 9:29 am Class over
  • 31st Jul 2023 9:29 am - 9:29 am Class over
  • 4th Aug 2023 9:29 am - 9:29 am Class over
  • 7th Aug 2023 9:29 am - 9:29 am Class over
  • 11th Aug 2023 9:29 am - 9:29 am Class over
  • 14th Aug 2023 9:29 am - 9:29 am Class over
  • 18th Aug 2023 9:29 am - 9:29 am Class over
  • 21st Aug 2023 9:29 am - 9:29 am Class over
  • 25th Aug 2023 9:29 am - 9:29 am Class over
  • 28th Aug 2023 9:29 am - 9:29 am Class over
  • 1st Sep 2023 9:29 am - 9:29 am Class over
  • 4th Sep 2023 9:29 am - 9:29 am Class over
  • 8th Sep 2023 9:29 am - 9:29 am Class over

Demo Online Class

Instructors

(4.45)

19 Courses

193 Students

2901 Reviews

Ram Niwas Sangwan

I have spent 27 years in IT Industry as an Educationist. I have been a software developer/corporate trainer and an information systems specialist with a record of developing and supporting solutions incorporating a wide range of applications. I have an entrepreneurial-mindset and a track record of success in recognizing opportunities spanning more than 26 years. Developing innovative and creative approaches, I have trained top level executives of companies driving revenue growth and enhancing long-term profitability. I have been motivating my team to ensure project success and on-time delivery. I, have time and again proven my ability at managing multiple priorities in fast-paced environments.
Businessman Leading a team of Professionals in the Area of Digital Marketing, Website Design and Development, Software Development with more than 1200 Satisfied Client. Currently I am managing My Own Production Servers with more than 500 Live Websites and Launching my Dream Project www.theskillpedia.com after working on for more than 4 Years.