In this course, the student is taught the basics of database modeling in a relational database environment, basic data modeling, syntax, as well as advanced concepts of relationships, integrity and performance tuning.
Prerequisites: Previous knowledge of a SQL database system.
Options: Database system options include Oracle 8i, Microsoft SQL Server and DB2. This course is taught using Visio as a database modeling tool. Contact us for other alternative database design tool options.
Who should attend: Intended for the Data Architect, DBA or Developer responsible to identify, define and setup relational databases to serve enterprise wise applications.
Duration: 3 days
Price: $1350
The Relational Model
- Tables
- Rows
- Columns
- Data types
- Advanced data types
- Nullability
|
Relationships
- One to one
- One to many
- Many to one
- Many to many
- Optional and required
|
Keys
- Unique keys
- Compound keys
- Referntial integrity
- Check Constraints
|
Data Management
- Queries and select
- Insert and update
- Delete
|
Modeling
- Data modeling life cycle
- Iterative data modeling
- Entity relationship diagrams
- Other modeling notations
- The crows foot ERD
- Modeling the domain
- Modeling to anticipate change
- Model correctness heuristics
- Physical model considerations
- Database security
- Validationg a model
|
Performance
- Database performance measurement
- Smart database tuning
- Efficient navigation
- Indexes
- Query modeling
- Access paths
- Query optimization
- Predicate processing
- Transaction modeling
- Locking, commits and roll backs
|
Normalization
- Zero form
- First normal form
- Second normal form
- Third normal form
|
Advanced Topics
- Object relational mapping
- Cascading operations
|
Register Now
This page is printer friendly.
