X

Introduction to SQL

sql is useful to us when we submit a form, and the data we submit in it, such as the information of a student, which contains information such as his name, address, father name, etc., we have to send that data to our server. have to be uploaded to database, in that case we need sql code.

SQL is connected to our database in a way, if we do any work related to the database, then sql code is used in it.

Example: – Like we have to add or delete personal data of a person, or display the data, verify, many such tasks require sql code.

What is SQL?

  • SQL stands for Structured Query Language
  • SQL lets you access and manipulate databases
  • SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

What Can SQL do?

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

SQL is a Standard – BUT….

Although SQL is an ANSI/ISO standard, there are different versions of the SQL language.

However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECTUPDATEDELETEINSERTWHERE) in a similar manner.

Example:-

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal','Tom B. Erichsen','Skagen 21','Stavanger','4006','Norway');

HTML
Categories: SQL TUTORIAL
coding786: