Solicita más información sobre este curso al centro de formación y uno de los colaboradores se pondrá en contacto contigo para resolver todas las dudas que tengas.
Curso de Oracle Database 11g: Complete
|
|
|||||||||
|---|---|---|---|---|---|---|---|---|---|
| titulo: | Curso de Oracle Database 11g: Complete |
||||||||
| Centro de formación: | Master D |
||||||||
| tipo de curso: | Curso |
||||||||
| Categoría: |
|
||||||||
| Metodología: | Online |
||||||||
| provincia: | - |
||||||||
| precio: | |||||||||
| convocatorias: | Matriculas abiertas | ||||||||
| Descripción: | Proporciona a los alumnos un alto nivel de conocimientos en la materia. Aprenderás a realizar las consultas SQL más complicadas, utilizar PL/SQL para crear tus scripts de mantenimiento de la forma más óptima y administrar la Base de Datos Oracle como un experto. |
||||||||
| a quien va dirigido: | Dirigido a: * Administradores de Sistemas o perfiles técnicos que quieran aprender o perfeccionar sus conocimientos de la base de datos Oracle. * Aquellos que desean obtener los Certificados Oficiales de Oracle OCA. |
||||||||
| requisitos: | Ninguno | ||||||||
| Lugar de impartición: | |||||||||
| horarios: | |||||||||
| Duración: | 6 meses | ||||||||
| descuentos: | Sin descuento | ||||||||
| becas: | No | ||||||||
| ¿Prácticas en empresas? | No | ||||||||
| salidas profesionales: | Consultar al centro | ||||||||
| programa del curso: | ORACLE DATABASE 11G: COMPLETE 1. ORACLE DATABASE 11G: SQL FUNDAMENTALS I - SELF-STUDY COURSE a) Using SQL to Query Your Database • Using SQL in Oracle Database 11g • Retrieving, Restricting and Sorting Data • Using Single-Row Functions b) Conversion Functions, Group Functions, and Joins • Conversion Functions and Conditional Expressions • Group Functions and Joins c) Subqueries, Set Operators, and Data Manipulation • Using Subqueries and Set Operators • Manipulating Data d) Using DDL, Views, Sequences, Indexes, and Synonyms • Using DDL Statements to Create and Manage Tables • Creating Other Schema Objects 2. ORACLE DATABASE 11G: SQL FUNDAMENTALS II SELF-STUDY COURSE a) Controlling User Access and Managing Schema Objects • Controlling User Access • Managing Schema Objects b) Data Dictionary Views and Large Data Sets • Managing Objects with Data Dictionary Views • Manipulating Large Data Sets c) Managing Data in Different Time Zones • Using Time Zones and Datetime Functions d) Using Subqueries and Regular Expressions • Retrieving Data Using Subqueries • Using Regular Expressions www.masterdformacion.com MASTERDformación http://www.masterdformacion.com/cursos-oracle-database-complete-11g 3. ORACLE DATABASE 11G: PL/SQL FUNDAMENTALS - SELF-STUDY COURSE a) PL/SQL Variables, Attributes, and Executable Statements • Getting Started with PL/SQL Elements • Using Executable Statements b) Using DML, DDL, Cursors, Control Structures, and Loops • Using DML, DDL, and SQL Cursors in PL/SQL • Using Control Structures and Loops in PL/SQL c) Using Data Types, INDEX BY Tables, and Cursors in PL/SQL • Using Data Types, INDEX BY, and PL/SQL Records • Using Explicit Cursors and Attributes in PL/SQL d) Working with Exceptions, Subprograms, JDeveloper, and REF Cursors • Handling Exceptions in PL/SQL • Using JDeveloper and Cursor Variables 4. ORACLE DATABASE 11G: DEVELOP PL/SQL PROGRAM UNITS SELF-STUDY COURSE a) Subprograms, Packages, and Exception Handling in PL/SQL • Using Subprograms and Handling Exceptions • Using Functions, Creating Packages, and Debugging b) Packages, Dynamic SQL, and Coding Considerations in PL/SQL • Using Packages and Dynamic SQL • Coding Considerations in PL/SQL c) Using Triggers, the PL/SQL Compiler, and Managing Code • Working with Triggers in PL/SQL • Using the PL/SQL Compiler and Managing Code d) Managing PL/SQL Code and Dependencies • PL/SQL Code and Dependency Management www.masterdformacion.com MASTERDformación http://www.masterdformacion.com/cursos-oracle-database-complete-11g 5. ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP I - SELF-STUDY COURSE a) Exploring the Oracle Database Architecture • Oracle Database Architecture Overview • Oracle ASM Architecture Overview • Process Architecture • Memory structures • Logical and physical storage structures • ASM storage components b) 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 c) 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 d) 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 e) Manage the ASM Instance • Set up initialization parameter files for ASM instance www.masterdformacion.com MASTERDformación http://www.masterdformacion.com/cursos-oracle-database-complete-11g • Start up and shut down ASM instances • Administer ASM disk groups f) 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 g) 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) h) Administering User Security • Database User Accounts • Predefined Administrative Accounts • Benefits of Roles • Predefined Roles • Implementing Profiles i) Managing Data Concurrency • Data Concurrency • Enqueue Mechanism • Resolving Lock Conflicts • Deadlocks j) Managing Undo Data • Data Manipulation • Transactions and Undo Data • Undo Data Versus Redo Data • Configuring Undo Retention k) Implementing Oracle Database Auditing • Describe DBA responsibilities for security • Enable standard database auditing • Specify audit options www.masterdformacion.com MASTERDformación http://www.masterdformacion.com/cursos-oracle-database-complete-11g • Review audit information • Maintain the audit trail l) 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 m) 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 n) 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 www.masterdformacion.com MASTERDformación http://www.masterdformacion.com/cursos-oracle-database-complete-11g • Monitoring the Flash Recovery Area o) 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 p) 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 q) Working with Support • Use the Enterprise Manager Support Workbench • Work with Oracle Support • Log service requests (SR) • Manage patches 6. ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP II - SELF-STUDY COURSE a) Database Architecture and Recovery Operations • Oracle Database Architecture • Backup and Recovery Operations b) The RMAN Catalog and Creating Backups • The RMAN Recovery Catalog • Creating Backups with RMAN c) Performing Restore and Recovery Tasks • Restore and Recovery Tasks • Performing User-Managed Backup and Recovery www.masterdformacion.com MASTERDformación http://www.masterdformacion.com/cursos-oracle-database-complete-11g d) Using, Monitoring and Tuning RMAN • Using RMAN to Perform Recovery • Monitoring and Tuning RMAN e) Database Diagnostics and Flashback Technologies • Diagnosing the Oracle Database • Flashback Technologies f) Managing Database Memory and Performance • Managing Memory • Managing Database Performance g) Managing Database Resources and the Scheduler • Managing Resources • Task Automation and Administration h) Managing Database Space and Duplication • Managing Database Space and Duplication • Duplicate Databases |
||||||||
|
|||||||||
otros cursos relacionados
Curso de SQL Server 2008
Curso de Microsoft Exchange Server 2007
Curso de SQL Server 2005
Curso de Linux Intermediate System Administration
Curso de Oracle Database 11g: Administration Workshop I
Curso de Programación Java Standard Edition
Curso de Fundamentos de programación en Java
Curso de Oracle Database 10g: Administration Workshop I
Curso de Oracle Database 11g: New Features for Administrators
Curso de System Administration for the Solaris 10 OS Part 2
Curso de Oracle BI Suite EE 10g R3: Create Reports and Dashboards
Centros recomendados
Tags