Categories:
Relational Database Skills
£385 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.
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Telephone Hotline
01933 233884
(Monday to Friday - 8:00am to 5:30pm).
© 2021 Book My Course Limited. All rights reserved
Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy