Database Design and Data Normalisation 1-Day Course, London
by
PCWorkshops
Location
Online event
Refund policy
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.