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.d2associates.com
Accelerated training for working professionals

Microsoft Access and Relational Database Training
Course Catalog

Item IDCourse Title and DescriptionLength
DBD201Accelerated Relational Database Design6.0 hrs
 Slightly shorter (1 day) version of DBD200 with minimal SQL. Ideal as a complement to one of the Microsoft Access or SQL courses. Students will construct, in Visio or another modeling tool, an Entity Relationship Diagram that applies to their application(s) during this course.

 
Session 1Relational database Foundations 
 
  • Relational Database Concepts
  • System Architectures; File Server, Lan, Intra/Internet
  • Relational Database Foundations
  • Data Structures; Lists, B-Trees, Hashes, Indexes

 
Session 2Relational Database Modeling and Design 
 
  • Relational Database Modeling
    • Entities
    • Attributes
    • Relationships
  • Entity Relationship Diagrams (ERD's); Chen, Others
  • Database Normalization; 1st, 2nd and 3rd normal forms