|
|
|
|
|
|
|
|
|
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. Not available as a scheduled
class. |
|
Scheduling: Flexible. Group and
private training can be scheduled to suit your
needs. See calendar for scheduled classes.
|
|
Group
Discounts: 2-4 students
20%, 5-8 35%, > 8 quote |
|
|
|
|
| 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
|
|
|
|
References: Please
see the book
list for references you may want to have available.
We are an Amazon.com affiliate and you may purchase your
database books through this site.
|
|
Materials: Students will
receive a notebook with a printout of the slides used in
their class and a training certificate.
|
|
Location: Classes are
normally taught on-site at your facilities or at our
location in San Juan Capistrano, Orange County. We do,
however, offer a wide range of alternatives. Please see
FAQ's
if interested. We also travel beyond Southern
California. |
|
Related
Services |
|
Need help with a Database project? We provide
design & programming services covering the above
material. See Programming
and Consulting for more information.
| |
| |
