*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3498-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, KSA 0502283468

MySQL for Database Administrators


Be the first to rate MySQL for Database Administrators
Or log in to access your purchased courses
by admin2
Price:  35,000  30,000
2 Days
0 Lessons

Print Friendly, PDF & Email

COURSE DESCRIPTION

MySQL for Database Administrators

The MySQL for Database Administrators course teaches DBAs and other database professionals how to maximize their organization’s investment in MySQL and about the benefits of using the MySQL Cloud Service. Learn to configure the MySQL Server, set up replication and security, perform database backups, optimize query performance, and ensure high availability.

Benefits To You:

After taking this course, you will be equipped to use all the features of MySQL to get the best out of your Web, Cloud, and embedded applications, whether you work with the command line or graphical tools such as MySQL Workbench and MySQL Enterprise Monitor, whether you use on-premise or MySQL Cloud-based instances, and whether your challenge is complex replication requirements or highly-tuned transactional systems.

Course Content:

Introduction to MySQL

MySQL overview
MySQL Enterprise Edition
MySQL on the Web
MySQL in the Cloud
The MySQL community

Installing MySQL

Installing MySQL
Installed Files and Directories
Initial Configuration
Starting and Stopping MySQL
Upgrading MySQL

MySQL Architecture

Architectural Overview
How MySQL Transmits Data
How MySQL Processes Requests
How MySQL Stores Data
Tablespaces
Redo and Undo Logs
How MySQL Uses Memory
Plug-in Interface

Configuring MySQL

Server Options, Variables, and the Command Line
Option Files
System Variables
Launching Multiple Servers on the Same Host

Monitoring MySQL

Monitoring MySQL with Log Files
Monitoring MySQL with Status Variables
Monitoring MySQL with Performance Schema
MySQL Enterprise Audit
MySQL Enterprise Monitor
Monitoring User Activity

User Management

MySQL Privilege System
Creating and Modifying User Accounts
Configuring Passwords and Account Expiration
Authentication Plug-Ins
Granting Permissions
Grant Tables
Resetting a Forgotten Root Password

MySQL Security

Security Risks
Network Security
Secure Connections
Password Security
Operating System Security
Protecting Against SQL Injections
MySQL Enterprise Firewall

Maintaining a Stable System

Stability
Why Databases Fail
Capacity Planning
Troubleshooting
Identifying the Causes of Server Slowdowns
InnoDB Recovery

Optimizing Query Performance

Identifying Slow Queries
The EXPLAIN statement
Working with Indexes
Index Statistics

Backup Strategies

Understanding Backups
Backup Techniques
Creating a Backup Strategy

Performing Backups

MySQL Backup Tools
Raw Backup Methods
Techniques that Use the Binary Log

Configuring a Replication Topology

Overview of Replication
Replication Conflicts
When to Use Replication
Configuring Replication

Administering a Replication Topology

Failover
MySQL Utilities
Replication Threads
Monitoring Replication
Troubleshooting Replication

Group Replication

Overview
Single-Primary and Multi-Primary Modes
Configuring Group Replication
Monitoring Group Replication

Training Track: Database

Flexible Class Options

  • Morning | Evening Classes | Workshops | Fast-Track
  • Week End Classes For Professionals  SAT | SUN
  • Online Classes – Live Virtual Class (L.V.C), Online Training

International Student FEE : 200$

Related MySQL Database Courses

Database Programming with MySQL

MySQL Database Administrator

KEY FEATURES

Online Classes for out of city / country students

AMAZING Discount OFFER

100% Success Rate

Weekend Classes for Professionals

Experience Faculty

Practice Exam

Please Fill the Inquiry Form

Inquire Now

Select Country:
Enter Phone e.g 923451234567
Branch
Online

Inquire Now

Lessons

Or log in to access your purchased courses
Learn to configure the MySQL Server, set up replication and security, perform database backups, optimize query performance.
ABOUT US

OMNI ACADEMY is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Gulshan Campus : A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, (Near Rab Medial) Karachi. 021 3498 6664, WhatsApp 0312 216 9325
  • Dha Campus: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 021 35344 600, 0333 3808376
  • 021 34986664, 021 35344 600, 0333 3808376, KSA 050 2283468
  • info@omni-academy.com
WORKING HOURS

  • Monday10.00am - 8.00pm
  • Tuesday10.00am - 8.00pm
  • Wednesday10.00am - 8.00pm
  • Thursday10.00am - 8.00pm
  • FridayClosed
  • Saturday10.00am - 8.00pm
  • Sunday10.00am - 8.00pm
WhatsApp chat