MP9003: Network and Database (General) - Creating Tables and Constraints > Oracle9i SQL 1Z0-007

This course examines creating and changing tables and defining constraints on tables in Oracle9i SQL. 

Topics:
Creating tables
Relational and temporary tables
Adding comments
Changing table structures
Renaming, truncating and dropping tables
Constraints
Primary key, unique and foreign key constraints
Table level and check constraints
Adding, modifying and dropping constraints

Objectives:
Create, modify, rebuild, and remove tables
Use the TRUNCATE command
Create, modify and drop constraints
Use primary key constraints
Use foreign key contraints
Add comments to SQL scripts and schema objects

Duration:
2 Hours