Top bar

Orange Coast Database Associates Database Training, Design and Programming Course Listing Page Computer training

Course Description

Separator bar

Group
Training

Individual
Training

Programming &
Consulting

FAQ's

Site Map

Separator bar

Current Category

Related Courses

Request information or a quote

Enroll in a public scheduled class

Sales: 800-355-9855

Home

About Us

Contact Us

DBD221M: Relational Database Design with MySQL

Book List | Course Links

Tuition: $245.00 per student

Length: 1 day

Synopsis: 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.

Formats: Custom scheduled corporate groups (min. 2 students) at your facility or online. Single individuals may arrange a private class.

Scheduling: Flexible. Group and private training can be scheduled to suit your needs.

Group Discounts: 2-4 students 20%, 5-8 30%, >8 quote

 

Format this document for printing

Session 1Design, Normalization3.0 Hours
 
  • 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 Structures2.0 Hours
 
  • 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
 

Materials: Complete student manual, training certificate.

 

Location: Classes are normally taught on-site at your facilities or via online Remote Learning.

Related Services

Need help with a project? We may also provide programming and consulting services covering the above material. See Programming and Consulting for more information.


Copyright 2022 D.H.D'Urso & Associates
P.O. Box 6142, Laguna Niguel, CA 92607 949-408-1350
Serving: Orange, Los Angeles, San Diego, Riverside, San Bernardino, Imperial and Ventura counties and beyond.

Privacy Statement | Contact Information | FAQ's | Site Map | Back | Home | Top