The student begins by gaining a deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication.
Tackle performance, availability, security, and compliance with Oracle Database products.
Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.
Earning Oracle Database certification helps you achieve more, faster, with fewer resources, empowers you with the skills and gives you an edge over the competition.
From basics to advanced curriculum, learn everything you need to know about management, development, security, and enabling high availability and data warehousing in Oracle Database versions 19c, 18c, 12c, 12c R2, and 11g.
-
-11%
Tune your databases with targeted queries and tuning methodology so you can identify problems before they arise.
Learn how to use advisors inside of an oracle database, as well as various tools provided by Oracle, in order configure the right settings for optimal performance. Gain skills in this Oracle database course to:
- use targeted query tuning and methodology to identify tuning problems in an Oracle database to take corrective action
- how to identify and tune a common database
- troubleshoot performance issues
- use advisors inside the database in order to understand in advance what settings need to be made and how to use the various tools provided by Oracle to configure the database
-
The Oracle AI Database: High Availability New Features equips students with essential knowledge on the latest high availability features, enhancing their capabilities to effectively manage and optimize Oracle databases in demanding environments.
-
Use the Multitenant feature of Oracle AI Database for it to function as a container database (CDB), thereby improving resource utilization, management, and overall security. Learn the benefits, configuration, and management of container and pluggable databases, including backup, security, and data migration using Oracle AI Database. With hands-on practices, you’ll be able to reinforce the learning of the new Oracle Multitenant feature and its capabilities.
-
This course covers the latest additions and improvements in Oracle AI Database. It equips Oracle Database Administrators with knowledge about enhanced tools for better management, focusing on performance, architecture, security, and database sharding. The topics include updates to AI Vector Search, True Cache, Sharding, Blockchain Tables, Data Migration with RMAN, Wide Tables, and Lock-Free Reservations.
-
This course explores developer-centric features in the Oracle AI Database release, starting with the AI Vector Search feature. It covers new capabilities in SQL for developers, offering flexibility in writing SELECT, DML, DDL, and Materialized View statements. The course also covers improvements in Oracle’s analytic capabilities, upgrades to JSON functionality, and introduces new Globalization features.
-
-11%
This course is targeted at Developers and Database Administrators and begins with the concepts of a relational database and the SQL programming language. It includes writing queries against single and multiple tables, manipulate data in tables, and create database objects.
You’ll also learn how to create sequences, synonyms, indexes, and views, manage schema objects, and manage data using subqueries. Additionally, the course covers controlling User Access and managing data in different time zones.
-
-11%
This course is targeted at Database Administrators and begins with explaining the architecture of an Oracle Database instance and the tools used to access it. The course includes creating and managing a database, configuring and managing Oracle Net Services along with creating and administering pluggable databases (PDBs). You learn how to create and manage database storage, users, backup, and implement database security.
Additionally, the course covers protection of database against failures, loading, and transporting data.
-
The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability. In the lessons, you learn the new and enhanced features of Oracle Database 19c amongst different areas such as database overall, security, availability, performance, big data and warehousing, and diagnosability.
-
The Oracle Database 12c: RAC and Grid Infra Deployment Workshop Ed 1 training course will give you a detailed overview of configuring, administering and using important features of Oracle Database 12c RAC and Grid Infrastructure. Additionally, you will also be given a basic overview of the Oracle Database Exadata Cloud Service.
-
The Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1 training course will give you a detailed overview of following modules, the Using SQL New Features and Tools, the Understanding DB Architectures, and the Diagnosing Database Problems. During the training, you will be skilled with the knowledge about on-premises Multitenant databases and various other new features in different areas of database administration.
-
The course covers planning, installation, and deployment of Oracle Database Appliance, Release 18c. Students will learn how Oracle Database Appliance compares to other Oracle engineered systems and the advantages of using Oracle Database Appliance. After reviewing and planning for a new deployment, students will utilize the Web Console to deploy a bare metal appliance and the Oracle Appliance Configuration Manager tool to generate a deployment plan configuration for a virtualized appliance. Additional instructional videos and simulation software covers the concepts of racking and cabling a newly arrived Oracle Database Appliance system, running first boot scripts, downloading and installing the end-user bundle, and applying the latest patch bundles. The simulation labs are performed for both bare metal deployments and virtualized Oracle Database Appliance deployments.
-
Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.
This OD-19c-PW: Oracle Database 19c: PL/SQL Workshop course introduces students to PL/SQL, Procedural Language for SQL. Explore the differences between SQL and PL/SQL. Examine the characteristics of PL/SQL and how it is used to extend and automate SQL.
-
This Oracle course introduces the main architectural concepts of Oracle Data Guard. The delegate will learn how to use Oracle Data Guard to protect an Oracle Database against planned and unplanned downtime.
Through a blend of hands-on labs and interactive lectures you will also learn how to create and manage physical, logical and snapshot standby databases and how to use standby databases for reporting, querying and testing purposes.
-
The Oracle Database 19c: SQL Workshop course offers students an introduction to Oracle Database 19c database technology. 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.
-
This OD-19c-FDS: Oracle Database 19c: Fundamentals for Devs and SysAdmins course teaches you how to perform common, day-to-day administrative tasks that are required of an Oracle database administrator (DBA).
The Oracle database course covers the following topics:
- Install the Oracle Database Software and Create a Database
- Use Enterprise Manager Database Express
- Use SQL*Plus and SQL Developer
- Use the Listener Control Utility
- Use SQL Developer to Shut Down and Restart a Database
- View Initialization Parameters
- Manage the Database Storage Structures
- Administer Users and Security
- Create Application Tables and Load Database
- Perform Backup and Recovery
- Monitor Database Performance
-
This OD-19c-SF: Oracle Database 19c: Security Fundamentals course teaches you Security aspect related to the latest release of Oracle Database (19c).
-
This is a newly curated course of one day duration that covers the Data Encryption aspect related to the latest of release of Oracle Database (19c).
The course covers the following topics:
- Managing Endpoints and Oracle Wallets
- Encryption
- Key Vault and Transparent Data Encryption
- Performing Oracle Key Vault Administrative Tasks
-
Oracle Database 19c is the latest release of Oracle’s flagship relational database management system.
This Oracle Database course teaches you how to use the advanced features of PL / SQL to design and tune PL / SQL to interface with the database and other applications.
In Oracle Database 19c: Advanced PL/SQL training you will learn advanced features of program design, packages, cursors, extended interface methods and collections. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.
-
Expand your database knowledge and gain an edge in a competitive IT marketplace.
Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.
This Oracle Database course teaches you about Oracle ASM architecture and its components. During the training, you will get a deep understanding of both standard ASM and Flex ASM applications.
-
Learn to write well-tuned SQL statements for the Oracle database.
This Oracle Database course teaches you how to write well-tuned SQL statements appropriate for the Oracle database. This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning.
MySQL Cloud Service provides numerous benefits over an on-premise database. It is easy to create a cloud instance, with flexible options for computing power, memory, and storage. GUI tools are available for backup and restore as well as patching and rolling back. After completing this course, you can take advantage of those benefits to use MySQL Cloud Service to its best advantage.
-
Get up to speed on Oracle RAC Administration.
This Oracle Database 19c: RAC Administration Workshop course will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion.
Learn To:
- Install and configure RAC
- Manage RAC Database
- Upgrade and patch RAC Database
- Manage backup and recovery for RAC
- Monitor and tune RAC Database
- Manage high availability of services
- Implement High Availability for connections and applications
- Configure RAC One Node Database
- Implement In-Memory Column Store in RAC
- Configure Multitenant Architecture in RAC
- Manage Quality of Service in RAC
-
The best database architecture for the hybrid cloud.
The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Through a blend of hands-on labs and interactive lectures, you will explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs).
-
A High Availability Cluster and the Foundation for Oracle RAC.
Oracle Clusterware is a portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clusterware was first released with Oracle Database 10g Release 1 as the required cluster technology for the Oracle multi-instance database, Oracle Real Application Clusters (RAC).
This OD-19c-CAW: Oracle Database 19c: Clusterware Administration Workshop course teaches you general cluster concepts and Oracle Clusterware architecture. In this course you will learn in-depth understanding of installing, configuring, patching and maintaining Oracle Clusterware 19c.
