MySQL DBA Course

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 00:25

₹38,500.00 ₹39,900.00 3.51% off

What's Included

  • 36 Lectures
  • 13 Assignments
  • Access on tablet and phone
  • Certificate of completion

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

Course Curriculum

Expand all Collapse all

36 Lectures

00:00

MySQL Security 1 Lectures

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

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.