What is SQL?

SQL stands for Structured Query Language, and is used to access(retrieve), create(store) and manipulate(update, delete) data from a database of a web server.

  • SQL stands for Structured Query Language
  • SQL lets you access, store and manipulate data
  • SQL is an ANSI (American National Standards Institute) standard
  • SQL is the standard used by RDBMS like MySQL, SQL Server, Microsoft Access, Oracle, Sybase, DB2 and many others

There are so many things SQL can do as basically stated above. It can do basically almost anything that involves accessing, creating, storing and manipulating data from a database housed by a server.

  • SQL can be used to execute queries against a database
  • SQL can be used to retrieve data from a database
  • SQL can be used to insert records in a database
  • SQL can be used to update records in a database
  • SQL can be used to delete records from a database
  • SQL can be used to create new databases
  • SQL can be used to create new tables in a database
  • SQL can be used to create stored procedures in a database
  • SQL can create views in a database
  • SQL can set permissions on tables, procedures, and views

What RDBMS?

As said earlier SQL is an ANSI standard which is used by RDBMS which includes MySQL, Microsoft SQL Server, Microsoft Access, Oracle, Sybase, DB2 and many others. Although these database systems all use the standard SQL commands, they all have their own specific SQL extensions for example Microsoft SQL Server uses T-SQL, Oracle uses PL/SQL, Microsoft Access uses JEt SQL and so on. It is known that some SQL database programs even have their own extensions too in addition to the SQL standard.
RDBMS stands for Relational Database Management System.

  • RDBMS stands for Relational Database Management System
  • Examples of RDBMS are MySQL, SQL Server, Microsoft Access, Oracle, Sybase, DB2 and many others
  • RDBMS uses tables to store data
  • RDBMS all mostly use same basic SQL commands like SELECT, UPDATE, DELETE, INSERT, WHERE
  • RDBMS mostly have their own SQL extensions