$100.00
Certification

Industry recognized certification enables you to add this credential to your resume upon completion of all courses

Need Custom Training for Your Team?
Get Quote
Call Us

Toll Free (844) 397-3739

Inquire About This Course
Instructor
Dan Grijzenhout, Instructor - Enterprise Data Architecture Strategy - Build a Metadata Repository

Dan Grijzenhout

Is an online business and marketing Instructor with 9 published books. He has 35 years enterprise systems delivery experience including Internet, mobile/web & telecommunications large projects. He worked for large enterprises like: JP Morgan Chase; Air Canada & WestJet; Gateway; E&J Gallo Wines; TRW; USAF; Blue Cross & Blue Shield; 3M HIS; Nextel; Tong Yang Insurance; MCI; NYPD; and more.

Instructor: Dan Grijzenhout

Learn Why and How to Build a Meta Data Repository for Your Corporation

  • Learn best practices relating to architecting meta data repositories for a corporation.
  • Learn how to implement and manage meta data repositories in corporations.
  • Instructor has 35 years enterprise systems delivery experience working at large enterprises like JP Morgan Chase; Air Canada; Nextel; Tong Yang Insurance; MCI; NYPD; and more.

Duration: 1h 15m

Course Description

As corporations increase in size and complexity, securing, managing and insuring the integrity and accuracy of internal data becomes a critical component to continued corporate growth. If a corporation is growing, there will come a time in each entity's evolution where an ELDR (Enterprise Level Data Repository/Meta Data Repository) becomes an integral component to the organizations information systems architecture. This course provides the student with the knowledge required to: Justify the need for an ELDR within the corporation Construct a set of Best Practices/Principles for it's design Design and build the Framework for the services the ELDR will provide Design the resulting architecture required for the ELDR Define the rules for the data/information to be stored within the ELDR (Data Dictionary, operational, decision support, etc.) Define the categories of data, data integrity, data security, etc. Define the rules, processes and structures required to check-in, check-out and modify data/information stored within the ELDR (Management Framework) Define the application components that will comprise the ELDR system This course is designed to support the ongoing efforts of an IT department and its data architects and managers in designing, building and maintaining a corporation's business, operational and decision support information systems. It is an advanced course most useful to database architects, senior information systems analysts and systems development personnel.

What am I going to get from this course?

  • Students will learn best practices relating to architecting Meta Data Repositories for a corporation.
  • Students will learn how to implement and manage meta data repositories in corporations.
  • Students will learn how to implement and operate geographically dispersed meta data repositories for complex organizations.

Prerequisites and Target Audience

What will students need to know or do before starting this course?

Students should have a knowledge of building and or supporting databases in a corporate environment.

Who should take this course? Who should not?

  • This course targets database administrators, developers and architects working for corporations.
  • The course would also be useful to information technology consultants.

Curriculum

Module 1: Introduction and Enterprise Level Data Repository Frameworks

Lecture 1 Introduction to Enterprise Level Meta Data Repositories

This course assists the student in learning how to define and construct an Enterprise Level Data Repository (ELDR). Within this course, we will define both an architectural and a management/operational framework for the Repository. The full scope of this course lecture series includes the following: •A defined and sample Repository Management Framework for a Corporation globally. •Defined personnel roles to manage this environment including an overview of tasks usually relating to each of the roles. •An ELDR “Help Desk” support environment definition including training tips; and, •An initial definition of targeted users of the ELDR systems and tools.

Lecture 2 Why Build an Enterprise Level Meta Data Repository?

As corporations grow, undertaking the construction and deployment of an Enterprise Level Meta Data Repository becomes an almost "Must Do" project. The increasing complexities of systems and data as corporations globally deploy need some form of structured meta data environment else the corporation is at risk of losing control of its internal information assets; and this can hurt them as they continue to try to compete in the marketplace. This lecture discusses in overview what an ELDR actually is, the benefits of implementing one within a corporate environment and the risks a corporation will face if it does not build one - so be sure to check this lecture out!

Lecture 3 Key Terms to Learn in This Lecture Series

This lecture provides detailed definitions of key terms used in this lecture series that the student should understand before going through the full course.

Lecture 4 Database Referential Integrity and Its Importance in High Availability Systems

Database referential integrity is not just a database design feature to be taken for granted when databases are implemented and deployed. As a database and systems architect, when working with high concurrent user and high availability systems, you will need to thoroughly understand referential integrity and all its ramifications to your final deployed database designs. In high availability systems, its usage becomes in actuality, an architectural design consideration.

Lecture 5 Building a Global Data Dictionary

A Global Data Dictionary is a "cornerstone" component to a Meta Data Repository. Be sure to watch this video to learn what types of content a corporation should be collecting about their internal data and application systems through these "Dictionaries".

Module 2: Enterprise Level Data Repositories - Strategies, Rationale and Implications

Lecture 6 The Overall Repository Management Strategy

Data Management Strategies, Rationale and Implications

Lecture 7 Data Management Strategies, Rationale and Implications

This lecture provides the student with important "Best Practice" information relating to Data Management. Rationale, Implications and general tasks need to be completed in relation to implementing a sound Data Management strategy are documented within this lecture.

Lecture 8 Data Categorization Strategies, Rationale and Implications

This lecture provides the student with important "Best Practice" information relating to Data Management. Rationale, Implications and general tasks need to be completed in relation to implementing a sound Data Management strategy are documented within this lecture.

Lecture 9 Data Distribution Strategies, Rationale and Implications

This lecture provides the student with important "Best Practice" information relating to distributing a Meta Data Repository within geographically dispersed and complex corporations. Rationale, Implications and general tasks need to be completed in relation to implementing sound data distribution strategies are documented within this lecture.

Lecture 10 Data Transaction Management Services

This lecture provides the student with important "Best Practice" information relating to implementing sound data transaction management services within complex corporations. Rationale, Implications and general tasks need to be completed in relation to implementing sound data transaction management services strategies are documented within this lecture.

Lecture 11 Data Integrity Strategies, Rationale and Implications

This lecture provides the student with important "Best Practice" information relating to maintaining data integrity within a Meta Data Repository environment. Rationale, Implications and general tasks need to be completed in relation to implementing sound data integrity strategies are documented within this lecture.

Lecture 12 Data Security Strategies, Rationale and Implications

This lecture provides the student with important "Best Practice" information relating to implementing effective Meta Data Repository security strategies to protect the MDR/ELDR environment. Rationale, Implications and general tasks need to be completed in relation to implementing sound data security strategies are documented within this lecture.

Lecture 13 ELDR Security Profiles

This lecture provides the student with useful knowledge on how to implement useful MDR security profiles for those that have a need to access the MDR environment. Rationale, Implications and general tasks need to be completed in relation to implementing security profiles for end users of the MDR/ELDR are documented within this lecture.