Relational Databases &
Data Modelling Training
Contents
Contents 2
Relational Databases & Data Modelling Training 3
Syllabus 4
Module 1: Introduction to Relational Databases 5
Module 2: Conceptual Data Models 6
Module 3: Relational Model 8
Our Delivery Methods 9
Have Questions for Us? 10
Relational Databases &
Data Modelling Training
✓ Relational Databases & Data Modelling Training Course emerges as a crucial
exploration of how data is structured, stored, and accessed. This course delves
into the fundamentals of relational databases and data modeling, unraveling
the intricacies of organising information for optimal functionality and
accessibility.
✓ Mastering Relational Databases & Data Modelling is imperative for
professionals navigating the data landscape. This knowledge is particularly
vital for IT specialists, database administrators, and data analysts tasked with
optimising data storage, retrieval, and structuring processes.
✓ This course by the Knowledge Academy empowers delegates with practical
skills to design and manage relational databases effectively. From
understanding the principles of data normalisation to creating efficient data
models, professionals will gain insights into transforming theoretical concepts
into tangible solutions.
✓ Upon completing the Relational Databases & Data Modelling Training Course,
you will possess the expertise to design and manage relational databases,
ensuring streamlined and efficient data management.
Syllabus
This course is split into 3 easy-to-understand units, which will provide you
with in-depth knowledge on how to develop skills in querying relational
databases for effective data retrieval.
Module 1: Introduction to Relational Databases
Module 2: Conceptual Data Models
Module 3: Relational Model
Module 1
Introduction to Relational Databases
Database Approach
Database Management Systems
Functions of a Database Management System
Processing, Schema, and Storage Architecture
Database System Development
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
Entity Relationship Diagram with the help of Flowchart Symbols
Sub-Type and Super-Type Relationships
Arc Relationships
Recursive Relationships
Constraints and Assumptions
Introduction to Normalisation
Module 2
Conceptual Data Models
Normalisation to the First Normal Form (1NF)
Normalisation to the Second Normal Form (2NF)
Normalisation to the Third Normal Form (3NF)
Benefits of Normalisation
Relational Database Analysis
Module 3
Relational Model
Introduction to Relational Model
Relational Structure and Terminology
Domains
Relational Schema
Candidate Keys, Primary Keys, and Foreign Keys
Mapping Constraints
Implementing Sub-Type/Super-Type Relationships
Views in SQL
Denormalisation Using Pre-Joined Tables and Derived Data
Introduction to Structured Query Language
Simple Queries and Update of the Data
Relational Decomposition
Our Delivery Methods
POPULAR POPULAR
Online Instructor-led Online Self-paced In-house Classroom
Join a scheduled class with a live Learn at your own pace. Our Our courses can be adapted to Some of our courses are
instructor and other delegates. expert trainers are on hand to meet your individual project or available in our classrooms. All of
Ask questions, share documents, help you with anything. business requirements. In-house our trainers are highly qualified,
interact with whiteboards, ask All of our courses come with a training gives your team a great having 10+ years of experience.
live questions and communicate standard 90 days access which opportunity to come together, We use the highest quality
with your trainer and peers. can be upgraded if need be.. bond and discuss, which may be learning facilities to make sure
Access the best pool of trainers, Our e-learning platform is limited in a standard classroom your experience is as
wherever you are. available on all devices. setting. comfortable as possible.
Have Questions
for Us?
We are a leading training provider of highly-demanded
learning programmes, and we always look forward to
guiding learners in the right direction. If you have
questions or need assistance while booking your
training, you can access our 24/7 support using our
email address and phone numbers. Our specialised
learning advisors will get in touch and help you with
your queries and needs by providing the correct
information and guidance.