Skip Main Navigation
Page Content

Save This Event

Event Saved

Database Design and Data Normalisation 1-Day Course, London

PCWorkshops

Database Design and Data Normalisation 1-Day Course,...
Available Dates

Ticket Information

Ticket Type Sales End Price Fee Quantity
Database Design and Data normalisation 1-Day Course
Thanks for booking! Please call us on 020 7164 6359 or 07784 357309 to confirm your attendance. Keep the mobile number for your contact on the day.
2 hours before event starts £350.00 £0.00

Share Database Design and Data Normalisation 1-Day Course, London

Event Details

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)
Exercises: Analyzing a specification
Creating an Entity Relationship Diagram from it

Session 2: 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 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

Do you have questions about Database Design and Data Normalisation 1-Day Course, London? Contact PCWorkshops

Save This Event

Event Saved

When & Where


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

Organiser

PCWorkshops

At PCWorkshops, we do courses in Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.

More about us:

training@pcworkshopslondon.co.uk

  • Courses well developed by registered, qualified instructors with a wealth of experience in software development and training.
  • The maximum class-size is normally 4.
  • Every one gets personalised attention.

Why learn with us at PCWorkshops:

  • Excellent, up-to-date courses, following latest trends and tecnologies.
  • Excellent trainers with professional experience.
  • We offer stress free training: we start at 11am, giving you an inexpensive, stress free, off peak travel to maximise your training experience. You could also if necessary still attend to the necessary emails etc. before starting.

Award Winning Trainer

  • 21 Years In Business
  • Excellent Client References
  • Assessment-based certificate, Oracle exam vouchers
  • Weekdays, Evenings and Weekends
  • At PCWorkshops, we love out job!

We offer Training Courses in Software Packages:

  • Java Programming
  • Python Programming, Python data analytics, Python Machine Learning
  • Database design and Data Normalisation
  • SQL Courses
  • Data Analysis and Data visualization courses
  • MS Excel, data analyses with Excel. Excel VBA
  • Access Database Courses.
  • MS Project Training
  • MS Office Training
  • Tableau, MS Power BI, MS Excel Dashboards

Our Style:

  • Relaxed, Practical, Useful

Methods of instruction:

  • Classroom training with max class-size 4 people
  • Virtual classrooms via online video links
  • 1-1 mentoring
  • Customised training

Certification:

Our PCWorkshops certificates are assessment based.
Our course outlines are in-line with Oracle courses. We assist with exam prep for the presitigeous, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of data
Software companies, testing companies,companies who employ software developers
Coders and new coders who need Accredited Java qualification

Customisation:

We can tailor all our courses. Email to customise location, times, content.

 

 

 

  Contact the Organiser

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.