The Knowledge Academy Logo
The Knowledge Academy Logo
01344 203999 - Available 24/7

Send us your message.

X

Relational Databases & Data Modelling Training - United Kingdom

Key points about this course


Duration: 1 Days*

Support: 24/7

Dates & Prices Enquire
  • Learn about database approaches and database management systems.
  • Acquire knowledge of logical data structure, relational schema, and database constraints.<
  • Learn about data normalisations, de-normalisation, and SQL queries.

Available delivery methods for this course

Classroom Icon

Classroom

Virtual Icon

Live Virtual

Online Icon

Online

Onsite Icon

Onsite

Course Information

Relational Databases & Data Modelling Training​ Course Overview

A relational database management system (RDMS) is a collection of programs and capabilities enabling delegates to create, update, administer and interact with a relational database. RDBMS (relational database) stores data in the form of tables and every table in a relational database comprises rows and columns. In computer science terminology, rows are called tuples and columns are called attributes, and the tables themselves called relation. RDBMS provides a dependable method to store and retrieve large amounts of data.

This course provides knowledge of the structure of the Relational Database Management System (RDBMS) and Data Modelling using entity and relationship diagrams and data normalisation, also in designing relational databases using the normalised entity model. Data modelling and data normalisation are essential topics to be covered in this course.

In this course, delegates will learn about database approach, database management systems and the logic of database architectures. They will also gain an understanding of entity modelling, constraints and assumptions. This course will teach delegates about normalisation’s first form, second form, and third form. They will also learn about logical data structure, relational schema, and database constraints. This course describes the concept of views and de-normalisation techniques. In addition, they will learn about simple queries in structured query language (SQL).

Relational Databases & Data Modelling Training​ Course Outline

Module 1: Introduction to Relational Databases

  • The Database Approach
  • Database Management Systems
  • The Function of a Database Management System
  • The Processing, Schema, and Storage Architecture
  • An Overview of Database System Development
  • An Overview of General Database Principles

Module 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 the Specification
  • Exercises: Data Normalisation Producing Table Specifications and Entity Diagrams

Module 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

Prerequisites

There are no prerequisites for this course.

Audience

Anyone can take this course who wants to learn about databases or RDMS.

Please arrive at the venue at 8:45am.
There are no prerequisites for this course.
Anyone can take this course who wants to learn about databases or RDMS.
We are able to provide support via phone & email prior to attending, during and after the course.
Delegate pack consisting of course notes and exercises, Manual, Experienced Instructor, and Refreshments
This course is 1 day.
Once your booking has been placed and confirmed, you will receive an email which contains your course location, course overview, pre-course reading material (if required), course agenda and payment receipts
The price for Relational Databases & Data Modelling Training certification in the United Kingdom starts from £
The Knowledge Academy is the Leading global training provider in the world for Relational Databases & Data Modelling Training.
Please see our Database Training courses available in the United Kingdom
  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Key points about this course


Duration: 1 Days*

Support: 24/7

View dates & prices

Find out more

Please enter Name
Please enter valid Email
Please enter valid phone
The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry. View privacy policy

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

Or call us now
01344 203999

Relational Databases & Data Modelling Training Dates & Prices

Select your preferred delivery method

Choose a Region

Choose a Location

Choose a Month

Office Icon Attend your course from the office or home
Trainers Icon Interactive support from experienced trainers
Simple Icon Simple to setup and easy to use on any device
Glasgow
Fri 13th Mar 2020
Places available
£2195
London
Fri 13th Mar 2020
Places available
£1995
Norwich
Fri 13th Mar 2020
Places available
£2195
Nottingham
Fri 13th Mar 2020
Places available
£2195
Sheffield
Fri 13th Mar 2020
Places available
£2195
Maidstone
Fri 13th Mar 2020
Places available
£2195
Dublin
Fri 13th Mar 2020
Places available
€2195
Birmingham
Fri 13th Mar 2020
Places available
£1995
Cambridge
Fri 13th Mar 2020
Places available
£2195
Leeds
Fri 13th Mar 2020
Places available
£2195
Milton Keynes
Fri 13th Mar 2020
Places available
£2195
Belfast
Fri 13th Mar 2020
Places available
£2195
Manchester
Fri 13th Mar 2020
Places available
£1995
Bristol
Fri 13th Mar 2020
Places available
£2195
Edinburgh
Fri 13th Mar 2020
Places available
£2195
Southampton
Fri 13th Mar 2020
Places available
£2195
Brighton
Fri 13th Mar 2020
Places available
£2195
Aberdeen
Fri 13th Mar 2020
Places available
£2195
Reading
Fri 13th Mar 2020
Places available
£2195
Cardiff
Fri 13th Mar 2020
Places available
£2195
Liverpool
Fri 13th Mar 2020
Places available
£2195
Newcastle
Fri 13th Mar 2020
Places available
£2195
Dublin
Fri 15th May 2020
Places available
€2195
Edinburgh
Fri 15th May 2020
Places available
£2195
Birmingham
Fri 15th May 2020
Places available
£1995
Cambridge
Fri 15th May 2020
Places available
£2195
Leeds
Fri 15th May 2020
Places available
£2195
Milton Keynes
Fri 15th May 2020
Places available
£2195
Belfast
Fri 15th May 2020
Places available
£2195
Manchester
Fri 15th May 2020
Places available
£1995
Bristol
Fri 15th May 2020
Places available
£2195
Southampton
Fri 15th May 2020
Places available
£2195
Brighton
Fri 15th May 2020
Places available
£2195
Newcastle
Fri 15th May 2020
Places available
£2195
Aberdeen
Fri 15th May 2020
Places available
£2195
Reading
Fri 15th May 2020
Places available
£2195
Cardiff
Fri 15th May 2020
Places available
£2195
Liverpool
Fri 15th May 2020
Places available
£2195
Glasgow
Fri 15th May 2020
Places available
£2195
London
Fri 15th May 2020
Places available
£1995
Norwich
Fri 15th May 2020
Places available
£2195
Nottingham
Fri 15th May 2020
Places available
£2195
Sheffield
Fri 15th May 2020
Places available
£2195
Maidstone
Fri 15th May 2020
Places available
£2195
Belfast
Fri 10th Jul 2020
Places available
£2195
Manchester
Fri 10th Jul 2020
Places available
£1995
Bristol
Fri 10th Jul 2020
Places available
£2195
Southampton
Fri 10th Jul 2020
Places available
£2195
Brighton
Fri 10th Jul 2020
Places available
£2195
Newcastle
Fri 10th Jul 2020
Places available
£2195
Aberdeen
Fri 10th Jul 2020
Places available
£2195
Reading
Fri 10th Jul 2020
Places available
£2195
Cardiff
Fri 10th Jul 2020
Places available
£2195
Liverpool
Fri 10th Jul 2020
Places available
£2195
Maidstone
Fri 10th Jul 2020
Places available
£2195
Glasgow
Fri 10th Jul 2020
Places available
£2195
London
Fri 10th Jul 2020
Places available
£1995
Norwich
Fri 10th Jul 2020
Places available
£2195
Nottingham
Fri 10th Jul 2020
Places available
£2195
Sheffield
Fri 10th Jul 2020
Places available
£2195
Dublin
Fri 10th Jul 2020
Places available
€2195
Edinburgh
Fri 10th Jul 2020
Places available
£2195
Birmingham
Fri 10th Jul 2020
Places available
£1995
Cambridge
Fri 10th Jul 2020
Places available
£2195
Leeds
Fri 10th Jul 2020
Places available
£2195
Milton Keynes
Fri 10th Jul 2020
Places available
£2195
Liverpool
Fri 11th Sep 2020
Places available
£2195
Newcastle
Fri 11th Sep 2020
Places available
£2195
Aberdeen
Fri 11th Sep 2020
Places available
£2195
Reading
Fri 11th Sep 2020
Places available
£2195
London
Fri 11th Sep 2020
Places available
£1995
Cardiff
Fri 11th Sep 2020
Places available
£2195
Maidstone
Fri 11th Sep 2020
Places available
£2195
Glasgow
Fri 11th Sep 2020
Places available
£2195
Norwich
Fri 11th Sep 2020
Places available
£2195
Nottingham
Fri 11th Sep 2020
Places available
£2195
Sheffield
Fri 11th Sep 2020
Places available
£2195
Dublin
Fri 11th Sep 2020
Places available
€2195
Edinburgh
Fri 11th Sep 2020
Places available
£2195
Birmingham
Fri 11th Sep 2020
Places available
£1995
Cambridge
Fri 11th Sep 2020
Places available
£2195
Leeds
Fri 11th Sep 2020
Places available
£2195
Milton Keynes
Fri 11th Sep 2020
Places available
£2195
Belfast
Fri 11th Sep 2020
Places available
£2195
Manchester
Fri 11th Sep 2020
Places available
£1995
Bristol
Fri 11th Sep 2020
Places available
£2195
Southampton
Fri 11th Sep 2020
Places available
£2195
Brighton
Fri 11th Sep 2020
Places available
£2195
Sheffield
Fri 13th Nov 2020
Places available
£2195
Maidstone
Fri 13th Nov 2020
Places available
£2195
Glasgow
Fri 13th Nov 2020
Places available
£2195
Norwich
Fri 13th Nov 2020
Places available
£2195
Nottingham
Fri 13th Nov 2020
Places available
£2195
Dublin
Fri 13th Nov 2020
Places available
€2195
Edinburgh
Fri 13th Nov 2020
Places available
£2195
Birmingham
Fri 13th Nov 2020
Places available
£1995
Cambridge
Fri 13th Nov 2020
Places available
£2195
Leeds
Fri 13th Nov 2020
Places available
£2195
Milton Keynes
Fri 13th Nov 2020
Places available
£2195
Belfast
Fri 13th Nov 2020
Places available
£2195
Manchester
Fri 13th Nov 2020
Places available
£1995
Bristol
Fri 13th Nov 2020
Places available
£2195
Southampton
Fri 13th Nov 2020
Places available
£2195
Brighton
Fri 13th Nov 2020
Places available
£2195
Liverpool
Fri 13th Nov 2020
Places available
£2195
Newcastle
Fri 13th Nov 2020
Places available
£2195
Aberdeen
Fri 13th Nov 2020
Places available
£2195
Reading
Fri 13th Nov 2020
Places available
£2195
London
Fri 13th Nov 2020
Places available
£1995
Cardiff
Fri 13th Nov 2020
Places available
£2195

Complete the steps below to receive a quote or more information

How will you be funding your training?

Self funding

Company funding

Not sure

Key points about this course


Duration: 1 Days*

Support: 24/7


Why choose TKA logo


Gold Tag

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Delivery Icon

Various delivery methods

Flexible delivery methods are available depending on your learning style.

Resource Icon

Resources

Resources are included for a comprehensive learning experience.

Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

Google Logo
Samsung Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell

hsbc-logo
mercedes-logo