les01资料参考 学习.pptVIP

Introduction Objectives After completing this lesson, you should be able to do the following: Discuss the goals of the course Identify the appendixes in this course Identify the environments, database schemas, and tables that are used in the course Identify some of the Oracle 11g data warehousing documentation and resources Questions About You To ensure that the class can be customized to meet your specific needs and to encourage interaction among all, answer the following questions: Which organization do you work for? What is your role in your organization? What is your level of data warehousing and database administrative expertise? What Oracle versions do you use? What do you hope to receive from this class? Lesson Agenda Course objectives, course prerequisites and suggested prerequisites, and suggested course schedule The schemas, appendixes, SQL environments, and data warehousing tools used in this course Oracle 11g documentation and additional resources Course Objectives After completing this course, you should be able to do the following: Describe the role of data warehousing and business intelligence (BI) in today’s marketplace Define the terminology and explain the basic concepts of data warehousing Define the decision support purpose and end goal of a data warehouse Develop familiarity with the various technologies required to implement a data warehouse Identify the technology and tools from Oracle to implement a successful data warehouse Identify data warehouse modeling concepts Course Objectives Describe methods and tools for extracting, transforming, and loading data Identify the tools for accessing and analyzing warehouse data Identify the features of Oracle Database 10g that aid in implementing the data warehouse Describe the online analytical processing (OLAP) and data mining techniques and tools Explain the implementation and organizational issues surrounding a data warehouse project Prerequisites and Suggested Prerequisites Required prerequi