SQL (Structured Query Language)
- Introduction SQL
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single Row Functions to Customize Output
- Manipulating Data
- Reporting Aggregated Data Using the Group Functions
- Displaying Data from Multiple Tables
- Using the Set Operators
- Using Sub queries to Solve Queries
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
- Managing Objects with Data Dictionary Views
- Controlling User Access
- Managing Schema Objects
- Manipulating Large Data Sets
- Generating Reports by Grouping Related Data
- Managing Data in Different Time Zones
- Retrieving Data Using Sub queries
- Hierarchical Retrieval
- Regular Expression Support
Administrator Workshop – I
- Introduction
- Installing the Oracle Database Software
- Creating an Oracle Database
- Managing the Oracle Instance
- Managing Database Storage Structures
- Administering User Security
- Managing Schema Objects
- Managing Data and Concurrency
- Managing Undo Data
- Automatic UNDO Management
- Implementing Oracle Database Security
- Configuring the Oracle Network Environment
- Proactive Maintenance
- Performance Monitoring
- Backup and Recovery Concepts
- Performing Database Backups
- Performing Database Recovery
- Performing Flashback
- Flashback data archive
- Log Minor Features
- Moving Data
Administrator Workshop – II
- Introduction
- Configuring Recovery Manager
- Using Recovery Manager
- Data Recovery Advisor
- Recovering from Noncritical Losses
- Database Recovery
- Flashback
- Dealing with Database Corruption
- Monitoring and Managing Memory
- Automatic Performance Management
- Managing Schema Objects
- Partitioning in Oracle
- Managing Storage
- Automatic Storage Management
- Managing Resources
- Automating Tasks with the Scheduler
- Database Security
- Using Globalization Support
- Using Materialized Views
- Java in Oracle
- An Introduction to Java
- JDBC Programming
- Java Stored Procedures
Duration: 2.5 Month