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 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.
This lecture provides the student with a structured strategy for distributing data throughout the corporate enterprise.
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.
This lecture discusses the scope of services provided by the Enterprise Data Environment with respect to Data Transaction Management.
Here is an important principle to adhere to that will assist the corporation in maintaining solid 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.
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!
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.
View this presentation to see where you can obtain discounts to other online training courses that I have published.
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.