Categories:
Relational Database Skills
£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
- 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.
| 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 | |||||
Click location to see venue
|
Move cursor over calendar icon to see course dates
|
|||||
Telephone Hotline
01933 233884
(Monday to Friday - 8:00am to 5:30pm).
