Job Credibility
Certification Valid for Life
Live Classes
Certificate of Completion

Mode of Exam : Online
Duration : 1 Hour
Multiple Choice Questions are asked
No. of Questions are asked : 50
Passing Marks : 25 (50%)
There is no negative marking

Welcome to the course, " Certified MySQL 8 for Administrators" which is the most popular open source database which comes with a major update.

The aim of this course which is comprehensive and concise is to assist you on setting up MySQL 8 and run with replication, know about database administration chapters like backups, replication, monitoring, switchovers, user management and version upgrades. It is designed by step by step instructions which is full of working examples which will help you to solve any problem you might find in MySQL administration.

In this course you will learn an Introduction to MYSQL 8, their core features in MySQL and the improved features in MySQL 8, their benefits, limitations, use cases. You will also know how to install and Upgrade MySQL 8, their installation process, post-installation setup, and how to upgrade and downgrade MySQL 8.

Throughout this course you will also learn how to use programs and utilities, the overview of MySQL 8 programs, their command line programs, client programs, administrative programs, environment variables and MySQL GUI tools.

Many more topics like:

MySQL 8 Data Types
Overview of MySQL 8 data types
Numeric data types
Date and time data types
Caching techniques
Globalization
MySQL 8 server logs
MySQL 8 client errors
MySQL 8 troubleshooting approach
Real-world scenario

You will learn all these things in detail and many other things which are in a very explained manner.

You will just require some basic knowledge of database concepts. And everything here is discussed in very to the point manner.

This course is for system administrators, Coding enthusiasts, programming enthusiasts, students pursuing computer science, and people belonging to IT industries.

The full course will be taught from scratch, from the root to the core. Now it is expected that when you are about to finish this course you will be well known with the high performance querying and database administration using MySQL. You will get many job opportunities and after this course which will ofcourse be an advantage to you. You will be provided with great knowledge, so what are you waiting for? Enroll your name in this course now.

Total: 97 lectures

An Introduction to MYSQL 8
Core features in MySQL
Improved features in MySQL 8
Benefits of using MySQL 8
Limitations of MySQL 8
Use cases of MySQL

Installing and Upgrading MySQL 8
The MySQL 8 installation process
Post-installation setup for MySQL 8
Upgrading MySQL 8
MySQL 8 downgrading

MySQL 8 – Using Programs and Utilities
Overview of MySQL 8 programs
MySQL 8 command-line programs
MySQL 8 client programs
MySQL 8 administrative programs
MySQL 8 environment variables
MySQL GUI tools

MySQL 8 Data Types
Overview of MySQL 8 data types
Numeric data types
Date and time data types
String data types
JSON data type
Storage requirements for data types
Choosing the right data type for column

MySQL 8 Database Management
MySQL 8 server administration
Data directory
The system database
Running multiple instances on a single machine
Components and plugin management
Roles and permissions
Caching techniques
Globalization
MySQL 8 server logs

MySQL 8 Storage Engines
Overview of storage engines
Several types of storage engines
The InnoDB storage engine
Creating a custom storage engine

Indexing in MySQL 8
An overview on indexing
Column-level indexing
B-Tree index
Hash index
Index extension
Using an optimizer for indexes
Invisible and descending indexes

Replication in MySQL 8
Overview of replication
Configuring replication
Implementing replication
Group replication
Replication solutions

Partitioning in MySQL 8
Overview of partitioning
Types of partitioning
Partition management
Partition selection and pruning
Restrictions and limitations in partitioning

MySQL 8 – Scalability and High Availability
Overview of scalability and high availability in MySQL 8
Scaling MySQL 8
Challenges in scaling MySQL 8
Achieving high availability

MySQL 8 – Security
Overview of security for MySQL 8
Common security issues
Access control in MySQL 8
Account management in MySQL 8
Encryption in MySQL 8
Security plugins

Optimizing MySQL 8
Overview of MySQL 8 optimization
Optimizing MySQL 8 servers and clients
Optimizing database structure
Optimizing queries
Optimizing tables
Leveraging buffering and caching

Extending MySQL 8
An overview of extending MySQL 8
Extending plugins and using services to call them
Adding new functions
Debugging and porting

MySQL 8 Best Practices and Benchmarking
MySQL benchmarking and tools
Best practices for memcached
Best practices for replication
Best practices for data partitioning
Best practices for queries and indexing

Troubleshooting MySQL 8
MySQL 8 common problems
MySQL 8 server errors
MySQL 8 client errors
MySQL 8 troubleshooting approach
Real-world scenario

₹3,500 ₹15,000

What you'll get

Exam details

Course Content

Reviews

For Support

Office Hours

We are on

Company

Customer Service

Help