Categories
shape
shape

MySQL DBA

Students0 Views270

MySQL DBA

About The Course

Trainer Profile:
✓ I am having more than 15+ Years of Experience.
✓ Trained more than 5000+ students in last 10 years.
✓ Strong Theoretical and Practical Knowledge.
✓ I am MySQL DBA Certified Professionals with High Grade.
✓ I have Experienced on multiple real-time projects in IT Industries.
✓ My students are working all over world in multinational companies such as
Infosys, TCS, Wipro, IBM, HCL, Birlasoft, Microsoft, HP, CGI, NTT Data, Philips
Technologies etc

Notes:
• MySQL DBA Course technical content is subject to change without notice.
• This MySQL DBA course also covers the topics required for the MySQL Database
Administrator Certified Exams. Before taking any exam, ensure you have the
recommended experience. The Oracle website lists all exam requirements and
these are updated regularly. Exams are not included as part of the course.

What Will You Learn?

Overview Of MySQL DBA Course Content

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

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 MySQL

server.

Notes:

• MySQL DBA Course technical content is subject to change without notice.

• This MySQL DBA course also covers the topics required for the MySQL Database

Administrator Certified Exams. Before taking any exam, ensure you have the

recommended experience. The Oracle website lists all exam requirements and

these are updated regularly. Exams are not included as part of the course.

Course Curriculam

Section 1: Introduction, Features, History, Uses, and Customers of MySQL
Introduction to DBMS and RDBMS • What is MySQL? • MySQL Major Features • Milestones • Uses of MySQL Database

  • Introduction to DBMS and RDBMS
    00:00
  • What is MySQL?
    00:00
  • MySQL Major Features
    00:00
  • Milestones
    00:00
  • Uses of MySQL Database
    00:00

Section 2: Installing MySQL Using Yum Repository on Red Hat or CentOS

Section 3: Installing MySQL on Red Hat or CentOS Using RPM Packages

Section 4: Installing MySQL on Red Hat or CentOS Using Generic Binaries

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

Section 6: Access Control and Account Management – Managing Users, Roles, and Privileges

Section 7: MySQL Utilities or Programs – Overview of MySQL Programs

Section 8: Running Multiple MySQL Instances on One Machine – Using mysqld_multi.server or mysqld_multi

Section 9: MySQL Storage Engines

Section 10: Overview of MySQL Storage Engine Architecture & InnoDB Architecture

Section 11: InnoDB Transaction Isolation Levels

Section 12: Understand the basics of MySQL locks

Section 13: MySQL Backup and Restore (Physical Backup – Logical Backup)

Section 14: Point-in-Time Recovery Using Binary Log and Event Positions

Section 15: MySQL Server Logs

Section 16: Source to Replica Replication & Source to Source Replication in MySQL

Section 17: Source to Replica & Source to Source Replication with GTID in MySQL

Section 18: Multi-Source Replication in MySQL

Section 19: Overview of Partitioning in MySQL & Types of MySQL Partitions

Section 20: Upgrading MySQL from 8.0 to 8.1

Section 21: Overview of MySQL Workbench

Section 22: Overview of MySQL Default System Schemas or Databases

Section 23: MySQL Performance Tuning & Optimization Tips

New_Project__2_ removebg preview 100x100

OSDT INDIA

Instructor

15 Courses 0 Student
No Review Yet
No Review Yet