Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Database Maintenance and Performance Tuning in Oracle Database 12c $74.95
Managing an Oracle Database 12c Instance $74.95
User Security and Auditing in Oracle Database 12c $74.95
Backing Up, Recovering, Importing, and Exporting Data in Oracle Database 12c $74.95
Connectivity and Space Management in Oracle Database 12c $74.95
SQL Tuning, Resource Management, and Job Scheduling in Oracle Database 12c $74.95

Bundle Price: $229.00
Total Savings: $220.70


Database Maintenance and Performance Tuning in Oracle Database 12c

Oracle Database 12c includes many features that simplify routine database maintenance and performance tuning. In this course, you'll learn how to configure and use the automated database monitoring and maintenance features available in Oracle Database 12c. You'll also learn how to monitor and tune both database and memory performance in Oracle Database 12c. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).
  • start the course
  • describe database maintenance tasks and view alert history in Oracle Database 12c
  • describe the Automatic Workload Repository (AWR) and its infrastructure in Oracle Database 12c
  • create an Automatic Workload Repository (AWR) baseline in Oracle Database 12c
  • manage Automatic Workload Repository (AWR) settings in Oracle Database 12c
  • describe the STATISTICS_LEVEL parameter for a database in Oracle Database 12c
  • use the Automatic Database Diagnostic Monitor in Enterprise Manager in Oracle Database 12c
  • describe the Advisory Framework in Oracle Database 12c
  • identify the packages used to invoke advisors in Oracle Database 12c
  • describe and view the automated database maintenance tasks in Oracle Database 12c
  • describe server-generated alerts and set metric thresholds for them in Oracle Database 12c
  • recognize different alert types and clear alerts in Oracle Database 12c
  • plan, monitor, and tune performance in Oracle Database 12c
  • tune the performance of a database instance in Oracle Database 12c
  • use EM Database Express and EM Cloud Control to monitor database performance in Oracle Database 12c
  • monitor session performance in Oracle Database 12c
  • monitor top services in Oracle Database 12c
  • describe and view wait events in Oracle Database 12c
  • use the data dictionary views to diagnose and tune performance problems in Oracle Database 12c
  • identify guidelines for memory management in Oracle Database 12c
  • describe Automatic Memory Management (AMM) and related memory parameters in Oracle Database 12c
  • enable and monitor Automatic Memory Management (AMM) in Oracle Database 12c
  • describe Automatic Shared Memory Management (ASMM) in Oracle Database 12c
  • describe and enable Automatic Shared Memory Management (ASMM) in Oracle Database 12c
  • describe values for autotuned SGA parameters in Oracle Database 12c
  • describe the program global area (PGA) in the Oracle Database 12c
  • configure AWR retention parameters, generate an AWR report, review server-generated alerts, and enable Automatic Memory Management (AMM) in Oracle Database 12c

Managing an Oracle Database 12c Instance

An understanding of the memory, process, and storage architecture – along with the new multitenant architecture – in Oracle Database 12c is a good foundation for working with Oracle database instances. In this course, you'll learn about all the key architectural structures in Oracle Database 12c and how they work together. You'll learn about the main tools for managing Oracle database instances. You'll then learn how to get started, configuring initialization parameters, starting up a database instance, working with log files, and using the various database views in Oracle Database 12c. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).
  • start the course
  • describe the new multitenant architecture and support for cloud computing in Oracle Database 12c
  • describe the database server architecture and key memory structures in Oracle Database 12c
  • identify the functions of the shared pool
  • identify the functions of the buffer cache and the redo log buffer in Oracle Database 12c
  • explain the functions of the large, Java, and Streams pools and the role of the Program Global Area in Oracle Database 12c
  • describe the new In-Memory column store, as well as in-memory caching of row data, in Oracle Database 12c
  • provide an overview of the process architecture and process structures in Oracle Database 12c
  • describe the database writer and log writer processes in Oracle Database 12c
  • describe the checkpoint, system monitor, and process monitor processes in Oracle Database 12c
  • describe the recoverer, listener registration, and archiver processes in Oracle Database 12c
  • provide an overview of the database storage architecture used in Oracle Database 12c
  • describe the logical and physical storage structures used in Oracle Database 12c
  • explain the new multitenant container database in Oracle Database 12c
  • describe key features of Automatic Storage Management in Oracle Database 12c
  • describe the Oracle Database 12c database management tools, SQL*Plus and SQL Developer
  • access Enterprise Manager (EM) Database Express and provide an overview of the options it provides for managing Oracle Database 12c
  • start Oracle Enterprise Manager Cloud Control and describe its core components in Oracle Database 12c
  • use Enterprise Manager Cloud Control in Oracle Database 12c
  • identify types of initialization parameters and the files that contain them in Oracle Database 12c
  • configure key initialization parameters in Oracle Database 12c
  • describe how to use SQL*Plus to view and configure initialization parameters for Oracle Database 12c
  • explain the steps that occur when you start up a database instance in Oracle Database 12c
  • explain what occurs when you shut down a database instance, as well as the available shutdown modes, in Oracle Database 12c
  • view the alert log and find and use trace files in Oracle Database 12c
  • administer the DDL log file and use the debug log file in Oracle Database 12c
  • describe and use dynamic performance views in Oracle Database 12c
  • describe and use the data dictionary views in Oracle Database 12c
  • configure initialization parameters, start a database instance, and use different views in Oracle Database 12c

User Security and Auditing in Oracle Database 12c

Protecting the security of an Oracle Database 12c system involves controlling and monitoring database access. In this course, you'll learn how to manage privileges and use roles, profiles, quotas, and password security in Oracle Database 12c. You'll learn how to detect and resolve lock conflicts, and you'll learn how to enable and manage auditing of database activity. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).
  • start the course
  • describe database user accounts in Oracle Database 12c
  • describe administrative user accounts in Oracle Database 12c
  • describe how users are authenticated with the Oracle Database 12c
  • describe administrator authentication when connecting to the Oracle Database 12c
  • create a user and unlock or reset a user's password in Oracle Database 12c
  • administer system privileges in Oracle Database 12c
  • administer object privileges in Oracle Database 12c
  • analyze privileges in Oracle Database 12c
  • describe the predefined database roles for managing privileges in Oracle Database 12c
  • create and assign profiles to users and modify the default profile in Oracle Database 12c
  • assign quotas on tablespaces in Oracle Database 12c
  • describe how to apply the principle of least privilege in Oracle Database 12c
  • implement password security in Oracle Database 12c
  • describe the locking mechanisms for managing data concurrency in Oracle Database 12c
  • identify causes of lock conflicts and detect lock conflicts in Oracle Database 12c
  • resolve lock conflicts and deadlocks in Oracle Database 12c
  • provide an overview of database security, auditing, and compliance monitoring in Oracle Database 12c
  • describe the requirements to implement unified auditing in Oracle Database 12c
  • enable unified auditing in Oracle Database 12c
  • describe the predefined unified audit policies in Oracle Database 12c
  • create unified audit policies in Oracle Database 12c
  • enable, disable, alter, and view audit policies in Oracle Database 12c
  • describe value-based auditing in Oracle Database 12c
  • describe fine-grained auditing (FGA) and assign FGA policies in Oracle Database 12c
  • describe considerations and guidelines for fine-grained auditing (FGA) in Oracle Database 12c
  • archive and purge the audit trail in Oracle Database 12c
  • create a user, assign a role, and configure auditing in Oracle Database 12c

Backing Up, Recovering, Importing, and Exporting Data in Oracle Database 12c

A key responsibility of an Oracle database administrator is protecting databases from failure. It's also important to be able to import and export data in various ways. In this course, you'll learn how to back up and recover databases, how to migrate and load data, and how to work with external tables in Oracle Database 12c. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).
  • start the course
  • recognize responsibilities for preventing and responding to database, statement, and user process failures in Oracle Database 12c
  • describe network failures, user errors and instance failures and describe the Oracle Flashback Technology features in Oracle Database 12c
  • describe media failure and distinguish between complete and point-in-time recovery in Oracle Database 12c
  • describe the Oracle data protection solutions in Oracle Database 12c
  • explain the use of checkpoints, redo log files, and log writers in Oracle Database 12c
  • describe and configure instance recovery, and use the Mean Time To Recover (MTTR) Advisor in Oracle Database 12c
  • configure and monitor the flash recovery area in Oracle Database 12c
  • multiplex control and redo log files in Oracle Database 12c
  • configure archiving of redo log files in Oracle Database 12c
  • describe backup solutions in Oracle Database 12c
  • describe backup types and the use of the Recovery Manager in Oracle Database 12c
  • use the Recovery Manager to configure backup settings in Oracle Database 12c
  • implement the Oracle suggested backup strategy and back up a control file to a trace file in Oracle Database 12c
  • create backups using RMAN commands and manage backups in Oracle Database 12c
  • recover a database and use the Data Recovery Advisor in Oracle Database 12c
  • recover from loss of a control file or redo log file in Oracle Database 12c
  • recover data files in NOARCHIVELOG and ARCHIVELOG modes in Oracle Database 12c
  • describe the functional components used for moving data and the use of Oracle Data Pump in Oracle Database 12c
  • work with Oracle Data Pump directory objects, clients, and modes in Oracle Database 12c
  • export data using Data Pump in Oracle Database 12c
  • import data using Data Pump in Oracle Database 12c
  • create a SQL*Loader control file in Oracle Database 12c
  • use SQL*Loader to load external data into tables in Oracle Database 12c
  • describe the uses of external tables in Oracle Database 12c
  • use ORACLE_LOADER to access external tables in Oracle Database 12c
  • create and populate an external table using ORACLE_DATAPUMP in Oracle Database 12c
  • use data dictionary views to access information about external tables in Oracle Database 12c
  • verify database configuration and export the HR schema in the Oracle Database 12c

Connectivity and Space Management in Oracle Database 12c

Key aspects of administering Oracle Database 12c include managing client connections to database servers and optimizing the ways data is stored to conserve space and improve system performance. In this course, you'll learn how to manage Oracle Net Services. You'll also learn how to work with tablespaces and data files, and how to manage the space used by the core storage structures, data blocks and segments. Finally, you'll learn about the Undo feature in Oracle Database 12c. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).
  • start the course
  • describe the functions of Oracle Net Services and Oracle Net Listener with Oracle Database 12c
  • use Oracle Net Services to connect to an Oracle Database 12c database instance
  • configure naming methods for connecting to an Oracle Database 12c database
  • describe and use tools for managing Oracle Net Services to manage connectivity with Oracle Database 12c
  • use the Oracle Net Configuration Assistant and the Listener Control utility to configure Oracle Database 12c
  • configure advanced connection options and test Oracle Net connectivity with Oracle Database 12c
  • describe dedicated and shared server configurations in Oracle Database 12c
  • configure communication between Oracle Database 12c database instances
  • describe how table data is stored in Oracle Database 12c
  • create a new tablespace in Oracle Database 12c
  • describe the default tablespaces created in a database and the options for altering the status or state of a tablespace
  • add a data file to a tablespace, modify a data file, and rename and move data files in Oracle Database 12c
  • describe and use Oracle Managed Files (OMF) in Oracle Database 12c
  • monitor Tablespace disk usage in Oracle Database 12c
  • describe block space management, including the use of row chaining and migration, in Oracle Database 12c
  • describe segment types and the allocation of segments to extents, and manage free space within segments in Oracle Database 12c
  • describe and control deferred segment creation in Oracle Database 12c
  • describe the phases of a table shrink operation
  • use the Automatic Segment Advisor to shrink segments online in Oracle Database 12c
  • shrink Oracle Database 12c segments using SQL and Enterprise Manager
  • manage resumable space allocation in Oracle Database 12c
  • describe the types and uses of table compression in Oracle Database 12c
  • use the Compression Advisor and the DBMS_COMPRESSION package to compress tables in Oracle Database 12c
  • describe the use of undo records in Oracle Database 12c
  • manage undo records and configure undo retention in Oracle Database 12c
  • describe and enable the Temporary Undo feature in Oracle Database 12c
  • monitor undo operations and use the Undo Advisor in Oracle Database 12c
  • create a tablespace, add a data file, and manage Undo operations in Oracle Database 12c

SQL Tuning, Resource Management, and Job Scheduling in Oracle Database 12c

Proper monitoring and tuning of databases significantly improves system performance. In this course, you'll learn how to use SQL tuning, optimizer statistics, and the range of SQL advisors included in Oracle Database 12c. You'll also learn how to manage resources to optimize performance and how to use the Oracle Scheduler to create and schedule jobs. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).
  • start the course
  • describe SQL tuning and the optimizer statistics used in Oracle Database 12c
  • describe the collection of optimizer statistics in Oracle Database 12c
  • use the Optimizer Statistics Console to set global preferences for optimizer statistics in Oracle Database 12c
  • gather optimizer statistics manually and set optimizer statistics preferences in Oracle Database 12c
  • describe concurrent statistics gathering in the Oracle Database 12c
  • view statistics information and the use of SQL plan directives in the Oracle Database 12c
  • describe the SQL Advisors available in Oracle Database 12c
  • describe and use the SQL Tuning Advisor in Oracle Database 12c
  • describe and use the SQL Access Advisor in Oracle Database 12c
  • describe and use the SQL Performance Analyzer in Oracle Database 12c
  • describe the uses of the Database Resource Manager in Oracle Database 12c
  • describe the default Resource Manager plan in Oracle Database 12c
  • create simple and complex resource plans in Oracle Database 12c
  • specify resource plan directives and allocate plan resources in Oracle Database 12c
  • describe the Active Session Pool mechanism, specify thresholds, and set idle timeouts in Oracle Database 12c
  • limit CPU utilization at the database and server levels, and monitor instance caging in Oracle Database 12c
  • track runaway queries and manage the mapping of sessions to resource consumer groups in Oracle Database 12c
  • monitor Resource Manager statistics in Oracle Database 12c
  • describe how to simplify management tasks using the Oracle Scheduler in Oracle Database 12c
  • describe the components of the Scheduler in Oracle Database 12c
  • describe the use of time and event-based schedules in the Oracle Database 12c
  • describe the creation of time and event-based jobs in the Oracle Database 12c
  • configure e-mail notifications and job chains using Oracle Scheduler in Oracle Database 12c
  • describe job classes and job prioritization in Oracle Database 12c
  • create a job array, create a file watcher, and configure file arrival events using Oracle Scheduler in Oracle Database 12c
  • schedule remote database jobs and view Oracle Scheduler metadata in Oracle Database 12c
  • collect statistics, use the SQL Tuning Advisor, and create a simple resource plan in Oracle Database 12c
Register Now
Oracle Database: 12c Administration Ed 2 e-learning bundle
  • Course ID:
    271472
  • Duration:
    n/a
  • Price:
    $229