Menu
  1. Home
  2. Digital Skills
  3. Database Administration & Development
  4. Short
  5. Database Design and Data Normalisation, Live Virtual Classroom
Enquire Now

Database Design and Data Normalisation, Live Virtual Classroom

Study Method
Online
Institution
PCWorkshops
Start Date
Enrol anytime

Course overview

Relational Databases & Data Normalisation Overview Training Course.

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.

Expand all and read more

Study method

  • Online
  • Blended
  • In-class
xo-logo

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.

Enrol in a course today to unlock exclusive deals.

Duration study load

  • 1 Day

Course features

  • SQL course certificate on completion (assessment based)
  • SQL course notes
  • Practical SQL course exercises, SQL course homework/SQL course revision work
  • To assist after the course, 1 free session for questions online SQL course via Skype or Teamviewer

Subjects

Core Sessions
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 a 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
  • Normalisation to the First Normal Form (1NF)
  • Normalisation to the Second Normal Form (2NF)
  • Normalisation to the Third Normal Form (3NF)
  • Exercises: analysing a specification
  • Creating an Entity Relationship Diagram from it
Session 3: Conceptual data models (continued)
  • Normalisation to the First Normal Form (1NF)
  • Normalisation to the Second Normal Form (2NF)
  • Normalisation to the Third Normal Form (3NF)
  • Exercises: Data Normalisation producing table specifications and Entity Diagrams
Session 4: 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
  • Denormalisation using pre-joined tables
  • Denormalisation using derived data
  • An Introduction to Structured Query Language (SQL)
  • Simple queries
  • Simple updates of the data
Want more information about the subjects for this course?
Get the course guide

Payment options

Course fees – £350

  • No government funding available for this course
Find out more about the payment options for this course
Get the course guide

About PCWorkshops

PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.

We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.

Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.