Oracle MySQL 5.5.8 for Database Administrators Training

Download Course Brochure

Instructor-Led Training Parameters

Course Highlights

  • Instructor-led Online Training
  • Project Based Learning
  • Certified & Experienced Trainers
  • Course Completion Certificate
  • Lifetime e-Learning Access
  • 24x7 After Training Support

Instructor-led Training Live Online Classes

Suitable batches for you

Mar, 2024 Weekdays Mon-Fri Enquire Now
Weekend Sat-Sun Enquire Now
Apr, 2024 Weekdays Mon-Fri Enquire Now
Weekend Sat-Sun Enquire Now

Share details to upskills your team



Build Your Own Customize Schedule



Oracle MySQL 5.5.8 for Database Administrators Training Course Overview

Oracle MySQL 5.5.8 for Database Administrators (DBA) Training course lays the foundation for the understanding of the powerful database, MySQL. The participants acquire the skills for securing access controls, defining user privileges, and setting recourse limitations. The training will also guide the attendees about the creation and usage of view, triggers, and stored procedures.

Oracle MySQL 5.5.8 for Database Administrators course will prepare you for Oracle Certified Professional, MySQL 5.6 Database Administrator.

By the end of this training, the participants will hold the following capabilities:

  • Understand MySQL architecture and its types of distributions
  • Installation and configuration of MySQL for different operating systems
  • Understand client-server architecture and use mysql client
  • Configure MySQL server options at runtime
  • Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server
  • Usage of different data types
  • Evaluate different types of storage engines and choose the appropriate one
  • Obtain partition information and explore the ways of creating, modifying and removing partitions
  • Understand data locking concept and its implications
  • Implement security by maintaining user accounts and controlling access to the resources at different levels
  • Execute SQL statements for table maintenance
  • Export and Import data using SQL
  • Use MySQL to create, execute, and modify the stored procedures, triggers, and views for administrative tasks
  • Define and schedule events
  • Understand the use of the InnoDB storage engine with MySQL
  • Use MySQL tools to perform backup and restore operations
  • Improve performance through query optimization
Target audience
  • Developers who want to administer MySQL
  • Database Administrators
  • Database Professionals
Prerequisites

Knowledge of relational database and prior hands-on experience on MySQL is required to attend this training program.

Exams

MySQL 5.6 Database Administrator 1Z0-883

Oracle MySQL 5.5.8 for Database Administrators Training Course Content

Introduction

  • MySQL Overview, Products, Services
  • MySQL Services and Support
  • Supported Operating Services
  • MySQL Certification Program
  • Training Curriculum Paths
  • MySQL Documentation Resources

MySQL Architecture

  • The client/server model
  • Communication protocols
  • The SQL Layer
  • The Storage Layer
  • How the server supports storage engines
  • How MySQL uses memory and disk space
  • The MySQL plug-in interface

System Administration

  • Choosing between types of MySQL distributions
  • Installing the MySQL Server
  • The MySQL Server installation file structure
  • Starting and stopping the MySQL server
  • Upgrading MySQL
  • Running multiple MySQL servers on a single host

Server Configuration

  • MySQL server configuration options
  • System variables
  • SQL Modes
  • Available log files
  • Binary logging

Clients and Tools

  • Available clients for administrative tasks
  • MySQL administrative clients
  • The mysql command-line client
  • The mysqladmin command-line client
  • The MySQL Workbench graphical client
  • MySQL tools
  • Available APIs (drivers and connectors)

Data Types

  • Major categories of data types
  • Meaning of NULL
  • Column attributes
  • Character set usage with data types
  • Choosing an appropriate data type

Obtaining Metadata

  • Available metadata access methods
  • Structure of INFORMATION_SCHEMA
  • Using the available commands to view metadata
  • Differences between SHOW statements and INFORMATION_SCHEMA tables
  • The mysqlshow client program
  • Using INFORMATION_SCHEMA queries to create shell commands and SQL statements

Transactions and Locking

  • Using transaction control statement to run multiple SQL statements concurrently
  • The ACID properties of transactions
  • Transaction isolation levels
  • Using locking to protect transactions

Storage Engines

  • Storage engines in MySQL
  • InnoDB storage engine
  • InnoDB system and file-per-table tablespaces
  • NoSQL and the Memcached API
  • Configuring tablespaces efficiently
  • Using foreign keys to attain referential integrity
  • InnoDB locking
  • Features of available storage engines

Partitioning

  • Partitioning and its use in MySQL
  • Reasons for using partitioning
  • Types of partitioning
  • Creating partitioned tables
  • Subpartitioning
  • Obtaining partition metadata
  • Modifying partitions to improve performance
  • Storage Engine Support of Partitioning

User Management

  • Requirements for user authentication
  • Using SHOW PROCESSLIST to show which threads are running
  • Creating, modifying and dropping user accounts
  • Alternative authentication plugins
  • Requirements for user authorization
  • Levels of access privileges for users
  • Types of privileges
  • Granting, modifying and revoking user privileges

Security

  • Recognizing common security risks
  • Security risks specific to the MySQL installation
  • Security problems and counter-measures for network, operating system, filesystem and users
  • Protecting your data
  • Using SSL for secure MySQL server connections
  • How SSH enables a secure remote connection to the MySQL server
  • Finding additional information for common security issues

Table Maintenance

  • Types of table maintenance operations
  • SQL statements for table maintenance
  • Client and utility programs for table maintenance
  • Maintaining tables for other storage engines

Exporting and Importing Data

  • Exporting Data
  • Importing Data

Programming Inside MySQL

  • Creating and executing Stored Routines
  • Describing stored routine execution security
  • Creating and executing triggers
  • Creating, altering and dropping events
  • Event execution scheduling

MySQL Backup and Recovery

  • Backup basics
  • Types of backup
  • Backup tools and utilities
  • Making binary and text backups
  • Role of log and status files in backups
  • Data Recovery

Replication

  • Managing the MySQL Binary Log
  • MySQL replication threads and files
  • Setting up a MySQL Replication Environment
  • Designing Complex Replication Topologies
  • Multi-Master and Circular Replication
  • Performing a Controlled Switchover
  • Monitoring and Troubleshooting MySQL Replication
  • Replication with Global Transaction Identifiers (GTIDs)

Introduction to Performance Tuning

  • Using EXPLAIN to Analyze Queries
  • General Table Optimizations
  • Monitoring status variables that affect performance
  • Setting and Interpreting MySQL server Variables
  • Overview of Performance Schema

video-img

Request for Enquiry

assessment_img

Free Oracle MySQL 5.5.8 for Database Training Assessment

This assessment tests understanding of course content through MCQ and short answers, analytical thinking, problem-solving abilities, and effective communication of ideas. Some Multisoft Assessment Features :

  • User-friendly interface for easy navigation
  • Secure login and authentication measures to protect data
  • Automated scoring and grading to save time
  • Time limits and countdown timers to manage duration.
Try It Now

Oracle MySQL 5.5.8 for Database Corporate Training

Employee training and development programs are essential to the success of businesses worldwide. With our best-in-class corporate trainings you can enhance employee productivity and increase efficiency of your organization. Created by global subject matter experts, we offer highest quality content that are tailored to match your company’s learning goals and budget.


500+
Global Clients
4.5 Client Satisfaction
Explore More

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

Expert
Mentors

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

360º Learning Solution

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

Learning Assessment

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

Certification Training Achievements: Recognizing Professional Expertise

Multisoft Systems is the “one-top learning platform” for everyone. Get trained with certified industry experts and receive a globally-recognized training certificate. Some Multisoft Training Certificate Features :

  • Globally recognized certificate
  • Course ID & Course Name
  • Certificate with Date of Issuance
  • Name and Digital Signature of the Awardee
Request for Certificate

What Attendees are Saying

Our clients love working with us! They appreciate our expertise, excellent communication, and exceptional results. Trustworthy partners for business success.

Share Feedback
  Chat On WhatsApp

+91-9810-306-956

Available 24x7 for your queries