This course provides an overview of the Oracle Database 18c new features and enhancements related to Multitenant architecture, security, RMAN, general database areas, performance, data warehousing and Sharding.

Learn To: 

• Use new features like Application PDB Fleet and PDB snapshots carousel of the Multitenant architecture.
• Understand new features like PDB keystores and encryption of sensitive data in Database Replay files of the Security.
• Benefit from new features like reuse of preplugin backups and duplication of active PDBs into an existing CDB of RMAN.
• Use new features like private temporary tables and online modification of partitioning and subpartitioning strategy of General Database.
• Configure and use new features like Automatic In-Memory Management in Performance.
• Manipulate new features like inline external tables and polymorphic table functions of the Data Warehousing.
• Understand enhancements like user-defined sharding method and support for PDBs as shards in Sharding.

This Oracle Database: SQL and PL/SQL Fundamentals training delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You’ll explore the concepts of relational databases.

Learn To:

• Write queries against single and multiple tables, manipulate data in tables and create database objects.
• Use single row functions to customize output. Invoke conversion functions and conditional expressions.
• Use group functions to report aggregated data. Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
• Develop anonymous PL/SQL blocks, stored procedures and functions. Declare identifiers and trap exceptions.
• Use DML statements to manage data.
• Use DDL statements to manage database objects.
• Declare PL/SQL Variables.
• Conditionally control code flow (loops, control structures).
• Describe stored procedures and functions.
• Retrieve row and column data from tables.

In the Oracle Database Security: Detective Controls course, students learn how they can use Oracle Database administration auditing features to meet the compliance requirements of their organization. The current regulatory environment requires better security at the database level. Students learn how to audit the access to their databases and how to use the auditing and compliance features to monitor data access and confidentiality. The course provides suggested Oracle solutions for common problems.

Learn To:

• Enumerate Oracle auditing solutions to monitor database security requirements.
• Implement Oracle Audit Vault and Oracle Database Firewall.
• Configure Oracle Audit Vault and Oracle Database Firewall.
• Explain Oracle Compliance Framework.
• Configure basic Compliance Framework rules.

This XML Fundamentals training introduces you to the basics of XML. In this 2 day hands on course, you will learn the central XML technologies, including writing well formed and valid XML, creating Document Type Definitions (DTDs) and XML schema documents and using XPath and XQuery.

Learn To:

• Create well-formed and valid XML documents.
• Use XML Namespaces in an XML document to resolve name ambiguities in XML documents.
• Create Document Type Definition and XML schema documents to validate XML documents.
• Use XPath expressions and functions to find and select nodes in XML documents.
• Transform XML documents by using stylesheets and XPath expressions.
• Use Oracle JDeveloper to view, create, edit, and test XML and other XML-related documents.
• Use XQuery to query, generate, and transform XML content.
• Identify the features and benefits of Oracle XML DB

The Oracle Database 12c R2: High Availability New Features course covers High Availability new features introduced in the Oracle Database 12c Release 2. Focus areas include Clusterware, ASM, ACFS, RAC, and Data Guard.

Learn To:

• Configure and administer the Oracle Database 12c R2 high availability new features contained in Oracle Clusterware Infrastructure (including Automatic Storage
• Management [ASM] and Cloud FS.
• Configure and administer RAC new features.
• Describe the new features contained in Oracle Data Guard.
• Describe Oracle Data Guard Enhancements.
• Gain an understanding of the Oracle Database Exadata Cloud Service.
• Gain an understanding of Clusterware Manageability Enhancements.
• Gain an understanding of ASM New Features.
• Gain an understanding of ACFS Manageability New Features & Performance Enhancements.
• Gain an understanding of Real Application Cluster New Features.
• Gain an understanding of Data Guard and Broker New Features.

No hands-on lab environment for the Training On-Demand course format

In the Oracle Audit Vault and Database Firewall: Policies & Reports course, students will learn how to create audit and Database Firewall policies, use built-in reports, create custom reports, and define alerts.

Learn To:

• Create and provision audit policies for Oracle Databases.
• Create and publish Database Firewall policies.
• Configure and respond to alerts.
• Use and customize built-in reports.
• Manage entitlements.

This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure. You’ll also learn to use regular expressions and sub-expressions to search for, match, and replace strings. In this course, you will be introduced to Oracle Business Intelligence Cloud Service.

Learn To:

• Use SQL with aggregation operators, SQL for Analysis and Reporting functions.
• Group and aggregate data using the ROLLUP and CUBE operators, the GROUPING function, Composite Columns and the concatenated Groupings.
• Analyze and report data using Ranking functions, the LAG/LEAD Functions and the PIVOT and UNPIVOT clauses.
• Perform advanced pattern matching.
• Use regular expressions to search for, match and replace strings.
• Gain an understanding of the Oracle Business Intelligence Cloud Service.