What is SQL?

  • SQL stands for Structured Query Language.
  • It is also Pronounced as See-Quell.
  • SQL is a programming language used for storing and processing information in a relational database.
  • SQL language is mainly designed to maintaining database in Relational Database Management System (RDMS).
  • A relational database stores information in tabular form, with rows and columns representing different data attributes and the various relationships between the data values.
  • SQL was developed by IBM in the early 1970s and became commercially available in 1979.
  • SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987.

What is use of SQL language?

SQL is not database system, it is language which is used by database management system like Oracle, MySQL, Microsoft SQL Server, MongoDB and More. Social media like Facebook, Instagram, LinkedIn uses SQL for storing data in back-end. Programming language like php, asp.net and python use SQL for backend.

 In other word SQL is used for

  •  Creating new databases.
  • Insert new record in database.
  • Update records in a database.
  • Delete records from a database.
  • Create new tables in a database.
  • Create stored procedures in a database.
  • Create views in a database.

What is Data?

  • Data is collection of information.
  • Data can be name, number, Image, Video, Audio.

What is a Database?

A database is a collection of organized data in tabular form, with rows and columns that is stored electronically in a computer system. In other words,  database typically consists of tables, which contain columns and rows which helps users to easily store, retrieve, and update information.

What is RDBMS?

  • RDBMS stands for Relational Database Management System.
  • The software used to store, manage, query, and retrieve data stored in a relational database is called a relational database management system (RDBMS).
  • The RDBMS provides an interface between users and applications and the database for managing data storage, access, and performance.
  • RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
  • The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.