Business Analysis - Data Modelling - Advanced

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 includeata 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.
Homepage