Northern Ireland based Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors.

  Public Courses
General Training

  On-Site Courses
Tailored Training

  ILM Qualifications
Level 4 & 5 Awards

  Beck-Bites
Articles & Reviews

  Team Building
Activities & Events

  Why Choose Us?
Our Clients
Our Services
Quality and Expertise
Financial Support
Course Tailoring
Our Support Team
Talk To Us

Join Mailing List

 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




© Beckinridge Ltd.

Site by redrhino

Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors in Northern Ireland.
Privacy Policy | Capability, Improvement, Through Training & Development