Length: 8 hours, instructor-led

Audience: 

• This course is designed for system analysts and application developers

Prequisites: 

• Knowledge of database concepts

• This course provide base knowledge for creating relational databases - design & modeling.

1. Introduction to Database Design

• Overview of DBMS Management Systems
• Data Modeling – background and Fundamentals
• Basic Building blocks of the Object Model
• The Relational Model and Normal Forms
• Relational Data Manipulation

2. Overview of DBMS Management Systems

• Introduction to DBMS
• Short History of DBMS
• Characteristics of Database
• Database Management Systems
• Database Administrator
• Requirements of a Well-Designed DBMS

3. Data Modeling – background and Fundamentals

• Introduction to Data Modelig
• Perspectives of Data Modeling
• Fundamental Analysis Concepts
• Stages of Data Modeling
• Fundamentals of Object Modeling
• Benefits of Data Modeling

4. Basic Building blocks of the Object Model

• Introduction to Object Modeling
• Fundamental Elements of E-R Diagrams
• Entity variation
• Relationship Variations
• Creating an Object Model
• Data Modeling Guidelines

5. The Relational Model and Normal Forms

• Introduction to Relational Modeling Techniques
• The Relational Model
• Components of the Relational Model
• Integrity Rules
• Normalization
• Relationships in the Relational Model
• Defining the Relational Model to the Database

6. Relational Data Manipulation

• Data Manipulation
• Relational Algebra
• Relational Calculus
• The Existential Quantifier
• Universal Quatifier