PCWorkshops

Java and Data-related training courses to companies of all sizes

Relational Databases & Data Modelling Overview Training Course

Download pdfContact Us – Book Now

Course Content – Day 1

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
  • Normalization to the First Normal Form (1NF)
  • Normalization to the Second Normal Form (2NF)
  • Normalization to the Third Normal Form (3NF)
  • Exercises: Analyzing a specification
  • Creating an Entity Relationship Diagram from it
Course Content – Day 2

Session 2: Conceptual Data Models(continued)

  • Normalization to the First Normal Form (1NF)
  • Normalization to the Second Normal Form (2NF)
  • Normalization to the Third Normal Form (3NF)
  • Exercises: Data Normalization 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
  • Denormalization using Pre-joined Tables
  • Denormalization 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
Training Location

PCWorkshops at Connections/Club Quarters at 8 Northumberland Avenue, Embankment, London WC2N 5AP

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s