Feedback

Feedback to trainingforit.co.uk


Site comment Site ratings
Email (optional)

Content

Design

Ease of use

Overall

Relational Databases & Data Modelling Overview

Summary
Length:
2 days
Price:
725 GBP excl. VAT
Training Provider:
StayAhead TrainingStayAhead Training
Location:
Training Method:
Startdate:  
London: 22/09/2010, 16/11/2010, 07/02/2011, 28/04/2011, 13/06/2011

Description of Relational Databases & Data Modelling Overview

Relational Databases & Data Modelling Overview Course Overview
The Relational Databases & Data Modelling Overview course is designed to give delegates practical experience in data modelling using entity relationship diagrams & data normalisation, also in designing relational databases using the normalised entity model.  Both entity modelling and data normalisation form core elements of this course.  Delegates are not expected to have any prior knowledge of systems analysis or databases, and the course includes a brief introduction to the principles of systems analysis.

Skills Gained
The delegates will gain knowledge and practise in:
  • The database approach
  • Database Management Systems
  • The logic of database architectures
  • Entity modelling
  • Constraints and assumptions
  • Data normalisation to the third normal form
  • Logical data structures
  • The relational schema
  • Database constraints
  • The concept of views
  • De-normalisation techniques
  • An introduction to simple queries in Structured Query Language (SQL)

Who will the Course Benefit?
Developers moving into the area of relational databases who need an understanding of the principles and logic of the relational database; programmers who are to start programming in SQL and need to know the principles on which it is built; programmers who need to understand entity modelling and normalization; analysts needing a knowledge of entity modelling and entity relationship diagrams and any others who need to know the principles of relational analysis and data modelling but do not need a complete systems analysis course.

Course Objectives
The Relational Databases & Data Modelling Overview course provides an understanding of the structure of a RDBMS (Relational Database Management System) and the underlying principles of relational analysis and data modelling.

Requirements
An understanding of Information Technology concepts and computer terms is required.

Follow-On Courses
  • Oracle SQL




Relational Databases & Data Modelling Overview Training Course
Course Contents - DAY 1
Course Introduction
  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: INTRODUCTION TO RELATIONAL DATABASES
  • The Database Approach
  • Database Management Systems
  • The function of a Database Management System
  • The Processing Architecture
  • The Schema Architecture
  • The Storage Architecture
  • An overview of Database System Development
  • An overview of general database principles

Session 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
  • Sub-type and Super-type Relationships
  • Arc Relationships
  • Recursive Relationships
  • Constraints and Assumptions
  • Normalisation to the First Normal Form (1NF)
  • Normalisation to the Second Normal Form (2NF)
  • Normalisation to the Third Normal Form (3NF)
  • Exercises:   Analysing a specification
    • Creating an Entity Relationship Diagram from it

Relational Databases & Data Modelling Overview Training Course
Course Contents - DAY 2
Session 2: CONCEPTUAL DATA MODELS (continued)
  • Normalisation to the First Normal Form (1NF)
  • Normalisation to the Second Normal Form (2NF)
  • Normalisation to the Third Normal Form (3NF)
  • Exercises:   Data Normalisation producing table specifications and Entity Diagrams

Session 3: THE RELATIONAL MODEL
  • Relational Structure
  • Relational Terminology
  • Domains
  • A Relational schema
  • Candidate keys and Primary Keys
  • Foreign Keys
  • Key Constraints
  • Attribute Constraints
  • Implementing Sub-type/Super-type Relationships
  • Views
  • Denormalisation using Pre-joined Tables
  • Denormalisation using Derived Data
  • An Introduction to Structured Query Language (SQL)
  • Simple Queries
  • Simple Updates of the Data
  • Exercise:   Data Modelling from an Invitation to Tender

Continuing studies

Follow on course: Oracle SQL

Expenses

£725.00

Description of StayAhead Training

technical it training

SQL, Oracle, UNIX and Linux experts

StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.

StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.

StayAhead IT Training works with some of the largest names in the IT training industry to provide courses on behalf of Parity Training, Global Knowledge, New Horizons and many more.

unix, linux, oracle, sql, javaSpecialist IT training

StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena and enjoy an enviable position in the UK by being amongst the top IT Technical training organisations.

The UNIX curriculum not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle curriculum also has depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.

StayAhead's training flexibility comes from developing their own courses that include high quality course material, written not only to support the learning process, but can also act as a helpful reference guide on the delegates return to work.

In-house IT training

In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.

StayAhead's focus on IT training

StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. Whether delegates attend a StayAhead Training scheduled course or an on-site course, each event is approached in a professional manner.

StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.

specialist it training


Show all courses with StayAhead Training

Request information - obligation free

When filling out this form on trainingforit.co.uk, your contact information will be sent to the school you are interested in. The school will then contact you and provide you with further information through email, telephone or regular mail.
To order information from StayAhead Training, please fill out the following information:
* =  Required field
Email Address*
First Name*
Last Name*
Company
Position
Town/City*
Telephone*
Start date
Message

Contact information for StayAhead Training

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

Phone no: 020 7600 6116
www.stayahead.com

Keywords

Relational Databases & Data Modelling Overview Training course, Relational Databases & Data Modelling Overview Training, Relational Databases & Data Modelling Overview course, StayAhead Relational Databases & Data Modelling Overview training course, Databases Training, MySQL & PHP Training, Oracle Training

More Information
Request Information
To order information from Relational Databases & Data Modelling Overview, please fill out the following information:

What happens now?
Your right to request 'Time to Train'

time to train, training, courses, employment law

Looking for training, or a course to improve your skills?

The new law 'Time to Train', gives employees the legal right to request time off work for training, and to take courses.

Good news for everybody! Learn more.

If you require help finding the right course for you - we can assist you - contact us.

Write a review
Have you studied » Relational Databases & Data Modelling Overview at » StayAhead Training? What did you think? By sharing your experiences you could help others to pick the right education. Set grades (1-5) where 1 is very poor and 5 is excellent.
Very poor | Poor | Ok | Good | Very good
Teacher / Teaching
Location / Facilities
Literature
Exchange with other students

Do you recommend the school:


Tell a friend

Tell a friend about the education Relational Databases & Data Modelling Overview at StayAhead Training.

To:  
From: