SQL Guide
SQL - Structured Query Language (Structured Query Language)
SQL is a standard computer language used to access and manipulate databases.
Common database management systems: MySQL, SQL Server, Access, Oracle, Sybase, and DB2
For those who want to store data and retrieve data from the database people, SQL knowledge is invaluable.
What is SQL?
- SQL refers to the Structured Query Language (S tructured Q uery L anguage)
- SQL gives us the ability to access the database
- SQL is an ANSI standard computer language
- SQL for database queries executed
- SQL can retrieve data from the database
- SQL can insert a new record in the database
- SQL can delete records from the database
- SQL is easy to learn
SQL database tables
A database typically contains one or more tables. Each table consists of a name identity (such as "customer" or "Order"). Table contains records with data (rows).
The following example is a table named "Persons" of:
LastName | FirstName | Address | City |
---|---|---|---|
Hansen | Ola | Timoteivn 10 | Sandnes |
Svendson | Tove | Borgvn 23 | Sandnes |
Pettersen | Kari | Storgt 20 | Stavanger |
The above table contains three records (each corresponding to a person) 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.
Discover the program like this:
The result set will look like this:
LastName |
---|
Hansen |
Svendson |
Pettersen |
How to learn SQL?
Visit our complete SQL Tutorial