Introduction to SQL
SQL is a standard computer language used to access and manipulate databases.
What is SQL?
SQL refers to Structured Query Language, and its full name is Structured Query Language.
SQL allows you to access and work with databases.
SQL is an ANSI (American National Standards Institute) standard computer language.
What can SQL do?
SQL executes queries against the database
SQL can retrieve data from the database
SQL can Insert new records in the database
SQL can update data in the database
- ##SQL can delete records from the database
- SQL can create a new database
- SQL can create a new table in the database
- SQL can create storage in the database Procedure
- SQL can create views in the database
- SQL can set permissions on tables, stored procedures and views
SQL is a standard - but...Although SQL is an ANSI (American National Standards Institute) standard computer language, there are still many different versions of the SQL language. However, in order to be compatible with the ANSI standard, they must jointly support some major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE, etc.) in a similar manner.
 | Note: In addition to the SQL standard, most SQL database programs have their own proprietary Expand! |
|---|
Using SQL in your websiteTo create a website that displays data from a database, you need:
- RDBMS database program (such as MS Access, SQL Server, MySQL)
- Use a server-side scripting language, such as PHP or ASP
- Use SQL to get the data you want
- Use HTML/CSS
RDBMS
