ORACLE (Database Administration Track)

Ministry Approved Certificate

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