Total Time: 2 hour(s)

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

Ojectives: 
After completing this course, students will be able to:
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 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.