Database Design and Data Normalisation 1-Day Course, London, Online, Thursday, 02. July 2015

This excellent database course summarizes data terminology and concepts and cover practical exercise in design the structure of database.

About this Event

DATABASE DESIGN AND DATA NORMALIZATION COURSE

Database Design and Data Normalization Course Summary

Relational Databases & Data Normalisation .

Learn how to decide which tables and columns are required for a database, plan relationships, how to decide on data types and how to relate tables.

Database Design and Data Normalization Course Description





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


    and Creating an Entity Relationship Diagram

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



WHAT IS INCLUDED IN THE DATABASE DESIGN AND DATA NORMALIZATION COURSES:
  • Database Design and Data Normalization Course Certificate on completion
  • Database Design and Data Normalization Course notes
  • Practical Database Design and Data Normalization Course exercises, Database Course Homework / Database Course Revision work
  • After the course, 1 free session for questions online Database Course via Gotomeeting.com.
  • Max group size on this Database Course is 4.

Thursday, 02. July 2015, Online, Database Design and Data Normalisation 1-Day Course, London

Red City Radio at El Corazon
Tuesday 09. February 2021
WEATHERS / DEAL CASINO
Thursday 11. February 2021
Galentine's Floral Workshop
Thursday 04. February 2021
The Hit Men
Thursday 11. February 2021
John Moreland
Wednesday 27. January 2021
Find more interesting events
Get event recommendations based on your Facebook taste. Get it now!Show me the suitable events for meNot now