Oracle

Introduction to Oracle Audit Vault Installing the Oracle Audit Vault Server Installing the Oracle Audit Vault Collection Agent Configuring Oracle Audit Vault Managing Audit Settings Configuring for Alerts and Reports Using Oracle Audit Vault Reports Configuring Alerts Securing Oracle Audit Vault Managing Your Oracle Audit Vault Configuration Managing the Oracle Audit Vault Data Warehouse

Introduction Using Recovery Manager (RMAN) and Enterprise Manager Configuring for Recoverability Using the RMAN Recovery Catalog Backup Concepts and Strategies Creating Backups Restore and Recovery Concepts Using Data Recovery Advisor Performing Recovery Using Flashback Technologies Flashback Database RMAN Performance and Tuning Backup and Recovery Workshop Scenarios

Oracle Grid Infrastructure Concepts racle Clusterware Architecture Grid Infrastructure Pre-installation Tasks Grid Infrastructure Installation Adding and Removing Cluster Nodes Administering Oracle Clusterware Upgrading and Patching Grid Infrastructure Troubleshooting Oracle Clusterware Making Applications Highly Available with Oracle Clusterware ASM: Overview Administering ASM Administering ASM Disk Groups Administering ASM Files, Directories, and Templates Administering ASM Cluster File Systems RAC Concepts Installing and Configuring Oracle RAC racle RAC Administration Managing Backup and Recovery for RAC RAC Database Monitoring and Tuning racle RAC One Node Quality of Service Management Design for High Availability

Grid Infrastructure Concepts Grid Infrastructure Installation and Configuration Administering Oracle Clusterware Managing Oracle Clusterware racle Clusterware High Availability Troubleshooting Oracle Clusterware Administering ASM Instances Administering ASM Disk Groups ASM Files, Directories, and Templates Administering ASM Cluster File Systems Real Application Clusters Database Installation racle RAC Administration Managing Backup and Recovery for RAC Monitoring and Tuning the RAC Database Services Design for High Availability

Oracle Grid Infrastructure Concepts racle Clusterware Architecture Grid Infrastructure Pre-installation Tasks Grid Infrastructure Installation Adding and Removing Cluster Nodes Administering Oracle Clusterware Upgrading and Patching Grid Infrastructure Troubleshooting Oracle Clusterware Making Applications Highly Available with Oracle Clusterware ASM: Overview Administering ASM Administering ASM Disk Groups Administering ASM Files, Directories, and Templates Administering ASM Cluster File Systems RAC Concepts Installing and Configuring Oracle RAC racle RAC Administration Managing Backup and Recovery for RAC RAC Database Monitoring and Tuning racle RAC One Node Quality of Service Management Design for High Availability

Introduction Introduction to PL/SQL Declare PL/SQL Identifiers Write Executable Statements Interaction with the Oracle Server Control Structures Composite Data Types Explicit Cursors Exception Handling Stored Procedures Stored Functions and Debugging Subprograms Packages Deploying Packages Implement Oracle-Supplied Packages in Application Development Dynamic SQL Design Considerations for PL/SQL Code Triggers Creating Compound, DDL, and Event Database Triggers PL/SQL Compiler Manage Dependencies

Data Warehouse Design Data Warehousing Schemas Partitioning Basics Extraction, Transportation, and Loading (Extraction and Transportation) ETL-Loading ETL-Transformation Parallelism Concepts Parallel Operations in Data Warehouses Materialized Views Dimensions Materialized Views Refresh Query Rewrite SQL Access Advisor Data Warehousing System Management

Exploring the Oracle Database Architecture Preparing the Database Environment Creating an Oracle Database Managing the Oracle Instance Configuring the Oracle Network Environment Managing Database Storage Structures Administering User Security Managing Schema Objects Managing Data and Concurrency Managing Undo Data Implementing Oracle Database Security Database Maintenance Performance Management Backup and Recovery Concepts Performing Database Backups Performing Database Recovery Moving Data Enhancing Database Capabilities

Database Architecture and ASM Configuring for Recoverability Using the RMAN Recovery Catalog Configuring Backup Specifications Creating Backups Performing User-Managed Backup and Recovery Using RMAN to Perform Recovery Using RMAN to Duplicate a Database Performing Tablespace Point-in-time Recovery Monitoring and Tuning RMAN Using Flashback Technology Using Flashback Database Diagnosing the Database Managing Memory Managing Database Performance Using the Segment Advisor Managing Resources Automating Tasks with the Scheduler Administering the Scheduler Globalization

Database Architecture and ASM Configuring for Recoverability Using the RMAN Recovery Catalog Configuring Backup Specifications Creating Backups Performing User-Managed Backup and Recovery Using RMAN to Perform Recovery Using RMAN to Duplicate a Database Performing Tablespace Point-in-time Recovery Monitoring and Tuning RMAN Using Flashback Technology Using Flashback Database Diagnosing the Database Managing Memory Managing Database Performance Using the Segment Advisor Managing Resources Automating Tasks with the Scheduler Administering the Scheduler Globalization

Introduction Using Recovery Manager (RMAN) and Enterprise Manager Configuring for Recoverability Using the RMAN Recovery Catalog Backup Concepts and Strategies Creating Backups Restore and Recovery Concepts Using Data Recovery Advisor Performing Recovery Using Flashback Technologies Flashback Database RMAN Performance and Tuning Backup and Recovery Workshop Scenarios

Introduction to Oracle Data Guard Creating a Physical Standby Database by Using SQL and RMAN Commands racle Data Guard Broker: Overview Creating a Data Guard Broker Configuration Creating a Physical Standby Database by Using Enterprise Manager Grid Control Creating a Logical Standby Database Creating and Managing a Snapshot Standby Database Using Oracle Active Data Guard Configuring Data Protection Modes Performing Role Transitions Using Flashback Database in a Data Guard Configuration Enabling Fast-Start Failover Managing Client Connectivity Performing Backup and Recovery Considerations in an Oracle Data Guard Configuration Patching and Upgrading Databases in a Data Guard Configuration Monitoring a Data Guard Configuration ptimizing a Data Guard Configuration

Introduction verviewing Data Mining Concepts Understanding the Data Mining Process Introducing Oracle Data Miner 11g Release 2 Using Classification Models Using Regression Models Performing Market Basket Analysis Using Clustering Models Performing Anomaly Detection Deploying Data Mining Results

Review of Linux Basics Preparing Linux for Oracle Installing Oracle on Linux Managing Storage on Linux Using Oracle ASM on Linux Automating Oracle on Linux ptimizing Linux for Oracle Additional Linux Tips for DBAs Troubleshooting Oracle Issues on Linux

Oracle Grid Infrastructure Installation and Upgrade Enhancements racle Restart ASM Enhancements Storage Enhancements Data Warehouse and Partitioning Enhancements racle SecureFiles Security and Networking Enhancements SQL Performance Analyzer SQL Plan Management Database Replay Automatic SQL Tuning Intelligent Infrastructure Enhancements Diagnosability Enhancements SQL Monitoring Performance Enhancements Application Maintenance and Upgrade Enhancements Backup and Recovery Enhancements Flashback Technology, LogMiner, and Data Pump Data Recovery Advisor

Examining the Role of Oracle OLAP within the Oracle BI / DW Platform Understanding the Dimensional Model Building OLAP Cubes Examining Cube-Organized Materialized Views (Cube MVs) Creating Calculated Measures Using SQL to Query Oracle OLAP Cubes Enhancing Analytic Content Using Ad Hoc Query and Reporting Tools Against OLAP Data Implementing Cube Security Designing Cubes for Performance and Scalability Examining Performance Tuning

Introduction Monitoring With Basic Tools Using Automatic Workload Repository Identifying the Problem Identifying Problem SQL Statements Influencing the Optimizer SQL Plan Management Change Management Server-Generated Alerts Using Metrics and Alerts Using AWR Based Tools Monitoring an Application (Using Services) Baselines Tuning the Shared Pool Tuning the Buffer Cache Tuning PGA and Temporary Space Automatic Memory Management Tuning Block Space Usage Tuning I/O Performance Tuning: Summary Using Statspack

Real Application Clusters Database Installation racle RAC Administration Managing Backup and Recovery for RAC Monitoring and Tuning the RAC Database Services Design for High Availability

Introduction to Database Security Choosing Security Solutions Basic Database Security Auditing Database Users, Privileges, and Objects Auditing DML Statements Using Basic User Authentication Using Strong Authentication Using Enterprise User Security Using Proxy Authentication Using Privileges and Roles Access Control Implementing Virtual Private Database racle Label Security Concepts Implementing Oracle Label Security Using the Data Masking Pack Encryption Concepts Using Application-Based Encryption Applying Transparent Data Encryption Applying File Encryption racle Net Services: Security Checklists Securing the Listener

Oracle Database 12c Release 1 (12.1.0.2) racle ASM Overview racle ASM Instance Administration Flex ASM Administering ASM Disk Groups Administering ASM Files, Directories, and Templates Administering Oracle Cloud File System

Use Oracle Restart to manage components Upgrade database to Oracle Database 12c Install Oracle Grid Infrastructure for a Standalone Server Create a container database Create an Oracle Database Install Oracle Database 12c software Monitor the Database Manage Database Performance Implement Database Auditing Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks Schedule Jobs to Run Inside or Outside of the Database Configure Oracle Net Services Configure your Database For Backup and Recovery Operations Describe Oracle Database Architecture Manage the Oracle Database Instance Manage Oracle Database Storage structures

Monitor the Database Manage Database Performance Implement Database Auditing Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks Schedule Jobs to Run Inside or Outside of the Database Configure Oracle Net Services Configure your Database For Backup and Recovery Operations Describe Oracle Database Architecture Manage the Oracle Database Instance Manage Oracle Database Storage structures Create and Administer User Accounts

Monitor the Database Manage Database Performance Implement Database Auditing Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks Schedule Jobs to Run Inside or Outside of the Database Configure Oracle Net Services Configure your Database For Backup and Recovery Operations Describe Oracle Database Architecture Manage the Oracle Database Instance Manage Oracle Database Storage structures Create and Administer User Accounts

Design PL/SQL packages and program units that execute efficiently Write code to interface with external applications and the operating system Create PL/SQL applications that use collections Write and tune PL/SQL code effectively to maximize performance Implement a virtual private database with fine-grained access control Write code to interface with large objects and use SecureFile LOBs

Introduction Course Objectives, Course Agenda and Class Account Information Describe the Schemas and Appendices used in the Lesson verview of SQL*Plus Environment verview of SQL Developer verview of Analytic SQL racle Database SQL and Data Warehousing Documentation Grouping and Aggregating Data Using SQL Generating Reports by Grouping Related Data Review of Group Functions Reviewing GROUP BY and HAVING Clause Using the ROLLUP and CUBE Operators Using the GROUPING Function Working with GROUPING SET Operators and Composite Columns Using Concatenated Groupings with Example Hierarchical Retrieval Using Hierarchical Queries Sample Data from the EMPLOYEES Table Natural Tree Structure Hierarchical Queries: Syntax Walking the Tree: Specifying the Starting Point Walking the Tree: Specifying the Direction of the Query Using the WITH Clause Hierarchical Query Example: Using the CONNECT BY Clause Working with Regular Expressions Introducing Regular Expressions Using the Regular Expressions Functions and Conditions in SQL and PL/SQL Introducing Metacharacters Using Metacharacters with Regular Expressions Regular Expressions Functions and Conditions: Syntax Performing a Basic Search Using the REGEXP_LIKE Condition Finding Patterns Using the REGEXP_INSTR Function Extracting Substrings Using the REGEXP_SUBSTR Function Analyzing and Reporting Data Using SQL verview of SQL for Analysis and Reporting Functions Using Analytic Functions Using the Ranking Functions Using Reporting Functions Performing Pivoting and Unpivoting Operations Performing Pivoting Operations Using the PIVOT and UNPIVOT Clauses Pivoting on the QUARTER Column: Conceptual Example Performing Unpivoting Operations Using the UNPIVOT Clause Columns in an UNPIVOT Operation Creating a New Pivot Table: Example Pattern Matching using SQL Copyright © 2013, Oracle. All rights reserved. Page 3 Row Pattern Navigation Operations Handling Empty Matches or Unmatched Rows Excluding Portions of the Pattern from the Output Expressing All Permutations Rules and Restrictions in Pattern Matching Examples of Pattern Matching Modeling Data Using SQL Using the MODEL clause Demonstrating Cell and Range References Using the CV Function Using FOR Construct with IN List Operator, incremental values and Subqueries Using Analytic Functions in the SQL MODEL Clause Distinguishing Missing Cells from NULLs Using the UPDATE, UPSERT and UPSERT ALL Options Reference Models racle Business Intelligence Cloud Service Overview racle BI Cloud Service Introducing Oracle Business Intelligence Cloud Service Guidance Through Exploratory Analysis & Deep Discovery through Rich Feature Set BICS Can Integrate Any Data Source Quickly BICS Makes Any Time The Right Time For New Insights Speed, Flexibility and Economy of Cloud Immediate Access to New Functionality Enterprise-Grade Service Reliability Copyright

Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure. Describe the Oracle Database architecture components related to backup and recovery operations. Plan effective backup and recovery procedures. Configure the database for recoverability. Use Recovery Manager (RMAN) to create backups and perform recovery operations. Use the Data Recovery Advisor to diagnose and repair failures. Use Oracle Flashback Technologies to recover from human error. Perform an encrypted database backup and restore. Perform tablespace point-in-time recovery. Describe additional high availability features such as Oracle Data Guard.

Use Data Guard to achieve a highly available Oracle database Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups Create and manage physical and logical standby databases Use Enterprise Manager Cloud Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration

Introduction Flex Clusters Policy-Based Cluster Management What-If Command Evaluation ther Clusterware New Features Flex ASM ther ASM New Features Cloud FS New Features Application Continuity RAC New Features Data Guard New Features Global Data Services

Create, manage and monitor multitenant container databases and pluggable databases and their resources consumption with Resource Manager Manage datafile online operations, heat map and automatic data optimization, archive data using Row-archival or Temporal Validity and Temporal History Manage security by using the new unified auditing, the new privileges, such as SYSBACKUP, the privilege analysis, and by creating and managing Data Redaction policies Use the Recovery Manager enhancements Manage the database performance with monitoring DB operations, Real-Time ADDM and Compare Period ADDM Understand the new in-memory capabilities of the Database In-Memory, Full Database In-Memory Caching, and Automatic Big Table Caching Tune the SQL performance using Adaptive Execution Plans, SQL Plan Directives and statistics enhancements Explore new Oracle Data Pump features and SQL*Loader Express Mode Use online operations during partition movement and compression, and other DDL operations Use partial global partitioned indexes Explain JSON support by Oracle database store and query JSON data Explain new SQL enhancements such as extended data type column and SQL row limiting clause

Diagnose and tune common Instance related performance problems Use Enterprise Manager performance-related pages to monitor an Oracle database Use the Oracle Database tuning methodology Utilize database advisors to proactively tune an Oracle Database Instance Use the tools based on the Automatic Workload Repository to tune the database Diagnose and tune common SQL related performance problems

Configure and use Policy-Based Cluster Management in conjunction with Policy-Managed Database and Oracle Multitenant Architecture Migrate from a standard cluster to a Flex Cluster and configure highly available application resources on Flex Cluster Leaf Nodes Implement Oracle Database In-Memory on an existing Oracle RAC database Configure an Oracle RAC database to use Application Continuity Configure and use Global Data Services in conjunction with Oracle RAC and Data Guard Upgrade an existing database to use Oracle ASM Filter Driver Migrate from standard ASM to Flex ASM and examine the effect of using Flex ASM Perform a database rolling upgrade, from Oracle Database 11gR2 to Oracle Database 12c, using a transient logical standby database

Analyze any security risks of their organization Find appropriate Oracle solutions to meet the security, privacy and compliance requirements of their organization Find solutions to secure database access through the network Configure appropriate authentication for the database or enterprise users in the organization Control data access and integrity in their organization using the appropriate feature or option or product like privileges or Oracle Label Security Ensure data confidentiality using an encryption solution like Transparent Data Encryption, or Data Redaction or Oracle Data Masking Audit user actions using any of the auditing features like unified auditing

Oracle Database 19c: Administration Workshop

Oracle Database 19c: Backup and Recovery

Oracle Database 19c: Data Guard Administration Workshop

Oracle Database 19c: Fundamentals for Devs and SysAdmins

Oracle Database 19c: New Features for Administrators Ed 1

Oracle Database 19c: Performance Management and Tuning

Oracle Database 19c: PL/SQL Workshop

Oracle Database 19c: RAC Administration Workshop

Oracle Database 19c: SQL Tuning Workshop

Oracle Database 19c: SQL Workshop

Introduction Working with Oracle Cloud Exadata Express Cloud Service Retrieving Data using the SQL SELECT Statement Restricting and Sorting Data Using Single-Row Functions to Customize Output Using Conversion Functions and Conditional Expressions Reporting Aggregated Data Using the Group Functions Displaying Data from Multiple Tables Using Joins Using Subqueries to Solve Queries Using the SET Operators Managing Tables using DML statements Introduction to Data Definition Language Introduction to Data Dictionary Views Creating Sequences, Synonyms, Indexes Creating Views Managing Schema Objects Retrieving Data by Using Subqueries Manipulating Data by Using Subqueries Controlling User Access Manipulating Data Managing Data in Different Time Zones

Oracle Database: SQL and PL/SQL Fundamentals Ed

Introduction Workshops, Demo Scripts, and Code Example Scripts SQL Environments Available in the Course Course Objectives, Course Agenda and Appendixes Used in this Course Sample Schemas Used in the Course Class Account Information Appendices in the Course Audience and Prerequisites Introduction to SQL Tuning SQLTXPLAIN (SQLT) Diagnostic Tool Development Environments: Overview SQL Tuning Session SQL Tuning Strategies Using Application Tracing Tools Using the SQL Trace Facility: Overview The trcsess Utility Formatting SQL Trace Files: Overview Available Tracing Tools: Overview Steps Needed Before Tracing Understanding Basic Tuning Techniques Developing Efficient SQL statement Index Usage Data Type Mismatch Table Design Scripts Used in This Lesson Transformed Index Tune the ORDER BY Clause NULL usage ptimizer Fundamentals Why Do You Need an Optimizer? Query Transformer SQL Statement Processing ptimizer Features and Oracle Database Releases Cost-Based Optimizer SQL Statement Representation Components of the Optimizer Adaptive Query Optimization Generating and Displaying Execution Plans DBML_SQL_MONITOR V$SQL_PLAN View AUTOTRACE The EXPLAIN PLAN Command Plan Table Execution Plan? SQL Monitoring Automatic Workload Repository Interpreting Execution Plans and Enhancements ptimizer: Table and Index Access Paths Full Table Scan Common Observations Row Source Operations Indexes Adaptive Optimizations Main Structures and Access Paths Interpreting a Serial Execution Plan ptimizer Join Operations Join Methods Join Types ther Optimizer Operators SQL operators Result Cache operators ther N-Array Operations Introduction to Optimizer Statistics Concepts Gather and Manage Optimizer Statistics: Overview ptimizer Statistics Types of Optimizer Statistics Using Bind Variables Cursor Sharing and Bind Variables Cursor Sharing and Different Literal Values SQL Plan Management Maintaining SQL Performance SQL Plan Management

Oracle Enterprise Manager Cloud Control 12c: Cloud Mgmt Workshop

Running a Forms Application Working in the Forms Builder Environment Creating a Basic Form Module Creating a Master-Detail Form Working Data Blocks and Frames Working with Text Items Creating LOVs and Editors Creating Additional Input Items Creating Noninput Items Creating Windows and Content Canvases Working with Other Canvas Types Producing and Debugging Triggers Adding Functionality to Items Displaying Run-Time Messages and Alerts Using Query Triggers Validating User Input Controlling Navigation Overriding or Supplementing Transaction Processing Writing Flexible Code Sharing Objects and Code Using WebUtil to Interact with the Client Introducing Multiple Form Applications

Gathering Evidence Acquiring confidence using the standard Oracle GoldenGate tools normally used to interact with the software: GGSCI Error Logs, Process Reports, Discard File, System Logs Competently using the tools mentioned above to gather evidence about alleged issues occurring to an Oracle GoldenGate environment racle GoldenGate Troubleshooting Tools Accessing knowledge Documents - Mailing lists, Oracle GoldenGate forums, etc. Consulting the Documentation Getting familiar with the ShowSyntax parameter Getting familiar with the logdump utility Basic and Startup Problems Getting familiar with basic problems Developing the ability to deal with Extract and Replicat startup issues Verifying file names, file permissions, consistency between Extract and Replicat group names and their supporting files Verifying consistent naming convention when defining trail files and their reference in the Extract/Replicat parameter files Verifying that the correct software version has been installed Verifying that the Oracle GoldenGate manager is running, that the group name which fails to start exists and is not misspelt Verifying that the the parameter file exists, has the same name as the Extract/Replicat group, and is accessible by Oracle GoldenGate Introducing the use of CHECKPARAMS to verify that the parameter syntax is correct Data Extraction Problems Developing the ability to deal with and troubleshoot data extraction issues:Extract is slow - Extract abends - Data pump abends Analyzing various causes of a slow Extract startup Copyright © 2013, Oracle. All rights reserved. Page 2 Tracing may be enabled, activity logging may be enabled, many columns listed in tables being replicated Introducing the use of the CacheMgr parameter to control the virtual memory and temporary disk space that are available for caching In-depth analysis of abending Extracts: is Extract unable to open the transaction logs? - Checking to see if the disk is full -Is an archive In-depth analysis of abending data pumps: Does the data pump abend with error number 509 ("Incompatible record")?Have the Was the primary Extract or the data pump stopped, re-added, or restarted without resetting the data pump?s read position in the Data Replication Problems Developing the ability to deal with and troubleshoot data replication issues: Analyzing the various causes of a "stuck" Replicat: Does "Stats Replicat" return no statistics? Do successive "Info Replicat" commands Verifying that the Replicat is reading the trail to which Extract is writing Analyzing the reasons why a Replicat abends: Is Replicat unable to locate a trail? Is Replicat unable to open a trail file? Was "Add Missed Transactions Developing the ability to deal with and troubleshoot missed transactions involving issues such as: Tables that are not properly specified Analyzing the reasons why transactions are not being processed: Were the tables included in Table and Map statements? Are fully 'Single quotes' on object names imply case-sensitive names for some databases (including the Oracle database) Are the transactions coming out of the source system properly? Mapping and Synchronization Problems Developing the ability to deal with and troubleshoot mapping problems, such us: Fetching from the source data fails - Table and Analyzing the causes of various mapping problems:Is Extract returning fetch-related errors? Was the row containing the data deleted? Has the undo retention expired? Is "NoUseLatestVersion" for "FetchOptions" being used? Do the source and target tables exist in the databases? Are they specified correctly in the Table or Map statement? Are their names Do table and column names contain only supported characters? Are WHERE clauses comparing different data types? Is KeyCols being used? Are both source and target KeyCols being used? Corresponding source and target columns must match. SQLEXEC, File-Maintenance, and Other Problems Developing the ability to deal with and troubleshoot : SQLEXEC problems - File-maintenance problems - Time differences - Too many open cursors File-Maintenance Problems: Discard File Is Not Created - Discard File Is Too Big - Trail File Is Too Big Miscellaneous Problems: Time Differences - INFO Command Shows Incorrect Status "Classic" Performance Tuning Identifying causes of slow startups Monitoring lag and statistics Tuning Manager Identifying network and disk bottlenecks Tuning "Classic" Extract Tuning "Classic" Replicat "Integrated" Performance Tuning Describing architecture and advantages of the new Integrated capture Describing architecture and advantages of the new Integrated delivery Familiarizing with the new V$ tables holding real time Oracle GoldenGate statistics "Integrated" Capture and Delivery Troubleshooting Familiarizing with Troubleshooting Aids and Tools for Integrated Replication Describing Oracle GoldenGate Healthcheck for Integrated Replicat Describing the Oracle Database 12c GoldenGate AWR report Copyright © 2013, Oracle. All rights reserved. Page 3

Oracle GoldenGate 19c: Fundamentals for Oracle

Grid Infrastructure Concepts Grid Infrastructure Installation and Configuration Administering Oracle Clusterware Managing Oracle Clusterware racle Clusterware High Availability Troubleshooting Oracle Clusterware Administering ASM Instances Administering ASM Disk Groups ASM Files, Directories, and Templates Administering ASM Cluster File Systems

Introduction to Oracle Audit Vault Installing the Oracle Audit Vault Server Installing the Oracle Audit Vault Collection Agent Configuring Oracle Audit Vault Managing Audit Settings Configuring for Alerts and Reports Using Oracle Audit Vault Reports Configuring Alerts Securing Oracle Audit Vault Managing Your Oracle Audit Vault Configuration Managing the Oracle Audit Vault Data Warehouse

Course Introduction racle NoSQL Database: Overview Planning An Installation Installing and Configuring Nodes Configuring and Deploying A KVStore Modifying a KVStore Securing the Configuration Troubleshooting Oracle NoSQL Database Installation Issues Fixing Hardware Failures Setting Store Parameters ptimizing KVStore Performance General Monitoring Backup and Recovery Managing AVRO Schema Upgrading the Software

Course Introduction Big Data and NoSQL Overview racle NoSQL Database: Overview Schema Design Application Specific Requirements Creating Tables Writing Data To Tables Retrieving Table Data Manipulating Data Stored in Key-Value Model Configuring Consistency Configuring Durability Creating Transactions Handling Large Objects Accessing a Secure Store Handling Exceptions

Introduction verview of Oracle Spatial Concepts Creating Spatial Layers Defining Collection Geometries Associating Spatial Layers with Coordinate Systems Loading Spatial Data Validating and Debugging Geometries Using the Oracle Application Server MapViewer Indexing Spatial Data Querying Spatial Data Using SDO_WITHIN_DISTANCE, SDO_NN, and SDO_JOIN Operators Analyzing Geometries by Using Spatial Operators and Functions Using Spatial Analysis, MBR, Utility, and Aggregate Functions Defining Maps by Using the Map Builder Tool Leveraging Oracle Maps: The Map Cache and JavaScript API Creating a User-Defined Coordinate System Implementing a Linear Referencing System Managing Spatial Indexes Geocoding Address Data Using the Spatial Routing Engine

Understand Oracle Clusterware architecture Describe how Grid Plug and Play affects Clusterware Describe Automatic Storage Management (ASM) architecture Perform Grid Infrastructure installation and create RAC database Demonstrate Clusterware management proficiency Manage application resources Troubleshoot Oracle Clusterware Administer ASM Instances and disk groups Administer ASM Cluster File Systems Install Oracle Database 11gR2 software and create RAC database Manage RAC databases Manage backup and recovery for RAC Determine RAC-specific tuning components Configure and manage services in a RAC environment Describe high availability architectures

Introduction Retrieve Data using the SQL SELECT Statement Restricted and Sorted Data Usage of Single-Row Functions to Customize Output Conversion Functions and Conditional Expressions Aggregated Data Using the Group Functions Display Data From Multiple Tables Usage of Subqueries to Solve Queries SET Operators Data Manipulation DDL Statements to Create and Manage Tables ther Schema Objects Introduction to PL/SQL PL/SQL Identifiers Write Executable Statements Interaction with the Oracle Server Control Structures Usage of Composite Data Types Explicit Cursors Exception Handling Stored Procedures and Functions