The Aggregate functions world in the MySQL
In this post, we will see how to use aggregate functions in MySQL. Each function takes the column name and according to their functionality returns the numeric value.
SQL Tutorial
Update and delete commands in MySQL
In this post, you will see how to use update and delete commands in MySQL. As the name suggests they are used to update or delete the data in table. But there are some important thing we need to keep in mind while using those commands.
Order by keyword and is null operator
In this post, you will see how to order the data in ascending or descending order. Also you will see how to is the field is NULL or not with IS NULL and IS NOT NULL operator.
AND, OR, and NOT operators in MySQL
In this post, you will see AND, OR, and NOT operators in MySQL. How to filter data by combining these operators with WHERE clause. Also, how to combine these operators with each other.
WHERE clause in MySql
In this post, you will learn about WHERE clause in MySql command line. Where clause is used to fetch data with some specific conditions. If that specific condition is met, then it return the data to print.
Fetch data using select keyword
In this post, you will see how to fetch data using select keyword. Also, you will see different options to use with select statement. You will see how to use distinct keyword with the select statement.
Creating database, tables and inserting data
In this post, you will see how you can create database, table and insert data into table. Also you will learn what are the things required while creating table.
How to install MySQL command line?
In this post you learn to install MySQL command line client for windows. Also you will see how you can use phpMyAdmin instead of command line client.
Introduction to SQL, Databases and RDBMS
In this post you will see what is SQL, what is database. Also what is RDBMS and database systems which follows RDBMS. SQL command type based on their usage.