Overview

For many new or intermediate database developers, it's difficult to know where to start when designing a relational database. It's easy to make the mistake of assuming that the functionality of a database will take shape over time, or the design will fall into place as you build the database. This course covers the steps to effectively plan and design functional, efficient databases.

Course Objectives

You will plan a relational database so that you have a database that is efficient and easy to maintain.

Prerequisites

Before taking this course, you should have a basic understanding of your computer's operating system. For example, you should know how to launch an application, create and save files, and copy files from CD and other media. You should have some familiarity with data tables and basic knowledge of how to create queries in Microsoft Access.

To ensure your success, we also recommend you first take Access 2002: Levels 1 and 2.

Target Student:

Individuals who already use relational databases, and have a need to design or modify the design of tables to be used in a relational database management system. They know the basics of how to use a relational database, but do not know how to design a database.

Platform Requirements

• Windows 98, Me, NT 4.0 (Service Pack 6), Windows 2000, or Windows XP (Windows 2000 or XP recommended).