MySQL QA Episode #1: Bash/GNU Tools & Linux Upskill & Scripting Fun

This episode consists of 13 parts, and an introduction. See videos below

In HD quality (set your player to 720p!)

Introduction

Part 1: echo, ls, cp, rm, vi, cat, df, du, tee, cd, clear, uname, date, time, cat, mkdir

Part 2: find, wc, sort, shuf, tr, mkdir, man, more

Part 3: Redirection, tee, stdout, stderr, /dev/null, cat

Part 4: Vars, ‘ vs “, $0, $$, $!, screen, chmod, chown, export, set, whoami, sleep, kill, sh, grep, sudo, su, pwd

Part 5: grep, regex (regular expressions), tr

Part 6: sed, regex (regular expressions)

Part 7: awk

Part 8: xargs

Part 9: subshells, shells, …

Stored routines give you the ability to create a statement in one application (MySQL) that can be used in multiple client applications that use different programming languages or work on different platforms.

Take the MySQL for Developers course to learn more about stored routines and other key topics. This will build your expertise as a MySQL Developer.

You can take this 5-day instructor-led course as a:

• Live-Virtual Event: Attend a live-event from your own desk, no travel required. Choose from a selection of events already on the schedule to suit different timezones.
• In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.

The MySQL for Database Administrators training course is one of the most popular courses at Oracle. This is not surprising since it provides a comprehensive range of administration skills to those using the world's most popular open source database.

You can travel to an education center to take this 5-day instructor-led course, and as shown in the table below, events are currently scheduled for delivery in 8 languages (Arabic, Brazilian Portuguese, English, French, Hebrew, Italian, Spanish, Turkish).

If you want to take this training from your own desk, you have two options:

• Training-on-Demand: Start training within 24 hours of registration, following training at your own pace.
• Live-Virtual Event: Follow a live event …

Just released - the all new MySQL Cluster training course.

This MySQL Cluster training teaches you how to install and configure a real-time database cluster at the core of your application. Expert instructors will teach you how to design and maintain your clusters for high availability and scalability by using MySQL Cluster's open-source and enterprise components.

This 4-day training course is a must for those who want to learn about MySQL Cluster as you will not only learn about the concepts and features but you will get extensive hands-on experience. You can follow this training course from your own desk via a live-virtual training or by traveling to an education center to follow this course.

Be the first to influence the schedule for this …

To learn about the many factors that can affect the performance of the MySQL Database, take the MySQL Performance Tuning course.

You will learn:

• How your hardware and operating system can affect performance
• How to set up and logging to improve performance
• Best practices for backup and recovery
• And much more

You can take this 4-day instructor-led course through the following formats:

• Training-on-Demand: Start training within 24 hours of registering for training, following lectures at your own pace through streaming video and booking time on a lab environment to suit your schedule.
• Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose …

Database modelling is the process of defining the logical structure of a database. This structure determines how data is stored, organized and manipulated. This enables you to:

• Understand your data before building the database
• Consider what questions your data must answer

The entity relationship model (ERM) is the most common model for an RDBMS.

Learn more about database modelling, design and much more in the MySQL for Beginners training course.

You can take this 4-day instructor-led training course via the following formats:

• Training-on-Demand: Start training within 24 hours of registration. Follow lectures at your own pace through streaming video. Book time on a lab environment to suit your …

To ensure that your MySQL Database works as efficiently as possible, it is important to know how to handle error messages and warnings.

Error messages have three components:

• A MySQL-specific error code, such as 1146
• A SQLSTATE error code. These codes are defined by standard SQL and the ODBC standard.
• A text message that describes the problem

MySQL Server generates a warning when it is not fully able to comply with a request or when an action has possibly unintended side effects. You can display these warnings with the SHOW WARNINGS statement.

To learn about handling error messages and warnings along with other developer topics, consider taking the MySQL for Developers training course.

MySQL Replication allows servers to copy changes from one instance to another. Take the MySQL for Database Administrators course to learn about replication, including:

• How to set up a replication environment
• Complex topologies
• Replication types
• Global transaction IDs (GTIDs)
• MySQL Utilities
• Logs and threads

Replication is one of the many topics covered in the MySQL for Database Administrators course. You can take this 5-day instructor-led course as  

• Training-on-Demand: Start …

Get the best from both worlds with bundled packages: a training course and a certification exam voucher. You save 20% when you buy training and certification in discount packages.

Training helps you acquire product expertise. Certification proves this expertise to your future employers.

There are two MySQL Discount Packages: MySQL Database Administration and MySQL Developer.

For more information about the authentic MySQL curriculum, go to …

MySQL Cluster enables high availability by storing data replicas on multiple hosts. MySQL Cluster maintains connections between data nodes by using high-speed interconnects over TCP/IP - standard or direct connections - or SCI (Scalable Coherent Interface) sockets.

To learn more about MySQL Cluster, take the MySQL Cluster training course.

This course is currently scheduled for the following locations: