MySQL is a free open source relational database management system (RDBMS). It was originally developed by Oracle Corporation, but now it has become an independent project under the name MariaDB.
In this tutorial you will learn A to Z about MySQL database, from create to delete data including monitoring, optimization, and scaling the system.
Here, in this tutorial you will get everything in 10 Units:
- MySQL Introduction & Installation
- Using MySQL
- MySQL Configuration
- MySQL Transactions
- Binary Logging
- MySQL Backups
- MySQL Restoring Data
- MySQL Replications
- MySQL Security
- MySQL Performance Tunning
MySQL Introduction & Installation
In this section, you will learn basics about MySQL database management system, when it developed? how it comes into market? etc.
You will also learn to install this database system into your system (Linux, window), and also get the knowledge on basic configuration before using the MySQL.
This section explains the concept of using MySQL database with examples.
You will learn how to use MySQL for different purposes like creating tables, inserting data, updating data, deleting data, selecting data, joining multiple tables, querying data, displaying data, sorting data, grouping data, searching data, exporting data, importing data, etc.
In this section, you will see how to configure MySQL server properly.
You will learn some important settings that are required while configuring MySQL server. These include setting up root password, user accounts, hostname, port number, max_connections, tmp directory location, log file location, query cache size, etc.
In this section, you will learn about MySQL transactions. Transactions are used to ensure the consistency of data stored in databases.
In other words, transactions provide atomicity, isolation, and durability. They can be used to perform all kinds of operations such as insert, update, delete, select, or any combination of these.
This section deals with binary logging feature which is used to track all changes made to the database.
The binary logs contain information about each change performed on the table. This helps us to restore the database after any failure. You will learn to configure, read and use these binary logs.
In this section, you will learn how to backup our data. There are two types of backups available in MySQL; full and incremental.
Full backups contain all the data present in the database at one point of time. Incremental backups only contains the changed data since last full backup. You will learn how both these types of backups work. Also, you will understand why we need to take regular backups.
MySQL Restoring Data
In this section, we will learn how to recover a corrupted database.
If you have lost data due to hardware failure, power outage, virus attack, human error, etc., then restoring the data becomes very essential. You will learn how MySQL restores the data from backup or corrupted database.
Replication is a process where data is copied from one place to another. It allows us to have copies of data in more than one place.
For example, if we want to make sure that data is always available even if there is a problem with the primary copy, then replication is used. In this section, you will know what replication is, how it works, and when to use it.
Security is an important aspect of every application. To keep our data safe, we must secure our applications against attacks.
In this section, you will know the various security aspects of MySQL. You will learn how we can protect ourselves from SQL injection, XSS, buffer overflows, cross site scripting, etc.
MySQL Performance Tunning
Performance tuning is an art. It requires experience and expertise.
In this section, you will learn the basic concepts of performance tuning. We will also look into some advanced techniques for improving the performance of your MySQL servers.