Database Architecture Design - Frameworks and Best Practices
3.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
114 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Database Architecture Design - Frameworks and Best Practices to your Wishlist.

Add to Wishlist

Database Architecture Design - Frameworks and Best Practices

Learn architectural design frameworks and best practices for deploying database systems in a corporation globally
3.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
114 students enrolled
Created by Dan Grijzenhout
Last updated 9/2017
Current price: $10 Original price: $60 Discount: 83% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
  • 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

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,


Who is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
13 Lectures
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

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
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

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

Data Transaction Management Services Overview

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

Maintaining Data Integrity

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
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

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

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

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
About the Instructor
Dan Grijzenhout
3.7 Average rating
450 Reviews
16,321 Students
20 Courses
35+ Years of Consulting and Entrepreneurial Expertise!

About Dan Grijzenhout: For close to thirty years, Dan has been a professional business and information systems consulting professional working to executive levels for both private and public sector organizations globally, a number of which were "Fortune" level enterprises. Dan has founded, operated and sold an online global payment services company that moves millions of dollars on behalf of its 100,000 plus account holders annually; he has been interviewed on the show "World Business Review" by former head of NATO and Secretary of State, General Alexander Haig, for his work in advanced digital and online telecommunications services and nation-wide online and card based "Loyalty" programs; and now works at writing and building training programs to share his years of experience with others interested in online entrepreneurship.

Social Media Marketing, Content Creation and Authorship: During the past few years, Dan has focused nearly all his time and energy on designing and building online marketing systems and social media marketing platforms. In fact, Dan recently completed a two year project as the project manager and chief architect to build a marketing system used by several major airlines, travel agencies and Fortune Level manufacturing corporations. Dan has written, self-published and self-marketed five books now being sold through Amazon Kindle and Create Space; he has written and published over 40 published social media related training/learning articles, and has created over 100 training videos and knowledge enhancing video podcasts.

He has gained expertise in many online content creation tool-sets including the full suite of Adobe Creative tools and Adobe Dreamweaver for website development; video and audio editing software; 3rd party social media related website services and content creation partners; and most main-stream social communication platforms including Facebook and Facebook business pages, Pinterest, Twitter, Instagram, Google Plus, Reddit, Goodreads, Amazon Author Central, LinkedIn, Ezine Articles Publishing, Amazon-Kindle Book Publishing, Amazon Create Space and more. On these social media platforms, Dan has now amassed over 15,000 followers and subscribers and more are following him daily.