Chapter 1 - Introduction

Table of content


SQL, one type of programming language that the propose is to retrieve data and manipulate data; and the data are kept in database management system (DBMS) like Microsoft SQL Server, Oracle, DB2 and etc.

Unlike text file or XML, DBMS are actually storing data into rows and column format, whereby it had to be predefined at the beginning stage of development.

Data in a text file.

Data in XML format.

Data in DBMS format.

There are 2 way to manipulate the data that stored in database.

1. Get the data output-ed in desire format/condition, output can be different from the data stored in database (SELECT).
2. Permanently modified the data in the database (INSERT/UPDATE/DELETE/MERGE).

To retrieve the data from database, following is the syntax.

SELECT <column name> FROM <table name> JOIN <table name> WHERE <condition>

Next
Chapter 2 - SELECT