SQL explained: What is SQL | Select Statement | Select Where | Insert | Update/Edit | Delete | Order By | Select Between

What is SQL?

SQL is a language used to talk to and communicate with most databases. You can use SQL to access, define, delete and edit the data in a database system like Oracle, Microsoft SQL Server, Access and others.

A database is a collection of data stored in an organised fashion. The data is usually stored in structured tables. Tables contain Columns and Rows of data. Diagram 1 illustrates an example of a Table called "Members_tbl".

Diagram 1

FirstName, LastName, Address, and City are table Columns. The Rows contain 3 records with personal details about 3 people. As you can gather from the table above Henry lives in the lovely city of 'Dublin', and Dave's address is '32 Donki Park'.

SQL is an important part of using ASP. We use SQL to determine what records we retrieve or manipulate from the database.