Author Topic: Content of Oracle Database 12c DBA Fundamental  (Read 5067 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3974
  • Karma: +35/-11
Content of Oracle Database 12c DBA Fundamental
« on: January 09, 2016, 08:09:29 AM »
Oracle Database 12c DBA Fundamental 16:00 to 19:00 (USA PST) Saturday 
 02/07  02/14  02/21  02/28  03/07  03/14  03/21  03/28  04/04 04/11

Pre-requisition: Oracle 11g/12c SQL Fundamental

Price: The same class cost $3500 in other place. Our Price:
         $1749 for general public
         $1599 for Oracle 12c SQL student
         $1199 for Core Package 2013 student (Paid $2999 and up)
         $1099  for Core 2013 and MSBI2012 student (Paid $5000 and up)
         
Register: Click this link register use Credit Card.

Course Objectives

   Describe Oracle Database architecture
   Configure the database to support your applications
   Manage database security and implement auditing
   Implement basic backup and recovery procedures
   Move data between databases and files
   Employ basic monitoring procedures and manage performance
   Manage resources and automate tasks
   Work with Oracle Support

Chap 1 Exploring Oracle Database Architecture

   List the major architectural components of Oracle Database
   Explain memory structures
   Describe background processes
   Correlate logical and physical storage structures
   Describe pluggable databases
   Describe ASM storage components

Chap 2 Oracle Database Management Tools

   Use SQL*Plus to access the Oracle database
   Use Oracle Enterprise Manager Database Express to perform administrative tasks
   Use Oracle Enterprise Manager Cloud Control to manage the database instance

Chap 3 Managing the Database Instance

   Start and stop the Oracle database instance and components
   Modify database initialization parameters
   Describe the stages of database startup
   Describe database shutdown options
   View the alert log
   Access dynamic performance views

Chap 4 Configuring the Oracle Network Environment

   Use Enterprise Manager Cloud Control and Oracle Net Manager to:
   Create additional listeners
   Create Oracle Net Service aliases
   Control Oracle Net Listener
   Use the Listener Control Utility to manage Oracle Net Listener
   Use tnsping to test Oracle Net connectivity
   Identify when to use shared servers and when to use dedicated servers

Chap 5 Administering User Security

   Create and manage database user accounts:
   Authenticate users
   Assign default storage areas (tablespaces)
   Grant and revoke privileges
   Create and manage roles
   Create and manage profiles:
   Implement standard password security features
   Control resource usage by users

Chap 6 Managing Database Storage Structures

   Describe the storage of table row data in blocks
   Create and manage tablespaces
   Obtain tablespace information

Chap 7 Managing Space

   Describe how the Oracle Database server automatically manages space
   Save space by using compression
   Proactively monitor and manage tablespace space usage
   Describe segment creation in the Oracle database
   Control deferred segment creation
   Use the Segment Advisor
   Reclaim wasted space from tables and indexes by using the segment shrink functionality
   Manage resumable space allocation

Chap 8 Managing Undo Data

   Explain DML and undo data generation
   Monitor and administer undo data
   Describe the difference between undo data and redo data
   Configure undo retention
   Guarantee undo retention
   Enable temporary undo
   Use the Undo Advisor

Chap 9 Managing Data Concurrency

   Describe the locking mechanism and how Oracle manages data concurrency
   Monitor and resolve locking conflicts

Chap 10 Implementing Oracle Database Auditing

   Describe DBA responsibilities for security and auditing
   Enable unified auditing
   Create unified audit policies
   Maintain the audit trail

Chap 11 Backup and Recovery: Concepts

   Identify the types of failure that can occur in an Oracle database
   Describe instance recovery
   Describe complete and incomplete recovery

Chap 12 Backup and Recovery: Configuration

   Configure the fast recovery area
   Multiplex the control file
   Multiplex redo log files
   Configure ARCHIVELOG mode

Chap 13 Performing Database Backups

   Create consistent database backups
   Back up your database without shutting it down
   Create incremental backups
   Automate database backups
   Manage backups

Chap 14 Performing Database Recovery

   Determine the need for performing recovery
   Describe and use available options, such as Recovery Manager (RMAN) and the Data Recovery Advisor
   Perform recovery:
   Control file
   Redo log file
   Data file

Chap 15 Moving Data

   Describe ways to move data
   Explain the general architecture of Oracle Data Pump
   Create and use directory objects
   Use Data Pump Export and Import to move data between Oracle databases
   Use SQL*Loader to load data from a non-Oracle database (or user files)
   Use external tables to move data via platform-independent files

Chap 16 Database Maintenance

   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

Chap 17 Managing Performance

   Enterprise Manager to monitor performance
   Automatic Memory Management (AMM)
   The Memory Advisor to size memory buffers

Chap 18 Managing Performance: SQL Tuning

   Manage optimizer statistics
   Use the SQL Tuning Advisor to:
   Identify SQL statements that are using the most resources
   Tune SQL statements that are using the most resources
   Use the SQL Access Advisor to tune a workload

Chap 19 Using Database Resource Manager

   Configure the Database Resource Manager
   Access and create resource plans
   Create consumer groups
   Specify directives for allocating resources to consumer groups
   Map consumer groups to plans
   Activate a resource plan
   Monitor the Resource Manager

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3974
  • Karma: +35/-11
Re: Content of Oracle Database 12c DBA Fundamental
« Reply #1 on: August 26, 2016, 11:26:20 PM »
Oracle Database 12c DBA Fundamental 18:00 to 20:30 (USA PST) Tue, Thur
 09/27 to 11/03   total 30 hour

Class demo video: Use Oracle 12c RMAN recover lost data file:
https://www.youtube.com/watch?v=GFQ6hSnBoNQ&feature=youtu.be



Course Objectives

   Describe Oracle Database architecture
   Configure the database to support your applications
   Manage database security and implement auditing
   Implement basic backup and recovery procedures
   Move data between databases and files
   Employ basic monitoring procedures and manage performance
   Manage resources and automate tasks
   Work with Oracle Support

Chap 1 Exploring Oracle Database Architecture

   List the major architectural components of Oracle Database
   Explain memory structures
   Describe background processes
   Correlate logical and physical storage structures
   Describe pluggable databases
   Describe ASM storage components

Chap 2 Oracle Database Management Tools

   Use SQL*Plus to access the Oracle database
   Use Oracle Enterprise Manager Database Express to perform administrative tasks
   Use Oracle Enterprise Manager Cloud Control to manage the database instance

Chap 3 Managing the Database Instance

   Start and stop the Oracle database instance and components
   Modify database initialization parameters
   Describe the stages of database startup
   Describe database shutdown options
   View the alert log
   Access dynamic performance views

Chap 4 Configuring the Oracle Network Environment

   Use Enterprise Manager Cloud Control and Oracle Net Manager to:
   Create additional listeners
   Create Oracle Net Service aliases
   Control Oracle Net Listener
   Use the Listener Control Utility to manage Oracle Net Listener
   Use tnsping to test Oracle Net connectivity
   Identify when to use shared servers and when to use dedicated servers

Chap 5 Administering User Security

   Create and manage database user accounts:
   Authenticate users
   Assign default storage areas (tablespaces)
   Grant and revoke privileges
   Create and manage roles
   Create and manage profiles:
   Implement standard password security features
   Control resource usage by users

Chap 6 Managing Database Storage Structures

   Describe the storage of table row data in blocks
   Create and manage tablespaces
   Obtain tablespace information

Chap 7 Managing Space

   Describe how the Oracle Database server automatically manages space
   Save space by using compression
   Proactively monitor and manage tablespace space usage
   Describe segment creation in the Oracle database
   Control deferred segment creation
   Use the Segment Advisor
   Reclaim wasted space from tables and indexes by using the segment shrink functionality
   Manage resumable space allocation

Chap 8 Managing Undo Data

   Explain DML and undo data generation
   Monitor and administer undo data
   Describe the difference between undo data and redo data
   Configure undo retention
   Guarantee undo retention
   Enable temporary undo
   Use the Undo Advisor

Chap 9 Managing Data Concurrency

   Describe the locking mechanism and how Oracle manages data concurrency
   Monitor and resolve locking conflicts

Chap 10 Implementing Oracle Database Auditing

   Describe DBA responsibilities for security and auditing
   Enable unified auditing
   Create unified audit policies
   Maintain the audit trail

Chap 11 Backup and Recovery: Concepts

   Identify the types of failure that can occur in an Oracle database
   Describe instance recovery
   Describe complete and incomplete recovery

Chap 12 Backup and Recovery: Configuration

   Configure the fast recovery area
   Multiplex the control file
   Multiplex redo log files
   Configure ARCHIVELOG mode

Chap 13 Performing Database Backups

   Create consistent database backups
   Back up your database without shutting it down
   Create incremental backups
   Automate database backups
   Manage backups

Chap 14 Performing Database Recovery

   Determine the need for performing recovery
   Describe and use available options, such as Recovery Manager (RMAN) and the Data Recovery Advisor
   Perform recovery:
   Control file
   Redo log file
   Data file

Chap 15 Moving Data

   Describe ways to move data
   Explain the general architecture of Oracle Data Pump
   Create and use directory objects
   Use Data Pump Export and Import to move data between Oracle databases
   Use SQL*Loader to load data from a non-Oracle database (or user files)
   Use external tables to move data via platform-independent files

Chap 16 Database Maintenance

   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

Chap 17 Managing Performance

   Enterprise Manager to monitor performance
   Automatic Memory Management (AMM)
   The Memory Advisor to size memory buffers

Chap 18 Managing Performance: SQL Tuning

   Manage optimizer statistics
   Use the SQL Tuning Advisor to:
   Identify SQL statements that are using the most resources
   Tune SQL statements that are using the most resources
   Use the SQL Access Advisor to tune a workload

Chap 19 Using Database Resource Manager

   Configure the Database Resource Manager
   Access and create resource plans
   Create consumer groups
   Specify directives for allocating resources to consumer groups
   Map consumer groups to plans
   Activate a resource plan
   Monitor the Resource Manager

Pre-requisition: Oracle 11g/12c SQL Fundamental

Register: Click this link register use Credit Card.