Topics to Be Covered in This Course (Cont.)


Databases
A database is a collection of information organized in such a way that a computer program can quickly select desired pieces of data. In a relational database the data and relations between them are organized in tables.

A table is a collection of records and each record in a table contains the same fields. To access information from a database, you need a database management system (DBMS). This is a collection of programs that enables you to enter, organize, and select data in a database.

SQL (Structured Query Language)
SQL is a specialized programming language designed for managing and manipulating data stored in databases.

Demonstration
Below is an SQL test area from W3Schools, which uses the well-known Northwind sample database. The tables here are for read only because of the problem of embedding the scripts. For a fully working example, check this by using Chrome.

SQL Statement:

Edit the SQL statement and click     to see the result, or  

Result:
The Database includes:
The Database includes:

TablenameRecord
Customers91
Categories8
Employees10
OrderDetails518
Orders196
Products77
Shippers3
Suppliers29


Review: SQL (Structured Query Language)
Which function can NOT be performed by SQL?
      Create new tables in a database.
      Delete records from a database.
      Receive user inputs.
      Update records in a database.
Result: