Аннотация:

The Oracle TimesTen In-Memory Database for Exalytics course teaches the core functionality of Oracle TimesTen In-Memory Database with emphasis on how to best use TimesTen with Oracle BIEE in the Exalytics In-Memory Machine environment. This course covers the key areas of the product that are applicable to Exalytics.

Слушатели изучат:

• Use TimesTen core functionality for performance.
• Understand installation, database sizing, operating system (OS) and database attributes that are relevant to TimesTen performance.
• Configure and set up TimesTen for optimal performance and operational efficiency.
• Make use of TimesTen native data types for optimal in-memory storage.
• Use columnar compression to further reduce memory requirements.
• Tune SQL Queries for fast query performance.
• Use tools and best practices for data loading from the data warehouse to TimesTen.
• Understand TimesTen system statistics and monitor using TimesTen Plug-in for Enterprise Manager.
• Troubleshoot common configuration and setup mistakes.

Преимущества:

This course will benefit you as it clearly demonstrates the use of Oracle TimesTen In-Memory Database, with specific emphasis on the extensive benefits of using TimesTen in the Exalytics environment. You'll gain valuable insight into how TimesTen works, along with the best practices for achieving optimal query performance.

Темы курса:

• Introduction and Course Overview
• Overview of Oracle TimesTen In-Memory Database for Exalytics
• Getting Started with TimesTen
• Understanding TimesTen Persistence and Recovery
• Sizing Your TimesTen Database
• Loading Data into Your TimesTen Database
• Importing Tables from an Oracle Database
• Analyzing and Tuning SQL Queries
• Client Tools and OBIEE Connectivity
• Operating System Settings for TimesTen Database
• Monitoring Your TimesTen Databases
• TimesTen Utilities and Built-in Procedures
• Upgrading Your TimesTen Installation
• Best Practices for TimesTen in Exalytics
• Troubleshooting Your TimesTen Database

Цели курса:

• Understand the Oracle TimesTen In-Memory Database core architecture and functionality
• Configure and administer TimesTen databases
• Understand the key concepts when using TimesTen in the Exalytics environment
• Understand TimesTen persistence and recovery
• Understand TimesTen database sizing and database loading
• Run TimesTen tools to load data from the data warehouse to TimesTen
• Understand performance tuning concepts such as data type mapping for optimal storage and in-memory columnar compression
• Understand how to tune SQL queries and define proper indexes for optimal query performance
• Use monitoring tools to monitor TimesTen databases
• Use the TimesTen data management utilities
• Identify TimesTen best practices for optimal usage and functioning of TimesTen databases
• Examine troubleshooting techniques

Рекомендованные курсы:

• Oracle Database 12c: Introduction for Experienced SQL Users

This Oracle Database 12c: Introduction for Experienced SQL Users training teaches you about Oracle Database 12c. Explore the database environment and the Oracle SQL Developer tool.

• Oracle Database 12c: Analytic SQL for Data Warehousing

This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to use Analytic SQL to aggregate, analyze, report and model data. Interact with expert Oracle University instructors.

• Oracle Database 12c: Advanced PL/SQL

ThisOracle Database 12c: Advanced PL/SQL training teaches you how to use the advanced features of PL/SQL. Learn how to efficiently design and tune PL/SQL to interface with the database and integrate with the other applications.