We are constantly adding new dates for all parts of this series. So be sure to check back regularly. Sessions do not need to be taken in order. Skip ahead to info/registration for a specific session:
This two hour class introduces new features and enhancements in the Oracle 19c Database. Students will get hands-on experience with Automatic Indexing, Performance Tuning and SQL Quarantine. Participants will also discover ways the Oracle 19c improves database security and protects data.
In this two hour class, students will get hands-on experience with on how to upgrade databases to Oracle Database 19c.
A virtual presentation will be followed by the hands-on practicum on performing an actual database upgrade. Attendees will have access to a virtual machine with Oracle database versions 11.2.0.4 and 12.1.0.2 pre-installed with the latest PSU. Attendee can perform database upgrades from Oracle versions 11.2.0.4 or 12.1.0.2 to Oracle Database 19c (19.7 or higher).
Oracle database upgrades often lead to performance related issues. This is due to the number of underlying technical changes in software, introduction of new features, and general enhancement of the products. With many 19c upgrades going on, it’s good to know how to use the many technical features in Oracle for dealing with or even eliminating performance issue. In this lab we will go through some of the basic skills that every DBA should have around performance tuning from enhance explain plans and gathering statistics to using SQL Plan Management. We will also cover the differences between SQL Baselines and SQL profiles. This session should be good if you are an experienced DBA just brushing up on your skills, or new to using Oracle database performance tuning tools.
Two-hour course: A virtual presentation will be followed by the hands-on practicum on SQL tuning. Attendees will have access to a virtual machine with Oracle database pre-installed.
In this two hour class, students will get access to 2 VMs with Oracle Database 19c pre-installed to setup and configure Data Guard.
Learn how you can setup Data Guard with all the best practices. Attendees will receive a brief history of Data Guard and how it became Data Guard. Then, dive directly into new features in Oracle Data Guard 12c Release 2/18c/19c. This workshop will disseminate Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle ecosystem. Viscosity will demonstrate how DBAs should setup, configure, and monitor mission critical Data Guard environments (including Active Data Guard).
In this two hour class, students willlearn the fundamentals to managing the new frontier of pluggable databases. Each student will be assigned 2 VMs to configure PDBs and work labs.
With the recent announcement at Oracle OpenWorld, starting in Oracle Database 19c, we are allowed to have up to 3 pluggable databases per container database. Effective Oracle Database 20c, non-containerized databases will no longer be supported. As an attendee of this session, you will receive a free copy of the PDB Me to Oracle Cloud book written by Oracle ACEs. Come learn what it takes to effectively create, configure, manage and monitor Oracle PDBs while learning all the latest and greatest new features of Oracle PDBs from Oracle 12.2/18c/19c.
Viscosity's core expertise includes:
Data Transformation, Emerging Technology, High Availability & Scalability Solutions, Cloud Migrations, Performance Tuning, Data Integrations, Machine Learning, APEX Development, and Custom Application Development.