Orange Coast Database Associates
P.O. Box 6142
Laguna Niguel, CA 92607

Previous Page

949-489-1472 (Office)
800-355-9855 (Toll free)
http://www.ocdatabases.com

Accelerated training for working professionals

Orange Coast Database Associates, Inc.
Course Catalog (All Modalities)

Item IDCourse Title and DescriptionPricePerLength
DBD221MRelational Database Design with MySQL265.00Student6.0 hrs
 In this course, you will plan, design, and create a functional and efficient relational database. You can create effective database designs by applying the relational database design techniques taught in this course. MySQL will be used for implementation and is the basis for the manual. However, another database can be substituted upon request. Visio or equivalent design tools may be used for design. Students should have some familiarity with data tables and basic knowledge of how to create queries in Microsoft Access or equivalent.

 
Session 1Design, Normalization 
 
  • Lesson 1: Analyzing Client Requirements
    • Topic 1A: Analyze Current Data Storage Systems
    • Topic 1B: Identify New Client Requirements
    • Topic 1C: Determine the Required Data Fields
    • Topic 1D: Group Fields into Tables
    • Topic 1E: Identify Key Fields
  • Lesson 2: Creating a Preliminary Design
    • Topic 2A: Create a Preliminary Entity Relationship Diagram
    • Topic 2B: Apply the First Normal Form
    • Topic 2C: Apply the Second Normal Form
    • Topic 2D: Apply the Third Normal Form
    • Topic 2E: Apply the Higher Normal Forms
    • Topic 2F: Denormalize Tables
    • Topic 2G: Incorporate Client Feedback
  • Lesson 3: Implementing the Database Design
    • Topic 3A: Translate Business Rules into Constraints
    • Topic 3B: Create Tables
    • Topic 3C: Create Indexes

 
Session 2SQL, Modifying Data Structures 
 
  • Lesson 4: Generating Reports
    • Topic 4A: Manipulate Data
    • Topic 4B: Generate Reports Using Conditions
    • Topic 4C: Generate Reports from Multiple Tables
    • Topic 4D: Generate Summary Reports
    • Topic 4E: Create Views
  • Lesson 5: Customizing a Database
    • Topic 5A: Modify Constraints
    • Topic 5B: Modify Fields
    • Topic 5C: Modify Tables