Pular para o conteúdo
[email protected]
Contato
Curitiba 41 3204.1999 | Brasil 4007.2186
Tel
WhatsApp 41 98754.3534
WhatsApp
SoftSell
MENUMENU
  • HOME
  • TREINAMENTOS E CERTIFICAÇÕES
    • CALENDÁRIO DE TREINAMENTOS
    • Certificações em TI
    • Check Point
      • CCSA – Check Point Certified Security Administrator
      • CCSE – Check Point Security Engineering
      • Check Point CCSA+CCSE – Bundle R.80
    • Cisco
      • Cisco Digital Network Architecture Implementation Essentials (DNAIE) v2.0
      • Cisco SD-WAN Operation and Deployment (ENSDW) v1.0
      • Designing Cisco Enterprise Networks (ENSLD) v1.0
      • Implementing and Administering Cisco Solutions (CCNA) v1.0
      • Implementing and Configuring Cisco Identity Services Engine (SISE) v3.0
      • Implementing and Operating Cisco Collaboration Core Technologies (CLCOR) v1.0
      • Implementing and Operating Cisco Enterprise Network Core Technologies (ENCOR) v1.0
      • Implementing and Operating Cisco Security Core Technologies (SCOR) v1.0
      • Implementing Cisco Advanced Call Control and Mobility Services (CLACCM) v1.0
      • Implementing Cisco Application Centric Infrastructure (DCACI) v1.0
      • Implementing Cisco Catalyst 9000 Switches (ENC9K) v1.0
      • Implementing Cisco Collaboration Applications (CLICA) v1.0
      • Implementing Cisco Collaboration Cloud and Edge Solutions (CLCEI) v1.0
      • Implementing Cisco Enterprise Advanced Routing and Services (ENARSI) v1.0
      • Implementing Cisco Enterprise Wireless Networks (ENWLSI) v1.1
      • Implementing Secure Solutions with Virtual Private Networks (SVPN) v1.0
      • Securing Email with Cisco Email Security Appliance (SESA) v3.1
      • Securing the Web with Cisco Web Security Appliance (SWSA) v3.0
      • Understanding Cisco Collaboration Foundations (CLFNDU) v1.1
      • Understanding Cisco Wireless Foundations (WLFNDU) v1.0
    • CompTIA
      • Linux+ CompTIA
      • Security+ CompTIA
      • Webinar – Cibersegurança e o Mercado de Trabalho
    • EC-Council
      • CASE JAVA Training & Certification
      • CEH v11
      • CHFI
      • CND v2
      • CSA Certified SOC Analyst
      • CSCU Certified Secure Computer User
      • ECIH
    • Extreme Networking
      • Campus EXOS Switching and Routing
    • F5
      • Configuring F5 Advanced WAF (previously licensed as ASM)
      • F5 ADM BIG IP – Administering BIG-IP
      • F5 BIG-IP DNS (Antigo GTM)
      • F5 Configuring BIG-IP (AFM): Advanced Firewall Manager
      • F5 Configuring BIG-IP (APM): Access Policy Manager
      • F5 LTM – Configuring BIG-IP Local Traffic Manager
      • F5 Troubleshooting BIG-IP
    • Fortinet
      • NSE 4 FortiGate (I) Security v6
      • NSE 4 FortiGate (II) Infrastructure v6
      • NSE 5 FortiAnalyzer
      • NSE 5 FortiManager
      • NSE 7 Enterprise Firewall
      • NSE 7 Network Security Architect
    • Furukawa
      • Data Cabling System
      • FCP Fibras Ópticas
      • FCP Fibras Ópticas | Módulo Emendas Ópticas
      • FCP Fibras Ópticas | Módulo Medição em Redes Ópticas
      • FCP Fibras Ópticas | Módulo Redes Externas
      • FCP Master
      • FCP Professional
      • FCP Update
      • FTTx Conceitos e Projetos
      • FTTx Equipamentos | Módulo 1 Networking
      • Webinar
    • Infoblox
      • CDAT – Core DDI Advanced Troubleshooting 8.x
    • Juniper
      • Advanced Junos Enterprise Routing (EDU-JUN-AJER)
      • Advanced Junos Enterprise Switching (EDU-JUN-AJEX)
      • Juniper Networks Design Security (EDU-JUN-JNDSEC)
      • Juniper Networks Fundamentos de Design (EDU-JUN-JNDF)
      • Junos Enterprise Switching (EDU-JUN-JEX)
      • Junos Intermediate Routing (EDU-JUN-JIR)
    • Oracle
      • Database 12c: Clusterware Administration
      • Database 12c: Data Guard Administration
      • Database 12c: New Features for Administrators
      • Database 12c: Performance Management and Tuning
      • Database 12c: RAC Administration
      • Database 12c R2: Administration Workshop Ed 3
      • Database 12c R2: ASM Administration
      • Database 12c R2: Backup & Recovery Workshop
      • Database 12c R2: Install and Upgrade Workshop NEW
      • Database 12c R2: New Features for Administrators 2
      • Database 18c: Managing Multitenant Architecture
      • Database Cloud for Oracle DBAs
      • Database Program with PL/SQL Ed 2
      • Database SQL and PL/SQL New Features Ed 1
      • Database SQL and PL/SQL Fundamentals
      • Database SQL Workshop II
      • Data Integrator 12c: Integration and Administration Ed 3 NEW
      • Exadata Database Machine: 12c Administration Workshop
      • Introduction to SQL
      • Java
        • Java Performance Tuning
        • Java SE 8 Fundamentals
        • Java SE 8 New Features
        • Java SE 8 Programming
        • Object – Oriented Analysis and Design Using UML
      • MySQL
        • MySQL Cluster
        • MySQL for Beginners
        • MySQL for Database Administrators
        • MySQL for Developers
        • MySQL Fundamentals
        • MySQL Performance Tuning
      • SQL Tuning for Developers Workshop
      • WebLogic Server 12c: Administration I
      • WebLogic Server 12c: Administration 2
      • WebLogic Server 12c: JMS Administration
      • WebLogic Server 12c: Performance Tuning Workshop
      • WebLogic Server 12c: Troubleshooting Workshop
    • Palo Alto Networks
      • PAN 210 – Firewall 10.0 Essentials: Configuration and Management
      • PAN 214 – Firewall 8.1: Optimizing Firewall Threat Prevention
      • PAN 220 – Palo Alto Panorama: Managing Firewalls at Scale v9
      • PAN 318 – Prisma Access Sase Security: Design and Operation
      • PAN 330 – Firewall: Troubleshooting v9
    • Salesforce
      • ADX 201 Essentials Administration for new Admins in Lightning Experience
      • ADX 251 Sales Cloud Administration
      • ADX 261 Service Cloud Administration
      • DEX 450 Desenvolvedor Salesforce
      • Marketing Cloud Email Marketers EEB101 e JB101
    • SoftSell
      • Linux Essentials
    • SonicWall
      • SonicWall Network Security Administrator (SNSA)
      • SonicWall Network Security Professional (SNSP)
    • Veeam
      • Veeam Certified Engineer (VMCE) v9 classroom
    • VMWare
      • VMware vSphere: Install, Configure, Manage v6.7 – VMware
  • SOLUÇÕES DE TI
    • Fábrica de Softwares e BI
    • Produtos e Equipamentos de TI
    • Serviços de TI
      • Computação em Nuvem
      • Gerenciamento de TI
      • IBM Cloud
      • Suporte Infraestrutura
  • INSTITUCIONAL
    • Sobre a SoftSell
  • BLOG
Oracle Database 12c R2: New Features for Administrators Part 2
Publicada em 11 de abril de 2018 na categoria
Slider
logo_oracle

Database 12c R2: New Features for Administrators 2

Sobre este Treinamento

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 2 course constituted by five modules:
1- Securing Data module
2- Making Data Available module
3- Partitioning Data module
4- Managing Information Lifecycle module and the Monitoring DB Operations
5- Managing Performance module

Students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration like Unified Auditing, Transparent Data Encryption (TDE) and other areas of security, Recovery Manager, online operations, Oracle Data Pump, SQL*Loader, new partitioning methods, Automatic Data Optimization, In-Memory Column Store, Full Database In-Memory Caching, and Automatic Big Table Caching.

Learn To:

Gain an understanding of the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as security, availability, partitioning, performance, and Information Lifecycle Management (ILM).

Benefits to You

Benefit from getting a thorough understanding of the following lessons:
 
  • The lessons of the Securing Data module cover enhancements in auditing like role based conditional auditing, in privilege administration like new system administrative privilege for RAC, in Privilege Analysis and Data Redaction, in Transparent Sensitive Data Protection with new types of policies for FGA and TDE, and finally also in Transparent Data Encryption (TDE)
  • The lessons of the Making Data Available module cover enhanced features in RMAN like table recovery, transport data across platforms, enhancements related to online operations, and finally ongoing enhancements with Oracle Data Pump, SQL*Loader and external tables
  • The lesson of the Partitioning Data module covers enhancements and new partitioning methods
  • The lessons of the Managing Information Lifecycle module introduce Heat Map and Automatic Data Optimization with heat map statistics tracking and ADO policies
  • The lessons also cover Temporal functionalities such as temporal history and temporal validity. In-Database Archiving provides a new feature, the Row-archival
  • The lessons of the Monitoring DB Operations and Managing Performance module explain the new features to improve the performance of the databases with SQL Performance Analyzer, DB Replay and SQL Plan Management, and to improve query execution with the Optimizer Statistics Advisor, JOIN processing
  • You will also learn about In-Memory Database option

Carga Horária: 5 dias

GARANTIR MINHA VAGA!

Pré-requisito

Required Prerequisites
Knowledge of Oracle Database 11g R2
Knowledge of Oracle Multitenant Container Database architecture

Suggested Prerequisites
Oracle Database 12c R2: New Features for Admin Part 1 Ed 1
Oracle Enterprise Manager Cloud Control 13c: Install & Upgrade Ed 1
Oracle Enterprise Manager Cloud Control 13c: Install & Upgrade Ed 2

Database Administrators
Users System Administrator

Público-alvo

Conteúdo

Tópicos principais

  • Manage security by using Unified Auditing
  • Manage security by using privileges and profiles
  • Manage security by using Privilege Analysis
  • Manage security by using Data Redaction
  • Manage security by using Transparent Data Encryption
  • Manage security by using Transparent Sensitive Data Encryption
  • Describe the new RMAN enhancements
  • Manage data availability by using new features of Oracle Data Pump, SQL*Loader and external tables
  • Manage data availability by performing online operations
  • Manage data partitioning
  • Manage Information Lifecycle by using ADO
  • Manage Information Lifecycle by using In-Database Archiving and Temporal features
  • Describe database operations
  • Configure and use In-Memory Column Store
  • Use In-Memory Caching
  • Use Real Application Testing enhancem

Introduction
Global objectives of the course
Lessons grouped by modules
Schedule of the week

Auditing Using Unified Audit
Quick review of 11g R2 audit trail implementation
Overview of the Unified Audit Trail
Creating and enabling audit policies for all users to whom the role is granted directly
Capturing VPD (Virtual Private Database) generated predicates

Controlling Data Access Using Privileges and Profiles
New 12.2 administrative privileges
Password file enhancements
Enhance the security of administrative users
Enforce the associated profile’s password limits
Using mandatory INHERIT PRIVILEGES privilege to execute invoker’s rights procedure
Using mandatory INHERIT PRIVILEGES privilege to select from BEQUEATH current_user views
Using new INHERIT (ANY) REMOTE PRIVILEGES privilege

Controlling Data Access Using Privilege Analysis
Overview of database privilege analysis
Granting the CAPTURE_ADMIN role to enable management of privilege captures
Creating and starting/stopping privilege captures and runs
Viewing privilege analysis result
Querying DBA_PRIV_CAPTURES

Redacting Data
Overview of Oracle Data Redaction
Types of Data Redaction Policies
New redaction format library in EM GUI
Redaction policy expression
Redacting with Nullify redaction function

Encrypting Data
Encrypt / decrypt / rekey tablespaces online
Configure automatic tablespace encryption

Controlling Data Access Using Transparent Sensitive Data Protection
Configure and use TSDP with VPD
Configure and use TSDP with Data Redaction
Configure and use TSDP with Unified Auditing
Configure and use TSDP with Fine-Grained Auditing (FGA)
Configure and use TSDP with Transparent Data Encryption (TDE)

Making Data Available by Using RMAN Features
RMAN enhancements
Transport Data Across Platforms
Table recovery
Automate the manual recovery process by using Recover Database Until Available Redo
REPAIR FAILURE command extented

Making Data Available by Using Oracle Data Pump, SQL*Loader and External Tables
Oracle Data Pump enhancements
SQL*Loader enhancements
Querying against external tables and overriding external table clauses

Making Data Available by Performing Online Operations
Describe online redefinition supports
Move and compress table partitions ONLINE

Partitioning Data
Enable reference partitioning with interval partitioned parent tables
Incorporate the CASCADE option for TRUNCATE PARTITION and EXCHANGE [SUB]PARTITION operations
Convert partitioning Range to Interval and vice-versa
Convert subpartitioning Range to Interval and vice-versa
Simplify the maintenance of (sub) partitioned tables
Composite partitioning

Managing Information Lifecycle Using ADO
Data classification in 12c : tablespace, group, object, row levels
Configure heat map
Automatic movement and compression
Compression levels and types
Policy declaration
Customized automated action execution with user-defined function
Execution in scheduled maintenance windows and by MMON
Customized schedule with DBMS_ILM package

Managing Information Lifecycle Using In-Database Archiving and Temporal
Challenges of old data in tables and 11g solutions
In-database archiving new solutions
Use ROW ARCHIVAL clause to enable row lifecycle state for applications
Set ROW ARCHIVAL VISIBILITY for session level visibility control
Use predicate on ORA_ARCHIVE_STATE column
Temporal Validity versus Temporal History (Transaction Time of FDA)
Set a Temporal Validity by using PERIOD FOR clause of CREATE / ALTER TABLE
New SQL temporal data type

Monitoring DB Operations and Performance
Overview
Use cases
Current Tools
Define a DB operation
Monitoring: Bracketing an Operation
Monitoring the Progress of Operations
DB Operation Tuning
DB Operation Active Rep

Configuring In-Memory Column Store
In-Memory Database option goals and benefits
Row format and columnar format
New SGA component
Deployment
Compression and priority in-memory segments attributes
Dictionary tables, added columns, IM statistics and IM Advisor
IM FastStart
Interaction with other products

Using In-Memory Column Store
Caching results of frequently evaluated expressions and virtual columns
Optimizing joined columns by creating join groups

Improving Performance Using In-Memory Caching
Setting up Full Database In-Memory Caching
Explaining the two buffer replacement algorithms of Automatic Big Table Caching
Configuring Automatic Big Table Caching with DB_BIG_TABLE_CACHE_PERCENT_TARGET initialization parameter
Using Automatic Big Table Caching

Improving SQL Performance
Statistics gathering performance improvements: Optimizer Statistics Advisor
Adaptive Execution Plan
Benefit from automatic dynamic sampling

Using Real Application Testing Enhancements
SQL Performance Analyzer enhancements
SQL Plan Management enhancements
Database Replay enhancements

Improving Performance Using Other Features
Manage session PGA limit
Multiple indexes on the same set of columns
Describe Advanced Row Compression and Avanced Index Compression HIGH level
Reduce Cursor Invalidations for DDLs
Define real-time materialized views with on query computation and ON STATEMENT refresh materialized views
Using multi-process multi-threaded Oracle architecture
Describe Database Smart Flash Cache enhancements
Use temporary undo for your temporary tables

Acesse o Calendário de Treinamentos

Atendimento Personalizado

Para saber mais sobre os treinamentos, certificações e soluções de TI da SoftSell, entre em contato com a gente.
É só escolher o seu canal preferido e aguardar breve resposta em horário comercial:

Curitiba: 41 3204.1999
Demais localidades: 4007.2186
WhatsApp : 41 98754.3534
Email: [email protected]
 

ENDEREÇO
Rua Emiliano Perneta, 680 – 9º Andar
Centro – Curitiba – Paraná – 80420-080

    Relacionado

    TREINAMENTOS E CERTIFICAÇÕES

    • Treinamentos e Certificações
    • Certificações em TI
    • Inscrições

    INFRAESTRUTURA DE TI

    • Software e BI
    • Serviços
    • Produtos e Equipamentos

    SOFTSELL

    • Sobre a SoftSell
    • Trabalhe Conosco

    ATENDIMENTO

    Telefone SoftSell Curitiba 41 3204.1999

    Telefone SoftSell Demais localidades 4007.2186

    Whatssap SoftSell WhatsApp 41 98754.3534

    Contato SoftSell [email protected]

     


    Rua Emiliano Perneta, 680 – 9º Andar – Centro – Curitiba – Paraná – 80420-080

    Siga-nos

    • Ver perfil de softsell no Facebook
    • Ver perfil de softsell.treinamentos no Instagram
    • LinkedIn

    CERNE Informática Ltda. | Todos os Direitos Reservados | Desenvolvido por Pontodesign

    Pontodesign
    © 2021 SoftSell • Distribuído por GeneratePress
    Voltar ao topo