SQL Stands for Standard Query Language. SQL lets us to create, delete, and manipulate databases. It is useful in handling structured data where there are relations between different entities/variables of the data.
How many employees of company are getting salary higher than 50000?
This can be achieved using SQL.
To run sql syntax, manage database and tables, we are going to need a Relational Database Management System (in short RDBMS) software package. There are plenty but the following are used widely.
For learning purpose we are going to use MySQL. If you learn any one RBMS Software then you can use any other software too.
If you have not installed xampp yet, then install it now. It will help you to learn lots of language easily at your own computer system.
Want to know, how to install xampp in Mac and Windows OS then read following article
REMEMBER: MySQL is a software. Most commonly known as Relational Database Management System. In short RDBMS. Where as SQL is not a software but a query language. Using SQL syntax we are going to accomplish various tasks in MySQL.
What are these tasks?
Such as database creation, table creation, data insertion, data deletion, table deletion etc.