Description

1. Introduction: Managing The Database Instance

1.1. The Database Management Tools
1.2. EM Database Express
1.3. EM Cloud Control
1.4. SQL Developer
1.5. Database Administration Duties

2. Introduction: Database Architecture Review

2.1. Database Instance Configurations
2.2. Memory Structures
2.3. Process Structures
2.4. Storage Architecture

3. Introduction: Starting & Stopping Database Services

3.1. Start & Stop The Database Listener
3.2. About Database Startup/Shutdown
3.3. SYSOPER
3.4. SYSDBA
3.5. Database State & Stages
3.6. Startup With EM Cloud Control
3.7. Startup With SQLPLUS
3.8. Shutdown With EM Cloud Control
3.9. Shutdown With SQLPLUS
3.10. Using MS Windows Services

4. Introduction: Oracle Network Environment

4.1. Oracle NET Services Architecture
4.2. Oracle NET Configuration Assistant
4.3. Oracle NET Manager
4.4. Using EM Cloud Control
4.5. Advanced Network Compression
4.6. Troubleshooting Network Problems

5. Introduction: Diagnostics & Oracle Support

5.1. About Database Diagnostics
5.2. Fault Diagnosability Infrastructure
5.3. Database Instance Health Snapshot
5.4. The Support Workbench
5.5. Proactive Database Health Checks
5.6. Package Diagnostic Data
5.7. Working With The Knowledge Base

6. Storage: Tablespace Management

6.1. Starter Tablespaces
6.2. Create Tablespace With EM CC
6.3. Create Tablespace With SQL
6.4. Manage Tablespaces With EM CC
6.5. Manage Tablespaces With EM DE
6.6. Manage Tablespaces With SQL
6.7. DROP Tablespace
6.8. ALTER Tablespace

7. Storage: Advanced Tablespace Management

7.1. Managing Temporary Tablespaces
7.2. Temp Tablespace Groups With EM
7.3. Temp Tablespace Groups With SQL
7.4. Default Permanent Tablespaces
7.5. Bigfile Tablespaces
7.6. Managing The SYSAUX Tablespace

8. Storage: Data Files & Temp Files Management

8.1. Manage Data Files With EM
8.2. Access Metadata With SQL
8.3. Manage Data Files With SQL
8.4. Manage Temp Files
8.5. Oracle-Managed Files (OMF)

9. Storage: Undo Data & Undo Tablespaces

9.1. About Undo Space Management
9.2. Configure Undo Management
9.3. Guarantee Undo Retention
9.4. Monitor Undo Space With SQL
9.5. Use The EM Undo Advisor

10. Security & Schemas: Security Overview & Database Privileges

10.1. Database Security Principles
10.2. Database System Privileges
10.3. Database Object Privileges
10.4. Super Administrator Roles
10.5. Privilege Analysis

11. Security & Schemas: User Security

11.1. Create & Manage User Accounts
11.2. Manage Users With EM
11.3. Manage Users With SQL
11.4. CREATE User
11.5. ALTER User
11.6. DROP User
11.7. Grant & Revoke Privileges
11.8. Resource Limits Via Profiles
11.9. ALTER Profile
11.10. DROP Profile
11.11. Password Management Via Profiles
11.12. Role-Based Security Management
11.13. Alter User…Default Role
11.14. Set Role
11.15. Delegating Privilege Authorization
11.16. With Admin Option & System Privileges

12. Security & Schemas: Database Auditing

12.1. Auditing Database Activity
12.2. Traditional Auditing
12.3. Unified Auditing
12.4. Create Audit Policy

13. Security & Schemas: SQL Loader

13.1. Loader Concepts
13.2. Loader From The Command Line
13.3. Control File Options
13.4. Load Methods
13.5. Loader Express Mode
13.6. Loader From EM

14. Security & Schemas: Export & Import

14.1. Manage Directory Objects
14.2. The Data Pump Architecture
14.3. Data Pump Export
14.4. Data Pump Import
14.5. Data Pump Dictionary Views
14.6. Using The EM CC Interface

15. Performance & Availability: Managing Performance & SQL Tuning

15.1. Management Advisory Framework
15.2. Performance Monitoring & AWR
15.3. The SQL Tuning Advisor
15.4. Monitoring Exceptions With Metrics

16. Performance & Availability: Data Concurrency

16.1. About System & User Locks
16.2. Monitor & Manage User Locks
16.3. Monitor Locks With Data Dictionary
16.4. Manage Locks With EM

17. Performance & Availability: Backup & Recovery Concepts

17.1. Backup & Recovery Structures
17.2. Managing Redo Data
17.3. Configuring For Recoverability
17.4. Instance Recovery
17.5. Recoverability Checklist

puts on Oracle Database Administration you can connect here.
Contact the L&D Specialist at Locus IT.

Locus Academy has more than a decade experience in delivering the training/staffing on Oracle Database for corporates across the globe. The participants for the training/staffing on Oracle Database are extremely satisfied and are able to implement the learnings in their on going projects.