logo

Oracle Database 12c: Administration Workshop II (DB6158)

This course considers advanced features for Oracle 12c database administrators. Like any major software platform, the management of an Oracle database in a production environment can present challenges. Responding to those challenges requires more than just a basic understanding of database administration.

Pohađajte naše Oracle obuke u Beogradu, putem virtuelne učionice (online, uživo) ili u vašim prostorijama (on-site).

Specijalni popusti se odobravaju prilikom prijave više učesnika koji istovremeno pohađaju obuku iz vaše kompanije, državni i neprofitni sektor, itd. Kontaktirajte nas da biste saznali više.

Termini obuke

Trajanje obuke: 
5 dana / 35 sati

Privatni trening

On-site / Online
Minimalan broj polaznika: 3
5 dana / 35 sati
Cena na zahtev
srpski ili engleski
Plan obuke: 

Advanced Administration: About Advanced Database Administration

  • Database Feature Usage

  • Server Alert Framework

  • Managing The Server Alerts Using EM CC

  • pDB Level Alerts

Advanced Administration: Globalization

  • Globalization Settings

  • Managing NLS Settings

  • Date & Time Localization

  • Linguistic Sorting & Matching

  • Linguistic Indexes

  • About Locale Builder

Advanced Administration: Database Connections & Shared Servers

  • Connection & Session Options

  • Shared Servers Architecture

  • Comparing Shared Servers & Dedicated Servers

  • Configure Shared Servers

  • Use Shared Servers

  • Monitor Shared Servers

Advanced Security: Database Security Threats

  • Potential Threats

  • Potential Attackers

  • The Threat Matrix

  • Database Security Checklist

Advanced Security: Encryption Concepts

  • About Encryption

  • Data-At-Rest Encryption

  • Data-In-Transit Encryption

  • Data-En-Route Encryption

  • Encryption Limitations

  • Encryption Algorithms & Potential Weaknesses

  • Managing Encryption Keys

Advanced Security: TDE Keystore Management

  • About Transparent Data Encryption

  • The SYSKM Administrator

  • TDE Encryption Algorithms

  • Understanding How Column Encryption Works

  • Understanding How Tablespace Encryption Works

  • Is TDE Unbreakable?

  • Managing TDE

  • Managing The Keystore

  • Managing A Wallet Keystore Using SQL

  • Managing A Wallet Keystore Using EM CC

  • Managing A Wallet Keystore Using OWM

  • Advanced Management Options

  • Keystore Backups

  • Migrate To HSM Keystore

  • Wallet Open Options

  • Regenerate Master Encryption Key

Advanced Security: TDE Data Encryption

  • Implement Tablespace Encryption

  • Implement Column Encryption

  • Assessing Encryption Usage

Advanced Security: Oracle Net Services Encryption & Security

  • Network-Launched Attacks

  • Limiting Database Attacks

  • Preventing Denial-of-service Attacks

  • Avoiding Disclosure Of Vulnerabilities

  • Oracle Net Services User Notifications

  • Oracle Net Native Encryption

  • Implementation With Oracle Net Manager

  • Implementation With sqlnet.ora

Advanced Storage: Space Management

  • Space Management Best Practices

  • Segment Storage Specifications

  • Estimate & Track Space Usage

  • Resumable Space Allocation

  • Enable A Resumable Session

  • Detect A Suspended Session

  • Resuming A Session

  • Using DBMS_RESUMABLE()

  • Deferred Segment Creation

Advanced Storage: The Segment Advisor

  • About The Segment Advisor

  • Using The SHRINK SPACE Option

  • Segment Advisor Within EM CC

  • The Automatic Segment Advisor

  • Programmatic Segment Advisor

Advanced Compression

  • About Compression

  • Table Compression

  • Basic Table Compression

  • Advanced Row Compression

  • Additional Table Compression Considerations

  • Index Compression

  • Key Compression

  • Advanced Index Compression

  • Hybrid Columnar Compression

  • Compression Analysis

  • Using SQL Metadata Queries

  • Using DBMS_COMPRESSION()

  • Using EM CC

Heat Map Tracking & Automatic Data Optimization (ADO)

  • About ILM

  • The Oracle Database & ILM Support

  • Heat Map Tracking

  • Automatic Data Optimization (ADO)

  • Adding ADO Policies Using SQL

  • Managing ADO Policies Using SQL

  • Managing ADO Policy Evaluation

  • Managing ADO Policies Using EM CC

In-Memory Storage

  • About Traditional Table Caching

  • Big Table Caching

  • Full Database Caching

  • In-Memory Column Store

  • IMCS Internals

  • Configuring The IMCS

  • Assigning Objects To The IMCS

  • Assigning Columns To The IMCS

  • Monitoring IMCS Using EM CC

In-Database Archiving

  • About In-Database Archiving

  • In-Database Archival Tables

  • In-Database Archiving Of Rows

  • Temporal Validity

Data Redaction

  • About Data Redaction

  • The Redaction Functions

  • Using Function Type dbms_redact.random

  • Using Function Type dbms_redact.partial

  • Function Type dbms_redact.partial Shortcuts

  • Using Function Type dbms_redact.regexp

  • Function Type dbms_redact.regexp Shortcuts

  • Defining Redaction Policies

  • Managing Redaction Policies

  • Customizing Full Redaction

  • Viewing Redaction Metadata

  • Using EM Cloud Control

  • Inference Attacks

Benefiti: 
  • Video snimak predavanja u periodu od 180 dana posle kraja obuke

  • Pristup laboratorijama u toku trajanja kursa
  • Materijal u elektronskom obliku

  • Sertifikat o pohađanju kursa

Poželjno predznanje: 

The entire Oracle database administrator curriculum has these prerequisites:

  • ORACLE DATABASE 12C: SQL FUNDAMENTALS (LEVELS I & II)

  • ORACLE DATABASE 12C: PL/SQL FUNDAMENTALS (LEVELS I & II)

Equivalent experience is also acceptable.

With regard to this course and its position within the curriculum, these are the required prerequisites, or equivalent experience:

  • ORACLE DATABASE 12C: INSTALL & UPGRADE WORKSHOP

  • ORACLE DATABASE 12C: ARCHITECTURE & INTERNALS

  • ORACLE DATABASE 12C: ADMINISTRATION WORKSHOP

Kontaktirajte nas za više informacija o ceni:

Eccentrix
Office: +381 11 71 38 192
Mobile: +381 65 31 38 195
E-mail: Jelena.Mijanovic@eccentrix.rs

Milutina Milankovića 9đ,
11070 Novi Beograd
www.eccentrix.rs

Eccentrix
Office: +381 11 71 38 192
Mobile: +381 65 31 38 197
E-mail: Boris.Gigovic@eccentrix.rs

Milutina Milankovića 9đ,
11070 Novi Beograd
www.eccentrix.rs