Préparation à la Certification : Oracle Database 12c : Installation et Administration

QUESTIONS ?

Préparation à la Certification : Oracle Database 12c : Installation et Administration

Prix: 220 €Durée: 1 jourCode de Réference: D96684 Catalogue ,
Oracle Database 12c
Print Friendly, PDF & Email



Ce séminaire de préparation et de révision vous aide à préparer l'examen de certification Oracle Database 12c: Installation et Administration (1Z0-062).

Objectifs de la formation

A l’issue de cette formation Oracle, vous serez capable de :

  • Review key technologies and certification concepts related to Oracle Database 12c: Advanced Administration.
  • Understand the depth and breadth of the Oracle Database Administrator.
  • Get information that will help you complete your preparation and study.
  • Receive tips and information that will help you on the test.
  • Learn from one of Oracle University's top instructors.

Public

Cette formation s'adresse aux concepteurs de base de données, développeurs de base de données et administrateurs de base de données.

Prérequis

Avoir suivi les cours Oracle Database 12c: SQL and PL/SQL Fundamentals, Oracle Database: Administration Workshop et Oracle Database : Deploy, Patch and Upgrade Workshop ou disposer de connaissances et compétences équivalentes.

Compréhension de l’anglais et du vocabulaire anglais spécifique IT.

Vous souhaitez faire vérifier vos prérequis ? Contactez-nous pour l’organisation d’un entretien téléphonique avec un de nos consultants formateurs.

Programme

  • Exploring the Oracle Database Architecture
  • List the architectural components of Oracle Database Explain the memory structures Describe the background processes Explain the memory structures

  • Oracle Database Instance
  • Understand initialization parameter files Start up and shut down an Oracle database instance View the alert log and access dynamic performance views

  • Configuring the Oracle Network Environment
  • Configure Oracle Net Services Use tools for configuring and managing the Oracle network Configure client-side network Troubleshoot network issues Configure communication between databases Configure shared servers

  • Monitoring and Managing Memory
  • Implement Automatic Memory Management Implement Automatic Shared Memory Management Manually configure SGA parameters for various memory components in the SGA Use Automatic PGA Memory Management

  • Storage Management
  • Describe the storage of table row data in blocks Create and manage tablespaces Create and maintain bigfile tablespaces Rename tablespaces Create a default permanent tablespace Relocate SYSAUX occupants

  • Space Management
  • Explain how Oracle database server automatically manages space Save space by using compression Proactively monitor and manage tablespace space usage Use the Segment Advisor

  • Resumable Space Allocation and Segment Shrinking
  • Manage resumable space allocation Reclaim wasted space from tables and indexes by using the segment shrink functionality

  • Managing Undo Data
  • Explain DML and undo data generation Describe the difference between undo data and redo data Monitor and administer undo data Configure undo retention Use automatic undo retention tuning and temporary undo

  • Managing Data Concurrency
  • Describe the locking mechanism and how Oracle manages data concurrency Monitor and resolve locking conflicts

  • Privileges
  • Create and manage database user accounts Grant and revoke privileges Create and manage roles Create and manage profiles

  • Auditing
  • Explain DBA responsibilities for security and auditing Enable standard database auditing and unified auditing Enable and configure Unified Audit Data Trail

  • Automatic Storage Management
  • Automatic Storage Management Set up initialization parameter files for ASM and database instances Start up and shut down ASM instances Administer ASM diskgroups Set up ASM fast mirror resync Execute SQL commands with ASM file names Use the ASMCMD command-line interface

  • Backup and Recovery Concepts
  • Identify the importance of checkpoints, redo log files, and archive log files Configure ARCHIVELOG mode

  • Configuring Recovery Manager
  • Create and maintain the Fast Recovery Area Configure database parameters that affect RMAN operations Change RMAN default settings with CONFIGURE Manage RMAN's persistent settings Start the RMAN utility and allocate channels

  • Basics of Using RMAN to Create Backups
  • Create backupsets and image copies Create a whole database backup Perform full and incremental backups Enable fast incremental backup Report on and maintain backups

  • Performing Recovery
  • Determine the need for performing recovery Perform complete recovery from a critical or noncritical data file loss using RMAN Recover the control file Recover a redo log group member

  • Loading and Unloading Data
  • Describe ways to move data Use SQL*Loader to load data from a non-Oracle database Explain Data Pump architecture Use Data Pump export and import Monitor a Data Pump job Use Oracle Data Pump enhancements (in 12c) Create external tables for data population Use SQL*Loader and External table enhancements (in 12c)

  • Managing Resources
  • Configure the Resource Manager Assign users to Resource Manager groups Create resource plans within groups Specify directives for allocating resources to consumer groups Monitor the Resource Manager

  • Proactive Performance Management
  • Manage the Automatic Workload Repository (AWR) Use the Automatic Database Diagnostic Monitor (ADDM) Describe and use the advisory framework Set alert thresholds Use automated tasks Manage optimizer statistics Use the Memory Advisor to size memory buffers Use the Redo Logfile Size Advisor

  • Using the SQL Tuning and Access Advisor
  • Use the SQL Tuning Advisor Use the SQL Access Advisor to tune a workload

  • Automating Tasks with the Scheduler
  • Use Oracle Scheduler to simplify management tasks Create a job, program, and schedule Use a time-based or event-based schedule for executing Scheduler jobs Use job chains to perform a series of related tasks Create lightweight jobs Create Windows and Job Classes Use advanced Scheduler concepts to prioritize jobs Use Scheduler jobs on remote systems

  • Installing Oracle Database 12c
  • Plan for an Oracle Database software installation Install Oracle Grid Infrastructure for a stand-alone server Install Oracle Database software Use OUI and DBCA for installation and configuration Use Oracle Restart (View the full list of topics on the exam page at certification.oracle.coView All Exams)

    Méthodes pédagogiques

    Alternance d'apports théoriques et d'exercices avec un vaste choix d'exercices pratiques et de scénarios d'atelier permettent de mettre en œuvre les connaissances acquises.

    La dernière version du support, en anglais, est disponible en ligne.
    Print Friendly, PDF & Email
    retour vers le catalogue des formations