What is SQL?

Acronym SQL stands for Structured Query Language used to communicate between you and the database. Data is stored in the database in the form of tables. SQL is used to
  • Write data in a database
  • Read (query) data stored in a database
  • Update and insert new data
Syntax for SQL depends on the relational database management system (RDBMS) you are working with and some popular RDBMS are SQL Server, MySQL, PostgresSQL.
Database Stores organised information. Within database we have tables which are structured list of data elements. A table is made up of one or more columns. A row in a table is called as "Record".
customers table
Data Modelling is the process of organising and structuring information into multiple related tables.