Oracle

The Oracle Database 12c R2: New Features for 12c R1 Administrators course is designed for existing 12c Release 1 DBAs. In addition to covering the New Features of R2, this course also introduces students to the Oracle Database Cloud Service. Learn To: Create and manage application containers and applications in multitenant container databases. Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles and new memory directives. Perform pluggable database flashback. Upgrade the multitenant container databases and pluggable databases. Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection and Transparent Data Encryption. Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements, and by performing enhanced online operations. Increase the SQL performance by using the In-Memory Column-Store enhancements at deployment and SQL performance. Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing. Monitor your databases by using DB operations enhancements. Benefit from enhancements in partitioning methods. Benefit from ADR automatic space file management. Use the Trace File Analyzer collector to diagnose issues. Use the new SQL*Plus history commands and SQL enhancements such as long identifiers. Use the new SQLcl utility to benefit from commands and features missing from SQL*Plus itself. Describe the Oracle Public Cloud services related to databases management.

In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations. Learn To: Develop appropriate backup and recovery procedures to address your business needs. Implement backup and recovery settings and perform backup operations to disk and tape. Employ Oracle Database recovery procedures to recover from media and other failures. Diagnose and repair data failures. Use Flashback Technologies and data duplication to complement backup and recovery procedures. Secure the availability of your database by appropriate backup and recovery strategies.

This Oracle Database 12c: Data Guard Administration Ed 1 training teaches you how to use Oracle Data Guard. Expert Oracle University instructors will demonstrate how this solution protects your Oracle database against planned and unplanned downtimes. In this course, you will be introduced to Oracle Database Exadata Cloud Service. Learn To: Build highly available systems. Offload business processing needs to another system. Offload backup needs to another system. Gain an understanding of Oracle Database Exadata Cloud Service.

This Oracle Database 12c: Clusterware & RAC Admin Accelerated training covers 8 days worth of content in only 5 days. It starts with the Oracle Database 12c: Clusterware Administration course (4 days) and then covers the Oracle RAC database architecture (4 days); learn how these products work together. In this course, you will be introduced to Oracle Database Exadata Cloud Service. Learn To: Perform Grid Infrastructure pre-installation tasks. Install both Standard and Flex clusters. Add and remove nodes from a cluster in addition to upgrading and patching existing Grid Homes. Manage and administer both Standard Clusters and Policy-Managed Clusters. Use Oracle Clusterware to make applications highly available. Install Oracle RAC software. Create cluster databases. Administer both administrator and policy-managed Oracle RAC databases. Monitor and address performance issues. Learn about services in a RAC environment as well as highly available connection features including Application Continuity and Transaction Guard. Create and administer a RAC One Node Database. Create and manage multi tenant RAC databases. Gain an understanding of the Oracle Database Exadata Cloud Service.

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 2 course constituted by five modules; the Securing Data module, the Making Data Available module, the Partitioning Data module, the Managing Information Lifecycle module and the Monitoring DB Operations and Managing Performance module, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration like Unified Auditing, Transparent Data Encryption (TDE) and other areas of security, Recovery Manager, online operations, Oracle Data Pump, SQL*Loader, new partitioning methods, Automatic Data Optimization, In-Memory Column Store, Full Database In-Memory Caching, and Automatic Big Table Caching. Learn To: Gain an understanding of the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as security, availability, partitioning, performance, and Information Lifecycle Management (ILM).

This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. In this course, you will be introduced to Oracle Database Exadata Cloud Service. Learn To: Install Oracle RAC software. Create cluster databases. Administer both administrator and policy-managed Oracle RAC databases. Monitor and address performance issues. Learn about services in a RAC environment as well as highly available connection features including Application Continuity and Transaction Guard. Create and administer a RAC One Node Database. Create and manage multitennant RAC databases. Gain an understanding of the Oracle Database Exadata Cloud Service.

This Oracle Database 12c: Implement Partitioning training teaches you how to manage partitioning using Oracle Database 12c. Expert Oracle University instructors will demonstrate the benefits of partitioning for different types of workloads and learn the syntax for partitioning maintenance operations. In this course, you will be introduced to Oracle Database Cloud Service. Learn To: Apply partitioning strategies to enhance application performance. Use partitioning techniques to reduce impact of table and index maintenance. Use partitioning to decrease the time to refresh materialized views. Partition lob segments, nested tables and object tables. Understand the Oracle Partitioning methods for tables, index and materialized views available in Oracle Database 12c Release 1. Gain an understanding of the Oracle Database Cloud Service.

After completing this seminar, you’ll understand the benefits of parallelizing requests in an Oracle 12c database. You’ll also be able to use features of parallel processing introduced in Oracle 11g Release 1 and 2. Learn To: Optimize SQL statement execution using parallel processing. Use parallel processing appropriately to derive a benefit over serial processing. Control the use of parallel processing. Use a variety of features for parallelizing statements. Read execution plans of parallelized statements. Troubleshoot different issues associated with parallel processing. Use, control and manage parallelization.

In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service. Learn To: Use the Oracle tuning methodology. Use Oracle-supplied tools for monitoring and diagnosing SQL and instance performance issues. Use database advisors to proactively correct performance problems. Identify and tune problem SQL statements. Monitor instance performance by using Enterprise Manager. Tune instance components. Gain an understanding of the Oracle Database Cloud Service.

This Oracle Database 12c: Clusterware Administration training will explore general cluster concepts and Oracle Clusterware architecture. Work with expert Oracle University instructors through interactive instruction and hands-on exercises to reinforce your learning. In this course, you will be introduced to Oracle Database Exadata Cloud Service. Learn To: Perform Grid Infrastructure pre-installation tasks. Install both Standard and Flex clusters. Add and remove nodes from a cluster in addition to upgrading and patching existing Grid Homes. Manage and administer both Standard Clusters and Policy-Managed Clusters. Use Oracle Clusterware to make applications highly available. Gain an understanding of the Oracle Database Exadata Cloud Service.

Oracle Database Vault helps an organization meet their security goals. Many requirements are being put on systems regarding separation of duties and privacy and protection of data, including insider threats. DBAs and security administrators need to understand these requirements, and also the tools available for meeting them. This course introduces the student to the Database Vault product, including installation, configuration, and how it affects activities in the database. New security concepts are introduced, illustrated, and clearly demonstrated by relevant practices. Learn To: How to use the various features of Oracle Database Vault How to monitor and maintain an Oracle Database Vault environment Install and configure Oracle Database Vault to meet your security compliance goals How to use the various features of Oracle Database Vault How to monitor and maintain an Oracle Database Vault environment Install and configure Oracle Database Vault to meet your security compliance goals

The goal of this Oracle Database 11g: 2 Day DBA Release 2 training is to teach database administrators how to install the Oracle Database 11g software and perform the tasks required to manage an Oracle Database. Enterprise Manager is used throughout to teach you how to quickly accomplish the required task. Learn To: Install Oracle Database 11g software and create a database. Use Enterprise Manager Database Control to manage the database. Manage database storage structures and schema objects. Administer users and security. Backup and recover the Oracle Database. Monitor the database and use the Advisors.

This course will discuss the Oracle Partitioning methods for tables, index, and materialized views that are available in Oracle Database 11g Release 2 with examples and explanations of appropriate use. Oracle Database 11g introduces several new partitioning methods: Reference partitioning, System partitioning, Interval partitioning, Virtual column partitioning, and several new composite partitioning methods: Range-Range, Hash-Hash, List-List, List-Hash, List-Range, along with Interval-Range, Interval-Hash, and Interval-List. When added to all the existing methods of partitioning, this large range of choices require that Database Administrators and Data Architects understand each method and appropriate uses. The course will also cover partitioning of Lob segments, nested tables, and object tables. Proper use of partitioning can greatly benefit many types of applications including Data Warehouses, Information Lifecycle management, and very large databases in general. This course is based on Oracle Database 11g Release 2 Patch Set 1. Learn To: Apply partitioning strategies to enhance application performance Use partitioning techniques to reduce impact of table and index maintenance Use partitioning to decrease the time to refresh materialized views

In this course, students learn how to install, configure, manage, and troubleshoot Oracle RAC One Node. In this course, students will learn about Oracle Real Application Clusters One Node (Oracle RAC One Node). Oracle RAC One Node is a single instance of Oracle RAC running on a single node in a cluster. Students will learn how to install, configure and administer an Oracle RAC One Node database. Rolling Patch Application and Instance Relocation using Omotion will be covered as well. Students will learn how to control the CPU consumption of individual database instances using Resource Manager instance caging. In addition, students will learn about the scalability features of an Oracle RAC One Node database including the migration to an Oracle RAC Database. Finally, students will learn about RAC One Node troubleshooting and RAC One Node best practices. Learn To: Install and manage Oracle Grid Infrastructure Create an Oracle RAC One Node database Students will learn about Oracle RAC One Node administration, tuning, and troubleshooting Students will learn about Oracle RAC One Node best practices

This Oracle 11g: RAC and Grid Infrastructure Administration Accelerated training teaches you about the Oracle Grid Infrastructure products, including Oracle Automatic Storage Manager (ASM), ASM Cluster File System and Oracle Clusterware. You will also learn to administer the Oracle Clusterware and storage products using both command line utilities and graphical tools using both command line and graphical user interface clients. Learn To: Describe the Oracle Database 11g Grid Infrastructure. Administer both Policy and Administrator managed RAC databases. Install and configure Grid Infrastructure. Describe Oracle Database 11g RAC enhancements and new features<./li> Describe Grid Plug and Play. Use Oracle Clusterware to make applications highly available. Troubleshoot the Oracle Clusterware by examining log files, enabling debugging and enabling tracing for various utilities. Add and remove nodes and explore quality of service concepts. Upgrade or patch the Grid Infrastructure environment. Upgrade and path Oracle RAC databases.

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery. Learn To: Diagnose and repair data failures with Flashback technology. Manage space to optimize database storage so you can respond to growing space requirements. Monitor and manage major database components, including memory, performance and resources. Secure the availability of your database through appropriate backup and recovery strategies. Automate DBA tasks with the Scheduler

This Oracle Database 11g Performance Tuning training starts with an unknown database that requires tuning. You’ll then learn the steps a DBA performs to identify problem areas, diagnose common problems and fix them. Learn To: Describe Oracle tuning methodology. Use Oracle supplied tools for monitoring and diagnosing SQL and Instance tuning issues. Use database advisors to correct performance problems proactively. Identify problem SQL statements & tune SQL performance problems. Monitor the Instance Performance using Enterprise Manager. Tune instance components, primarily using Instance parameters.

In this course, students learn how to use Oracle Audit Vault. Oracle Audit Vault is a powerful enterprise-wide audit solution to efficiently consolidate, detect, monitor, alert and report on audit data for security auditing and compliance. Oracle Audit Vault provides the ability to consolidate audit data and critical events from various systems such as databases, application servers, applications, and operating systems into a centralized and secure audit warehouse. In this course, students install Audit Vault and configure audit data sources. They learn how to manage audit settings and audit vault alerts. In addition, they learn how to use the Audit Vault Dashboard and reporting functionality. The version of Oracle Database that Oracle Audit Vault uses is 10g Release 2. Learn To: Consolidate audit data and critical events from various database systems Use Audit Vault policy manager to view and provision Oracle Database audit policies centrally Define alerts to provide real-time notification of out-policy activity Use Audit Vault reports to meet security compliance regulations