Categories
shape
shape

MySQL DBA in Telugu

Students0 Views157

MySQL DBA in Telugu

About The Course

This MySQL DBA Course is designed for MySQL Database Administrators who have a basic understanding of a database and SQL commands. Therefore, the course will provides 100% practical experience in setting up and maintaining a MySQL server, including installation,, upgrading, backing up, recovery, configuration and optimization. The MySQL DBA Course will assist you in understanding the fundamental concepts, trouble shooting techniques, GUI tools for managing data and administering the MySQL Database.

Key Features

  • 20 Hours of Training
  • Expert & Certified Trainers
  • Practical Approach
  • Articles for each topic
  • 24/7 Support
What Will You Learn?

This MariaDB DBA course is basically designed for all people who wants to become

MariaDB Database Administrators and who have a basic understanding of a database,

Unix/Linux commands, and SQL commands.

The course provides 100% practical experience in setting up and maintaining a MariaDB

server.

Course Curriculam

Overview of MySQL DBA Course Contents

  • Lesson 1
    22:52

How to Become a Database Administrator & MySQL DBA Roles and Responsibilities

Introduction, Features, History, Uses, and Customers of MySQL

Installing MySQL 8.0 Using Yum Repository on Red Hat or CentOS

Installing MySQL on Red Hat or CentOS Using RPM Packages

Installing MySQL on Red Hat or CentOS Using Generic Binaries

Installing MySQL 8.0 Using RPM Packages on Fedora

Installing MySQL 8.0 Using APT Repository & Debian Packages on Ubuntu

Installing MySQL 8.0 on Windows Using MySQL Installer (MSI) & using a no install ZIP Archive

Access Control and Account Management

MySQL Utilities or Programs – Overview of MySQL Programs

Running Multiple MySQL Instances on One Machine

MySQL Storage Engines

Overview of MySQL Storage Engine Architecture & InnoDB Architecture

InnoDB Transaction Isolation Levels

Understand the basics of MySQL locks

MySQL Backup and Restore

Point-in-Time Recovery Using Binary Log and Event Positions

MySQL Server Logs

Source to Replica Replication & Source to Source Replication in MySQL

Source to Replica & Source to Source Replication with GTID in MySQL

Multi-Source Replication in MySQL

Overview of Partitioning in MySQL & Types of MySQL Partitions

Upgrading MySQL from 5.7 to 8.0 in both Linux & Windows

Overview of MySQL Shell

Overview of MySQL Workbench

Overview of MySQL Default System Schemas or Databases

MySQL Performance Tuning & Optimization Tips

THE END IS JUST THE BEGINNING

New_Project__2_ removebg preview 100x100

OSDT INDIA

Instructor

15 Courses 0 Student
No Review Yet
No Review Yet