• SQLSTAR Global Logo
  • About Us

  • Certification

  • Courses

  • Corporate

  • Placements

  • Contact Us

  • Location


    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!

    AWS Training Data Science Training in ISQL Global Big Data Training in ISQL Global

    All rights reserved. ©1999 - 2022, ISQL Global.

    Terms of Service | Privacy Policy