COURSE FINDER

Database Design and Database Normalisation

£350 per delegate. This may be less for special offers on specific course dates and in-company training courses

Duration: 1 day

Trainer: WC315P

Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...

Course Content Day 1

Course Introduction: 

- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions

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
- Normalisation to the First Normal Form (1NF)
- Normalisation to the Second Normal Form (2NF)
- Normalisation to the Third Normal Form (3NF)
- Exercises: Analysing a specification
- Creating an Entity Relationship Diagram from it 

Course Content Day 2: 

Session 2: Conceptual Data Models (continued) 

- Normalisation to the First Normal Form (1NF)
- Normalisation to the Second Normal Form (2NF)
- Normalisation 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
- Denormalisation using Pre-joined Tables
- Denormalisation 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

Additional Information:

This course can be offered both as an open course and as a one-to-one private session with the trainer.
Telephone Hotline 01933 233884

Enter a location to find distance

Location Region Start Date Days Price ex. VAT    
London London, London All Areas, London West, South East Thu 21 Jun 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 21 Jun 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Portsmouth South Central England, South East Thu 21 Jun 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 21 Jun 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 28 Jun 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 28 Jun 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Portsmouth South Central England, South East Thu 28 Jun 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 28 Jun 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 5 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 5 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Portsmouth South Central England, South East Thu 5 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 5 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 12 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 12 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Portsmouth South Central England, South East Thu 12 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 12 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 19 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 19 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Portsmouth South Central England, South East Thu 19 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 19 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 26 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 26 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Portsmouth South Central England, South East Thu 26 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 26 Jul 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 2 Aug 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Courses found 1 to 25 of 108 1 2 3 4 5
  • 1UPACCESS Logo
  • BAM Construction Training Logo
  • Gold Cross Training Services Logo
  • Citrus Training Logo
  • 3B Training Logo
  • Astutis Logo
  • Construction Industry Training Providers Logo
  • MecSafe Logo
  • Health Life and Safety Logo
  • CSM Services Logo
  • MI Construction Training Logo
  • Innov8 Training Logo
  • BSI Training Logo
  • OM Safety Training Logo
  • TotalComms Training Logo
  • SDA Safety Logo
  • Construction Skills People Logo
  • Phoenix Health and Safety Logo
  • Complete Health and Safety Logo
  • Harris Safety Training Logo
  • First Response Training Logo
  • Alliance Learning Logo
  • Le Breton Training Logo
  • ALS Safety Logo
  • KeyOstas Logo
  • Libben Health and Safety Logo
  • Global Management Academy Logo
  • Illumine Logo
  • ATC Risk Management Logo
  • CCAS Health and Safety Logo
  • MGM Training Logo
  • ROSPA Logo
  • PJH Safety Training Logo
  • OMS Logo
  • Tala Training Logo
  • PRS Health and Safety Training
  • SSG Training and Consultancy Logo
  • RB Services Logo
  • Safety Training Services Logo
  • Clarkson Evans Training Logo
  • Lighthouse Training Logo
  • SWL Training Logo
  • The Building Safety Group Logo
  • ProSafety Logo
  • Genesys Training Logo
  • Total Training Solutions Logo
  • Kentec Training Logo
  • Total Electrical Training logo
  • NTSS logo
  • Safe Life Logo
  • Frinton Training logo
  • Envesca logo
  • The Safety Maintenance Company logo
  • Arthur Adams logo
  • APT Health and Safety logo
  • Sandwell Training Association logo
  • PC Workshops logo
  • Zero Harm Training logo
  • R2 Training logo
  • Whites forklift training logo
  • The Bradley Group logo
  • Risk Health and Safety logo
  • Wise Global Training logo
  • Smallpeice Enterprises logo
  • Total Training Company Logo
  • Sibbald Training logo
  • Highlander logo
  • Total Construction Training logo
  • e-testing logo
  • UTN Training logo
  • Ideal IT training logo
  • PQMS Training logo
  • Paradise Training logo
  • Collective Safety Solutions logo
Telephone Hotline (footer image)

Telephone Hotline

01933 233884

(Monday to Friday - 8:00am to 5:30pm).

© 2018 Book My Course Limited. All rights reserved

Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy