|
|
Tuition: $590.00 per student |
Length: 2
days | |
Synopsis:
2 day course on 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. |
Formats:
Custom
group at your facility or ours and private
training. |
References: Please see
our Database
Design Book List for recommended books (with Amazon.com
links) you may want to have available and/or review in advance
of your class. None are required, per se.
|
Group Discounts: Yes - see FAQ's. |
|
|
|
Session
1 |
Relational
Database Foundations |
4.0 Hours |
|
- Relational Database Concepts
- System Architectures; File Server, Lan, Intra/Internet
- Relational Database Foundations
- Data Structures; Lists, B-Trees, Hashes, Indexes
|
|
Session
2 |
Relational
Database Modeling and Design |
4.0 Hours |
|
- Relational Database Modeling
- Entities
- Attributes
- Relationships
- Entity Relationship Diagrams (ERD's); Chen, Others
- Database Normalization; 1st, 2nd and 3rd normal forms
|
|
Session
3 |
Application
Development |
4.0 Hours |
|
- 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
|
|
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 and a training certificate.
|
|
Scheduling: Each
session above may be customized and scheduled as
desired for each custom group class or private
training session.
|
|
Location: On-site
classes are normally taught at your facilities. We do,
however, offer a wide range of alternatives, including
our own training rooms (map
and directions). Please
see FAQ's
for details. We also travel beyond Southern
California. |
|
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. | |
| |