Hands On Training

MySQL 8 for Administrators

O’Reilly

(4)

Course Features

Duration

5.25 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

5.25 hours

Course Description

MySQL is the most widely used open-source database in the world. MySQL 8 is the most recent major update since MySQL 5.0 was released in 2003.

This course teaches you the basics of MySQL administration using examples from MySQL 8. It also covers the differences among different MySQL versions. It begins with the basics: Installing MySQL, and creating users. We will then get sysbench running. Sysbench is responsible for issuing queries against MySQL databases. It is the main benchmarking tool for MySQL. We will be able to learn about different topics such as backups, replication and monitoring, point-in-time recovery, switchovers and user management, as well as database administration topics such version upgrades.

After completing this course you will be able set up MySQL databases and perform basic administration tasks with the latest version.

Highlights

Pedagogy

Top 10 Percentile

Course Credibility

Top 20 Percentile

Parameters

Course Credibility

Delivered through O’Reilly a renowned institution in the field, this course offers a comprehensive learning experience.

Pedagogy

Acquire all major Big Data Platforms skills in this course for seamless integration into your daily life. Develop a versatile skill set, allowing you to confidently apply what you've learned in various practical scenarios, enhancing your daily experiences and overall proficiency. An exceptional course in Big Data Platforms, this stands out for its Self Paced learning approach. Learners have the flexibility to progress at their own speed, tailoring the experience to their individual needs. With a focus on cultivating industry-relevant skills, this course ensures that learners attain a skillset aligned with current industry demands.

Course Overview

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

Setting up MySQL 8 and running with replication, learn about database administration topics like backups, replication, monitoring, point in time recovery, switchovers, user management and version upgrades

Hands on experience of operations carried out on MySQL instances, running sysbench against them, and producing a workload

Target Students

This course targets new and returning MySQL DBAs, who are just getting to know MySQL, or who knew earlier versions and are curious about the latest administration differences in MySQL 8

Course Content

Expand all sections

Module 1: Chapter 1 : Setting Up MySQL 8

Module 2: Chapter 2 : Configuring MySQL 8

Module 3: Chapter 3 : MySQL Users and Privilege System

Module 4: Chapter 4 : MySQL Replication

Course Instructors

Peter Boros

Instructor

Peter Boros is the instructor for this course

Course Reviews

Average Rating Based on 4 reviews

4.8

75%

25%