Management Sales Technology training courses, Dublin Belfast Cork Ireland, Beckinridge
Management Sales Technology training courses, Dublin Belfast Cork Ireland, Beckinridge

Relational Database Design

Course Code - MC-101 Duration - 2 Days

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

« Back to last page

Why Choose Us?

ILM Qualifications

Beck-Bites

Team Building

Public Schedule


© web design by redrhino

Privacy Policy