Learn Basic SQL Queries Using MySQL

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.

1. How To Install MySQL 8 on Windows
2. How To Install MySQL Workbench On Windows
3. How To Install MySQL 8 on Ubuntu
4. How To Install MySQL Workbench On Ubuntu
    

Basics of SQL using MySQL

1. Create Database
2. Drop Database
3. Create Table
4. Insert Query
5. Select Query
6. Where Clause (with AND, OR, IN, NOT IN, IS NULL, IS NOT NULL)
7. Update Query
8. Delete Query
9. Searching (LIKE, NOT LIKE)
10. Sorting (ORDER BY, ASC, and DESC)
11. Group By Clause

Additional Topics

1. Aggregate Functions
2. Transactions