Oracle Database 11g: Administration Workshop I

Tipo de curso	Curso
Método	Presencial / Barcelona ver instalaciones...
Duración	25 horas
Precio/Facilidades	900 €
Centro	Loyal Infinity
Para qué te prepara	Describe Oracle Database Architecture. Install and configure Oracle Database 11g. Configure Oracle Net services. Manage the database storage structures. Create and administer user accounts. Perform basic backup and recovery of a database. Manage users and schemas. Manage data and concurrency. Monitor and administer undo data. Backup and recover a database. Monitor performance.
Dirigido a	Database Administrators, Database Designers, Developer, Support Engineer, Technical Administrator.
Alumnos	12 alumnos han realizado ya este curso
Aulas	6 alumnos por clase

Temario	Información adicional y temario

Loyal Infinity

Nos dedicamos a la formación a empresas y particulares. Disponemos de aulas alta

mente equipadas, y cursos nuevos en el mercado. Las aulas de Loyal Infinity se encuentran en el propio local Can Bruixa , mediante los diferentes transportes públicos de la ciudad. Están provistas con los equipos y software de última generación (cañón, proyector, ...) apropiados para poder imparti...

Contactar sin compromiso con el centro Loyal Infinity

Debes de rellenar correctamente todos los datos de este formulario para que podamos enviarlo al centro de formación. Hemos marcado en rojo aquellos datos incompletos y/o erroneos.

* Datos obligatorios

*Nombre: *Apellidos:

*e-mail: *Teléfono:

*¿En qué país resides?: *Provincia:

*Comentarios:

¿Deseas recibir información gratuita sobre cursos similares a este en tu email? Sí, quiero darme de alta en Emagister.com

En breve un asesor de Loyal Infinity se pondrá en contacto contigo para informarte.

Al presionar "Enviar solicitud/ Ver Teléfono" estás aceptando las reglas de uso, y política de protección de datos, del mismo modo, autorizas expresamente que el centro de formación que imparte el curso que has solicitado nos remita la confirmación o no de tu matriculación al curso mismo.

Cursos de la misma temática (Atención al cliente garantizada | Titulación oficial | Prácticas)

Oracle Database 11g: Administration Workshop II

Curso - Barcelona

Atención garantizada

Administración de BBDD Oracle 9i

Curso para trabajadores - Online - Gratuito

Atención garantizada

Programación Oracle 9i SQL

Curso para trabajadores - Online - Gratuito

Atención garantizada

Administración de Oracle 9i: Redes y Seguridad

Curso para trabajadores - Online - Gratuito

Atención garantizada

Oracle Forms Developer 2000

Curso para trabajadores - Online - Gratuito

Atención garantizada

+ Cursos de Oracle en Barcelona

+ Cursos de Oracle

Instalaciones del centro: Loyal Infinity

Madrazo, 27/29, 4º Barcelona 08006 Barcelona (España)

Madrazo 27 Barcelona 08006 Barcelona (España)

	Temario del curso
Exploring the Oracle Database Architecture Oracle Database Architecture Overview Interacting with an Oracle Database Process Architecture Database Storage Architecture Logical and Physical Database Structures Tablespaces and Data Files SYSTEM and SYSAUX Tablespaces Segments, Extents, and Blocks Preparing the Database Environment Tasks of an Oracle Database Administrator Tools Used to Administer an Oracle Database Installation: System Requirements Optimal Flexible Architecture (OFA) Setting Environment Variables Oracle Universal Installer (OUI) Database Configuration Options Advanced Installation Options Creating an Oracle Database Planning the Database Configuring the Listener Using the DBCA to Create a Database Password Management Creating a Database Design Template Using the DBCA to Delete a Database Using DBCA For Additional Tasks Managing the Oracle Instance Management Framework Oracle Enterprise Manager Initialization Parameter Database Startup and Shutdown Shutdown Modes Viewing the Alert History Using Trace Files Data Dictionary: Overview Configuring the Oracle Network Environment Oracle Net Services & Listener Establishing Net Connections Tools for Configuring and Managing the Oracle Network Net Services Administration Pages Naming Methods Directory Naming SGA and PGA When Not to Use a Shared Server 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) ASM: Concepts Administering User Security Database User Accounts Predefined Accounts: SYS and SYSTEM Administrator Authentication Benefits of Roles Predefined Roles Implementing Password Security Features Assigning Quota to Users Managing Schema Objects What Is a Schema? Accessing Schema Objects Specifying Data Types in Tables Creating and Modifying Tables Understanding Data Integrity Indexes & Views Sequences Temporary Tables Managing Data and Concurrency Manipulating Data Through SQL PL/SQL Administering PL/SQL Objects Functions, Procedures, Packages & Triggers Data Concurrency Enqueue Mechanism Resolving Lock Conflicts Using SQL Deadlocks Managing Undo Data Data Manipulation Transactions and Undo Data Undo Data Versus Redo Data Configuring Undo Retention Guaranteeing Undo Retention Using the Undo Advisor Viewing System Activity Implementing Oracle Database Security Industry Security Requirements Principle of Least Privilege Monitoring for Compliance Value-Based Auditing Fine-Grained Auditing DBA Auditing Security Updates Applying Security Patches Database Maintenance Introducing Terminology Optimizer Statistics Automatic Workload Repository (AWR) Automatic Database Diagnostic Monitor (ADDM) Advisory Framework Automated Maintenance Tasks Server-Generated Alerts Reacting to Alerts 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 Moving Data: General Architecture Directory Object: Overview SQL*Loader: Overview Data Pump: Overview Performance Initialization Parameters Using Enterprise Manager to Monitor Data Pump Jobs Data Dictionary Enhancing Database Capabilities Using EM Support Workbench Create a Service Request Package and upload diagnostic data to Oracle Support Track the SR and Implement Repairs Incident Packaging Configuration Working with Oracle Support MetaLink Integration Managing Patches