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/Investment

Public Course at Softek Private Course at Your Office Private Course at Softek
$350 per student $1400 flat fee up to 8 students $1550 flat fee up to 8 students
  $1600 flat fee up to 12 students $1750 flat fee up to 12 students
  $100 per additional student $100 per additional student

Private Group Training

Private group courses are cost effective when you have a group of students who need the same course. Pricing is based on the maximum number of students anticipated per day per course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your office, you are responsible for the classroom setup, including student computers, instructor station, LCD projector, and software installation. For courses conducted at Softek, we take care of classroom setup.

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, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee