MySQL for Database Administrators Training & Placements in Chennai "ISQL Global"

MySQL for Database Administrators Ed 4
(Course Materials and Course Completion Certificates are directly delivered from Oracle University to those required for Foreign Opportunity)

(Government of India Approved Education Center)

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.
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.
Through a variety of realistic, hands-on activities, expert MySQL instructors will teach you to install, configure, secure, and maintain your database server which you can deploy on-premise or as a MySQL Cloud Service instance.
Learn To:

• Installand configure MySQL Server and client programs.
• Recognizethe key components of the MySQL architecture.
• Secureyour server.
• Troubleshootserver slowdowns and other issues.
• Improvequery performance.
• Configureand administer a variety of replication topologies.
• Understand the benefits of MySQL Cloud.

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.
Prerequisites
Suggested Prerequisite

• Shouldbe knowlegeable with MySQL data types and executing basic DDL andDML queries using SQL
• Shouldbe knowlegeable with relational database concepts and using themysql command-line client
• Shouldbe knowlegeable with Joining tables

Required Prerequisite

• MySQLFundamentals Ed 1
• MySQLfor Developers

Audience

• Database Administrators
• Database Administrators
• DatabaseDevelopers
• DatabaseDevelopers
• Technical Consultant

Course Objectives

• Define and implement a backup strategy
• Performphysical and logical backups of your data
• DescribeMySQL replication and its role in high availability andscalability
• Configuresimple and complex replication topologies
• Administera replication topology
• Installthe MySQL server and client programs
• UpgradeMySQL on a running server
• DescribeMySQL architecture
• Explainhow MySQL processes, stores, and transmits data
• ConfigureMySQL server and client programs
• Useserver logs and other tools to monitor database activity
• Create and manage Users
• Protectyour data from common security risks
• Identifyand optimize poorly-performing queries
• Troubleshootserver slowdowns and other common problems
• Gain an understanding of MySQL Cloud

Course Topics
Introduction to MySQL

• MySQL on the Web
• TheMySQL community
• MySQLin the Cloud
• MySQL overview
• MySQL Enterprise Edition

Installing MySQL

• InitialConfiguration
• Starting and Stopping MySQL
• Upgrading MySQL
• Installing MySQL
• InstalledFiles and Directories

MySQL Architecture

• Redo and Undo Logs
• How MySQL Stores Data
• Table spaces
• How MySQL Uses Memory
• ArchitecturalOverview
• How MySQL Processes Requests
• How MySQL Transmits Data
• Plug-inInterface

Configuring MySQL

• Launching Multiple Servers on the Same Host
• Server Options, Variables, and the Command Line
• SystemVariables
• OptionFiles

Monitoring MySQL

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

User Management

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

MySQL Security

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

Maintaining a Stable System

• Trouble shooting
• Identifying the Causes of Server Slowdowns
• Capacity Planning
• Stability
• InnoDBRecovery
• WhyDatabases Fail

Optimizing Query Performance

• Working with Indexes
• The EXPLAIN statement
• Identifying Slow Queries
• Index Statistics

Backup Strategies

• Understanding Backups
• Creating a Backup Strategy
• Backup Techniques

Performing Backups

• MySQLBackup Tools
• RawBackup Methods
• Techniquesthat Use the Binary Log

Configuring a Replication Topology

• Configuring Replication
• ReplicationConflicts
• Overview of Replication
• Whento Use Replication

Administering a Replication Topology

• Monitoring Replication
• Trouble shooting Replication
• ReplicationThreads
• Failover
• MySQLUtilities

Group Replication

• Monitoring Group Replication
• Single-Primaryand Multi-Primary Modes
• Overview
• Configuring Group Replication

Conclusion

• Course Overview
• Q&ASession
• Course Evaluation
• MySQL Curriculum
• Thank You!