Database Training
DAY 1:
Database Fundamentals.
-
Database
-
Database Environments.
-
Business Rules. Business
Processes. Information and Data. Requirements Analysis.
-
Entities. Attributes. Business
Process Reengineering.
-
Database Schema. Table. Data
Types.
-
Primary Keys. Foreign Keys.
Relationships.
-
Key Database Design Concepts.
-
Design Methodology. Converting
the Business Model to Design. Application Design.
-
Performance. Redundant Data Is
Minimized.
DAY
2:
Database Models.
-
Types of Databases.
-
Flat-File Database Model.
Hierarchical Database Model. Network Database Model.
-
Relational Database Model.
-
Relational Database
Characteristics.
-
Relational Database Objects.
-
SQL: The Relational Database
Language.
DAY
3.
Design Planning.
-
What Is a Database Design?
-
Importance of Database Design.
-
Planning Database Design.
-
The Mission Statement.
-
Devising a Work Plan.
-
Setting Milestones and Making
Deadlines.
-
Establishing the Design Team
and Assigning Tasks.
-
Logical Versus Physical
Modeling.
-
Automated Design Tools.
DAY
4: Design Life Cycle.
-
The System Development
Process.
-
Traditional Method.
-
The Barker Method.
-
Adapted Design Methods.
-
Overview of Design Processes.
-
Redesign of an Existing
Database.
-
Overview of the Database Life
Cycle.
DAY
5:
Requirements Analysis.
-
Types of Requirements.
-
Business Requirements. System
Requirements.
-
Overview of Requirements
Analysis. Determining Business Requirements.
-
Interviewing Management.
Interviewing the Customer. Interviewing the End User.
-
Studying the Existing
Processes in Place.
-
Analyzing Business
Requirements. Determining System Requirements.
-
Establishing Relationships.
DAY
6:
Entities and Relationships.
-
Overview of Entities and
Entity Relationships.
-
One-to-One Relationship.
One-to-Many Relationship. Many-to-Many Relationship.
-
Transformation of the Entity
in Design.
-
Data Retrieval
-
Avoiding Poor Relationship
Constructs.
-
Understanding Relationships
and Table Joins.
DAY
7:
Normalization and De-Normalization
-
Overview of Normalization.
-
Advantages of Normalization.
Disadvantages of Normalization.
-
Overview of the NORMAL FORMS.
-
FIRST NORMAL FORM: The Key.
SECOND NORMAL FORM: The Whole Key. THIRD
-
NORMAL FORM: And Nothing but
the Key. Boyce-Codd NORMAL FORM. FOURTH
-
NORMAL FORM. FIFTH NORMAL
FORM.
DAY
8:
Review of Examples and Advance Topics
|