DescripciĂłn del curso:
Oracle Database 11g delivers economies of scale on easily managed low-cost grids, making it easier to reduce cost of downtime with maximum availability architecture, change IT systems faster using Real Application Testing, partition and compress data to run queries faster using less disks, securely protect and audit data, enable total recall of data, and make productive use of standby resources with Active Data Guard.
This course addresses administration for Oracle Database 11g and is focused on:
- Database Architecture and Installation
- Database Creation, Instance Management, and Connectivity
- Storage Structures and User Security
- Managing the Schema, Data, and Concurrency
- Managing Undo Data, Database Security, and Maintenance
- Performance Monitoring, Recovery Concepts and Backup
- Recovering, Moving, and Enhancing the Oracle Database
For on-demand learning, you will have access to this course for 12 months from the purchase date.
Temas del curso
 Oracle Database 11g: Database Architecture and Installation
- Main structural components of Oracle Database 11g
- Components of the Oracle Database 11g memory structures
- Functions of the Oracle Database 11 server and background processes
- How information is stored and structured within the Oracle Database 11g storage architecture
- Necessary tasks and essential tools required to administer an Oracle Database 11g database
- Planning and carrying out an installation of Oracle Database 11g software using the Oracle Universal Installer (OUI)
- Install Oracle Database 11g software in a given scenario
2. Oracle Database 11g: Database Creation, Instance Management, and Connectivity
- Creating, configuring, or deleting a database using the Database Configuration Assistant (DBCA) and managing a database instance using various Oracle tools
- Scope and capabilities of Oracle Database 11g initialization parameters and the steps for maintaining them
- Configuring database startup and shutdown options, administering a blackout, and using alerts and dynamic data to assess database performance
- Using the Data Dictionary to find information about users, objects, constraints, and storage
- Create a database using the DBCA and manage instances using Enterprise Manager
- Ways of configuring and managing the Oracle network and the steps for creating a new Oracle Net Listener via Enterprise Manager
- Connecting to an Oracle Database 11g database using different naming methods as well as advanced connection options and when to employ connection pooling
- Using and configuring Oracle Net Services in a given scenario
3. Oracle Database 11g: Storage Structures and User Security
- Purposes of table spaces and datafiles
- Creating a new tablespace
- How to manage the storage of information by maintaining tablespaces and viewing their information, and automating manual storage using Automatic
- Storage Management (ASM)
- View tablespace information and create a new tablespace
- Creating and authenticating database user accounts
- Granting and revoking privileges and creating and managing roles
- Creating and managing profiles, implementing password security, and assigning quotas
4. Oracle Database 11g: Managing the Schema, Data, and Concurrency
- Features and functions of schemas and data types and the steps for modifying a table
- Using constraints to maintain data integrity, view the contents of a table, and perform actions on the table
- Ways of improving data update and retrieval, storing queries, speeding up performance by creating and using indexes, views, sequences, and temporary tables
- Create a table with columns and also create constraints and indexes, in a given scenario
- Ways for manipulating data with SQL commands and for administering PL/SQL objects
- Triggering events and monitoring and resolving locking conflicts
5. Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance
- Managing undo operations in Oracle Database 11g to allow users to roll back transactions
- Requirements and best practices for implementing database security according to international and regional laws
- Enabling, specifying, maintaining, and reviewing database auditing
- Process for obtaining and applying Critical Patch Updates (CPUs)
- Configure an Oracle Database 11g database to support retention and implement database security in a given scenario
- Managing and gathering optimizer statistics
- Managing Automatic Workload Repository (AWR) statistics, using the Automatic Database Diagnostic Monitor (ADDM), and utilizing advisors
- Viewing and configuring automated tasks and setting alert thresholds
6. Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup
- Monitoring and analyzing performance, managing memory, and troubleshooting invalid objects that affect performance
- Ways to anticipate and avoid various types of failure that can occur in Oracle Database 11g
- Process used to configure an Oracle Database 11g database for instance recovery
- Features of different backup strategies you can employ in Oracle Database 11g
- Using RMAN to configure, schedule, manage, and view backup operations
- Resolve performance issues, prepare the database for recovery, and perform a database backup in a given scenario
7. Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database
- Tools required and steps performed in identifying whether a recovery is necessary
- Recovering various types of database files
- Features of the various options for moving data in Oracle Database 11g
- Importing, exporting, and moving data between Oracle databases using Oracle Data Pump
- Recover the database from a media failure and move data using the Data Pump Wizard in a given scenario
- Using the Enterprise Manager Support Workbench and Oracle Support to investigate, report on, and resolve problems
- Searching MetaLink for new critical patches and logging service requests
- Managing and applying patches in Oracle Database 11g
Supplemental Assets:
Lab Simulations:Â Task-based multipath scenarios provide realistic practice of technology subjects or applications, where applicable.
Pre and Post Courseware Assessments:Â Section-based assessments offer a range of practice and testing options within the section, including feedback and tracking.
Test Prep Exams:Â Practice tests will help you prepare for a certification exam. You can take a test prep exam in Study Mode (where you receive feedback after each question) or in Certification Mode (designed to mimic a certification exam) as many times as you want.
Mentoring:Â Mentors are available to help students with their studies for certification exam. You can reach them by entering a Mentored Chat Room or by using the Email My Mentor service.
Inclusiones
Con CCS Learning Academy, recibirás:
- FormaciĂłn dirigida por un instructor certificado
- Manual del Estudiante del Seminario Oficial de CapacitaciĂłn
- Colaboración con compañeros de clase (actualmente no disponible para cursos a su propio ritmo)
- Escenarios y actividades de aprendizaje del mundo real.
- Soporte para la programación de exámenes*
- Disfrute de asistencia para la colocación laboral durante los primeros 12 meses después de finalizar el curso.
- Este curso es elegible para el programa Learn and Earn de CCS Learning Academy: obtenga un reembolso de la matrĂcula de hasta 50% si se le coloca en un trabajo a travĂ©s de CCS Global Tech. DivisiĂłn de colocaciĂłn*
- Precios gubernamentales y privados disponibles.*
*Para más detalles llame al: 858-208-4141 o correo electrónico: formación@ccslearningacademy.com; ventas@ccslearningacademy.com