Know about SQL and get started to use it

Share

In this article, you will learn about what exactly SQL is and how we can use it on our website. let’s get started with the history of SQL and its basics.

History of SQL

Initially created in the 1970s, SQL became the de facto standard programming language for relational databases after they emerged in the late 1970s and early 1980s. Finally, An official SQL standard was adopted by the American National Standards Institute (ANSI) in 1986 and then by the International Organization for Standardization, known as ISO, in 1987

What is SQL?

  1. SQL stands for Structured Query Language
  2. It is use to access or manipulate databases.

Why SQL?

SQL is used for :

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

How to use SQL?

In order to use SQL in a website that fetches data from the website, the following prerequisites are required:

  1. RDBMS ( Relational Database Management System ) Program . Like : MySQL, MSAccess, PostgreSQL  and many more
  2. Server Side scripting language like PHP or ASP
  3. SQL commands
  4. HTML/CSS to rendering and styling.

# RDBMS

RDBMS stands for Relational Database Management System and is the basis for SQL and all modern databases. Data stored in RDBMS are in the form of tables, further classified into rows and columns.

Some most used RDBMS are MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. we will continue this series of SQL using MySQL servers.

# Commands and Syntax

SQL commands are a set of instructions that communicates with the database and performs specific tasks or functions. Operations like create a table, add data to tables, drop the table, modify the table, set permission for users. There are 5 types of SQL commands, which you can read here in detail.

Share
Sudeep Mishra

Sudeep Mishra

Healing

One thought on “Know about SQL and get started to use it

Leave a Reply

Your email address will not be published.

%d bloggers like this: