Oracle DBA 11g
.........................................................................................
Architecture & Administration I
Architectural overview of Oracle Database 11g
- Memory Structures
- Process Structures
- Storage Structures
Installing and Creating a Database
- Tools for Administering an Oracle Database
- Oracle Database Installation
- Install the Oracle Software
- Create a Database
Instance Management
- Initialization Parameters
- Stages of Database Startup and Shutdown
- Alert Log and Trace Files
- Data Dictionary and Dynamic Performance Views
Oracle Storage
- Tablespaces and Datafiles
- Manage Tablespaces
Oracle Security
- Manage Database User Accounts
- Manage Privileges
- Manage Roles
- Manage Profiles
- Database Security
- Database Auditing
Globalization
- Language-Dependent Behavior
- Database and NLS Character Sets
SQL
DDL and Schema Objects
- Database/Schema Objects
- Tables/Indexes
- Data Types
- Constraints
- Temporary Tables
- Views
- Sequences
- Synonyms
DML and Concurrency
- Data Manipulation Language (DML) Statement
- Insert/Update/Delete Statement
- Transactions
- PL/SQL Objects
- Locking Conflicts
- Manage Undo
Retrieving, Restricting, and Sorting Data Using SQL
- SQL SELECT Statements
- Limit the Rows Retrieved by a Query
- Sort the Rows Retrieved by a Query
- Substitution Variables
Single-Row and Conversion Functions
- SQL Functions
- Character, Number, and Date Functions
- Conversion Functions
Group Functions
- Group Functions
- Using the GROUP BY Clause
- Using the HAVING Clause
SQL Joins
- Equijoins and Nonequijoins
- Self-Join
- Using Outer Joins
- Cartesian Product
Subqueries and Set Operators
-
Subqueries
-
Single-Row and Multiple-Row Subqueries
-
Set Operators
-
Control Order of Returned Rows
Oracle Net
Oracle Networking
- Manage Oracle Network
- Oracle Shared Server
Backup & Recovery
Configuring the Database for Backup and Recovery
- Oracle Database Failures
- Instance Recovery
- Checkpoints, Redo Log Files, and Archived Log files
- ARCHIVELOG Mode
- Flash Recovery Area
Back Up with RMAN
- Consistent Database Backups
- Inconsistent Database Backups
- Incremental Backups
- Retention Policy
- Whole Database Backup
- Configure Backup Settings
- Allocate Channels
Restore and Recover with RMAN
- Data Recovery Advisor
- Complete Recovery using RMAN
- Incomplete Recovery Using RMAN
- Recover Using a Backup Controlfile
- Block Media Recovery
Advanced RMAN Facilities
- RMAN Recovery Catalog
- RMAN Stored Scripts
- Duplicate Database
- Disaster Recovery
- Automated TSPITR
User-Managed Backup, Restore, and Recovery
- Recover from a Lost Redo Log Group
- User-Managed Complete Database Recovery
- User-Managed Incomplete Database Recovery
- User-Managed Backups
- Back Up and Recover a Controlfile
Flashback
-
Flashback Query
-
Flashback Transaction
-
Flashback Table
-
Flashback Database
-
Flashback Data Archive
Monitoring & Performance Tuning
Moving and Re-Organizing Data
- Directory Objects, SQL*Loader, and External Tables
- Oracle Data Pump
- Transportable Tablespaces and Databases
- Resumable Space Allocation
- Using the Segment Shrink Functionality
The AWR and the Alert System
- Automatic Workload Repository (AWR)
- Use Advisory Framework
- Manage Alerts and Thresholds
