Description

COURSE OBJECTIVESYou Will Learn How To:

• Design, build and use a relational database using proven methods

• Ensure database designs accurately model business requirements

• Normalize and denormalize your data to optimize performance

• Work with integrity constraints

• Automatically generate database documentation using CASE tools

• Simplify code and improve performance by avoiding common errors

Hands-On Experience: You are provided with an in-classcomputer dedicated for your sole use.

• Analyzing and documenting database structures with CASE tools

• Identifying entities, attributes, relationships and their properties

• Reverse-engineering an Oracle database

• Building a database using a data model as a blueprint

• Accessing a relational database using SQL

TARGET PARTICIPANTSAnyone involved in designing, building and using relational databases, implementing database applications or managing database development projects. Experience with relational databases is not necessary.