Database Design and Data Normalization Course

Database Design and Data Normalization Course Summary

Relational Databases & Data Normalisation Overview Training Course. 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
Creating an Entity Relationship Diagram from it

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 (assessment based)
  • Database Design and Data Normalization Course notes
  • Practical Database Design and Data Normalization Course exercises, Database Course Homework / Database Course Revision work
  • Tea, coffees, but no lunch
  • To assist after the course, 1 free session for questions online Database Course via Skype or Teamviewer.
  • Max group size on this Database Course is 4.
LOCATIONS
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops Manchester
MANCHESTER: 53 Fountain Street, Manchester, M2 2AN
Read More
PCWorkshops Birmingham
BIRMINGHAM: One Victoria Square, Birmingham, B1 1BD
Read More
PCWorkshops Southend-on-Sea
SOUTHEND-ON-SEA: The Forum, Elmer Square, Southend-on-Sea SS1 1NS
Read More
PCWorkshops Milton Keynes
MILTON KEYNES: Exchange House, 494 Midsummer Boulevard, Milton Keynes, MK9 2EA
Read More
PCWorkshops PORTSMOUTH
PORTSMOUTH: Building 1000, Lakeside North Harbour, Western Road, Portsmouth, PO6 3EZ
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More

Subscribe our Newsletter

Sign up to receive lessons, tips, examples, quizzes and other training materials.