Hour 9

Creating and Managing Database Objects

What You’ll Learn in This Hour:

  •    An introduction to database objects

  •    An introduction to schemas

  •    An introduction to tables

  •    The nature and attributes of tables

  •    Examples of creating and manipulating tables

  •    Table storage options

  •    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. Most of the instruction during this hour revolves around tables, but keep in mind other database objects exist, many of which are discussed in later hours of study.

Database Objects ...

Get SQL in 24 Hours, Sams Teach Yourself, 7th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.