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.
-
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
-
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.
-
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).
-
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
-
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.
-
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.
-
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.
-
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
-
This OD-19c-SF: Oracle Database 19c: Security Fundamentals course teaches you Security aspect related to the latest release of Oracle Database (19c).
-
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
-
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.
