What you'll get

  • Job Credibility
  • Certification Valid for Life
  • On-demand video*
  • E-Book
  • Self-Paced Learning
  • Certificate of Completion

Exam details

  • 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.

Course Content

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

Reviews

Please login or register to review
Frequently Asked Questions