Relational Databases & Data Modelling Overview

2 days @ £795.00  
S5

Relational Databases & Data Modelling Overview Course Overview

The Relational Databases & Data Modelling Overview course is designed to give delegates practical experience in data modelling using entity relationship diagrams & data normalisation, also in designing relational databases using the normalised entity model.  Both entity modelling and data normalisation form core elements of this course.  Delegates are not expected to have any prior knowledge of systems analysis or databases, and the course includes a brief introduction to the principles of systems analysis.

Skills Gained

The delegates will gain knowledge and practise in:

  • The database approach
  • Database Management Systems
  • The logic of database architectures
  • Entity modelling
  • Constraints and assumptions
  • Data normalisation to the third normal form
  • Logical data structures
  • The relational schema
  • Database constraints
  • The concept of views
  • De-normalisation techniques
  • An introduction to simple queries in Structured Query Language (SQL)

Who will the Course Benefit?

Developers moving into the area of relational databases who need an understanding of the principles and logic of the relational database; programmers who are to start programming in SQL and need to know the principles on which it is built; programmers who need to understand entity modelling and normalization; analysts needing a knowledge of entity modelling and entity relationship diagrams and any others who need to know the principles of relational analysis and data modelling but do not need a complete systems analysis course.

Course Objectives

The Relational Databases & Data Modelling Overview course provides an understanding of the structure of a RDBMS (Relational Database Management System) and the underlying principles of relational analysis and data modelling.

Requirements

An understanding of Information Technology concepts and computer terms is required.

Follow-On Courses

NOTE: Course technical content is subject to change without notice.

Relational Databases & Data Modelling Overview Training Course

Course Contents - 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

Relational Databases & Data Modelling Overview Training Course

Course Contents - 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 Normalisation 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

Follow-On Courses


       Home     Let Us Call You     Enquiry     Make Booking     Top

Make A Booking

In London




May also be run upon request at:

Centres


Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

 

MOD Career Transition

Ministry Of Defense - Career Transition Partnership

 

We have created our website to the following W3C standards, this helps makes our pages easier to use for you.

Valid HTML 4.01 Transitional

Valid CSS!

If you find a non-compliant page on our site, please let us know and we will endeavour to fix it immediately.
 

Publicly Scheduled
Training Locations
London centre:
6 Long Lane
Barbican
London
EC1A 9HF
UK

telephone:
+44 (0)20 7600NoSkype 6116
Manchester centre:
St James Court
30 Brown Street
Manchester
M2 1DH
UK
Birmingham centre:
The Enterprise Suite
9th Floor Centre City Tower
5-7 Hill Street
Birmingham
B5 4UA
UK
Bristol centre:
Apex House
Westerleigh Business Park
Turner Drive
Yate
Bristol
BS37 5YX
UK
Leeds centre:
Halsbury House
Chancellor Court
21 The Calls
Leeds
LS2 7EH
UK
Edinburgh centre:
16 St Mary's Street
Edinburgh
Scotland
B3 2HJ
UK
Please contact our London office for all enquiries.

telephone:
+44 (0)20 7600NoSkype 6116

or email:

info@
stayahead.com



 

Top  |  Go back  

Print Friendly

Printer friendly version of the Relational Databases & Data Modelling Overview outline