Menu

Curso: Administración de la Base de Datos ORACLE v.12c


126 horas

Presencial

16/10/17

El programa de certificación Oracle, ofrece tres niveles de certificación distintos -Asociado, Profesional y Master - cada uno diseñado para validar grados de competencia en conceptos y usos de la Tecnología de Oracle.

Cada nivel ofrece un marco de referencia reconocido por la industria y que se aplica a roles de trabajo específicos.

Cas Training ofrece a través del convenio WDP y Partner, los niveles de certificación OCA y OCP:

  • La certificación Oracle Certified Associate (OCA), corresponde a un nivel básico, que da las bases para dar soporte a productos Oracle.
  • La certificación Oracle Certified Professional (OCP), representa el nivel de experto avanzado necesario para administrar base de datos de gran escala o para desarrollar aplicaciones que se puedan poner en funcionamiento a nivel global en una organización.

La obtención de la Certificación OCP acredita las aptitudes de una persona aumentando su credibilidad profesional con reconocimiento a nivel mundial, garantizando un alto nivel de conocimientos técnicos y experiencia en la administración de la BBDD Oracle.

Es el mejor aliado para desarrollar una prometedora carrera profesional en el sector de las tecnologías de la información.

Los profesionales certificados como OCP tienen una alta demanda en el mundo actual y se espera que dicha demanda crezca al aumentar el número de instalaciones de tecnologías de Oracle alrededor del mundo.

Prestaciones

  • Documentación OFICIAL de Oracle University. Esta documentación solo la podrás obtener con nosotros o recibiendo un curso de calendario directamente en el fabricante. Se facilita en formato electrónico.
  • 25% de descuento en los exámenes de certificación haciendo la gestión a través de Cas-Training.
  • Un ordenador por persona.
  • Posibilidad de hacer prácticas en el aula.

Con este curso aprenderá a combinar varias consultas en una sola utilizando operadores SET y a crear informes agregando datos utilizando las funciones de grupo. Aprenda esto y mucho más haciendo multitud de ejercicios y prácticas.

Obtendrá conceptos sólidos de Instalación y Administración de Bases de datos Oracle 12c. El estudiante aprenderá a instalar Oracle Grid Infrastructure en un servidor independiente, a utilizar Oracle Restart para administrar los componentes, a actualizar una base de datos existente de Oracle a Oracle Database 12c, a crear un contenedor de base de datos y a provisionar bases de datos conectables, a crear y administrar una instancia de base de datos Oracle, a crear y gestionar estructuras de almacenamiento, a configurar el entorno de red de Oracle, a crear y gestionar usuarios, a supervisar la base de datos y a ge stionar el rendimiento, a conocer la información básica sobre las técnicas de copia de seguridad y recuperación y a usar el Soporte Workbench Oracle y My Oracle Support para actualizar el software de su base de datos Oracle.

En este taller le ayudaremos a entender todos los conceptos relativos a la arquitectura multitenant. Usted practicará como conectar y desconectar las bases de datos en bases de datos de contenedor multitenant, mientras aprende cómo crear usuarios comunes y locales y administrar la seguridad de base de datos para satisfacer sus necesidades de negocio. Aprenderá a comprender la arquitectura multitenant, creación, gestión, administración del almacenamiento, administración de la seguridad, supervisión del rendimiento y gestión de los recursos, realización de copias de seguridad, recuperación y operaciones de flashback de una base de datos una base de datos contenedor multitenant y bases de datos enchufables. Gestionar la CDB y PDB en configuraciones específicas, como Data Guard, Database Vault y a realizar operaciones concretas como el transporte, la carga, el cifrado y la auditoría con Oracle Data Pump.

D80174GC11S Oracle Database 12c: Introduction to SQL, 1.1 English

  • Introduction to Oracle Database
    • List the features of Oracle Database 12c.
    • Discuss the basic design, theoretical, and physical aspects of a relational database.
    • Categorize the different types of SQL statements.
    • Describe the data set used by the course.
    • Log on to the database using SQL Developer environment.
    • Save queries to files and use script files in SQL Developer.
  • Retrieve Data using the SQL SELECT Statement
    • List the capabilities of SQL SELECT statements.
    • Generate a report of data from the output of a basic SELECT statement.
    • Select All Columns.
    • Select Specific Columns.
    • Use Column Heading Defaults.
    • Use Arithmetic Operators.
    • Understand Operator Precedence.
    • Learn the DESCRIBE command to display the table structure.
  • Learn to Restrict and Sort Data
    • Write queries that contain a WHERE clause to limit the output retrieved.
    • List the comparison operators and logical operators that are used in a WHERE clause.
    • Describe the rules of precedence for comparison and logical operators.
    • Use character string literals in the WHERE clause.
    • Write queries that contain an ORDER BY clause to sort the output of a SELECT statement.
    • Sort output in descending and ascending order.
  • Usage of Single-Row Functions to Customize Output
    • Describe the differences between single row and multiple row functions.
    • Manipulate strings with character function in the SELECT and WHERE clauses.
    • Manipulate numbers with the ROUND, TRUNC, and MOD functions.
    • Perform arithmetic with date data.
    • Manipulate dates with the DATE functions.
  • Invoke Conversion Functions and Conditional Expressions
    • Describe implicit and explicit data type conversion.
    • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions.
    • Nest multiple functions.
    • Apply the NVL, NULLIF, and COALESCE functions to data.
    • Use conditional IF THEN ELSE logic in a SELECT statement.
  • Aggregate Data Using the Group Functions
    • Use the aggregation functions to produce meaningful reports.
    • Divide the retrieved data in groups by using the GROUP BY clause.
    • Exclude groups of data by using the HAVING clause.
    • Display Data From Multiple Tables Using Joins.
    • Write SELECT statements to access data from more than one table.
    • View data that generally does not meet a join condition by using outer joins.
    • Join a table to itself by using a self join.
  • Use Sub-queries to Solve Queries
    • Describe the types of problem that sub-queries can solve.
    • Define sub-queries.
    • List the types of sub-queries.
    • Write single-row and multiple-row sub-queries.
  • The SET Operators
    • Describe the SET operators.
    • Use a SET operator to combine multiple queries into a single query.
    • Control the order of rows returned.
    • Data Manipulation Statements.
    • Describe each DML statement.
    • Insert rows into a table.
    • Change rows in a table by the UPDATE statement.
    • Delete rows from a table with the DELETE statement.
    • Save and discard changes with the COMMIT and ROLLBACK statements.
    • Explain read consistency.
  • Use of DDL Statements to Create and Manage Tables
    • Categorize the main database objects.
    • Review the table structure.
    • List the data types available for columns.
    • Create a simple table.
    • Decipher how constraints can be created at table creation.
    • Describe how schema objects work.
  • Other Schema Objects
    • Create a simple and complex view.
    • Retrieve data from views.
    • Create, maintain, and use sequences.
    • Create and maintain indexes.
    • Create private and public synonyms.
  • Control User Access
    • Differentiate system privileges from object privileges.
    • Create Users.
    • Grant System Privileges.
    • Create and Grant Privileges to a Role.
    • Change Your Password.
    • Grant Object Privileges.
    • How to pass on privileges?.
    • Revoke Object Privileges.
  • Management of Schema Objects
    • Add, Modify, and Drop a Column.
    • Add, Drop, and Defer a Constraint.
    • How to enable and Disable a Constraint?.
    • Create and Remove Indexes.
    • Create a Function-Based Index.
    • Perform Flashback Operations.
    • Create an External Table by Using ORACLE_LOADER and by Using ORACLE_DATAPUMP.
    • Query External Tables.
  • Manage Objects with Data Dictionary Views
    • Explain the data dictionary.
    • Use the Dictionary Views.
    • USER_OBJECTS and ALL_OBJECTS Views.
    • Table and Column Information.
    • Query the dictionary views for constraint information.
    • Query the dictionary views for view, sequence, index and synonym information.
    • Add a comment to a table.
    • Query the dictionary views for comment information.
  • Manipulate Large Data Sets
    • Use Subqueries to Manipulate Data.
    • Retrieve Data Using a Subquery as Source.
    • Insert Using a Subquery as a Target.
    • Usage of the WITH CHECK OPTION Keyword on DML Statements.
    • List the types of Multitable INSERT Statements.
    • Use Multitable INSERT Statements.
    • Merge rows in a table.
    • Track Changes in Data over a period of time.
  • Data Management in different Time Zones
    • Time Zones.
    • CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP.
    • Compare Date and Time in a Session’s Time Zone.
    • DBTIMEZONE and SESSIONTIMEZONE.
    • Difference between DATE and TIMESTAMP.
    • INTERVAL Data Types.
    • Use EXTRACT, TZ_OFFSET and FROM_TZ.
    • Invoke TO_TIMESTAMP,TO_YMINTERVAL and TO_DSINTERVAL.
  • Retrieve Data Using Sub-queries
    • Multiple-Column Subqueries.
    • Pairwise and Nonpairwise Comparison.
    • Scalar Subquery Expressions.
    • Solve problems with Correlated Subqueries.
    • Update and Delete Rows Using Correlated Subqueries.
    • The EXISTS and NOT EXISTS operators.
    • Invoke the WITH clause.
    • The Recursive WITH clause.
  • Regular Expression Support
    • Use the Regular Expressions Functions and Conditions in SQL.
    • Use Meta Characters with Regular Expressions.
    • Perform a Basic Search using the REGEXP_LIKE function.
    • Find patterns using the REGEXP_INSTR function.
    • Extract Substrings using the REGEXP_SUBSTR function.
    • Replace Patterns Using the REGEXP_REPLACE function.
    • Usage of Sub-Expressions with Regular Expression Support.
    • Implement the REGEXP_COUNT function.

D79027GC10–Oracle Database 12c: Admin, Install and Upgrade Accelerated

  • Introduction
    • Course Objectives.
    • Course Schedule.
    • Overview of Oracle Database 12c.
    • Overview of Oracle Cloud.
    • Overview of the HR Schema.
  • Exploring the Oracle Database Architectur.
    • Oracle Database 12c Introduction.
    • Oracle Database Architecture: Overview.
    • Oracle Database Instance Configurations.
    • Connecting to the Oracle Database Instance.
    • Oracle Database memory Structures (overview).
    • Process Architecture (description).
    • Process Structures.
    • Process Startup Sequen.
  • Oracle Software Installation Basics
    • Planning Your Installation.
    • Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM.
    • Operating System Groups and Users.
    • Environment Variables.
    • Configuring the Oracle Software Owner Environment.
    • Using Oracle Universal Installer (OUI).
    • Installation Option: Silent Mode.
  • Installing Oracle Database Software
    • System Requirements for Oracle Database.
    • Operating.
    • Types of Installations.
  • Creating an Oracle Database by Using DBCA
    • Planning the Database Storage Structure.
    • Types of Databases (based on workload).
    • Choosing the Appropriate Character Set.
    • Understanding How Character Sets are Used.
    • Setting the NLS_LANG Initialization Parameter.
    • Using the Database Configuration Assistant (DBCA).
  • Oracle Database Management Tools
    • Introducing Oracle Database Management Tools.
    • Using SQL*Plus.
    • Using SQL Developer.
    • Logging in to Oracle Enterprise Manager Database Express.
    • Using the Enterprise Manager Database Express Home Pag.
    • Understanding the Enterprise Manager Cloud Control Framework.
    • Using Enterprise Manager Cloud Control.
  • Managing the Database Instance
    • Initialization Parameter Files.
    • Starting an Oracle Database Instance.
    • Shutting Down an Oracle Database Instance.
    • Viewing Log Files.
    • Using Trace Files.
    • Using the Dynamic Performance Views.
    • Data Dictionary.
  • Configuring the Oracle Network Environment
    • Oracle Net Services Overview.
    • Oracle Net Listener Overview.
    • Establishing Oracle Network Connections.
    • Connecting to a Server.
    • Tools for Configuring and Managing the Oracle Network.
    • Using the Listener Control Utility.
    • Using Oracle Net Configuration Assistant.
    • Using Oracle Net Manager.
  • Administering User Security
    • Database User Accounts (overview).
    • Predefined Administrative Accounts.
    • Creating a User.
    • Authentication.
    • Unlocking a User Account and Resetting the Password.
    • Privileges.
    • Roles.
    • Profiles.
  • Managing Database Storage Structures
    • Understanding Storage of Data.
    • Database Block contents.
    • Exploring the Storage Structure.
    • Creating a New Tablespace.
    • Overview of Tablespaces Created by Default.
    • Managing Tablespaces.
    • Viewing Tablespace Information.
    • Using Oracle Managed Files.
  • Managing Space
    • Space Management Overview.
    • Block Space Management.
    • Row Chaining and Migration.
    • Free Space Management Within Segments.
    • Types of Segments.
    • Allocating Extents.
    • Allocating Space.
    • eating Tables Without Segments.
  • Managing Undo Data
    • Undo Data Overview.
    • Transactions and Undo Data.
    • Storing Undo Information.
    • Comparing Undo Data and Redo Data.
    • Managing Undo.
    • Configuring Undo Retention.
    • Guaranteeing Undo Retention.
    • Changing an Undo tablespace to a Fixed Size.
  • Managing Data Concurrency
    • Overview of Locks.
    • Locking Mechanism.
    • Data Concurrency.
    • DML Locks.
    • Enqueue Mechanism.
    • Lock Conflicts.
  • Implementing Oracle Database Auditing
    • Separation of Responsibilities.
    • Database Security.
    • Monitoring for Compliance.
    • Standard Database Auditing.
    • Unified Audit Data Trail.
    • Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles).
    • Configuring the Audit Trail.
    • Specifying Audit Options.
  • Backup and Recovery Concepts
    • Categories of Failures.
    • Flashback Technology.
    • Understanding Instance Recovery.
    • Phases of Instance Recovery.
    • Tuning Instance Recovery.
    • Using the MTTR Advisor.
    • Comparing Complete and Incomplete Recovery.
    • Oracle Data Protection Solutions.
  • Backup and Recovery Configuration
    • Configuring for Recoverability.
    • Configuring the Fast Recovery Area.
    • Multiplexing the Control File.
    • Online Redo Log File.
    • Multiplexing the Online Redo Log File.
    • Archived Redo Log Files.
    • Archiver Process.
    • Archived Redo Log File Naming and Destinations.
  • Performing Database Backups
    • Backup Solutions Overview.
    • Oracle Secure Backup (overview).
    • User Managed Backup (overview).
    • Backup Terminology and Types of Backups.
    • Using Recovery Manager (RMAN).
    • Configuring Backup Settings.
    • Oracle-Suggested Backup.
    • Backing Up the Control File to a Trace File.
  • Performing Database Recovery
    • Data Recovery Advisor.
    • Loss of a Control File.
    • Loss of a Redo Log File.
    • Loss of a Datafile in NOARCHIVELOG Mode.
    • Loss of a Noncritical Datafile in ARCHIVELOG Mode.
    • Loss of a System-Critical Datafile in ARCHIVELOG Mode.
  • Moving Data
    • Moving Data: General Architecture.
    • Oracle Data Pump.
    • SQL*Loader.
    • External Tables.
  • Performing Database Maintenance
    • Database Maintenance (overview).
    • Viewing the Alert History.
    • Terminology.
    • Automatic Workload Repository (AWR).
    • Statistic Levels.
    • Automatic Database Diagnostic Monitor (ADDM).
    • Advisory Framework.
    • Enterprise Manager and Advisors.
  • Managing Performance
    • Performance Monitoring.
    • Tuning Activities.
    • Performance Planning.
    • Instance Tuning.
    • Performance Tuning Methodology.
    • Performance Tuning Data.
    • Monitoring Performance.
    • Managing Memory.
  • Managing Performance: SQL Tuning
    • SQL Tuning.
    • Oracle Optimizer.
    • SQL Plan Directives.
    • Adaptive Execution Plans.
    • SQL Advisors.
    • Automatic SQL Tuning results.
    • Implement Automatic Tuning Recommendations.
    • SQL Tuning Advisor.

D78850GC10 – Oracle Database 12c: Backup and Recovery Workshop

  • Introduction
    • Curriculum Context.
    • Assess your Recovery Requirements.
    • Categories of failures.
    • Oracle Backup and Recovery Solutions.
    • Oracle Maximum Availability Architecture.
    • Oracle Secure Backup.
    • Benefits of using Oracle Data Guard.
    • Basic Workshop Architecture.
  • Getting Started
    • Core Concepts of the Oracle Database, Critical for Backup and Recovery.
    • Oracle DBA Tools for Backup and Recovery.
    • Connecting to Oracle Recovery Manager (RMAN).
    • Quick Start: A Problem-Solution Approach.
  • Configuring for Recoverablility
    • RMAN commands.
    • Configuring and managing persistent settings.
    • Using the Fast Recovery Area (FRA).
    • Control File.
    • Redo Log File.
    • Archiving Logs.
  • Using the RMAN Recovery Catalog
    • Creating and Configuring the Recovery Catalog.
    • Managing Target Database Records in the Recovery Catalog.
    • Using RMAN Stored Scripts.
    • Maintaining and Protecting the Recovery Catalog.
    • Virtual Private Catalogs.
  • Backup Strategies and Terminology
    • Backup Solutions Overview and Terminology.
    • Balancing Backup and Restore Requirements.
    • Backing Up Read-Only Tablespaces.
    • Best Practices for Data Warehouse Backups.
    • Additional Backup Terminology.
  • Performing Backups
    • RMAN Backup Types.
    • Incrementally Updated Backups.
    • Fast Incremental Backup.
    • Block Change Tracking.
    • Oracle-Suggested Backup.
    • Reporting on Backups.
    • Managing Backups.
  • Improving Your Backups
    • Compressing Backups.
    • Using a Media Manager.
    • Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets.
    • Creating and Managing Archival Backups.
    • Backing Up Recovery Files.
    • Backing Up the Control File to a Trace File.
    • Cataloging Additional Backup Files.
    • Backing Up ASM Disk Group Metadata.
  • Using RMAN-Encrypted Backups
    • Creating RMAN-Encrypted Backups.
    • Using Transparent-Mode Encryption.
    • Using Password-Mode Encryption.
    • Using Dual-Mode Encryption.
  • Diagnosing Database Failures
    • Reducing Problem Diagnosis Time.
    • Automatic Diagnostic Repository.
    • Interpreting RMAN Message Output and Error Stacks.
    • Data Recovery Advisor.
    • Diagnosing Data File Loss (file system and ASM).
    • Handling Block Corruption.
  • Restore and Recovery Concepts
    • Restoring and Recovering.
    • Instance Failure and Instance/Crash Recovery.
    • Media Failure.
    • Complete Recovery (Overview).
    • Point-in-Time Recovery (Overview).
    • Recovery Through RESETLOGS.
  • Performing Recovery, Part 1
    • RMAN Recovery in NOARCHIVELOG Mode.
    • Performing Complete Recovery (of critical and noncritical data files).
    • Restoring ASM Disk Groups.
    • Recovery with Image Files.
    • Performing Point-in-Time (PITR) or Incomplete Recovery.
    • Table Recovery from Backups.
  • Performing Recovery, Part 2
    • Recovery of Server Parameter File, Control File.
    • Redo Log File Loss and Recovery.
    • Password Authentication File Re-creation.
    • Index, Read-Only Tablespace, and Tempfile Recovery.
    • Restoring the Database to a New Host.
    • Disaster Recovery.
    • Restoring RMAN Encrypted Backups.
  • RMAN and Oracle Secure Backup
    • Oracle Secure Backup Overview.
    • Oracle Database Disk and Tape Backup Solution.
    • Backing Up the Fast Recovery Area to Tape.
    • Defining Retention for RMAN Backups.
    • RMAN and Oracle Secure Backup Basic Process Flow.
    • Integration with Cloud Control.
    • RMAN Database Backup to Tape.
  • Performing Tape Backups and Restores
    • Scheduling Backups with EM.
    • Oracle-Suggested Backup.
    • RMAN and OSB Process Flow.
    • RMAN and Oracle Secure Backup Jobs.
    • Managing Database Tape Backups.
    • Performing Database Recovery.
    • RMAN Automatic Failover to Previous Backup.
  • Using Flashback Technologies
    • Flashback Technology: Overview and Setup.
    • Using Flashback Technology to Query Data.
    • Flashback Table.
    • Flashback Transaction (Query and Backout).
    • Flashback Drop and the Recycle Bin.
    • Flashback Data Archive.
  • Using Flashback Database
    • Flashback Database Architecture.
    • Configuring Flashback Database.
    • Performing Flashback Database.
    • Best Practices for Flashback Database .
  • Managing Backup Space or Transporting Data
    • Transporting Tablespaces.
    • Transporting Databases.
  • Duplicating a Database
    • Using a Duplicate Database.
    • Choosing Database Duplication Techniques.
    • Creating a Backup-up Based Duplicate Database.
    • Understanding the RMAN Duplication Operation.
    • Using Cloud Control to Clone a Database.
  • RMAN Performance and Tuning
    • Tuning Principles.
    • RMAN Multiplexing.
    • Diagnosing Performance Bottlenecks.
    • Restore and Recovery Performance Best Practices.
  • Backup and Recovery Workshop
    • Workshop Structure.
    • Workshop Approach to Solving Failure Scenarios.
    • Business Requirements for Database Availability and Procedure.

Taller - Oracle Database 12c: Managing Multitenant Architecture

  • Introduction
    • Course Objectives.
    • Course Schedule.
    • Tools.
  • Container and Pluggable Database Architecture
    • Challenges and Benefits.
    • Multitenant Architecture.
    • Provisioning PDBs.
    • Terminology.
  • CDB and PDB Creation
    • Using Tools.
    • Configuring and Creating a CDB.
    • Creating PDBs.
    • Dropping PDBs.
    • Migrating PDBs.
  • Managing a CDB and PDBs
    • Connection.
    • Managing a CDB and PDBs.
    • Managing PDBs Open Mode and Settings.
    • Configuring CDB and PDBs Initialization Parameters.
  • Managing Storage in a CDB and PDBs
    • Managing Permanent Tablespaces in CDB and PDBs.
    • Managing Temporary Tablespaces in CDB and PDBs.
  • Managing Security in a CDB and PDBs
    • Managing Common and Local Users.
    • Managing Common and Local Privileges.
    • Managing Common and Local Roles.
    • Understanding Shared and Non-Shared Objects.
    • Managing Common and Local Profiles.
  • Managing Availability
    • Managing Backups.
    • Managing Recovery Operations.
    • Managing Flashback Database.
    • Duplicating PDBs.
    • Special Situations and Views.
  • Managing Performance
    • Managing Performance.
    • Managing Resource Allocation.
    • Maximizing Consolidated Database Replay.
  • Miscellaneous
    • Exporting and Importing Data.
    • Loading Data.
    • Auditing Operations.
    • Scheduling Jobs.
    • Using Other Products .
De acuerdo con lo dispuesto en la Ley Orgánica de Protección de Datos 15/99 de 13 de Diciembre, así como en su Reglamento de Aplicación (Real Decreto 1720/2007), Cas Training, S.L. se compromete a utilizar únicamente los datos que le solicitamos con el fin de prestarle información relativa a esta consulta. Por su seguridad, sus datos pasarán a formar parte de nuestro fichero automatizado con el objetivo de poder mantener el contacto con Ud. Si desea oponerse, acceder, cancelar o rectificar sus datos, póngase en contacto con Cas Training, S.L. al teléfono 915536162 o a través del correo electrónico info@cas-training.com.