MySQL Server is one of the most popular RDMS(Relational Database Management System) server providing various options to manage a relational database using tables having columns and rows. It's widely used due to its speed, ease of use and robustness.
This post is the starting point of the series to learn the basics of SQL using MySQL server and maintains a list of posts available in this series. You can use either MySQL Shell or MySQL Workbench to execute the queries. The other popular option is to install phpMyAdmin.
In case you have not downloaded MySQL and workbench yet, you can also follow below listed tutorials.
- How To Install MySQL 8 on Windows
- How To Install MySQL Workbench On Windows
- How To Install MySQL 8 on Ubuntu
- How To Install MySQL Workbench On Ubuntu
Basics of SQL using MySQL
Where Clause (with AND, OR, IN, NOT IN, IS NULL, IS NOT NULL)
Searching (LIKE, NOT LIKE)
Sorting (ORDER BY, ASC, and DESC)