MySQL for Database Administrators Training & Placements in Chennai "ISQL GLOBAL"
MySQL for Database Administrators Ed 4
(The Course Materials and Course Completion Certificates are directly delivered from Oracle University to those seeking for Foreign Opportunity)
(Government of India Approved Education Center - SQL STAR)
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.
- Configure and 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
- 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
- Identify and optimize poorly-performing queries
- Troubleshootserver slowdowns and other common problems
- Gain an understanding of MySQL Cloud
Course Topics
Introduction
to MySQL
- MySQLon the Web
- The MySQL community
- MySQLin the Cloud
- MySQLoverview
- MySQLEnterprise Edition
Installing
MySQL- InitialConfiguration
- Starting and Stopping MySQL
- UpgradingMySQL
- InstallingMySQL
- InstalledFiles and Directories
MySQL
Architecture- Redoand Undo Logs
- HowMySQL Stores Data
- Tablespaces
- HowMySQL Uses Memory
- ArchitecturalOverview
- HowMySQL Processes Requests
- HowMySQL Transmits Data
- Plug-inInterface
Configuring
MySQL- Launching Multiple Servers on the Same Host
- ServerOptions, Variables, and the Command Line
- SystemVariables
- OptionFiles
Monitoring
MySQL- Monitoring MySQL with Performance Schema
- MySQLEnterprise Audit
- MonitoringMySQL with Log Files
- Monitoring User Activity
- MySQLEnterprise Monitor
- MonitoringMySQL with Status Variables
User
Management- Configuring Passwords and Account Expiration
- MySQLPrivilege System
- Resetting a Forgotten Root Password
- AuthenticationPlug-Ins
- GrantTables
- Creating and Modifying User Accounts
- Granting Permissions
MySQL
Security- Security Risks
- SecureConnections
- MySQLEnterprise Firewall
- NetworkSecurity
- ProtectingAgainst SQL Injections
- Operating System Security
- PasswordSecurity
Maintaining
a Stable System- Troubleshooting
- Identifying the Causes of Server Slowdowns
- CapacityPlanning
- Stability
- InnoDBRecovery
- WhyDatabases Fail
Optimizing
Query Performance- Working with Indexes
- The EXPLAIN statement
- Identifying Slow Queries
- IndexStatistics
Backup
Strategies- UnderstandingBackups
- Creating a Backup Strategy
- BackupTechniques
Performing
Backups- MySQLBackup Tools
- RawBackup Methods
- Techniquesthat Use the Binary Log
Configuring
a Replication Topology- ConfiguringReplication
- ReplicationConflicts
- Overview of Replication
- Whento Use Replication
Administering
a Replication Topology- MonitoringReplication
- TroubleshootingReplication
- ReplicationThreads
- Failover
- MySQLUtilities
Group
Replication- MonitoringGroup Replication
- Single-Primaryand Multi-Primary Modes
- Overview
- ConfiguringGroup Replication
Conclusion- CourseOverview
- Q&ASession
- CourseEvaluation
- MySQLCurriculum
- ThankYou!