Mail :
India : +91-8143-111-555
USA : +1-703-445-4802
uk : +44-20-3287-2021
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Monday... 13-11-2017
Search Course Here

Live Chat
Oracle TimesTen and In-Memory Database Online Training

Oracle TimesTen and In-Memory Database


Oracle TimesTen In-Memory Database (TimesTen) is a full-featured, memory-optimized, relational database with persistence and recoverability. It provides applications with the instant responsiveness and very high throughput required by database-intensive applications. Deployed in the application tier, TimesTen operates on databases that fit entirely in physical memory (RAM).
  • Oracle database administration
  • Relational database concepts and SQL
  • UNIX or Microsoft Windows operating system commands and concepts
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 20% theory, 80% Hands-on.

  • It is a 3 days program and extends up to 8hrs each.
  • The format is 20% theory, 80% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Introduction and Course Overview
    • Describe course objectives
    • Intended audience and course prerequisites
  • Overview of Oracle TimesTen In-Memory Database
    • List the features of Oracle TimesTen In-Memory Database
    • List the features of Oracle In-Memory Database Cache
  • Getting Started with TimesTen In-Memory Database
    • Access TimesTen Quick Start and the documentation library
    • Describe the concept of an instance and the instance administrator user associated with installing TimesTen
    • Create a data source name and set its attributes
    • Use the ttIsql command-line interface utility and the Oracle SQL Developer graphical user interface tool to create or connect to a TimesTen database
  • Creating and Accessing TimesTen Database Elements
    • Execute SQL data definition language statements to create TimesTen supported database elements
    • Explain the concept of access control, and define users and assign privileges
    • List and describe the different types of TimesTen indexes
    • Execute SQL data manipulation language statements to access tables, sequences, views and synonyms
    • Create and execute PL/SQL functions, stored procedures and packages
  • Managing TimesTen Databases
    • Use the various utilities to import and export data into and out of a TimesTen database's table, and backup and restore a database
    • Use the ttSize utility to estimate the size of a table
    • Use the ttStatus utility to display connections on TimesTen databases
    • Call the TimesTen built-in procedures
    • Configure a database RAM policy
    • Modify the size of a TimesTen database
  • Concurrency Control and Performance Tuning
    • Explain how transactions are started and completed
    • Explain how isolation levels coordinate concurrent transactions on a TimesTen database
    • Use the ttXactAdmin utility to view locks requested and acquired by active transactions
    • Prepare and execute statements including parameterized statements
    • Update column and table statistics used by the query optimizer to generate an optimal execution plan
    • Create indexes to improve query performance
    • Display a query execution plan
  • Configuring TimesTen Client/Server Connections
    • Describe the TimesTen client/server architecture
    • Configure a client/server environment
    • Access a TimesTen database with a client/server connection
    • Configure the TimesTen Server to run in multithreaded mode
    • Use the ttStatus utility to display information about the server process and connections from client applications
  • Overview of Oracle In-Memory Database Cache
    • List and describe features of Oracle In-Memory Database Cache
    • Describe various usages of Oracle In-Memory Database Cache
  • Getting Started with Oracle In-Memory Database Cache
    • Configure the Oracle and TimesTen databases to cache Oracle data in the TimesTen database
    • Describe the contents and benefits of a cache grid
    • Describe the role of the cache agent and start the agent process
  • Creating Cache Groups
    • Create read-only and writethrough cache groups
    • Describe the automatic refresh operation
    • Passthrough statements from TimesTen to Oracle for execution
    • Manually load and refresh a cache group
    • Create a dynamic cache group and perform dynamic load operations
    • Configure an automatic data aging policy on a cache group
    • Create a global cache group and understand how data is shared between cache grid members
  • Other Cache Group Operations and Topics
    • Create a cache group with multiple tables
    • Create user-managed cache groups
    • Flush a user-managed cache group
    • Use SQL Developer to perform cache group operations
  • Overview of TimesTen to TimesTen Replication
    • Describe the benefits of TimesTen to TimesTen replication
    • Describe the active standby pair replication configuration
    • Describe the basic architecture of TimesTen replication
    • Describe the differences between asynchronous and synchronous replication
  • Configuring Replication of TimesTen Databases
    • Create an active standby pair replication scheme
    • Create a return two-safe synchronous replication scheme
    • Configure replication of cache tables
    • Start the replication agent process and describe its role
    • Configure replication on a system with multiple network interface cards
  • Database Recovery and Monitoring Replication
    • List and describe the different replication states
    • Configure a transaction log file threshold
    • Recover a replicated database after a failure
    • Use various utility commands and built-in procedures to monitor replication
  • Using Oracle Clusterware with TimesTen to Provide a High Availability Solution
    • Describe the benefits of using Oracle Clusterware with TimesTen
    • Describe the two different levels of availability that Oracle Clusterware can be implemented for TimesTen
    • Configure a cluster for a TimesTen active standby pair
    • Create a configuration to implement application failover
    • Describe how to recover from failure of one or both master database nodes

Oracle TimesTen and In-Memory Database Videos will be updated soon
To watch more Videos Click Here

Flash News

AngularJS New Batch Starting From 14th NOV & 15th NOV.

Hadoop Dev New Batch Starting From 15th NOV & 16th NOV.

IBM COGNOS TM New Batch Starting From 16th NOV & 17th NOV.

Informatica Dev New Batch Starting From 17th NOV & 18th NOV.

Mean Stack New Batch Starting From 18th NOV & 19th NOV.

SAP BODS new Batch Starting From 19th NOV & 20th NOV.

SAP S/4 HANA New Batch Starting From 20th NOV & 21st NOV

Tableau New Batch Starting From 21st NOV & 22nd NOV


(1) Workday Technical Demo Training

Demo Schedule : 09:30 P.M EST / 08:30 P.M CST / 6:30 P.M PST on 13th NOV & 07:00 A.M IST on 14th NOV

Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :