REDCAPACITACION Chile, El Portal de la Capacitación
  Requerimientos de capacitación   Requerimientos de relatores   Requerimientos de servicios

Curso de Capacitación: CERTIFICACION ORACLE DATABASE 11G: ADMINISTRACION 1

CERTIFICACION ORACLE DATABASE 11G: ADMINISTRACION 1

Centro de Capacitación

Logo Oferente

Descripción

Preparacion para ORACLE CERTIFIED ASSOCIATE

Contenidos

Exploración de la arquitectura de Oracle database.

Preparación del entorno de base de datos.

Creación de una base de datos Oracle.

Introduction

Overview of Oracle Database 11g and related products
Overview of relational database management concepts and terminologies
Introduction to SQL and its development environments
The HR schema and the tables used in this course
Oracle Database documentation and additional resources
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
Usage of arithmetic expressions and NULL values
Implement Column aliases
Describe the concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
Display the table structure using the DESCRIBE command
Restrict and Sort Data

Write queries with a WHERE clause to limit the output retrieved
Use the comparison operators and logical operators
Identify the rules of precedence for comparison and logical operators
Usage of character string literals in the WHERE clause
Write queries with an ORDER BY clause
Sort output in descending and ascending order
Substitution Variables
Use Single-Row Functions to Customize Output

Differentiate between single row and multiple row functions
Manipulate strings using character functions
Manipulate numbers with the ROUND, TRUNC, and MOD functions
Perform arithmetic with date data
Manipulate dates with the DATE functions
Conversion Functions and Conditional Expressions

Describe implicit and explicit data type conversion
Describe TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Nesting multiple functions
Apply the NVL, NULLIF, and COALESCE functions to data
Use conditional IF THEN ELSE logic
Aggregated Data Using Group Functions

How aggregation functions help to produce meaningful reports?
Use the AVG, SUM, MIN, and MAX function
How to handle Null Values in a group function?
Divide the data in groups by using the GROUP BY clause
Exclude groups of date by using the HAVING clause
Display Data From Multiple Tables Using Joins

Write SELECT statements to access data from more than one table
Join Tables Using SQL:1999 Syntax
View data that does not meet a join condition by using outer joins
Join a table to itself by using a self join
Create Cross Joins
Use Sub-queries to Solve Queries

Use a Subquery to Solve a Problem
Execute Single-Row Sub-queries
Deploy Group Functions in a Sub-query
Multiple-Row Subqueries
Use ANY and ALL Operator in Multiple-Row Sub-queries
Use EXISTS Operator
SET Operators

What are SET operators?
Use a SET operator to combine multiple queries into a single query
Use UNION, UNION ALL, INTERSECT, and MINUS Operator
Use ORDER BY Clause in Set Operations
Data Manipulation

Add New Rows to a Table
Change the Data in a Table
Use DELETE and TRUNCATE Statements
Save and discard changes with the COMMIT and ROLLBACK statements
Implement Read Consistency
Describe the FOR UPDATE Clause
Use DDL Statements to Create and Manage Tables

Categorize Database Objects
Create Tables using the CREATE TABLE Statement
Identify the data types
Describe Constraints
Create a table using a subquery
How to alter a table?
Drop a table
Other Schema Objects

Create, modify, and retrieve data from a view
Perform Data manipulation language (DML) operations on a view
Drop a view
Create, use, and modify a sequence
Create and maintain indexes
Create and drop synonyms

Exploring the Oracle Database Architecture

Oracle Database Architecture Overview
Oracle ASM Architecture Overview
Process Architecture
Memory structrues
Logical and physical storage structures
ASM storage components
Installing your Oracle Software

Tasks of an Oracle Database Administrator
Tools Used to Administer an Oracle Database
Installation: System Requirements
Oracle Universal Installer (OUI)
Installing Oracle Grid Infrastructure
Installing Oracle Database Software
Silent Install
Creating an Oracle Database

Planning the Database
Using the DBCA to Create a Database
Password Management
Creating a Database Design Template
Using the DBCA to Delete a Database
Managing the Oracle Database Instance

Start and stop the Oracle database and components
Use Oracle Enterprise Manager
Access a database with SQLPlus
Modify database installation parameters
Describe the stages of database startup
Describe database shutdown options
View the alert log
Access dynamic performance views
Manage the ASM Instance

Set up initialization parameter files for ASM instance
Start up and shut down ASM instances
Administer ASM disk groups
Configuring the Oracle Network Environment

Use Enterprise Manager to create and configure the Listener
Enable Oracle Restart to monitor the listener
Use tnsping to test Oracle Net connectivity
Identify when to use shared servers and when to use dedicated servers
Managing Database Storage Structures

Storage Structures
How Table Data Is Stored
Anatomy of a Database Block
Space Management in Tablespaces
Tablespaces in the Preconfigured Database
Actions with Tablespaces
Oracle Managed Files (OMF)
Administering User Security

Database User Accounts
Predefined Administrative Accounts
Benefits of Roles
Predefined Roles
Implementing Profiles
Managing Data Concurrency

Data Concurrency
Enqueue Mechanism
Resolving Lock Conflicts
Deadlocks
Managing Undo Data

Data Manipulation
Transactions and Undo Data
Undo Data Versus Redo Data
Configuring Undo Retention
Implementing Oracle Database Auditing

Describe DBA responsibilities for security
Enable standard database auditing
Specify audit options
Review audit information
Maintain the audit trail
Database Maintenance

Manage optimizer statistics
Manage the Automatic Workload Repository (AWR)
Use the Automatic Database Diagnostic Monitor (ADDM)
Describe and use the advisory framework
Set alert thresholds
Use server-generated alerts
Use automated tasks
Performance Management

Performance Monitoring
Managing Memory Components
Enabling Automatic Memory Management (AMM)
Automatic Shared Memory Advisor
Using Memory Advisors
Dynamic Performance Statistics
Troubleshooting and Tuning Views
Invalid and Unusable Objects
Backup and Recovery Concepts

Part of Your Job
Statement Failure
User Error
Understanding Instance Recovery
Phases of Instance Recovery
Using the MTTR Advisor
Media Failure
Archive Log Files
Performing Database Backups

Backup Solutions: Overview
Oracle Secure Backup
User-Managed Backup
Terminology
Recovery Manager (RMAN)
Configuring Backup Settings
Backing Up the Control File to a Trace File
Monitoring the Flash Recovery Area
Performing Database Recovery

Opening a Database
Data Recovery Advisor
Loss of a Control File
Loss of a Redo Log File
Data Recovery Advisor
Data Failures
Listing Data Failures
Data Recovery Advisor Views
Moving Data

Describe ways to move data
Create and use directory objects
Use SQL*Loader to move data
Use external tables to move data
General architecture of Oracle Data Pump
Use Data Pump export and import to move data
Working with Support

Use the Enterprise Manager Support Workbench
Work with Oracle Support
Log service requests (SR)
Manage patches

Otros Datos

Área: Oracle
Dirigida a:
Relator:
Horas Teóricas: 32 | Horas Prácticas: 32
Modalidad: Presencial
Valor referencial por persona: $ 980000

Otros Comentarios




Cotice este curso

Palabras Claves




Eventos


Curso QGIS - Nivel Basico
Ver más

Curso Excel Tres Niveles por 60 Dólares
Ver más

HABILIDADES BLANDAS (Sin SENCE)
Ver más

APLICACIÓN DE TÉCNICAS EFECTIVAS PARA ENVÍO DE LOS LIBROS ELECTRÓNICOS DE COMPRAS Y VENTAS
Ver más

Curso Abierto: Taller Diseño Universal de Aprendizaje (DUA)
Ver más






  • Logo 21d Capacitaciones
  • Logo Capac Training S.a.
  • Logo Sociedad De Capacitación Encap Limitada
  • Logo Otec Oficios Del Sur Ltda
  • Logo Smart Capacitaciones Limitada
  • Logo Cencomín
  • Logo Lihuenko Capacitaciones Spa
  • Logo A&g Capacitaciones
  • Logo Clyc Capacitaciones
  • Logo  Formación Ti Spa
  • Logo Octopus  Capacitacion
  • Logo Ropcas Capacitaciones Spa
  • Logo Global Capacitaciones Ltda
  • Logo Gestcap Chile Ltda.
  • Logo Cege Learning S.a,
  • Logo Inacim
  • Logo M.a.s. Limitada
  • Logo Dial Capacita
  • Logo Fesanco Capacitaciones
  • Logo Enac Conductores
  • Logo Capacitacion Play Comp Ltda.
  • Logo Proyecto  Educacional Y Capacitación Ltda
  • Logo Soc. Invierte Capacitación Spa
  • Logo Innovocap
  • Logo Areté Capacitaciones
  • Logo Organismo Técnico De Capacitación San Marti Limitada
  • Logo Capacitaciones Campbell Spa
  • Logo Biocap
  • Logo Gicap Capacitacion
  • Logo Cm Pro Educa Spa
  • Logo Instituto Minero De Capacitacion Limitada
  • Logo Ey Servicios De Capacitación Spa
  • Logo Capacitaciones Altazor Spa
  • Logo Eprime Formación Ltda
  • Logo Avanti Capacitaciones Spa
  • Logo Instituto Nacional De Certificacion
  • Logo Quality Training Limitada
  • Logo Universidad Pedro De Valdivia
  • Logo Sociedad De Capacitación Y Asesoría García Y García Limitada
  • Logo Otec Concepcion Capacita Figueroa & Godoy Limitada
  • Logo Organismo Técnico De Capacitación Sistémica Limitada
  • Logo Red Global
  • Logo Instituto De Capacitación Bienestar Y Progreso Ltda.
  • Logo Inglobal Capacitación Y Desarrollo Empresarial E.i.r.l
  • Logo Sociedad Educacional Planacap Limitada
  • Logo Claudio Erazo
  • Logo Avanza Capacitaciones Limitada
  • Logo Empleando Capacitación Ltda.
  • Logo Andes Experience
  • Logo Capacitaciones Apu Formacion Spa
  • Logo Norteduc Capacitaciones
  • Logo Red Sur
  • Logo Enfocap Spa
  • Logo Valero Servicios Educacionales Limitada
  • Logo Apsa Capacitacion
  • Logo Aysen Consultores Ltda
  • Logo G-nesys
  • Logo Atecra
  • Logo Cetecap Spa
  • Logo Instituto Chileno De Soldadura
  • Logo Otec Regional Ltda.
  • Logo Ultraccion
  • Logo Otec Vortices
  • Logo Lester Fibla Saavedra
  • Logo Otec Chelenko Limitada
  • Logo Arancibia Y Ocharan Limitada
  • Logo Instacapchile
  • Logo Otec Kimen Sp Ltda
  • Logo Thomson Reuters
  • Logo Denacap Ltda
  • Logo Sercap Educa Ltda
  • Logo Competere
  • Logo Otec Carpe Diem
  • Logo Deloitte Servicios De Capacitación Limitada
  • Logo Framauro
  • Logo Capacitaxion Spa
  • Logo Impact Learning Group
  • Logo Qualia Capacitaciones
  • Logo Insigne Capacitación Spa
  • Logo Gs Capacitaciones Spa
  • Logo Sociedad De Capacitación T&w Spa
  • Logo Instituto De Proyectos Empresariales
  • Logo T&s Capacitacion Chile Ltda.-
  • Logo Evs
  • Logo Capacitaciones Nahuelbuta E.i.r.l.
  • Logo Qualitymas Capacitacion
  • Logo Ceincap Ltda.
  • Logo C.y.e Capacitaciones Ltda
  • Logo Pretorian Capacitaciones
  • Logo Sotercap Limitada
  • Logo Capin Limitada
  • Logo Captop Capacitacion
  • Logo Cfcap Chile Ltda
  • Logo Agrochilecapacita Escuela De Agronegocios
  • Logo Capacitacion Boletin Del Trabajo
  • Logo Innova Capacitación Ltda
  • Logo Concrevi Centro De Capacitación
  • Logo Lsqa Academy
  • Logo Servinorte Empresa Individual De Responsabilidad Limitada
  • Logo Socadeh
  • Logo Capacitaciones Falem Skill Training Limitada
  • Logo Sociedad De Capacitación Mvc Limitada.
  • Logo Instituto De Capacitacion Profesional Limitada
  • Logo Kapacitate
  • Logo Manuel Leonardo Cáceres Lizana, Actividades De Asesoramiento Empresarial Y En Materia De Gestión, E.i.r.l.
  • Logo Otedep Spa.
  • Logo Otec Digimental
  • Logo Layner Centro De Capacitaciones E.i.r.l.
  • Logo Welearn Cap
  • Logo Orangreb Ltda.
  • Logo Trabajando Seguro
  • Logo Redotec
  • Logo Servicio De Capacitación Pamela Maturana Courdurier E. I. R. L.
  • Logo Ybm Capacitacion
  • Logo Capacitaciones Empresariales
  • Logo Netsolutions
  • Logo Sin Fronteras Capacitación
  • Logo Geming Capacitación Spa
  • Logo Proactiva Capacitaciones Limitada
  • Logo Enasys
  • Logo Piramidal
  • Logo Fundacion Asiva
  • Logo Cyc Capacitaciones
  • Logo Sociedad De Capacitación Capasistem Limitada
  • Logo Docentes Al Dia Otec Spa
  • Logo Instituto De Capacitación Edycal
  • Logo Otec Pcm Prod
  • Logo Capacitas 23
  • Logo Aprendeser
  • Logo Cinder Capacitacion
  • Logo Bitgo
  • Logo Ser-cap Spa
  • Logo Instituto Athenas Ltda.
  • Logo Hepta Capacitación Limitada
  • Logo Sembrando Conocimiento Ltda.
  • Logo Instituto Idomek
  • Logo Titanium Training Spa
  • Logo Eslabón Capacitación
  • Logo Novaotec Capacitacion Empresarial Ltda.
  • Logo Keep Learning
  • Logo Centro De Capacitacion Laboral Capacitar & Crecer Limitada
  • Logo Seminaria Otec Spa
  • Logo A&m Capacitacion Ltda
  • Logo Otc Consultores
  • Logo 3lobos Spa
  • Logo Formar Chile Capacitación Ltda.
  • Logo 3ag Capacitacion Ltda
  • Logo Otec Capacitamas
  • Logo Centro De Alta Formación Y Capacitación Chile Spa.
  • Logo Pro Acitud Asutral Capacitaciones
  • Logo Escuela De Capacitación Pedagógica Artemisia Montessori Limitada
  • Logo Mas Futuro
  • Logo Humanuss
  • Logo Instituto Panamericano De Seguridad S.a.
  • Logo Educacion Mas
  • Logo Icm Chile
  • Logo Tecno-gestión Limitada
  • Logo Ki Capacitacion
  • Logo Ingenio Capacitacion
  • Logo Dimac Capacitacion Y Desarrollo
  • Logo Otec Gloria Jury Jamis Eirl
  • Logo Ergocap Spa
  • Logo It Wall S.a.
  • Logo Instituto De Capacitación Social Y Empresarial Spa.
  • Logo Comunikrte Capacita Spa
  • Logo Ejrc Capacitaciones
  • Logo Mincap
  • Logo Instituto Cultural Ecos Limitada
  • Logo Perfectus Capacitaciones
  • Logo Cereduc
  • Logo Andinacap Ltda.
  • Logo Escuela Punto De Partida
  • Logo Safety & Security Capacitaciones Eirl
  • Logo Transversal Capacitaciones Ltda.
  • Logo Centro De Capacitacion Y Desarrollo Minero Industrial Spa
  • Logo Itec Chile Capacitaciones
  • Logo Cd Capacitacion
  • Logo Prevenir
  • Logo Somital
  • Logo Cahp Spa
  • Logo Otec Blackboard Training Ltda
  • Logo Cecace
  • Logo Indotec
  • Logo Sociedad De Capacitación Se3 Spa
  • Logo Tempus Capacitaciones
  • Logo Capacitacion Gastro Tur
  • Logo Procap Servicios De Capacitacion
  • Logo Ennovate Business Trends
  • Logo Universidad Autonoma De Chile
  • Logo Capacitación Andes Learning Ltda.
  • Logo Tec Capacitaciones Spa
  • Logo Sociedad De Capacitación Alquimistas Ltda.
  • Logo J&g Capacitaciones  Ltda
  • Logo Sociedad De Capacitacion Nahuelbuta Spa
  • Logo Energytime
  • Logo C&r Virtual Capacita Spa
  • Logo Dmadison Capacitacion S.a.
  • Logo Cidep Educa
  • Logo Iconas Educación Spa
  • Logo Creciendo Más
  • Logo Instituto De Capacitación Y Desarrollo De Educación Continua Nacional
  • Logo Capacitación Alfa Y Omega
  • Logo Valoracapacita
  • Logo Iibi
  • Logo Cim Ltda
  • Logo Otec Hseq Mining Ltda.
  • Logo Fundación Del Cuerpo De Bomberos De Viña Del Mar Para La Capacitación
  • Logo Rbu Capacitaciones Spa
  • Logo Centro Yeah Capacitaciones Inteligentes Spa
  • Logo Ekufal Spa
  • Logo Tecnotraining
  • Logo Sgs Academy
  • Logo Otec Sosercap Ltda.
  • Logo Skydive Andes
  • Logo Capacitaciones Karen Fuentes Montecinos E.i.r.l.
  • Logo Tempus Capacitaciones
  • Logo Ideas En Movimiento
  • Logo Capaf Ltda.
  • Logo Más Ambiente Ltda.
  • Logo Centro De Formación Y Capacitación Empowerment Spa.
  • Logo Sociedad De Capacitación Cbp Limitada
  • Logo Educación Y Capacitación Semilla Eirl
  • Logo Link Capacitación Y Recursos Humanos
  • Logo Instituto De Capacitacion  Agcap  Spa
  • Logo Igscap
  • Logo Educatechile Spa.
  • Logo Corporacion Crisol
  • Logo Training Class Organismo Tecnico De Capacitacion Spa
  • Logo Vanguardia Capacitación E.i.r.l.
  • Logo Casem Capacitaciones Spa
  • Logo Sts Capacitación
  • Logo Pixelab
  • Logo New Horizons
  • Logo Creadero Capacitación Ltda
  • Logo Centro De Estudios Mas Capital Humano
  • Logo Otec Ethos Limitada
  • Logo Sociedad Nacional De Capacitacion Ltda
  • Logo Fs Team Capacitaciones
  • Logo Deachile Capacitacion Spa
  • Logo Capaseg
  • Logo Werker Capacitaciones
  • Logo Vgroup
  • Logo Patagonia Capacitaciones Spa
  • Logo Macor Consulting Ltda.
  • Logo Capacitaciones Carrasco
Flecha Izquierda Flecha Derecha