This is the recommended eighth class of the Technical Solutions Delivery Certificate that provides an overview of technological understanding to help in the communication of projects and working relationships. To learn more about the Technical Solutions Delivery Certificate and to learn how these classes can help bridge the communication gap on technology-related issues, see more information here.
Databases store and organize data to provide valuable decision making and analysis tools for business. There are multiple layers of employees using the database for a variety of reasons. Accurate, complete collection of needs from the working groups is essential to making the database successful. An understanding of database structure and function can help facilitate conversations to plan and provide a product that is fully functional for all levels of a business team.
Class format includes lecture, hands-on exercises, and real world examples.
Upon completion of this class, you should be able to:
- Compare and contrast Online Transaction Processing (OLTP) databases and data warehouses
- Define the four step design process for data warehouses
- Outline common data warehouse structures: Star, Snowflake and OLAP
- Determine what fact tables are and how they measure business performance
- Understand dimension tables and tracking the details of measurements
Audience: This course is ideal for anyone, but especially communications professionals, who are involved in data project conception. This class is aimed at non IT professionals to gain an overview understanding of the IT world.