Relational Database Design: A Practical Approach

Students will learn the general principles involved in designing a database that complies with the relational database model.

Benefits:

Students will learn how to correctly design tables for use in a relational database application.

Prerequisites:

Some familiarity with data tables and basic knowledge of how to create queries in Access 97 or Access 2000.

Target Student:

Students enrolling in this course should have a need to design or modify the design of tables to be used in a relational database management system.

Performance-Based Objectives:

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

Be conversant with the terminology used in reference to relational databases and be familiar with the design process.
Identify data as fields, group fields into tables, select key fields, and identify table relationships.
Identify data problems and apply data normalization techniques to solve them.
Use referential integrity and other data integrity techniques to support the accuracy of data in the database.
Use criteria and operators and perform appropriate table joins in queries.
Understand basic SQL queries and techniques for improving the performance of queries.

Delivery Method:

Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Course duration:

1 Day(s)

Course outline:

Lesson 1: Introduction to Relational Databases

The Basics of Relational Databases
Planning the Database

Lesson 2: Designing Tables

Deciding on Tables and Fields
Selecting Primary Key Fields
Identifying Table Relationships
More on Keys and Relationships

Lesson 3: Data Normalization

Solving Data Problems
Higher Normal Forms

Lesson 4: Data Integrity

Referential Integrity
Field-level Integrity
Table-level Integrity
Reviewing and Finalizing the Database Design

Lesson 5: Query Basics

Performing Queries
Multiple Table Queries

Lesson 6: More on Queries

Other Types of Queries
SQL
Optimizing Query Performance

Appendix: Additional resources

Hardware/Software Requirements:

The conceptual content of this course in not specific to any software application. Microsoft Access 97 or Access 2000 is needed to perform the tasks in the lessons pertaining to queries.

Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2008 Wintrac Inc.