Professional Consulting - Database Architecture Strategy
3.7 (13 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
167 students enrolled

Professional Consulting - Database Architecture Strategy

Learn architectural design frameworks and best practices for deploying database systems in a corporation globally
3.7 (13 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
167 students enrolled
Created by Dan Grijzenhout
Last updated 9/2017
English
English
Current price: $38.99 Original price: $59.99 Discount: 35% off
16 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand Best Practices Relating to Managing Data In A Corporation
  • Know "Best Practices" for Distributing Data in a Corporation
  • Understand the Scope of Services Provided by an Enterprise Data Environment
  • Better Architect Globally Deployed Database Solutions
Requirements
  • The best students for this course will be working or will have worked within an IT systems development team building applications and database solutions in a corporation
Description

This course is designed to assist database analysts, database architects and IT development personnel in understanding "Best Practices" that should be considered when architecting the data solutions for a corporation.  

It starts out by discussing the The Enterprise Data Environment Framework which provides the architectural boundaries for all aspects of architecting a corporation's data.  This defines the scope within which the architect will work - from database structures through to data management, data services, data security, etc.

Then it discusses "Best practices" in each of these areas supported by their rationale and general implications to a corporation if these concepts are implemented.  In the final lectures of this course, additional guidance is given in the arts of architecting for high availability, high concurrent user bases and high complexity situations.

The course should take the student about an hour and a half to two hours to complete. 

The course is "lecture" based and no additional tools or software is required to take this course.

This course has been upgraded for "Close Captioned" viewing - so subtitles are there to be viewed at your option.

Best wishes,

-Dan

Who this course is for:
  • This course is best suited for Intermediate level database designers, administrators and architects and above
  • System development personnel wanting to learn more about the databases they build applications for
Course content
Expand all 13 lectures 01:17:15
+ Enterprise Data Environment Overview
5 lectures 28:16

This lecture introduces this course.  It discusses in overview what the student who takes it will learn.

Preview 02:26

The Enterprise Data Environment Framework provides the architectural boundaries for all aspects of architecting a corporation's data.  This defines the scope within which the architect will work - from database structures through to data management, data services, data security, etc.

The Enterprise Data Environment Framework
09:20

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

Preview 05:38

Operational data within a corporation is often transformed at some point into Decision Support Data so it can be used for strategic reporting purposes.  This lecture describes and discusses the Framework for operational and DSS data within a corporation, it's transformations and uses.  

Preview 04:42

This lecture provides the student with a structured strategy for distributing data throughout the corporate enterprise.  

The Data Distribution Framework
06:10
+ Enterprise Data Environment Best Practices / Principles
4 lectures 24:52

This provides a set of "Best Practices" or "Principles" for operating the Enterprise Data Environment along with rationale for their existence and implications the corporation will face should it choose to adhere to these Principles.

Enterprise Data Environment - Architectural Principles
11:22

This lecture discusses the scope of services provided by the Enterprise Data Environment with respect to Data Transaction Management.

Data Transaction Management Services Overview
03:27

Here is an important principle to adhere to that will assist the corporation in maintaining solid data integrity.

Maintaining Data Integrity
06:08

Data security in concept is about controlling access to data and protecting it.  This encompasses viewing data, adding new records, editing existing records and deleting records.  In this lecture, I discuss a “Best Practice” or “Principle” that can act as a good corporate guideline to assist in protecting the security of the corporation’s internal data assets.  

Maintaining Data Security
03:55
+ Guidance for Implementing High Availability High Output Systems in a Corporation
4 lectures 24:07

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.

Database Referential Integrity and Its Importance in High Availability Systems
09:56

This is a technically deep lecture that discusses various aspects of managing a corporate level messaging management system. It talks about how to ensure your e-mails get to their intended recipients, how to stay white listed with e-mails ISP's, how to build in virtual IP's and IP fail-over strategies into your message management infrastructures, and much more. So if you are a geek at heart, you won't want to miss this lecture!

Corporate Message Management - Risk Avoidance Considerations
05:33

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!

Why Implement a Meta Data Repository
07:29

This quiz both tests a student's new knowledge gained from taking this course and provides the student with more reinforcement of key concepts discussed in the course.

End of Course Quiz - Good Luck!
3 questions

View this presentation to see where you can obtain discounts to other online training courses that I have published.

Bonus Lecture: Congratulations and More Course Discounts for You
01:09