Register Now      202-747-5000

Introduction to Database Design

2010 | 2013 | 2016
1 Day, 9:00-4:00

Course Overview

This thought-provoking course will explain important database terms and concepts that everyone should know in order to properly design a relational database. The emphasis of this course is 1) building the tables, 2) establishing the relationships between the tables and 3) understanding the various considerations when building a relational database. Microsoft Access is the software used for the examples throughout this course; however, the concepts learned can be applied to any relational database application.

This course is designed for students that need to create their own relational database or that are on a team and need to give feedback regarding the design of the database. Students should have a basic understanding of Microsoft Access or another relational database application.

Course Objectives

  • Understand the why and what behind a relational database
  • Review the steps for designing a relational database

Course Outline

What is a Relational Database?

Steps for Designing a Relational Database

  • Step 1: Determining General Requirements
  • Step 2: Generating a List of Fields
    • Splitting Information into Multiple Fields
    • Handling Calculated or Derived Fields
  • Step 3: Determining the Data Type for Each Field
    • Data Validation Rules
  • Step 4: Organizing the Fields into Appropriate Tables
    • How Many Tables Should I Create?
    • Dealing with Privileged Information
  • Step 5: Relating Multiple Tables
    • Understanding Key Fields
    • Types of Relationships
  • Step 6: Setting Referential Integrity
  • Step 7: Testing the Structure

On Your Own

Sample Worksheets

  • Worksheet 1: Determine General Requirements
  • Worksheet 2: Generate a List of Fields
  • Worksheet 3-4: Determine the Data Types and Organize the Fields
  • Worksheet 5-6: Relate Multiple Tables and Set Referential Integrity

 

Cost and Delivery Format Options

We offer the above listed class as a private group class in the following delivery formats:

Private Group Class: Live Virtual
1-4 students $950
5-8 students $1400
9-12 students* $1600
*$100 per additional student
Private Group Class: At Your Location or Softek
1-4 students $1100
5-8 students $1550
9-12 students* $1750
*$100 per additional student

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

  • A computer for each student (with the appropriate software installed), and
  • An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).

Customization

Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $125 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization. There is a 2-hour minimum fee for customization.

Why Choose Softek?

  • Live, virtual or in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee