Managing SQL Database Objects
- What Are Database Objects?
- What Is a Schema?
- Tables: The Primary Storage for Data
- Integrity Constraints
What You'll Learn in This Hour:
- 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
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 logical units that compose the building blocks of the 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.
What Are Database Objects?
A database object is any defined object in a database that is used to store or reference data. Some examples of database objects include tables, views, clusters, sequences, indexes, and synonyms. The table is this hour's focus because it is the primary and simplest form of data storage in a relational database.