SQL Tutorial

What is SQL?

SQL Stands for Structured Query Language

SQL is a language to perform actions on databases like MYSQL, OracleDB, MongoDB, SQL Server etc.,

SQL is an ANSI Standard.

All Database use SQL as the standard database language.

Note: SQL is just a language, not a database where most people get confused by it as a database.


What is SQL Used for?

SQL is used:

  • To create a Database, tables, views.
  • To insert and retrieve records into database
  • To update records in database
  • To delete records in database


What can SQL do?

  • SQL can create, delete, update database.
  • SQL can create, delete, update, alter and drop new tables in a database.
  • SQL can insert, retrieve and update data records in a database.


What is Database?

The database is the collection of organized data.

The database is mainly used to operate a large amount of data by storing, retrieving and managing.

Every dynamic website on the WWW (World Wide Web) uses a Database to operate data of the site. For Example, e-commerce sites use the database for their operations.

There are many databases available. MYSQL, Oracle DB, Mongo DB, SQL Server, etc..


What is DBMS?

DBMS stands for Database Management System.

DBMS is used for managing the data like storing, retrieving data in an organized manner.


What is RDBMS?

RDBMS stands for Relational Database Management System.

It is as same as DBMS but it is based on the Relational model by E.F. CODD.

Databases like MYSQL, Oracle, SQL Server, IBM DB2, MS ACCESS are based RDBMS.


How RDMS works?

RDBMS is the most commonly used Database.

The data is stored in a number of tables in the terms of rows (tuples). Every table will have a primary key to retrieve data easily.

Data can be easily managed in RDBMS as the data is well organized in tables.