Take the first step towards success as an Oracle TimesTen professional by taking this comprehensive course on the Oracle TimesTen In-Memory Database base product. In this class, you will learn about the architecture, and also how to install and administer a TimesTen data store.
Gain a conceptual understanding of the TimesTen In-Memory Database architecture and how its components work and interact with one another. Learn how to create an operational data store and properly manage the various elements in an effective and efficient manner including performance tuning, user and privilege management, and connection configuration modes. A combination of lecture and hands-on lab exercises ensure that students will acquire the skills and knowledge to become productive using TimesTen.
Topics covered:
- Introduction and Course Overview
- TimesTen Product Overview
- TimesTen System Architecture
- Installing TimesTen
- Creating Data Source Names and Data Stores
- Creating Data Store Elements
- Accessing Data Store Elements
- Managing Data Stores
- Transactions and Concurrency Control
- Performance Tuning and Query Optimization
- Configuring TimesTen Client/Server
- Troubleshooting TimesTen
Objectives:
Upon completion of this course, student should be able to:
- Describe the TimesTen products and the In-Memory Database architecture
- Install the TimesTen software and configure a data source name
- Create and access TimesTen data store elements
- Perform backup and restore of a data store
- Tune the performance of data store operations
- Configure direct and client/server data store connections
- Monitor and troubleshoot a data store
Target Audience:
- Application Developers
- Database Administrators
- Database Designers
- Developer
- Java Developer
- Sales Consultants
- Support Engineer
- Technical Consultant
Prerequisites:
Attendees should be familiar with UNIX or Microsoft Windows operating system commands and concepts, as well as Relational database concepts and SQL.
