ORACLE 11G DBA

• Introducing SQL Basic Commands
• Writing basic select statements
• Restricting and sorting of data
• Introducing sql function
• Single row function and group function
• Conditional Expression
• Using substitution on variable
• Introducing sql commands
• Using DDL Statements
• Managing Tables
• Data manipulation operation
• Understanding transaction
• Using transaction control statements
• Overview of locks
• Using flashback and purge command
• Granting and revoking system and object privileges
• Designing tables by using key constraints
• Deferred constraints
• Retrieving data from more than one tables using join operation
• Aggregating Data Using Group Functions
• Introducing With View
• Introducing With Indexes
• Introducing With Synonyms
• Introducing With Sequence And Use With Database
• Introducing Sub queries
• Single row sub query ,Multiple row sub query
• Introduction
• Correlated sub query
• Top - n analysis
• Using the Set Operators
• Inserting and Updating Data
• Deleting Data
• Creating Other Schema Objects
• Managing Objects with Data Dictionary Views
• Date and Time Function
• Rollup and Cube Operator Using Group by Function
• Multiple Insertion and Types
• Hierarchical Tree
• Sql loader

ADVANCED SQL

• Overview of analytical function
• Introducing inline view
• Introduction of With clause
• Materialize view
• Overview of restore
• Overview of semi join and anti join
• Embedding sub query with Dml operation

ORACLE DATABASE 11G : ADMINISTRATION WORKSHOP 1 RELEASE 1

• Introduction (database architecture)
• Describe course objectives
• Explore the oracle 11g database architecture
• Installing the oracle database software on windows and linux
• Creating on oracle database
• Managing the oracle instance
• Managing database strong structure
• Administering user security
• Managing the oracle instance
• Managing database storage structures
• Administering user security
• Managing schema security
• Managing schema objects
• Managing data and concurrency
• Managing undo data
• Implementing oracle database security
• Configuring the oracle network environment
• Proactive maintenance
• Performance management
• Backup and recovery concepts
• Performing database recovery
• Performing flashbacks
• Moving data

ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP 2 RELEASE 2

• Introduction
• Configuring Recovery Manager
• RMAN Backup
• Recovering from Non-critical Losses
• Database recovery
• flashback
• Dealing with Database Corruption
• Monitoring and Managing Memory
• Monitoring and Managing Memory
• Managing Schema objects
• Managing Storage
• Automatic Storage Management
• Managing Resources
• Automating Tasks with the Scheduler
• Database Security
• Using Globalization Support

ORACLE-PL/SQL

• Declaring PL/SQL identifiers
• Writing executable statements
• Writing control structures
• Using explicit cursors
• Creating stored procedures
• Creating stored functions
• Creating packages
• Creating triggers

REDHAT LINUX

• Linux ideas and History
• Installation
• Linux Basic COMMANDS
• Users, Groups and Permissions
• VIM: Text Editor
• YUM server configuraton
• System configuration tools
• Investigating and managing process
• Configuring the BASH shell
• Finding and processing files
• Linux file system
• Package management
• File system management