Oracle

In the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service. Learn To:   Use Oracle tools to identify inefficient SQL statements. Use Automatic SQL Tuning. -Use Real Time SQL monitoring. Write more efficient SQL statements. Monitor and trace high load SQL statements. Manage optimizer statistics on database objects. Understand the optimizer process steps and operators. Interpret execution plans. Perform application tracing. Gain an understanding of the Oracle Database Exadata Express Cloud Service.

The Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code. Learn To:  Use various features of PL/SQL.  Write anonymous blocks of code in PL/SQL.  Use various PL/SQL conditional constructs and loops in program blocks.  Interface the PL/SQL code with the database.  Use stored procedures and functions in their program blocks.  Handle Exceptions in PL/SQL code.

This Oracle Database 12c: Real Application Cluster (RAC) Administration training teaches you about Oracle RAC database architecture. Explore Global Resources and Cache Fusion and more. 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.

The Oracle Database: SQL Workshop I Ed 3 course offers students an introduction to Oracle Database 12c database technology. The students are also introduced to Oracle Database Exadata Express Cloud Service. In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Learn To:  Identify what a SQL statement is.  Understand the Oracle Relational Database.  Use SQL Developer.  Write reports using SQL Statements.  Manipulate data in relational tables and save the data.

During the Oracle Database 12c Administration Workshop, students cover a brief overview of the multitenant container database and its pluggable databases. This Oracle Database 12c R2: Managing Multitenant Architecture course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases. You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods.  In addition, you learn how to create common and local users and administer database security to meet your business requirements by using encryption, Database Vault and auditing and you will learn how to create a database deployment in the Cloud.  Learn To:  Understand the multitenant architecture. Create and manage a multitenant container database and pluggable databases. Understand regular and application pluggable databases. Manage storage within a multitenant container database and pluggable databases. Manage security within a multitenant container database and regular and application pluggable databases. Monitor performance and manage resources within a multitenant container database and pluggable databases. Perform backup, recover and flashback operations on a multitenant container database and regular and application pluggable databases. Perform particular operations like Oracle Data Pump transportation, loading, encrypting, auditing. Manage the CDB and PDBs in specific configurations like Data Guard, Database Vault.

This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications. In this course, you will be introduced to Oracle Database Exadata Cloud Service. Learn To:  Administer ASM files, directories, templates, and disk groups.  Manage and administer Oracle Cloud File System and its components. Configure and manage advanced CloudFS features like ACFS Auditing and Encryption, ACFS Replication and High Availability NFS. Gain an understanding of the Oracle Database Exadata Cloud Service.

In the Oracle Database 12c: New Features for Administrators Ed 2 course, you’ll learn about the new and enhanced features and options of Oracle Database 12c. Expert instructors will teach you how these features and options increase security, manageability and performance. In this course, you will be introduced to Oracle Database Cloud Service.  Learn To: Manage the Oracle multitenant container databases and pluggable databases.  Configure Heat Map and use Automatic Data Optimization.  Benefit from Online Datafile Move. Understand the new Temporal capabilities as well as In-Database Archiving with Row-archival. Enforce security with the Unified Auditing, the new administrative privileges, Privilege Analysis, and Data Redaction. Increase SQL performance with the Database In-Memory option, and Full Database In-Memory Caching and the Automatic Big Table Caching features. Benefit from optimizer enhancements such as Adaptive Execution Plans and SQL Plan Directives, Real-Time ADDM and Compare Period ADDM. Use enhanced features of Resource Manager in multitenant container databases and pluggable databases. Understand how and when to use enhancements in Data Pump, partitioning, and SQL. Gain an understanding of the Oracle Database Cloud Service.

This Exadata Database Machine: 12c Administration Workshop training introduces you to Oracle Exadata Database Machine, covering the features and capabilities of the Exadata Database Machine X6 product family. In this course, you will be introduced to Oracle Database Exadata Cloud Service. Explore the various Exadata Database Machine features and configurations, with emphasis on the unique capabilities delivered by Exadata Storage Server. This course uses a virtualized environment for the hands-on component. Learn To: Describe Exadata Storage Server and how it's different from traditional database storage. List the key capabilities and features of Exadata Database Machine and Exadata Storage Server. Initially configure Exadata Database Machine and make appropriate up-front configuration decisions. Implement Exadata Storage Server security. Use query execution plans, statistics and wait events to examine Exadata Smart Scan. Describe various options and best-practice recommendations for consolidation on Exadata Database Machine. Describe various options for migrating to Database Machine and how to select the best approach. Perform various maintenance tasks on Exadata Database Machine. Configure Enterprise Manager Cloud Control 12c in conjunction with Exadata Database Machine. Monitor Exadata Database Machine using the monitoring infrastructure inherently within Exadata Database Machine, along with the monitoring capabilities exposed through Enterprise Manager Cloud Control 12c. Use other utilities for monitoring Exadata Database Machine which are supplied by Oracle. Gain an understanding of the Oracle Database Exadata Cloud Service.

Oracle Database 12c: Clusterware & ASM Admin Accelerated training covers 6 days worth of content in only 5 days. It starts with the Oracle Database 12c: Clusterware Admin Ed 1 course (4 days) and then covers the Oracle Database 12c: ASM Administration course (2 days). Learn about Oracle Clusterware and ASM architectures and how these products work together. 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. Administer ASM files, directories, templates, and disk groups. Manage and administer Oracle Cloud File System and its components. Configure and manage advanced CloudFS features like ACFS Auditing and Encryption, ACFS Replication and High Availability NFS.

This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications. In this course, you will be introduced to Oracle Database Exadata Cloud Service. Learn To: Administer ASM files, directories, templates, and disk groups. Manage and administer Oracle Cloud File System and its components. Configure and manage advanced CloudFS features like ACFS Auditing and Encryption, ACFS Replication and High Availability NFS. Gain an understanding of the Oracle Database Exadata Cloud Service.

This Oracle Database 12c: Admin, Install and Upgrade Accelerated course covers 7 days worth of content in only 5 days. It consists of the Oracle Database 12c: Administration Workshop Ed 1 course (5 days) and the Oracle Database 12c: Install and Upgrade Workshop Ed 1 course (2 days). In this course, you will be introduced to Oracle Database Cloud Service. This course will teach you about the Oracle Database architecture and you will discover how to effectively manage an Oracle Database instance. You will also be provided key information on how to install and administer Oracle Database 12c. Learn To: Upgrade an existing Oracle Database to Oracle Database 12c. Create and manage an Oracle Database Instance. Create and manage Storage Structures. Configure the Oracle Network Environment. Create and manage users. Monitor the database and manage performance. Learn basic information on backup and recovery techniques. Gain an understand of the Oracle Database Cloud Service.

This Oracle Database 12c: Security training teaches you how you can use Oracle Database features to meet the security, privacy and compliance requirements of your organization. You’ll get the chance to interact with expert Oracle University instructors through a combination of instruction and hands-on exercises that reinforce new concepts. Learn To: Understand Oracle security solutions and how they can help address your security requirements. Configure strong authentication for database users using PKI and Kerberos. Control data access using virtual private database and Oracle Label Security. Analyze application privileges and reduce the attack surface using Oracle Database Vault Privilege Analysis. Reduce risk of data exposure using Oracle Advanced Security Data Redaction, Transparent Data Encryption and Oracle Data Masking and Subsetting. Audit activity inside the database using policy and condition based unified auditing. Configure network encryption to protect information in transit. Audit activity inside the database using policy and condition based unified auditing. Protect against application bypass using Oracle Database Vault Realms.

Practice configuring, administering and using noteworthy features associated with Oracle Database 12c RAC and Grid Infrastructure. In this course, you will be introduced to Oracle Database Exadata Cloud Service. Learn To: Perform a database rolling upgrade, from Oracle Database 11gR2 to Oracle Database 12c, using a transient logical standby database. 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. 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. Gain an understanding of the Oracle Database Exadata Cloud Service.

The Oracle Database 12c: OCM Exam Preparation Workshop is designed for those candidates who are preparing to take the Oracle Database 12c: Oracle Certified Master (OCM) Exam. This workshop has extensive hands-on practices to enable students to: Create a Multitenant Container Database and Pluggable Databases Perform Backup, Recovery, and Flashback of CDB and PDBs Load and unload data Implement partitioning Configure Dataguard Configure Clusterware Install RAC

This course is ideal for Database Administrators of small to medium sized businesses. This Oracle Database 12c: Fundamentals for Developers and System Administrators course helps you perform basic Oracle Database 12c administration tasks needed to keep the database operational. In this course, you will be introduced to Oracle Database Cloud Service. Learn To: Install Oracle Database 12c software and create a database. Use Enterprise Manager Database Express 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. Gain an understanding of the Oracle Database Cloud Service.

The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.

This Oracle Database 12c: Managing Multitenant Architecture training helps you gain a conceptual understanding of the multitenant architecture. You’ll practice plugging and unplugging databases in multi-tenant container databases, while learning how to create common and local users and administer database security to meet your business requirements. In this course, you will be introduced to Oracle Database Cloud Service. Learn To: Understand the multitenant architecture. Create and manage a multitenant container database and pluggable databases. Manage storage within a multitenant container database and pluggable databases. Manage security within a multitenant container database and pluggable databases. Monitor performance and manage resources within a multitenant container database and pluggable databases. Perform backup, recover and flashback operations on a multitenant container database and pluggable databases. Manage the CDB and PDBs in specific configurations like Data Guard, Database Vault. Perform particular operations like Oracle Data Pump transportation, loading, encryption, auditing. Gain an understanding of the Oracle Database Cloud Service.

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.