The aim of this unit is to look at how to create databases, how to alter them, and how to add tables to a database. These tables are created with certain constraints such as primary keys, foreign keys, etc. The unit then looks at how to insert data into the tables that were created.
Detailed explanations and exercises are given to demonstrate how to query information from a database. Certain data is selected from a table as well as inserting selected data in another table. The unit also explains how to update and delete information in a table.
There are a few extras including indices, joins, views, stored procedures, and triggers. These are all explained to give the database and functions an edge.
|
