ORACLE DBA2 TRAINING
- Introduction to Oracle
- Retrieve Data using the SQL SELECT Statement
- Learn to Restrict and Sort Data
- Usage of Single-Row Functions to
- Customize Output
- Invoke Conversion Functions and
- Conditional Expressions
- Aggregate Data Using the
- Group Functions
- Display Data From Multiple
- Tables Using Joins
- Use Sub-queries to Solve
- Queries
- Data Manipulation Statements
- Use of DDL Statements to Create
- and Manage Tables
- Other Schema Objects
- Control User Access
- Management of Schema Objects
- Manage Objects with Data
- Dictionary Views
- Manipulate Large Data Sets
- Retrieve Data Using Sub-queries
- Oracle Admin part I
Exam Code:- 1Z0 – 0 43
- Introduction
- Configuring Recovery Manager
- Using Recovery Manager
- Oracle Secure Backup
- Recovering from Noncritical
- Losses
- Incomplete Recovery
- Flashback
- Dealing with Database
- Corruption
- Monitoring and
- Managing Memory
- Automatic Performance Management
- Monitoring and Managing Storage I
- Monitoring and Managing Storage II
- Automatic Storage Management
- VLDB Support
- Managing Resources
- Automating Tasks with the Scheduler
- Database Security
- Data Movement
- Using Globalization Support
- Oracle Admin part II
- Introduction
- Incomplete Recovery
- Flashback
- Dealing with Database Corruption
- Monitoring and Managing Memory
- Automatic Performance Management
- Monitoring and Managing
- Storage I
- Monitoring and Managing
- Storage II
- Automatic Storage Management
- VLDB Support
- Managing Resources
- Automating Tasks with the Scheduler
- Database Security
- Data Movement
- Using Globalization Support