Skip Main Navigation
Page Content

Save This Event

Event Saved

Database Design and Data Normalisation

PCWorkshops

Thursday, 19 January 2017 from 11:00 to 18:00 (GMT)

Database Design and Data Normalisation
Available Dates

Ticket Information

Ticket Type Sales End Price Fee Quantity
Database Design and Data Normalisation, 2 Day-Course 12 Jan 2017 £750.00 £38.94
Database Design and Data Normalisation, 2-Day course, Early Bird 5 Jan 2017 £675.00 £37.44

Share Database Design and Data Normalisation

Event Details

Relational Databases & Data Normalisation Course, 2Days

Course Content – Day 1

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
Course Content – Day 2

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
  • Exercise: Data Modelling from an Invitation to Tender

 Included:

  • Teas/Coffees
  • Course notes
  • Exercises and Examples with sample data
  • Certificate
Do you have questions about Database Design and Data Normalisation? Contact PCWorkshops

Save This Event

Event Saved

When & Where


http://www.connectionsattrafalgarsquare.com/location/
8 Northumberland Ave
WC2N 5BJ London
United Kingdom

Thursday, 19 January 2017 from 11:00 to 18:00 (GMT)


  Add to my calendar

Organiser

PCWorkshops

About Us

PC Workshops is an IT Training company with 21 years of IT training experience. 

Our inspiring IT training programs, aim to be practical and effective.

Specialties: MS Project, Java Programming,Database setup, SQL,  Excel, Microsoft Access,

MS Office (Word, PowerPoint, Publishing) Presentational skills training, Train-the-trainer

Winner : Trainer of the Year Award, 2007 awarded by the Learning and Performance Institute.

http://www.pcworkshopslondon.co.uk

Linkedin Profile

 

 

References:  

From: Aine

To: Sarah (Ms)

Date: 25/09/2014

Rating:                        

Report: Sarah is a fantastic tutor. She helped me to study for a Java Programming exam in University. I ended up doing really well in the exam thanks to Sarah. She not only has a brilliant understanding of the subject but also had the ability to explain things to me in a way I understood. I would recommend her to anyone!

 

From: Tim

To: Sarah (Ms)

Date: 15/08/2013

Rating:

Report: Sarah is a very versatile and knowledgeable tutor. She is very intelligent and so can understand the students specific needs very quickly (even in specialist areas of a wider subject). Sarah can focus her tutoring to be very fact and situation specific. Her teaching style is very relaxed and informative. I would fully recommend Sarah to anyone wanting to learn more in her chosen subject areas.

 

From: Mohamed

To: Sarah (Ms)

Date: 19/06/2014

Rating:

Report: Sarah Barnard is one of the greatest tutor that I have ever meet with, she has excellent knowledge for Javascript, SQL and Pseudo-Code .
She also has a great way of teaching. I really enjoyed learning from Sarah.

 

 

Our Location:

Training Location - 8  Northumberland Avenue, London, WC2N 5BY

  Contact the Organiser
Database Design and Data Normalisation
Things to do in London Course Science & Tech

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.