Course SpecificationsCourse number: 085986
Course length: 1.0 day(s)
At work, storing and accessing data are part of a person's
day-to-day activities. One of the most efficient and powerful ways of managing
data is by using relational databases. Information can be stored, linked,
and managed using a simple relational database application and its associated
tools. You have used databases to store and retrieve data. Now, you may want
to plan and design your own database. A well-designed database allows easy
maintenance and quick access of data. In this course, you will plan, design,
and create a functional and efficient relational database. You can create
effective database designs by applying relational database design techniques.
Course Objective: You will design and create a relational database.
Target Student: Individuals who are able to write simple queries or run queries
that someone else has designed.
Prerequisites: Microsoft Access 2007 Level
1 (Second Edition) course (recommended).
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
For this course, you will need one computer for each student
and one for the instructor. Each computer will need the following minimum
- Minimum 250 MB hard disk space for installation of MySQL.
- 128 MB RAM or higher.
- Intel/Celeron (or similar) processor with minimum 300 MHz
- CD-ROM drive.
- Mouse or other pointing device.
- 1024 x 768 resolution monitor recommended.
- An Internet connection.
- Projection system to display the instructor's computer screen.
- Microsoft Windows XP Professional (SP2) or Microsoft Windows
2000 (SP2), both 32 bit.
- MySQL Server 5.0.
- MS Office.
Performance-Based ObjectivesUpon successful completion of this course, students will be able to:
- analyze client requirements.
- create a preliminary design.
- implement the database design.
- generate reports.
- customize a database.
- 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
- 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