DATABASE DESIGN AND DATA NORMALIZATION COURSE

Database Design and Data Normalization Course Summary

Relational Databases & Data Normalisation .

Learn how to decide which tables and columns are required for a database, plan relationships, how to decide on data types and how to relate tables.

Database Design and Data Normalization Course Description

Session 1:

• Introduction to Relational Databases
• The Database Approach
• Database Management Systems
• The function of a Database Management System
• The Processing Architecture
• The Schema Architecture
• The Storage Architecture
• An overview of Database System Development
• An overview of general database principles

Session 2:

• Conceptual Data Models
• Overview of Entity Models
• Entities and how to identify them
• Attributes and how to identify them
• Relationships and their qualities

• Building an Entity Relationship Diagram
• Resolving many-to-many relationships
• Sub-type and Super-type Relationships
• Arc Relationships
• Recursive Relationships
• Constraints and Assumptions

Session 3: Demos

• Normalization to the First Normal Form (1NF)
• Normalization to the Second Normal Form (2NF)
• Normalization to the Third Normal Form (3NF)

Session 4: Exercises

• Exercises: Analyzing a specification and Creating an Entity Relationship Diagram

Session 5:

• The Relational Model
• Relational Structure
• Relational Terminology
• Domains
• A Relational schema
• Candidate keys and Primary Keys
• Foreign Keys
• Key Constraints
• Attribute Constraints
• Implementing Sub-type/Super-type Relationships
• Views
• Denormalization using Pre-joined Tables
• Denormalization using Derived Data
• An Introduction to Structured Query Language (SQL)
• Simple Queries
• Simple Updates of the Data

WHAT IS INCLUDED IN THE DATABASE DESIGN AND DATA NORMALIZATION COURSES:

• Certificate on completion
• Course notes
• Course exercises, Worked examples, Sample Data Sets
• After the course, 1 free session for questions
• Max group size on this Database Course is 4.