Data Modelling, Database Design, Data Normalisation Course

Actions Panel

Data Modelling, Database Design, Data Normalisation Course

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

By PCWorkshops

Select date and time

Location

Online

Refund Policy

Contact the organiser to request a refund.

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

Session 3: Demos

  • Normalization to the First Normal Form (1NF)
  • Normalization to the Second Normal Form (2NF)
  • Normalization to the Third Normal Form (3NF)

Session 4: Exercises

  • Exercises: Analyzing a specification and Creating an Entity Relationship Diagram

Session 5:

  • 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:

  • Certificate on completion
  • Course notes
  • Course exercises, Worked examples, Sample Data Sets
  • After the course, 1 free session for questions
  • Max group size on this Database Course is 4.

Organised by

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.

More about us:

training@pcworkshopslondon.co.uk

  • Our classes are instructor led, in our Live Virtual Classroom
  • Courses well developed by registered, qualified instructors with a wealth of experience in software development and training.
  • The maximum groups size that can access our Virtual Classroom, is 4.
  • Every one gets personalised attention.

Why learn with us at PCWorkshops:

  • Excellent, up-to-date courses, following latest trends and technologies.
  • Excellent trainers with professional experience.

Award Winning Trainer

We offer Training Courses in Software Packages:

  • Java Programming
  • Python Programming, Python data analytics, Python Machine Learning
  • Database design and Data Normalisation
  • SQL Courses
  • Data Analysis and 
  • MS Excel, data analyses with Excel. Excel VBA
  • Access Database Courses.
  • MS Project Training
  • MS Office Training

Our Style:

  • Relaxed, Practical, Useful

Methods of instruction:

  • Classroom training with max class-size 4 people
  • Virtual classrooms via online video links
  • 1-1 mentoring
  • Customised training

Certification:

Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualification

Customisation:

We can tailor all our courses. Email to customise location, times, content.

 

 

 

£75