c2
Connect on:
  • Home
  • Course Centre
    • Project Management >
      • Professional Project Management
      • Project Management Essentials
      • Managing Project Requirements
      • Scheduling & Cost Control Project Managers
      • Project Leadership, Management & Communication
      • Risk Management for Project Managers
      • Negotiation Skills for Project Managers
      • Managing Remote Project Teams
      • Project Quality Management
      • Project Procurement Management
      • Earned Value Management
      • Professional Project Management - Best Practice
      • Professional Project Management - Exam Preparation
      • PRINCE2® Foundation & Practitioner
      • PRINCE2® Overview
    • Agile Project Management Courses >
      • Agile Project Management
      • Using Scrum in organistations
      • Certified ScrumMaster
    • Java >
      • Core Java Programming
      • Advanced Java Programming
      • Java Programming & XML
      • Java Networking
      • Java Virtual Machine (JVM)
      • Java & Java EE Open Source Testing Tools
    • Java Enterprise Edition (EE) >
      • Enterprise Java with Hibernate and Spring
      • Developing Java Web Applications
      • Java & Java EE Open Source Testing Tools
      • Spring Framework Development
    • C/C++ Programming >
      • C Programming Techniques
      • C++ Programming Fundamentals
      • C++ for C Programmers
      • Advanced C++ Programming
      • C++ & STL Design Patterns
      • Object Oriented C++ for Real-time Applications
    • Unix/Linux >
      • Linux Fundamentals
      • Linux Administration Essentials
    • Windows Server Courses >
      • Installing and Configuring Windows Server 2012
      • Windows Server 2008 - Server Administration
      • Configuring Windows Server 2008 Active Directory
    • .NET Courses >
      • ASP.NET MVC 4.0
    • Perl Programming Courses >
      • Perl Programming
      • Advanced Perl Programming
    • Python Programming Courses >
      • Python Programming
    • Database Courses >
      • MySQL for Developers
    • CompTIA >
      • CompTIA Network+
    • Scripting >
      • JavaScript - Introduction
      • JavaScript - Advanced
    • Data Analysis & Design >
      • Data Analysis & Design - Introduction
      • Data Analysis & Design with UML
    • Microsoft Office Courses >
      • Microsoft Word - Introduction
      • Microsoft Word - Intermediate
      • Microsoft Word - Advanced
      • Microsoft Access - Introduction
      • Microsoft Access - Intermediate
      • Microsoft Access - Advanced
      • Microsoft Excel - Introduction
      • Microsoft Excel - Intermediate
      • Microsoft Excel - Advanced
      • Microsoft Excel - Dashboards
      • Microsoft Excel - Macros
      • Microsoft Excel - Expert
      • Microsoft PowerPoint - Level 1
      • Microsoft PowerPoint - Level 2
      • Microsoft PowerPoint - Advanced
      • Microsoft Outlook - Introduction
      • Microsoft Outlook - To Manage Your Time Efficiently
      • Microsoft Project - Introduction
      • Microsoft Project - Advanced
      • Microsoft Publisher - Introduction
      • Microsoft Visio - Introduction
    • Solaris >
      • Solaris 10 Administration
  • Testimonials
  • About
  • Contact

Analysis & Design - Introduction

Course Description

This is a 2-day course which provides a complete view of database design from initial analysis of a business process to ensuring the database will be efficient in live use. Practical exercises reinforce the theory and the course instructor will use real-life examples to illustrate the points made during the course.

Course Duration

2 days

Course Objectives

On completion of this course delegates will be have learned:

·     Entity-Relationship Modelling of business processes
·     Third Normal Form analysis to remove redundancy
·     Conversion of logical to physical data model
·     Testing and tuning the physical design

Course Content

BACKGROUND
Introduction; Databases and data; The need for Data Modelling; Systems development lifecycles.

ENTITY-RELATIONSHIP MODELING
Logical data modeling; Bachman Diagrams; Relationships, attributes and entities; Mandatory, optional and special relationships.

NORMALISATION
Key Selection; Steps to Third Normal Form; Conversion to data model.

REFERENTIAL INTEGRITY
Primary and Foreign keys; Entity, domain and referential integrity; Constraints.

CONVERSION TO PHYSICAL
Usage profiles; Indexing; Security; Concurrency; Transaction design; SQL Data Definition Language; CASE tools; Backup strategy.

DATABASE TESTING
Profile and trace; SQL and Stored Procedure Testing; Access plans; Performance testing; Testing tools.

OTHER TECHNQIUES
Object-oriented data design; Entity Life Histories; CRUD matrix; Relationship Cardinality.

DISTRIBUTING DATA
Benefits and drawbacks; Latency; Replication; Two phase commit; Transaction logs.

SUMMARY & CONCLUSION
Key learning points; Personal Action Planning

Who should attend?

This course is designed for developers and/or system & business analysts who need to understand the principles behind database design. 

Pre-requisites

Whilst no prior experience of data analysis is needed, some knowledge and experience of IT systems or their use is assumed.
Powered by Create your own unique website with customizable templates.