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
      • Webinar CEH – Certified Ethical Hacker v10
    • 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
    • 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
      • Salesforce ADX 201
      • Salesforce ADX 251
      • Salesforce ADX 261
      • Salesforce DEX 450
      • Salesforce EEB101 + JB101
    • SoftSell
      • Gerenciamento Win Server 2012
      • Gestão de Projetos
      • Gestão de Projetos na era da Indústria 4.0
      • Linux Essentials
      • Pentest for Red Teams - Buffer Overflow Windows e Linux
      • Pentest for Red Teams – Web Application
      • Redes e Novas Tecnologias
    • 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: Administration Workshop
Publicada em 11 de abril de 2018 na categoria
Slider
logo_oracle

Database 12c R2: Administration Workshop Ed 3

Sobre este Treinamento

What you will learn

The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.

Learn To:

  • Manage an Oracle Database instance
  • Configure the Oracle Network environment
  • Create and manage storage structures
  • Manage and move data
  • Create and manage users
  • Monitor the database and manage performance
  • Create and manage Database as a Cloud Service database deployments

Benefits to You

You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

Carga Horária: 5 dias

GARANTIR MINHA VAGA!

Pré-requisito

Required Prerequisites
A working knowledge of SQL and PL/SQL packages is very helpful in the course

Suggested Prerequisites
Basic knowledge of Linux operating system

Data Warehouse Administrator
Database Administrators
Database Designers
Support Engineer
Technical Administrator

Público-alvo

Conteúdo

Tópicos Principais:

  • Back up, restore, and patch DBCS database deployments;
  • Describe the DBaaS and on-premises Oracle Database architectures;
  • Manage database instances;
  • Manage UNDO data;
  • Move data between databases;
  • Implement basic backup and recovery procedures;
  • Monitor and tune database performance;
  • Tune SQL to improve performance;
  • Manage resources with Oracle Database Resource Manager;
  • Create pluggable databases (PDBs);
  • Configure the Oracle network environment;
  • Administer user security and implement auditing;
  • Create and manage tablespaces;
  • Manage storage space;
  • Register databases and manage performance with Enterprise Manager Cloud Control;
  • Create and manage Database as a Cloud Service (DBCS) database deployments.

Introduction

  • Course Objectives
  • Course Organization
  • Course Agenda
  • Topics Not Included in the Course
  • Who Tunes?
  • What Does the DBA Tune?
  • How to Tune
  • Tuning Methodology

Basic Tuning Diagnostics

  • Performance Tuning Diagnostics
  • Performance Tuning Tools
  • Tuning Objectives
  • Top Timed Events DB Time
  • CPU and Wait Time Tuning Dimensions
  • Time Model
  • Dynamic Performance Views

Managing Database Instances

  • Initialization Parameter Files
  • Starting Up Oracle Databases
  • Shutting Down Oracle Databases
  • Opening and Closing PDBs
  • Working with the Automatic Diagnostic Repository (ADR)
  • Querying Dynamic Performance Views

Creating PDBs

  • Methods and Tools to Create PDBs
  • Creating PDBs from Seed with SQL*Plus
  • Cloning PDBs with SQL*Plus
  • Unplugging and Pluggin In PDBs with SQL*Plus
  • Dropping PDBs with SQL*Plus

Configuring the Oracle Network Environment

  • Oracle Net Services
  • How Listeners Work
  • Configuring Listeners for Dynamic Service Registration
  • Configuring Listeners for Static Service Registration
  • Configuring Local Naming for Connections
  • Testing Oracle Net Connectivity with tnsping
  • Configuring Communidation Between Databases
  • Dedicated Versus Shared Server Configurations

Administering User Security

  • Creating Users
  • Granting Privileges
  • Creating and Granting Roles
  • Revoking Privileges and Roles
  • Creating and Assigning Profiles
  • Authenticating Users
  • Assigning Quotas to Users
  • Applying the Principal of Least Privilege

Creating and Managing Tablespaces

  • How Table Data is Stored
  • Creating Tablespaces in SQL*Plus
  • Altering and Dropping Tablespaces in SQL*Plus
  • Viewing Tablespace Information in SQL*Plus
  • Implementing Oracle Managed Files
  • Moving and Renaming Online Data Files in SQL*Plus

Managing Storage Space

  • Oracle Database Space Management Features
  • Block Space Management
  • Row Chaining and Migration
  • Free Space Management Within Segments
  • Types of Segments
  • Allocating Extents
  • Understanding Deferred Segment Creation
  • Space-Saving Features

Managing UNDO Data

  • Undo Data  Overview
  • Transactions and Undo Data
  • Storing Undo Information
  • Comparing Undo Data and Redo Data
  • Managing Undo
  • Local Undo Mode Versus Shared Undo Mode
  • Configuring Undo Retension
  • Categories of Undo

Moving Data

  • Moving Data  General Architecture
  • Oracle Data Pump  Overview
  • Oracle Data Pump  Benefits
  • Data Pump Export and Import Clients
  • Data Pump Utility  Interfaces and Modes
  • Data Pump Import: Transformations
  • SQL*Loader Overview
  • Loading Methods

Backup and Recovery Concepts

  • DBA Responsibilities
  • Categories of Failure
  • Understanding Instance Recovery
  • Understanding Types of Backups
  • Comparing Complete and Incomplete Recovery
  • Oracle Data Protection Solutions
  • Flashback Technology

Monitoring and Tuning Database Performance

  • Managing Performance Activities
  • Performance Planning Considerations
  • Database Maintenance
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor
  • Performance Monitoring
  • Performance Tuning Methodology
  • Database Server Statistics and Metrics

SQL Tuning

  • SQL Tuning Process
  • Oracle Optimizer
  • Optimizer Statistics
  • SQL Plan Directives
  • Adaptive Execution Plans
  • SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Performance Analyzer

Oracle Database Resource Manager

  • Oracle Database Resource Manager: Overview
  • Resource Manager Elements
  • Using Resource Manager to Allocate Resources
  • Creating a Simple Resource Plan
  • Creating a Complex Resource Plan
  • Using the Active Session Pool Feature
  • Limiting CPU Utilization at the Database Level
  • Limiting CPU Utilization at the Server Level

Enterprise Manager Cloud Control

  • Controlling the Enterprise Manager Cloud Control Framework
  • Starting the Enterprise Manager Cloud Control Framework
  • Stopping the Enterprise Manager Cloud Control Framework

Introduction to Oracle Database Cloud Service

  • Oracle Cloud: Overview
  • Database Cloud Service Offerings
  • DBCS Architecture
  • Features and Tooling
  • Additional Database Configuration Options

Creating DBCS Database Deployments

  • Automated Database Provisioning
  • Creating a Database Deployment
  • How SSH Key Pairs are Used
  • Creating an SSH Key Pair
  • Storage Used for Database Files

Managing DBCS Database Deployments

  • Cloud Tooling
  • Accessing Tools and Features from the DBCS Console
  • Managing the Compute Node Associated With a Database Deployment
  • Managing Network Access to DBCS
  • Enabling Access to a Compute Node Port
  • Scaling a Database Deployment

Backing Up and Restoring DBCS Database Deployments

  • Backing Up and Recovering Databases on DBCS
  • Backup Destination Choices
  • Backup Configuration
  • Creating an On-Demand Backup
  • Customizing the Backup Configuration
  • Performing Recovery by Using the Console
  • Performing Recovery by Using the dbaascli Utility

Patching DBCS Database Deployments

  • Patching DBCS
  • Using the DBCS Console to Manage Patches
  • Using the dbaascli Utility to Manage Patches

Creating Master Encryption Keys for PDBs

  • CDB and PDB Master Encryption Keys
  • Determining Whether You Need to Create and Activate and Encryption Key for a PDB
  • Creating and Activating an Encryption Key

Tablespace Encryption by Default

  • Tablespace Encryption by Default in DBCS
  • Transparent Data Encryption (TDE) Overview
  • Components of TDE
  • Using TDE
  • Defining the Keystore Location
  • Controlling Tablespace Encryption by Default
  • Managing the Software Keystore and Master Encryption Key
  • Managing the Keystore in CDBs and PDBs
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

    SoftSell – Todos os Direitos Reservados | Desenvolvido por Pontodesign

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