|
This course shows users how to create and alter tables, define data types, and ensure integrity by implementing constraints.
Objectives:
After completing this course, students will be able to:
- Create and alter database objects
- Create and alter tables
- Design and create constraints
- Alter database objects to support replication
Topics:
- Creating and altering database objects
- Tables and data types
- Creating tables
- Modifying and deleting tables
- System-supplied data types
- User-defined data types
- Designing attribute integrity
- Cascading referential integrity/disabling constraints
- Replication and data types
- Generating column values
- Creating DEFAULT and RULE objects
|
