Coding With Fun
Home Docker Django Node.js Articles FAQ

SQL guide to website construction


May 27, 2021 Website construction guide


Table of contents


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":

LastName FirstName Address City
Hansen Ola Timoteivn 10 Sandnes
Svendson Tove Borgvn 23 Sandnes
Pettersen Kari Storgt 20 Stavanger

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:

SELECT LastName FROM Persons

The result set is something like this:

LastName
Hansen
Svendson
Pettersen


How do I learn SQL?

Visit our complete SQL tutorial