|
|
|
|
|
|
Tuition: $390 per student |
Length: 2 days |
|
|
Synopsis:
Introduction
to the basics of relational database design including tables,
fields, keys, indexes, views, normalization, entity relationship
diagrams, and SQL. Students will construct a simple ERD using Visio
or another modeling tool. Students should be familiar with Windows
and database concepts. Some programming or analysis background is desireable. |
|
Format:
Custom group at your facility or
ours and private training. Not
currently offered via open enrollment. On-site groups are
accommodated throughout the United States. |
|
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:
$100 |
|
|
|
- Module
I:
Relational
Database Foundations
- Relational
Database Concepts
- System
Architectures; File Server, Lan, Intra/Internet
- Relational
Database Foundations
- Data
Structures; Lists, B-Trees, Hashes, Indexes
-
|
4 hours |
- Module
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 |
- Module
III:
Application
Development
- SQL
(DDL)
- ...Create,
Alter statements
- ...Constraints,
Indexes
- SQL
(DML)
- ...SQL
Select Statement; grouping; calculations
- ...Insert,
Update and Delete SQL statements
- Application
Development
- Multi-user
issues (Security, Concurrency, etc.)
- Emerging
Technologies
-
|
4 hours |
Related Courses:
DBD201 Accelerated
Introduction to Relational Database Design is is very similar
but with module 3 (SQL) removed and foundation concepts (theory)
shortened. You may want to consider that course if you simply want
some exposure to modeling and constructing an Entity Relationship
Diagram (ERD).
|
|
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.
|
|
Location:
Classes are normally taught at your facilities. We do, however,
offer a wide range of alternatives, including our own training room,
to suit your requirements. Please see FAQ's
for details. We can also travel beyond Southern California if appropriate.
|
|
|
|
|
