Computer Based Training - Oracle9i SQL 1Z0-007: Creating Tables and Constraints

Summary:

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

Objectives:

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

Outline:

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

Features:

Exercises that allow users to practice the application
A file containing the text of the exercises
Simulations that allow users to practice course skills, even if they don't have access to the application
A glossary
A Skill Assessment

Applicability:

This course is for anyone who is interested in learning more about Oracle9i SQL and in taking the Oracle 9i exam 1Z0-007: Introduction to Oracle 9i:SQL.

Prerequisites:

Oracle9i SQL 1Z0-007: Introduction to SQLOracle9i SQL 1Z0-007: Intermediate QueriesOracle9i SQL 1Z0-007: Queries with Single-Row FunctionsOracle9i SQL 1Z0-007: Combining TablesOracle9i SQL 1Z0-007: Grouping and Summarizing DataOracle9i SQL 1Z0-007: Advanced Queries and ViewsOracle9i SQL 1Z0-007: Working with Data

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

Oracle9i™ is a trademark of the Oracle Corporation.

Terms of Use:

None