25,000+ Courses Nationwide
0345 4506120

Database Design and Data Normalization Course

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.

Select specific date to see price, venue and full details.

Course Content

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

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best