C++ DEVELOPER SITE
HTMLCSSJAVASCRIPTSQLPHPBOOTSTRAPJQUERYANGULARXML
 

SQL Introduction


SQL is a standard computer language for accessing and processing databases.


What is SQL?

  • SQL stands for Structured Query Language, and its full name is Structured Query Language.
  • SQL lets you 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 updates data in the database
  • SQL can delete records from the database
  • SQL can create a new database
  • SQL can create new tables in the database
  • SQL can create stored procedures in the database
  • 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 collectively support some major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE, and so on) in a similar manner.

Note: In addition to the SQL standard, most SQL database programs have their own proprietary extensions!


Use SQL in your website

To create a website that displays data from a database, you need:

  • RDBMS database programs (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
  • Using HTML /CSS

RDBMS

RDBMS stands for Relational Database Management System, and its full name is Relational Database Management System.

RDBMS is the foundation of SQL and is also the foundation of all modern database systems, such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

Data in RDBMS is stored in database objects called tables.

A table is a collection of related data items. It consists of columns and rows.