Learn MySQL – New Technology Week

This is the last week of the year and most places it is a holiday. While we learn about SQL Server entire year, let us get out of the comfort zone and learn about different technology every day of the week. Today we will discuss where we can learn MySQL.

MySQL is an open-source relational database management system (RDBMS). One of the most common requests I hear in the MySQL world is that there is not a good enough video tutorial and courses available for the technology. I decided to build courses that are easy to understand. I made sure that while I build these courses, I do not assume anything. Even if there is a small detail, I would like to cover in my course. Looking at the feedback and acceptance in the industry, I believe I have been successful in doing the same.

Learn MySQL – Learning Path

• Course 1: MySQL Fundamental – 1
  MySQL is a popular choice of database for use in web applications and is a central component of the widely used LAMP open-source web application software stack. This course covers the fundamentals of MySQL, including how to install MySQL as well as written basic data retrieval and data modification queries.
• Course 2: MySQL Fundamental – 2
  MySQL is a popular choice of database for use in web applications and is a central component of the widely used LAMP open-source web application software stack. In this course, which is part 2 of the Fundamentals of MySQL series, we explore more advanced topics such as stored procedures & user-defined functions, subqueries & joins, views and events & triggers.
• Course 3: MySQL Indexing for Performance
  Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. Indexes are the silver bullets for Performance. In this course we will gain an understanding of the basics of Indexes and further explore practical tips and tricks for performance tuning.
• Course 4:  MySQL Query Optimization and Performance Tuning
  Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. In this course, we will understand the basics of query optimization and look at practical tips and tricks for performance tuning.
• Course 5:  MySQL Workbench Guided Tour
  A detailed exploration of MySQL Workbench, a unified visual tool for data modeling, SQL development, and comprehensive administration tools for MySQL. This course will guide you through maximizing the power of MySQL Workbench and getting productive quickly with MySQL.
• Course 6: MySQL Backup and Recovery Fundamentals
  Data is very important to any application and business. It is very important that every business plan for data safety. Database backup strategies are often discussed after the disaster has already happened. In this introductory course, we will explore a few of the basic backup strategies every business should implement for data safely. We will explore how we can recover our server quickly after any unfriendly incident to our MySQL database.
• Course 7:  Monitoring MySQL with Performance Schema
  The latest version of MySQL has introduced a new feature of MySQL Performance Schema, which monitors MySQL server execution at a low level. The performance schema provides internal execution details of MySQL queries at run time, and it’s minimum impact on the performance of MySQL resources. In this course, Monitoring MySQL with Performance Schema, you’ll learn how to maximize your data-based performance with the use of performance schema.
• Course 8: phpMyAdmin Fundamentals
  phpMyAdmin is a free and open-source tool written in PHP for the administration of MySQL via a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields, and rows as well as executing SQL statements or managing users and permissions. This course will guide you through maximizing the power of phpMyAdmin to get productive quickly with MySQL.

I hope you find this MySQL Learning Path helpful. If you have a Pluralsight subscription, you can watch it for free. If you do not have a Pluralsight subscription, you can still watch the course for FREE by signing up for a trial account.

Reference: Pinal Dave (https://blog.sqlauthority.com)