Oracle Administration

Course details

ORACLE DBA

MINISTRY APPROVED INSTITUTE

Course Overview
(PL/SQL, Workshop I & Workshop II)
Oracle 10g- Introduction to SQL and PL/SQL
Course Contents:
Introduction
Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single Row Functions to Customize Reports
Reporting Aggregated Data Using the Group Functions
Displaying Data From Multiple Tables
Using Sub queries to Solve Queries
Using the SET Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects
Managing Objects with Data Dictionary Views
Controlling User Access
Generating Reports by Grouping Related Data
Managing Data in Different Time Zones
Searching Data Using Advanced Sub queries
Hierarchical Data Retrieval
Introduction to PL/SQL Objects
Procedural Language
PL/SQL Blocks, Anonymous Blocks and Named Blocks
Creating PL/SQL Procedures and Functions
Understanding Triggers
Packages
Oracle 10g-Administration Workshop I
Course Contents:
Introduction
Installing Oracle Database 10g Software
Create an Oracle Database
Database interfaces
Controlling the database
Storage Structures
Administering users
Managing Schema Objects
Managing Data
PL/SQL
Oracle Database Security
Oracle Net Services
Oracle Shared Server
Performance Monitoring
Proactive Maintenance: Objectives Undo Management
Monitoring and Resolving Lock Conflicts
Backup and Recovery Concepts
Database Backups
Database Recovery
Oracle 10g-Administration Workshop II
Course Contents:
Using Globalization Support
Securing the Oracle Listener
Configuring Recovery Manager
Using Recovery Manager
Diagnostic Sources
Recovering from non-critical losses
Database Recovery
Flashback database
Recovering from User Errors
Dealing with Database Corruption
Automatic Database Management
Monitoring and Managing Storage
Automatic Storage Management
Monitoring and Managing Memory
Managing Resources
Automating Tasks with the Scheduler Updated on 25 November, 2019