|
|
|
|
|
|
Tuition: $200 per student |
Length: 1 day |
|
|
Synopsis:
Accelerated
Introduction to the basics of relational database design including
tables, fields, keys, indexes, views, normalization and entity
relationship diagrams. Good course in conjunction with an Access or
SQL course. Students will construct, in Visio or another modeling
tool, an Entity Relationship Diagram that applies to their
application(s) during this course. |
|
Formats:
Custom
group at your facility or ours, private
training, and open enrollment
in San Juan Capistrano. Classes begin at 9:00AM unless otherwise arranged. |
|
References:
Please see our Database Design Book List
for recommended books you may want to have available and/or peruse in
advance of your class. None are required, per se. |
|
Group
Discounts: Yes
- see FAQ's. |
Group/Private
Registration:
$65 |
|
|
|
- Session
I:
Relational
Database Foundations
- Relational
Database Concepts
- System
Architectures; File Server, Lan, Intra/Internet
- Relational
Database Foundations
- Data
Structures; Lists, B-Trees, Hashes, Indexes
-
|
2 hours |
- Session
II:
Relational
Database Design and Modeling
- Database
Modeling
- ...Entities
- ...Attributes
- ...Relationships
- Entity
Relationship Diagrams (ERD's); Chen, Others
- Database
Normalization; 1st, 2nd and 3rd normal forms
-
|
4 hours |
Prerequisites:
Familiarity with Windows and MS Access, Visual FoxPro, MySQL, Oracle,
SQL Server or another relational database. Some programming background.
|
|
Materials:
Students will be provided a copy of all exercise files. They will
also receive a binder with a printout of the slides used in their class.
|
|
Scheduling:
Each session above may be customized and scheduled as desired for
each custom group class or private training session. See below for
open enrollment.
|
|
Location:
On-site classes are normally taught at your facilities. We do,
however, offer a wide range of alternatives, including our own
training rooms. Please see FAQ's
for details. We also travel beyond Southern California.
Open
enrollment classes are taught at our facilities in San Juan
Capistrano, just off the I-5 and close to shopping, fine dining and
local attractions (map
and directions). |
|
Check our calendar of Open Enrollment Classes. (Note: custom group
classes and private training scheduled by arrangement). Open
Enrollment classes begin at 9:00AM.
|
Related Services |
|
Need help with
a new database? We can also provide database
programming and consulting services covering the above material.
Contact programming for
more information. |
|
|
|
