Database Design Course, London
From £350 - FAQ's - Included - Course outline - Bespoke Course

Database Design and Data normalisation, 1-Day Course

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.

Course Outline


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: Conceptual Data Models(continued)
Normalization to the First Normal Form (1NF)
Normalization to the Second Normal Form (2NF)
Normalization to the Third Normal Form (3NF)
Exercises: Data Normalization producing table specifications and Entity Diagrams
Session 4: 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 this SQL Course:


SQL Course Certificate on completion (assessment based)
SQL Course notes
Practical SQL Course exercises, SQL Course Homework / SQL Course Revision work
Tea, coffees, but no lunch
To assist after the course, 1 free session for questions online SQL Course via Skype or Teamviewer.
Max group size on this SQL Course is 4.

Is this the course for you? Book today and start preparing for the course

PCWorkshops specialises in Java Courses, Database courses and MS Project Courses.

Free Examples and Tips