Aptech Computer Training ORACLE (Database Administration Track) Aptech Computer Training
33% off through Laimoon! Get This Deal
Price: AED 4,000
AED 5,970
Instructor led live virtual classroom online. Classes may be individual or in group.
  • Starting Date: Enquire About It
  • Timings: Flexible options
  • Accrediting country: UAE

Course details

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
Updated on 28 March, 2016

About Aptech Computer Training

Jurassic Institute of Management and Technology is a Learning Solutions Company playing a key role in helping individuals, organizations and nations adapt to the changing requirements of a knowledge-driven world. Jurassic commenced its IT and NON IT Education & Training business in 1993 in UAE. Jurassic is the franchisees of the brand Aptech Computer Education, Arena Multimedia and English Express in UAE. Aptech Computer Education, a division of Aptech Limited has over 3,256 training centers in 56 countries. Arena Multimedia - Global Multimedia Education, leading the way in Multimedia Training has trained  over 4,00,000 students.

See all Aptech Computer Training courses

Enquire about this course

You may add more courses here,
your list will be saved.

Rate this page