Database Design and Data Normalisation 1-Day Course, London

This excellent database course summarizes data terminology and concepts and cover practical exercise in design the structure of database.

About this Event

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
  
• Normalization to the First Normal Form (1NF)
  
• Normalization to the Second Normal Form (2NF)
  
• Normalization to the Third Normal Form (3NF)
  
• Exercises: Analyzing a specification
  
  
  and Creating an Entity Relationship Diagram

Session 3:

• 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:

• Database Design and Data Normalization Course Certificate on completion
  
• Database Design and Data Normalization Course notes
  
• Practical Database Design and Data Normalization Course exercises, Database Course Homework / Database Course Revision work
  
• After the course, 1 free session for questions online Database Course via Gotomeeting.com.
  
• Max group size on this Database Course is 4.