ORACLE TRAINING IN Nepal
Oracle Database 11g Certified Professional
ORACLE DATABASE 11G SQL FUNDAMENTAL
Course Duration: 1.5 Month
Course Hour: 1hour/day
Total Hour:45hr
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
- Displaying Data from Multiple Tables
- Using Subqueries to Solve Queries
- Using the Set Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
ORACLE DATABASE 11G WORKSHOP I
Course Duration: 1.5 Month
Course Hour: 1hour/day
Total Hour:45hr
Introduction
- Exploring the Oracle Database Architecture
- Installing your Oracle Software
- Creating an Oracle Database Using DBCA
- Managing the Database Instance
- Managing the ASM Instance
- Configuring the Oracle Network Environment
- Managing Database Storage Structures
- Administering User Security
- Managing Data Concurrency
- Managing Undo Data
- Implementing Oracle Database Auditing
- Database Maintenance
- Performance Management
- Backup and Recovery Concepts
- Performing Database Backups
- Performing Database Recovery
- Moving Data
- Working with Support
ORACLE DATABASE 11G WORKSHOP II
Course Duration: 1.5 Month
Course Hour: 1hour/day
Total Hour:45hr
Core Concepts and Tools of the Oracle Database
- Configuring for Recoverability
- Using the RMAN Recovery Catalog
- Configuring Backup Settings
- Creating Backups with RMAN
- Restore and Recovery Tasks
- Using RMAN to Perform Recovery
- Monitoring and Tuning RMAN
- Diagnosing the Database
- Using Flashback Technology I and II
- Performing Flashback Database
- Managing Memory
- Managing Database Performace
- Managing Performace by SQL Tuning
- Managing Resources
- Automating Tasks with the Scheduler
- Managing Space
- Managing Space for the Database
- Duplicating a Database
