Professional Consulting - Database Architecture Strategy
- 1.5 hours on-demand video
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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
- 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.
- 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
This lecture introduces this course. It discusses in overview what the student who takes it will learn.
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.
This lecture provides detailed definitions of key terms used in this lecture series that the student should understand before going through the full course.
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.
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.
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.
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!
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!