Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 14-12-2016
Search Course Here




Live Chat
Support
Oracle TimesTen and In-Memory Database Online Training

Oracle TimesTen and In-Memory Database

overview

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).
prerequisties
  • Oracle database administration
  • Relational database concepts and SQL
  • UNIX or Microsoft Windows operating system commands and concepts
Duration
Online
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 20% theory, 80% Hands-on.

Corporate
  • It is a 3 days program and extends up to 8hrs each.
  • The format is 20% theory, 80% Hands-on.
Classroom
    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
Videos

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

Flash News


AngularJS New Batch Start From 09th DEC & 10th DEC.


Hadoop Dev New Batch Start From 10th DEC & 11th DEC.


IBM COGNOS TM New Batch Start From 11th DEC & 12th DEC.


Informatica Dev New Batch Start From 12th DEC & 13th DEC.


Mean Stack New Batch Start 13th DEC & 14th DEC.

SAP BODS new Batch Starting From 14th DEC & 15th DEC.

SAP S/4 HANA New Batch Start From 15th DEC & 16th DEC
.

Tableau New Batch Start From 16th DEC & 17th DEC

PUBLIC DEMO


(1) Workday Technical Demo Training

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

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings