This course gives you the skills help you create responsive and scalable applications. In this class, you will learn how to create cache groups which define the set of Oracle data to be cached in a TimesTen data store. You will gain a conceptual understanding of the different types of cache groups and the application scenarios that each cache group type is best suited. You will also learn the different types of operations that can be performed on cache groups to keep the TimesTen data store and Oracle database synchronized with each other. You will gain practical experience with the Web-based Cache Connect to Oracle Administrator which allows you to define and create cache groups using a graphical user interface tool. The lesson topics are reinforced with structured hands-on practices.

Topics covered:

• Introduction and Course Overview
• Cache Connect to Oracle Product Overview
• Configuring a Cache Connect to Oracle System
• System-Managed Cache Groups
• User-Managed Cache Groups
• Cache Connect to Oracle Administrator

Objectives:
Upon completion of this course, student should be able to:

• Configure a Cache Connect to Oracle system
• Describe how the different cache group types can be used in various applications
• Define and create cache groups using SQL statements
• Perform operations on cache groups to keep the TimesTen data store and Oracle database synchronized with each other
• Describe the role of the cache agent process and learn to start and stop the process
• Pass SQL statements from the TimesTen data store to the Oracle database for execution
• Use the Cache Connect to Oracle Administrator to define and create cache groups

Target Audience:

• Database Designers
• Database Administrators
• Developer
• Sales Consultants
• Support Engineer
• Technical Administrator
• Technical Consultant

Prerequisites:

• UNIX or Microsoft Windows operating system commands and concepts
• Oracle database administration and SQL
• Oracle TimesTen 6.0: Core Concepts and Administration