Analysing Complexity - Designing Simplicity

What you'll learn

Understand and apply the key concepts of Data Modelling in Business Analysis.

Construct and validate data models using Entity Relationship Diagrams and UML Class Diagrams.

Analyse requirements to construct Data Models for new or enhanced systems, that accurately reflect business needs.

Analyse and resolve more complex business requirements and business rules.

Requirements

Students need an understanding of the key concepts of Data Modelling - Entities / Object Classes, Attributes, Relationships / Associations, Optionality and Business Rules. The course content builds on these concepts and covers advanced Data Modelling techniques. Ideally students will have completed my introductory course - Data Modelling - or an equivalent training programme.

Description

If you are a practising or aspiring Business Analyst or Data Analyst, this course will help you to develop your career. Learn some advanced aspects of an essential Business Analysis technique - Data Modelling . By the end of the course you will be able to construct data models that accurately reflect more complex business requirements. You will learn some advanced data modelling and data analysis techniques. You will be able to apply all of this is practice on systems development projects.Contents include:Data Sub-typing and Inheritance.Exclusive Relationships.Business Rules and Data.Database Design.Analysis of Data Attributes.Analysis of Relationships / Associations.Transferable Relationships.Recursive Relationships.The course is highly practical and case study based. It aims to teach practice as well as theory. You will have plenty of chances to apply and consolidate your new skills. The course includes practical exercises and assignments which you can complete and receive feedback. Your tutor, Steve McIntosh, will give you as much help and support as you need.So - if you want to learn something useful, that you can apply in practice and will help to develop your career as a Business Analyst or Data Analyst - please dive in and join the course. I look forward to working with you!

Overview

Section 1: Introduction

Lecture 1 Data Modelling - Advanced - Course Introduction

Lecture 2 Data Modelling - Basic Concepts - Review 1 - Entities, Attributes and Keys

Lecture 3 Data Modelling - Basic Concepts - Review 2 - Relationships and Optionality

Lecture 4 Data Modelling - Basic Concepts - Review 3- UML Object Class Diagrams

Section 2: Data Modelling - Sub-Types and Inheritance

Lecture 5 Data Modelling - Sub-Types Part One

Lecture 6 Data Modelling - Sub-Types Part Two

Lecture 7 Sub-Types - Practical Exercise

Lecture 8 Sub-Types - Practical Exercise - Solution

Section 3: Data Modelling - Exclusive Relationships

Lecture 9 Data Modelling - Exclusive Relationships

Lecture 10 Exclusive Relationships - Practical Exercise

Lecture 11 Exclusive Relationships - Practical Exercise - Solution

Section 4: Database Fundamentals

Lecture 12 Database Fundamentals Part 1

Lecture 13 Database Fundamentals - Part 2

Section 5: Attributes

Lecture 14 Attributes - Further Analysis - Part 1

Lecture 15 Attributes - Further Analysis - Part 2

Lecture 16 Attributes - Practical Exercise

Lecture 17 Attributes - Practical Exercise - Solution

Section 6: Data Modelling - Transferable Relationships

Lecture 18 Data Modelling - Transferable Relationships - Part 1

Lecture 19 Data Modelling - Transferable Relationships - Part 2

Section 7: Analysing Relationships

Lecture 20 Analysing Relationships

Section 8: Data Modelling - Assignment

Section 9: Data Modelling - Recursive Relationships

Lecture 21 Data Modelling - Recursive Relationships - Part One

Lecture 22 Data Modelling - Recursive Relationships - Part Two

Section 10: Data Modelling - Review

Lecture 23 Data Modelling - Review

Business Analysts who need to learn more about data modelling and data analysis.,Business Stakeholders who will be involved in requirements analysis.,Database Designers who need to learn how to take business requirements forward into a workable design.,Systems Developers who need to learn how to take business requirements forward into a workable design.,Data Analysts who need to learn more about business analysis, data modelling and data analysis.