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    
Milton Keynes East Anglia, Midlands, South Central England Thu 20 Dec 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Portsmouth South Central England, South East Thu 20 Dec 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 20 Dec 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Trafalgar Square London, London All Areas, London West, South East Thu 20 Dec 18 Single day duration, date as indicated. 1 £350 + VAT BOOK ENQUIRE
Courses found 1 to 4 of 4 1
  • 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
  • ALS Safety Logo
  • KeyOstas Logo
  • Libben Health and Safety Logo
  • Global Management Academy Logo
  • Illumine Logo
  • CCAS Health and Safety 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