|
|
|
|
|
|
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. |
|
|
|
