Home

About Us

Catalog Main Catalog Microsoft Access Courses Database Development Courses Discounts and Passports Miscellaneous Fees & Services SQL Courses

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

Session 1	Design, Normalization	3.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 2	SQL, Modifying Data Structures	2.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.