SQL guide to website construction

SQL Guide

SQL - Structured Query Language

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

Common database management systems: MySQL, SQL Server, Access, Oracle, Sybase, and DB2

FOR those who want to store and get data in a database, SQL's knowledge is insa measured value.

What is SQL?

• SQL refers to structured query language (S tructured Q uery L anguage)
• SQL gives us access to the database
• SQL is a standard computer language for ANSI
• SQL performs queries on the database
• SQL can take data back from the database
• SQL can insert new records into the database
• SQL can delete records from the database
• SQL is easy to learn

SQL database table

A database typically contains one or more tables. E ach table is identified by a name (for example, "Customer" or "Order"). T he table contains records (rows) with data.

The following example is a table called "Peoples":

The table above contains three records (one person for each) and four columns (last name, first name, address, and city).

SQL query program

With SQL, we can query a database and get a result set returned.

The query program is something like this:

The result set is something like this:

How do I learn SQL?

Visit our complete SQL tutorial