Vantagem+, Consultores de Formação - Empresas

  Home      Mapa do Site      Pesquisar      Subscrever Newsletter   


      > Outros países    
> Ver Mais

Oracle 12c - Administração da Base de Dados

Datas de Início de Lisboa, Porto e Leiria (2017/2018)
(Clique nas datas para efectuar inscrição)
Out Nov Dez Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez
Ref# COR142Nº de Dias: 4 dias
 Inscrição    Info    Alerta    Enviar a amigo       Download PDF    FAQ


Oracle 12c - Administração da Base de Dados





Databases represent the core of an organization's informational infrastructure. It is imperative for administrators to be well trained. In this course, you gain the knowledge and skills to create and configure Oracle 12c databases, manage memory and storage effectively, and deploy essential procedures to maintain your organization's database and ensure its availability.





After completing this course, students will be able to:

·         Create, configure and maintain Oracle 12c databases

·         Automate database administration using OEM Cloud Control 12c

·         Ensure database security by managing user privileges and roles

·         Manage storage to optimize space and performance

·         Implement Oracle partitions to manage large tables and indexes

·         Deploy appropriate backup, recovery and flashback procedures





This course is designed for professionals whose work involves the administration of an Oracle 12c database, as well as anyone involved in working with databases who may be tasked with administering Oracle database.






This course is designed for professionals whose work involves the administration of an Oracle 12c database, as well as anyone involved in working with databases who may be tasked with administering Oracle databases. Experience equivalent to Course COR140_Oracle 12c - Introdução is assumed.





24 Hours





1 -    Overview of Oracle Database 12c Administration

·         Configuring the instance and database

·          Balancing user requirements and resources

·          Ensuring database availability

·         Conceptualizing the Oracle 12c architecture

·          Processing transactions with the Oracle 12c server

·          Identifying types of processes, memory structures and files

2 -    Constructing an Oracle 12c Database

·         Creating the database

·          Automating memory allocation with memory targets

·          Establishing network connectivity

·          Setting up control files and online redo log files

·         Starting and stopping the database

·          Mounting and opening the database

·          Authenticating connections having SYSDBA privilege

3 -    Automating administration with Oracle Enterprise Manager (OEM) Cloud Control 12c

·         Evaluating the OEM architecture

·          Navigating the graphical interface

·          Comparing command-line and graphical techniques

·         Maintaining the database with OEM Cloud Control 12c

·          Setting thresholds and generating alerts

·          Managing privileges and roles

·          Evaluating container and pluggable databases

4 -    Flashing Back Oracle 12c Data

·         Configuring UNDO tablespaces

·          Setting UNDO retention targets

·          Switching to an alternative UNDO tablespace

·         Monitoring and reversing changes to data

·          Tracking changes to data values with row history

·          Backing out user errors with Flashback Table

·          Retrieving dropped tables from the recycle bin

·          Implementing the Valid Time support feature

5 -    Managing Users and Resources

·         Establishing user accounts

·          Authenticating users with Oracle 12c password validation

·          Allocating space quotas and limiting resource usage

·         Enforcing security

·          Granting and revoking system and object privileges

·          Simplifying privilege management with roles

·          Capturing the use of privileges with dbms_privilege_capture

6 -    Performing Space Management

·         Building the storage hierarchy

·          Configuring tablespaces and datafiles

·          Handling sort data with temporary tablespaces

·          Creating Oracle Managed Files

·         Structuring data and index segments

·          Managing extents, blocks and large objects (LOB) storage

·          Eliminating row migration with PCTFREE and Data Pump

·          Conserving storage by compressing table data

·          Regaining space by shrinking tables and indexes online

7 -    Partitioning for Performance and Administration

·         Creating partitioned and subpartitioned tables

·          Evaluating range, list and hash partitioning methods

·          Administering partitions with merge, split, add and drop

·          Deploying partitioned tables based on virtual columns and referenced tables

·         Maintaining index partitions

·          Comparing the performance and maintenance of local and global indexes

·          Monitoring index partitions and rebuilding unusable indexes

·          Limiting indexing of partitions with partial indexing

8 -    Building a Fault-Tolerant Database

·         Safeguarding the database

·          Role of the redo log and control file

·          Ensuring recovery using archiving

·          Protecting and tracing the control file

·         Backing up the database and performing recovery

·          Implementing user-managed hot and cold backups

·          Restoring and recovering the entire database

·          Recovering corrupted tablespaces

·          Managing logical errors with flashback transaction back out


Preço 1º Participante:Preço 2º Participante:Preço 3º Participante:
1.990 EUR990 EUR890 EUR
Horário: 9h30 às 12h30 e das 14h00 às 17h00
Online Enrollement.

Come to to learn more
To subscribe 4 or more participants in the same training course, please contact our commercial department and together we can define a solution that will accommodate most situations.
All of our speakers have both the practical experience and knowledge in their areas, needed for such training.
As we both respect and understand the needs of clients with regard to both the availability and compliance to the No Cancel Policy, in this way we once a person has subscribed in a Vantagem + course he or she will be guaranteed that the course will occur on the predicted time and date(s).
Knowing the needs of each client we can organise and prepare all training programmes with success, according to the preferences of times, dates and locations given by our client.

Contacts Lisbon Contacts Porto
Largo Machado de Assis, 7C
Edificio Roma-Parque
(junto à Rua Conde de Sabugosa perpendicular à Av. de Roma)
1700-116 Lisboa

Tel: +351 21 849 33 33 / 50
Fax: +351 21 848 61 81
Edificio Tower Plaza,
Rotunda Engº Edgar Cardoso, Nº23-6º-G
4400-676 Vila Nova de Gaia
Tel: +351 22 606 50 77
Fax: +351 22 606 50 78 

 Inscrição    Info    Alerta    Enviar a amigo       Download PDF    FAQ
Outras Informações
Os preços  e incluem Coffee Breaks e Documentação. 

Aos valores acresce IVA à taxa legal em vigor.

Todos os cursos podem ser realizados em versão Intra-Empresa e também em Horário Pós Laboral. CONSULTE-NOS!

Tel. +351 21 849 33 33 / 50 Fax. +351 21 848 61 81 e-mail:

Tel. +351 22 606 50 77 Fax. +351 22 606 50 78 e-mail:

Tel. +351 24 457 75 97 Fax. +351 24 457 75 99 e-mail:

Tel. +244 222 718 081 ou +244 913 787 355 ou +244 944 541 910 ou +351 939 580 367 e-mail:

Tel. +258 844 985 751 ou +258 824 668 190 ou +351 939 580 367 ou +351 218 493 333 e-mail:

Bookmark and Share
Empresa  |   Os Nossos Serviços  |   Soluçóes Intra-Empresas  |   Clientes e Testemunhos  |   Inscrições  |   Apoio a Cliente  |   FAQ  |   Emprego  |   Contactos  |   Tabela de Áreas Formação  
©2014 Vantagem +. Direitos Reservados.

        LISBOA: Largo Machado Assis, 7C Edifício Roma-Parque | 1700-116 Lisboa | Tel: +351 218 493 333 | Fax: +351 218 486 181
        PORTO: Edifício Tower Plaza, Rotª Engº Edgar Cardoso, Nº 23 - 6º - G | 4400-676 Vila Nova de Gaia | Tel: +351 226 065 077
        LEIRIA: Centro de Negócios Maper, EN 242 - Albergaria, 2430-011 Marinha Grande | Tel: +351 244 577 597
        LUANDA: Bairro do Miramar, Praça da Unidade Africana Nº20 | Luanda ? Angola | Tel: +244 222 718 081 | Tel: +244 913 787 355 | Tel: +244 944 541 910
        MAPUTO: Av. 25 de Setembro, nº1147, 2º | Maputo | Tel: +258 824 668 190 | +351 218 493 333

Palavras mais pesquisadas
access acess acesso administrativos ajax ambiente Analise apresentação ar arquivo artes assistente Atendimento auditoria autocad balance balanced scorecard banca base de dados bcp Business Objects business plan cdps clientes cmmi co coaching com competências compras Comunicação comunicação escrita comunicar conflitos contabilidade contratos corel crm custos dados dim direito disaster Do Documentação Técnica de Requisitos domino e-commerce emocional eneagrama Equipa escrita eventos excel exchange Finanças fiscalidade Flash form formação formador formadores fornecedores ge gerir o caos gestão gestão de equipas GESTAO DE PROJECTOS gestão de projectos gestão do tempo gfi higiene html in indesign indicadores inovação internacionalização iso itil Java laboral laboratório lan li Liderança linux logistica logística lotus manutenção marketing melhorar a comunicação escrita métodos microsoft project mini mba Modelo mysql negociação noções oracle organização parcerias photoshop php planeamento plano plano oficial pmp politicas powerpoint Pr preço prince pro processos progra programação project PROJECTOS protocolo protocolo empresarial qualidade recursos humanos red hat redes reporting services requisitos responsabilidade social reuniões risco secretaria secretariado segurança sharepoint shell script snc spss sql sql server sql server 2005 stress tcp técnicas tempo testes testes de software tra trabalho UML unix VBA ve venda VENDAS visual basic word xml