USALaoTu 独家推出高薪利器 Oracle Database 12c DBA Fundamental 18:00 to 20:30 (USA PST) Tue, Thur
09/27 to 11/03 total 30 hour
Oracle 大学的教材,Oracle OCM 博士生导师讲课。 价格连Oracle大学同样课程一半都不到。Class demo video(视频预览) : Use Oracle 12c RMAN recover lost data file:
&feature=youtu.beCourse 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.