Database Design and Data Normalisation 1-Day Course, London

COVID-19: many events have been canceled or postponed, please check with the organizer the event status.
Database Design and Data Normalisation 1-Day Course, London
Image from eventbrite.co.uk
Fri 10 April 2020
Friday 10 April 2020
11:00 AM - 6:00 PM
Ended

Relational Databases & Data Normalisation Overview Training Course, 1-Day Course

 

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)

Creating an Entity Relationship Diagram 

Entity Diagrams

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

623 Views - 11/04/2020 Last update
culture art
PCWorkshops at Regus
Golden Cross House,, London, WC2N 4JF, United Kingdom

Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event

Nearby hotels and apartments

Golden Cross House,, London, WC2N 4JF, United Kingdom

Browse other venues in London
Discover now


Discover more events in London
Discover now



PCWorkshops at Regus
Golden Cross House,, London, WC2N 4JF, United Kingdom


Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event
  1. London
  2. PCWorkshops
  3. Database Design and Data Normalisation 1-Day Course, London
 
 
 
 
Your changes have been saved.