This
intensive
2-day
course
involves
an
in-depth
study
of
Relational
Database
design
and
will
provide
delegates
with
a
sound
foundation
in
the
techniques
and
underlying
concepts
concerned
with
this
area
of
technology.
It
also
examines
the
main
components
of
a
Relational
DBMS
and
illustrates
how
SQL
can
be
used
to
access
the
database.
The
course
consists
of
formal
lecture
sessions,
individual
exercises,
case
studies
and
discussion
groups.
Objectives
-
The
concepts
and
advantages
of
the
Relational
Database
approach
-
The
techniques
of
good
Relational
Database
Design
-
The
structures
underlying
Relational
Databases
-
Using
SQL
to
access
the
database
Who
Should
Attend?
This
course
is
aimed
at
anyone
involved
in
the
design
and
development
of
relational
databases.
Course
Content
Introduction -
Database
concepts
and
terminology
-
DBMS
Functionality
-
Advantages
of
a
DBMS
-
DB
Architecture
-
External
Schema
-
Conceptual
Schema
-
Internal
Schema
Data
Modelling -
E/R
Modelling
-
Mapping
to
Relational
Model
-
The
Relational
Algebra
-
Normalisation
techniques
-
Rules
to
apply
to
get
to
1st,
2nd,
3rd,
Normal
Forms
-
When
not
to
Normalise
Relational
DBMSs -
Fundamentals
-
Tables
-
Attributes
-
Relationships
-
Primary/Foreign
Keys
-
Indexes
etc.
-
Integrity
-
Entity
and
Referential
Integrity
-
Main
Components
-
Data
Dictionary
-
Query
Optimiser
-
Concurrency
and
Recovery
Handling
-
Data
Security
-
Integrity
Enforcer
Physical
Data
Organisation
&
Design -
Disk
Structures
-
Indices
-
Data
Clustering
-
Table
Fragmentation
SQL
to
Access
DB -
Defining
DB
Objects
(e.g.
Tables,
Indexes,
Views)
using
SQL
-
Implementing
Integrity
Constraints
-
Manipulating
the
data
using
SQL
-
Controlling
Access
to
the
data
using
SQL
