Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.

Advanced Data Modelling Course

6 sessions available starting from $2,200.00

Subject: Agile

Ages: All ages

Skill level: All difficulty levels

A concrete set of frameworks, methods, tips and techniques for resolving data modelling
issues

This intensive, participative course provides experienced data modellers with a concrete set of frameworks, methods, tips, techniques, and other tools that they can draw on to design a corporate architecture with the right balance between the business desire for flexibility/extensibility and need for control.

This is not just about designing a system that works today, but will also work tomorrow. A system that can predict patterns of change, and is therefore designed to accommodate future business needs for years to come.

A range of important strategic and technical issues are covered, including:

* The role of enterprise models
* How a data architecture team can add value
* Conceptual...

see more

A concrete set of frameworks, methods, tips and techniques for resolving data modelling
issues

This intensive, participative course provides experienced data modellers with a concrete set of frameworks, methods, tips, techniques, and other tools that they can draw on to design a corporate architecture with the right balance between the business desire for flexibility/extensibility and need for control.

This is not just about designing a system that works today, but will also work tomorrow. A system that can predict patterns of change, and is therefore designed to accommodate future business needs for years to come.

A range of important strategic and technical issues are covered, including:

* The role of enterprise models
* How a data architecture team can add value
* Conceptual, Logical and Physical models
* Quality criteria for data models - content and presentation
* Engaging the business and getting informed input
* Working with DBAs and other technical stakeholders
* Working with different approaches, including agile methods.

Participants will significantly increase their ability to solve complex data modelling issues and implement architecture solutions utilising a portfolio of skills such as:

* Normalising data beyond 3NF
* Mastering time-based data and rules
* Modelling the core organisation and its roles
* Defining business rules and processes using meta-data
* Understanding the right way to use Super-Type and Sub-Type structures
* Harnessing the power of Recursive structures
* Presenting 3-Dimensional data models.

Intended For

* Business and Systems Analysts involved in Corporate modelling
* Data Architects, Data Administrators
* Data Analysts, Data Consultants
* Data Warehouse Managers, Database Administrators

Prerequisites

The course does not focus on any particular modelling notation or database product - the concepts presented refer equally to ER models as well as Class/Object models. It is recommended that attendees have knowledge of and experience with the fundamentals of data modelling, such as the concept of Normalisation to 3NF, and some practical experience in the area.

Please note: Fundamentals of data modelling, including Normalisation to 3NF, are covered in Software Education's Business Systems Analysis course.

Learning Outcomes

By the end of this course, participants will be able to:

* View data from a more abstract perspective
* Integrate divergent business views into a single corporate architecture
* Utilise a range of advanced modelling techniques in their data modelling designs:
- more precise techniques for Control (business rules)
- more powerful designs to accommodate Flexibility/Extensibility
* Appreciate the need for 'resilience' in data models
* Understand how to involve corporate stakeholders meaningfully in the process
* Utilise a portfolio of skills to deliver high quality data models that will 'stand the test of time' for the business.

Content

Data modelling - Past, Present, Future

The fundamentals of data modelling may have stayed the same, however data modellers now have a variety of tools and techniques they never had before - XML and other mark-up languages, data warehouses, ETL (extract transform load) and alternative design strategies to bring about the realisation of true enterprise architecture. Data modellers don't just need these latest tools - they also need a new mindset to use them effectively. This module examines some of the history, the current trends and future patterns facing enterprise architects, and explores:

* The Zachman Framework - looking at different views of enterprise architecture
* Levelled Models - thinking about models in a different way
* The Price Stairway - a look at cost vs benefit.

Modelling Beyond 3rd Normal Form

Normalisation to 1NF, 2NF and 3NF involves some simple mechanistic rules that data modellers follow when looking at key structures and referential integrity checking. Useful to a point, but not much use for creating flexible structures to cater for complex business rules. This module looks at some of the challenges of Normalisation:

* Intra-key dependencies
* BCNF (Boyce-Cod Normal Form) - Update anomalies between 2NF and 3NF
* Ternary relationships - 4NF, 5NF
* Soft coded techniques - alternate keys, combination controls, consistency rules, virtual attributes and extended foreign keys
* Differentiating between facts versus rules

Super-Types & Sub-Types

The concept of abstract typing (Super-Class and Sub-Class for those who prefer Object Oriented terminology) is a powerful tool that allows generalisation for flexibility and specialisation for control. This module demonstrates the most effective and most appropriate way to use this technique to design stable structures, and explores:

* The problems of Aggregation
* The difference between Exclusive and Non-Exclusive Sub-Types
* Domain Key NF (DKNF, also known as 6NF)
* Nested Sub-Types and Dimensions - multi level sub-type hierarchies, looking at the problem of multiple inheritance.

Recursions

Recursions provide extensibility in the hands of the business. Recursive structures provide more flexibility than fixed structures, and give the business the ability to manage their own growth. At the same time, recursion needs stringent techniques to impose the needed control. This module explores these issues and these techniques:

* Ancestry checks (hierarchical and cyclic)
* Broken trees and orphans, Self-referential objects
* The difficulties faced with sub-typing recursions and intersecting recursions
* Recursive cardinality - 1:1, 1:M, M:M
* Use of both Static and Dynamic groups with recursion.

The Dimension Of Time

A key challenge faced by many businesses is the difficulty in enforcing business rules which are dependant on time. This module explores the importance of time-stamped or time-dependant information, and the extra level of precision required to define business rules that are time based:

* Differentiating between different types of time-based rules
* Attributes and relationships over time
* Units of time and recursions of time
* Time overlap v Time underlap, Concurrent v Discreet, Disjointed v Continuous.
* Determining the appropriate granularity - Point or Period

Generalisation and Patterns

Generalisation is vital for building robust data models as it provides reusable data structures, broad business rules, functionality and business process that can span multiple systems. It identifies and integrates implied roles, including those of our own organisation in the business activity, to provide the benefit of further reuse.

Patterns offer generic frameworks that facilitate top down design and allow Data Modelling to align with incremental/evolutionary approaches to systems development, such as Agile practices. This module explores these concepts:

* Levels Of Abstraction
* Implied Roles - Types or Subtypes?
* Controlled generalisation
* Modelling Ourselves - roles, functions, rules
* Business Object patterns
* Business Rule patterns

Metadata

"Meta-data" means data about data - information that allows us to understand and manage our data assets more effectively and productively.

In today's world of Data Warehouse and Business Intelligence, we now have distributed architectures that allow us to retain our existing systems separately and federate them through the abstract corporate data model.

A metadata model provides the mechanism to design and build systems that are more responsive to change, both for business objects and for business rules. This module explores these concepts:

* The Corporate Model - Data Warehouse, Business Intelligence
* Design Alternatives: adaption, federation, propagation
* Modelling the relational model - entities & attributes
* Keys, domains, virtual attributes
* Dynamic grouping - exception logic
* The business rule model, conditions & actions

3D Data Models

Traditionally, data models have been 2 dimensional - treating all entities as of equal importance. They satisfy the specification needs of database designers, but they have typically excluded other stakeholders from the data requirements process.

The 3D model separates the model into levels/layers, applying objective techniques to categorise entities by Type based on their level of importance to the business. It presents the model in a way that optimises Stakeholder engagement by providing different perspectives for different stakeholders: planner view, owner view, architect view, designer view.

This approach is also consistent with the use of Patterns to represent a top-down framework that can co-ordinate and integrate 'Agile' development projects.

Method Used

Lecturing is kept to the minimum necessary. The modelling techniques are presented as a series of challenges with multiple approaches and solutions discussed.

The workshop also contains a comprehensive case study that the participants work through over the three days, applying all the techniques and learning how to combine the requirements of 'control' with those of 'flexibility'.

Documentation

Course notes, including guides, templates and checklists. References to Web sites and further reading.

see less

Choose from 6 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Canberra, ACT

Price: $2,200.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Brisbane, QLD

Price: $2,200.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Melbourne, VIC

Price: $2,200.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Melbourne, VIC 2000

Price: $2,200.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Canberra, ACT

Price: $2,200.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Brisbane, QLD

Price: $2,200.00




My Other Listings

Small Team Leadership Course
Small Team Leadership Course
10 sessions available starting from $1,485.00
Business Systems Analysis Course
Business Systems Analysis Course
24 sessions available starting from $2,860.00
Taste of Agile Course
Taste of Agile Course
1 session available for $990.00

see all listings ยป


Found In