SQL Learning Guide | SQL Tutorial Part 1

SQL stands for “Structured Query Language”. SQL’s earlier name was SEQUEL. SQL is a programming language used to interact with structured databases. In structured database, data is stored in a tabular form i.e. in the form of rows and columns. In database terms, rows are referred as a records or tuples, and columns are referred as a field or an attribute.

To manage structured database, we use SQL Language. SQL help us to create, update and delete a database. It also helps in reading and writing into a database. Some of the most popular structured databases are MySQL,PostgreSQL, Microsoft SQL Server, Oracle etc. These different types have created their own SQL variations to interact with their databases, but more or less they all are similar with some syntax variations.

Case Sensitivity in SQL :

SQL is a case insensitive, i.e. it doesn’t matter whether we write SQL keywords in uppercase, lowercase or in any case. For Example -

SELECT * FROM Employees WHERE Join_Date > '2022-10-04';

SeLeCt * FRom Employees WherE Join_Date > '2022-10-04';

select * from Employees where Join_Date > '2022-10-04';

SQL COMMANDS :