Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Part II. Building Your Database
Hour 3. Managing Database Objects
In this hour, you learn about database objects: what they are, how they act, how they are stored, and how they relate to one another. Database objects are the underlying backbone of the relational database. These objects are logical units within the database that are used to store information, and are referred to as the back-end database. The majority of the instruction during this hour revolves around the table, but keep in mind that there are other database objects, many of which are discussed in later hours of study.
The highlights of this hour include
An introduction to database objects
An introduction to the schema
An introduction to the table
A discussion of the nature and attributes of tables
Examples for the creation and manipulation of tables
A discussion of table storage options
Concepts on referential integrity and data consistency