3 arrows

Popular Mirantis On Demand Training Courses Now 50% Off

closeClose

MySQL Learning Subscription

  • Tuition USD $3,495
  • Reviews star_rate star_rate star_rate star_rate star_half 2915 Ratings
  • Course Code LS51871
  • Available Formats Subscription

MySQL Learning Subscription

The MySQL Learning Subscription includes everything you need to get the most from your MySQL installations. MySQL is the world's most popular open-source database. It includes InnoDB, making it a fully integrated, transaction-safe, ACID-compliant database. In addition, MySQL Replication allows you to deliver high performance and scalable applications.

MySQL Cluster is the distributed database combining linear scalability and high availability. It provides in-memory, real-time access with transactional consistency across partitioned and distributed datasets. It is designed for mission critical applications.

Learn MySQL through Online, Expert-led Training Courses

MySQL experts, consultants, engineers, and support technicians lead Oracle University training courses within this subscription, drawing upon years of experience, best practices, and established guidelines. The MySQL Learning Subscription includes content all MySQL professionals need to know:

  • The layout of an installed server
  • Client and server executables and their options
  • Running and evaluating queries
  • Database design and structure
  • Securing MySQL with privileges and roles

Deep dive into specialist training modules that help you develop a deep understanding of administration, development, security, and high availability.

Learn to:

  • Configure replication, perform backups, monitor, and troubleshoot your servers
  • Develop Java, Python, and PHP programming skills to connect to MySQL servers and run web applications and complex reports
  • Use JSON and the MySQL Document Store to enable both NoSQL and SQL access to relational data
  • Configure sharded highly-available clusters with MySQL Cluster and the NDB networked storage engine
  • Practice advanced security techniques including encryption at rest, key-based security, MySQL Firewall, Enterprise Audit, and password validation and authentication plugins

Experienced DBAs: Access Advanced MySQL Training to Build MySQL High Availability, Performance, and Security Expertise

This subscription includes training modules designed specifically for experienced DBAs. These courses focus on exploring the difference between MySQL and other database platforms, including Oracle Database. Dive into case studies that illustrate how large web companies use MySQL to improve their bottom line while accessing "What's New" content that highlights key changes in new versions.

Finally, get a detailed walk-through to understand functionalities within the optimizer and transactional data dictionary (TDD).

Who Can Benefit

This Learning Subscription covers:

Topics

Below is just a sample of the topics included in this learning subscription:

  • What's New in MySQL 8.0
  • Using Subqueries to Solve Queries
  • Using Single-Row Functions to Customize Output
  • Tuning Storage
  • Troubleshooting and Optimizing MySQL NDB Cluster
  • Securing MySQL Instances
  • Overview of MySQL Performance Tuning
  • Optimizing and Troubleshooting Database Performance
  • Monitoring MySQL Instances
  • Managing and Monitoring MySQL NDB Cluster Instances
  • Managing MySQL Instances
  • Introduction to SQL Workshop 1
  • Introduction to Data Definition Language
  • Installing and Configuring MySQL
  • Implementing MySQL Cloud

Job Roles

  • MySQL administrators
  • Oracle DBAs
  • Database administrators
  • Database architects
  • Developers
  • IT managers
  • Security administrators
  • Web administrators
  • Data scientists
  • Database developers
  • NoSQL developers

Learning Paths

  • Getting Started with MySQL
  • MySQL Database Administration
  • MySQL Development
  • Securing MySQL
  • MySQL Cluster Administration
  • MySQL for Oracle DBAs
  • MySQL Extras

Skills Learned

  • Install and configure MySQL Server and client programs
  • Recognize the key components of the MySQL architecture
  • Secure your server
  • Troubleshoot server slowdowns and other issues
  • Improve query performance
  • Configure and administer a variety of replication topologies
  • Understand the benefits of MySQL Cloud
  • Install and configure MySQL Cluster nodes
  • Design simple and advanced cluster topologies
  • Secure cluster nodes and data
  • Backup and restore cluster data
  • Troubleshoot common cluster problems
  • Monitor and optimize cluster performance
  • Use enterprise tools to manage large cluster deployments
  • Understand performance tuning concepts
  • List factors that affect performance
  • Use a range of performance tuning tools
  • Configure and use the Performance Schema
  • Tune the MySQL server instance
  • Design a schema for optimal performance
  • Understand how MySQL optimizes queries
  • Identify and fix slow queries
  • Diagnose and resolve common performance issues
  • Optimize MySQL for your application environment
  • Identify the performance impact of hardware

MySQL Database Administrator and Developer Certification Exams Included with this Subscription

Gain professional recognition for your expertise with an Oracle Certification. This learning subscription provides you with one attempt to take the following Oracle Certification exams, at no additional charge, during the subscription period. Pass the MySQL exams and earn the corresponding Oracle Certification:

 

  • MySQL 8.0 Database Administrator | 1Z0-908
  • MySQL 8.0 Database Developer | 1Z0-909

 

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

The course material and the instructor were very good. This course met all my requirements.

Its really nice to have the snacks available everyday. The staff is courteous and professional.

Great course, with an amazing instructor Ruben Lopez. Would definitely recommend this course.

Everything went well. Enrollment process was easy and I always felt welcomed throughout the whole experience.

Great experience learning from ExitCertified. I would definitely come back to them for additional training.

Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward