Temario
La certificación Oracle Database 11g Administrator Certified Associate es una excelente forma de iniciarse en la carrera del Administrador de Bases de Datos (DBA). Durante este curso el alumno conocerá los fundamentos de la base de datos Oracle 11g, aprenderá a profundidad el manejo de SQL así como los componentes esenciales de la arquitectura de la base de datos Oracle 11g. Desde hacer una instalación hasta realizar optimizaciones, respaldos, recuperaciones y gestionar la seguridad de la base..
Objetivo
Iniciar la carrera del administrador de bases de datos brindándole los conocimientos y el reconocimiento oficial de Oracle como un DBA certificado.
Descripción
La certificación Oracle Database 11g Administrator Certified Associate es una excelente forma de iniciarse en la carrera del Administrador de Bases de Datos (DBA). Al ser una certificación oficial de Oracle, su reconocimiento es internacional. Esta certificación no tiene vigencia, por lo que no será necesario volver a presentar el examen para renovarla.
Durante este curso el alumno conocerá los fundamentos de la base de datos Oracle 11g, aprenderá a profundidad el manejo de SQL así como los componentes esenciales de la arquitectura de la base de datos Oracle 11g. Desde hacer una instalación hasta realizar optimizaciones, respaldos, recuperaciones y gestionar la seguridad de la base.
A quién está dirigido
Esta certificación está dirigida a profesionales de TI interesados en bases de datos y que cuenten con poca o ninguna experiencia con Oracle Database 11g.
Es altamente recomendable para aquellas personas interesadas en obtener un mejor sueldo o que están pensando en buscar una mejor oferta de trabajo.
Perfil del participante
Esta certificación no tiene ningún requisito previo, sin embargo tener conocimientos de diseño de bases de datos relacionales y/o experiencia con otros manejadores le ayudará a entender mucho más rápido los conceptos de Oracle.
Beneficios
Sin lugar a dudas Oracle es la base de datos relacional más usada en la industria. Obtener una certificación es una excelente herramienta para maximizar el potencial en la carrera del DBA. Esta certificación lo hará más valioso en su actual equipo de trabajo o le asegurará mejores oportunidades de un nuevo empleo.
Temario
Objetivos del examen 1Z0-051:
Retrieving Data Using the SQL SELECT Statement
List the capabilities of SQL SELECT statements
Execute a basic SELECT statement
Restricting and Sorting Data
Limit the rows that are retrieved by a query
Sort the rows that are retrieved by a query
Use ampersand substitution to restrict and sort output at runtime
Using Single-Row Functions to Customize Output
Describe various types of functions available in SQL
Use character, number, and date functions in SELECT statements
Using Conversion Functions and Conditional Expressions
Describe various types of conversion functions that are available in SQL
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply conditional expressions in a SELECT statement
Reporting Aggregated Data Using the Group Functions
Identify the available group functions
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause
Displaying Data from Multiple Tables
Write SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using outer joins
Generate a Cartesian product of all rows from two or more tables
Using Subqueries to Solve Queries
Define subqueries
Describe the types of problems that the subqueries can solve
List the types of subqueries
Write single-row and multiple-row subqueries
Using the Set Operators
Describe set operators
Use a set operator to combine multiple queries into a single query
Control the order of rows returned
Manipulating Data
Describe each data manipulation language (DML) statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions
Despliegue de aplicacionesUsing DDL Statements to Create and Manage Tables
Categorize the main database objects
Review the table structure
List the data types that are available for columns
Create a simple table
Explain how constraints are created at the time of table creation
Describe how schema objects work
Creating Other Schema Objects
Create simple and complex views
Retrieve data from views
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms
Objetivos del examen 1Z0-052:
Exploring the Oracle Database Architecture
Explain the Memory Structures
Describe the Process Structures
Overview of Storage Structures
Preparing the Database Environment
Identify the tools for Administering an Oracle Database
Plan an Oracle Database installation
Install the Oracle software by using Oracle Universal Installer (OUI)
Creating an Oracle Database
Create a database by using the Database Configuration Assistant (DBCA)
Managing the Oracle Instance
Setting database initialization parameters
Describe the stages of database startup and shutdown
Using alert log and trace files
Using data dictionary and dynamic performance views
Configuring the Oracle Network Environment
Configure and Manage the Oracle Network
Using the Oracle Shared Server architecture
Managing Database Storage Structures
Overview of tablespace and datafiles
Create and manage tablespaces
Space management in tablespaces
Administering User Security
Create and manage database user accounts
Grant and revoke privileges
Create and manage roles
Create and manage profiles
Managing Data and Concurrency
Monitor and resolve locking conflicts
Managing Undo Data
Overview of Undo
Transactions and undo data
Managing undo
Implementing Oracle Database Security
Database Security and Principle of Least Privilege
Work with Standard Database Auditing
Database Maintenance
Use and manage optimizer statistics
Use and manage Automatic Workload Repository (AWR)
Use advisory framework
Manage Alerts and Thresholds
Performance Management
Use Automatic Memory Management
Use Memory Advisors
Troubleshoot invalid and unusable objects
Intelligent Infrastructure Enhancements
Use the Enterprise Manager Support Workbench
Managing Patches
Backup and Recovery Concepts
Identify the types of failure that can occur in an Oracle database
Describe ways to tune instance recovery
Identify the importance of checkpoints, redo log files, and archived log files
Overview of flash recovery area
Configure ARCHIVELOG mode
Performing Database Backups
Create consistent database backups
Back up your database without shutting it down
Create incremental backups
Automate database backups
Manage backups, view backup reports and monitor the flash recovery area
Performing Database Recovery
Overview of Data Recovery Advisor
Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
Moving Data
Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
Explain the general architecture of Oracle Data Pump
Use Data Pump Export and Import to move data between Oracle databases