Oracle Database 12c R2: New Features for Administrators Part 1

Beschreibung

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 1 course constituted by three modules; the Using SQL New Features and Tools, the Understanding DB Architectures, and the Diagnosing Database Problems, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration, mainly in on-premises Multitenant databases.

Learn To:

  • Use the new SQLcl utility and gain information on SQL Plus and SQL enhancements
  • Understand the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as the new Multitenant architecture and the Sharded database architecture
  • Diagnose database issues, handling Automatic Diagnostic Repository (ADR) file management and using the Trace File Analyzer (TFA) tool

Benefits To You

You will benefit from learning the following lessons:

  • Using the SQL New Features and Tools module covers the usage of the new SQLcl utility and the new features in SQL Plus and SQL
  • Most of the Understanding DB Architectures module lessons cover the new Multitenant architecture. The concept of regular and application containers of a Multitenant container database includes new administrative tasks such as creating, managing, securing, backing up, recovering and upgrading regular and application containers, as well as migrating an 11g database to a 12c multitenant container database. The lessons also cover enhanced features of Resource Manager to help you manage the resources within a Multitenant container database. You will discover other enhancements supported in a Multitenant container database like heat map and Automatic Data Optimization (ADO) support, Database Vault and encryption. The second part of the module gives an overview of database sharding. It describes the challenges and benefits of a sharded database, the sharded database architecture and how to configure a sharded database
  • The lesson of the Diagnosing Database Problems module covers enhancements in ADR space management and explain what can be completed with the Trace File Analyzer (TFA) tool in terms of database diagnosis

Teilnehmerkreis

Teilnehmerkreis

  • Endbenutzer
  • Systemadministratoren
  • Datenbankadministratoren

Vorkenntnisse

Empfehlenswerte verwandte Kurse:

    Knowledge of Oracle Database 11g R2

Empfohlene Vorkenntnisse:

  • Oracle Database 12c R2: Install and Upgrade Workshop
  • Using Oracle Enterprise Manager Cloud Control 13c
  • Oracle Database 12c: RAC Administration

This Oracle Database 12c: 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

Oracle Database 12c: RAC Administration
In diesem Kurs "Oracle Database 12c: RAC Administration" erhalten Sie eine Einführung in die Architektur der Oracle RAC-Datenbank. Sie lernen globale Ressourcen, Cache Fusion und weitere Funktionen kennen.
Oracle Database 12c: RAC and Grid Infra Deployment Workshop

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

Oracle Database 12c: Data Guard Administration

This Oracle Database 12c: Data Guard Administration Ed 1 training teaches you how to use Oracle Data Guard. Learn how it protects your Oracle database against planned and unplanned downtimes. In this course, you will be introduced to Oracle Database Exadata Cloud Service

Oracle Database 12c: Data Guard Administration

In dieser Schulung "Oracle Database 12c: Data Guard Administration" lernen Sie, wie Sie mit Oracle Data Guard Ihre Oracle-Datenbank gegen geplante und ungeplante Ausfallzeiten schützen

Kursziele

Kursziele

  • Create and manage pluggable databases
  • Describe the challenges and benefits of a sharded database
  • Handle the ADR automatic file space
  • Diagnose database issues by using the Trace File Analyzer collector
  • Use the new SQL*Plus history commands and SQL enhancements such as long identifiers
  • Use the SQLcl new utility as the new SQL command line interface
  • Create and manage a multitenant container database

Kursthemen

Kursthemen

  • Introduction
  • Using SQL New Features and SQLcl
  • Understanding CDB Basics
  • Creating CDB and Regular PDBs
  • Creating Application PDBs and Installing Applications
  • Creating PDBs
  • Managing CDB and PDBs
  • Managing Storage
  • Managing Security
  • Backing up, Recoverying and Flashing Back
  • Managing Performance
  • Managing Resources Allocation
  • Moving and Migrating Data
  • Performing Miscellaneous Operations
  • Understanding Database Sharding
  • Diagnosing Database Problems

Schulungsdauer und Art

Schulungsdauer

  • 5 Tage

Schulungsart

  • Kurs durch Trainer

Sprache

Sprache

  • Deutsch / Englisch

Weitere Infos

Beginn:
Am ersten Kurstag um 10.00 Uhr: Ca. 15 Minuten sind vor Kursbeginn für die Registrierung vorgesehen. An den nachfolgenden Tagen sind die Kurszeiten von 9.00 - 17.00 Uhr.

Enthaltene Leistungen:

  • Schulungsunterlagen
  • Teilnahmezertifikat
  • Getränke (Kalte und Warme)
  • Obst und Snacks
  • Mittagessen

Kursdetails

Startdatum 02.03.2020 - 08:00
Enddatum 06.03.2020 - 16:00
Anmeldungsende 28.02.2020 - 08:00
Netto Einzelpreis € 3.315,00
Speaker English
Kurs-Nr. Oracle Database 12c R2: New Features for Administrators Part 1
Ort LVC
Abgeschlossen