This course examines creating and changing tables and defining constraints on tables in Oracle9i SQL.
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
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
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
