| |
|
| |
Relational Database Design A Practical Approach Training Class
Course ID: 5372
|
|
| |
|
|
| |
|
|
| |
Relational Database Design A Practical Approach Training Seminar
Overview:
Students will learn the general principles involved in designing a database that complies with the relational database model.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Introduction to Relational Databases
The Basics of Relational Databases
Planning the Database
|
|
Lesson 2: Designing Tables
Deciding on Tables and Fields
Selecting Primary Key Fields
Identifying Table Relationships
More on Keys and Relationships
|
Lesson 3: Data Normalization
Solving Data Problems
Higher Normal Forms
|
Lesson 4: Data Integrity
Referential Integrity
Field-level Integrity
Table-level Integrity
Reviewing and Finalizing the Database Design
|
Lesson 5: Query Basics
Performing Queries
Multiple Table Queries
|
|
Lesson 6: More on Queries
Other Types of Queries
SQL
Optimizing Query Performance
| |
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Relational Database Design A Practical Approach Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5372
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|