Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 

RDBMS: Relational Databases: Introduction

Course Code: RDI-2      Days: 2
Show all DBA Courses
Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.

Course Overview

This course is designed to give delegates practical experience in data modelling using entity relationship diagrams and data normalisation, and designing relational databases using the normalised entity model.

Audience

Delegates who require an understanding of relational databases.

Skills Gained

On completion of this course, delegates will have an understanding of the structure of a Relational Database Management System and have sufficient knowledge to converse with RDBMS professionals.

Prerequisites

An understanding of Information Technology concepts and computer terms.

Course Outline

  • Introduction to Databases
  • Database Management Systems
  • Database System Development
  • Conceptual Data Models
  • Entities
  • Attributes
  • Relationships
  • Constraints
  • Assumptions
  • Identifying Entities, Attributes, Relationships
  • Sub-type/Super-type relationships
  • Arc, Non-transferable and Redundant Relationships
  • Recursive Relationships
  • Normalisation
  • The Relational Model
  • Structure
  • Relational Terminology
  • A Relational Schema
  • Implementing Constraints
  • Implementing Sub-type/Super-type Relationships
  • Views
  • Denormalisation

Follow On Courses

Introduction to SQL.


How to make a booking for the RDI-2 course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership