Professional Program on Oracle Database

Date: 
06 June - 01 July 2011

Program Objectives

This hands-on oriented course is designed to give participants a firm foundation in Oracle database administration, core features of Oracle database, Graphical Tool for Database Development (SQL developer) and Crystal report. Participants will learn how to install and maintain an Oracle database, gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another, develop skills in PL/SQL and learn on the graphical tools for database development. Participants will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

Course Outline:

The course will be mostly hands on based program. The course will focus on the following topics:

  • Oracle Database Administration (Oracle DBA)
    • Oracle Database Architecture
    • Installing your Oracle Software
    • Creating an Oracle Database
    • Managing the Oracle Database Instance
    • Manage the ASM Instance
    • Configuring the Oracle Network Environment
    • Managing Database Storage Structures
    • Administering User Security
    • Managing Data Concurrency
    • Managing Undo Data
    • Implementing Oracle Database Auditing
    • Database Maintenance
    • Performance Management
    • Backup and Recovery Concepts
    • Moving Data
    • Working with Support
  • SQL
    • Retrieve Data Using the SQL SELECT Statement
    • Restrict and Sort Data
    • Use Single-Row Functions to Customize Output
    • Conversion Functions and Conditional Expressions
    • Aggregated Data Using Group Functions
    • Display Data From Multiple Tables Using Joins
    • Use Sub-queries to Solve Queries
    • SET Operators
    • Data Manipulation
    • Use DDL Statements to Create and Manage Tables
    • Other Schema Objects
    • Control User Access
  • PL/SQL
    • Declare PL/SQL Identifiers
    • Write Executable Statements
    • Interaction with the Oracle Server
    • Control Structures
    • Composite Data Types
    • Explicit Cursors
    • Exception Handling
    • Stored Procedures and Functions
    • Packages and deployment of the packages
    • Implement Oracle-Supplied Packages in Application Development
    • Dynamic SQL
    • Design Considerations for PL/SQL Code
    • Triggers
    • Creating Compound, DDL, and Event Database Triggers
    • PL/SQL Compiler
    • Manage PL/SQL Code
    • Manage Dependencies
  • SQL Developer
  • Reporting using Crystal Report

Salient Features of Application Software

  • Operating System: Windows or Linux Database Server; Windows Clients
  • Oracle Database Software: Oracle 11g/Oracle 12g
  • Application Development Software: Oracle SQL Developer

Training Duration:

23 Days (excluding travel time). Classes might be held on Saturdays and
Sundays (or public holidays during the training period, 06 June – 28 June 2011)

Training Venue: 

Asian Institute of Technology, Klong Luang, Pathum Thani, Thailand

Training Fee

Training fee per participant = USD 4,000 (US Dollar four thousand) per person

Remarks

  • The total training fee does not cover the expenses for international travel, daily subsistence allowance, accommodation, visa fees, and airport taxes. Client organizations will bear the above costs.
  • Major medical treatment, health insurance and travel insurance are not covered in the course fee. Participants must secure their entry visa for Thailand, along with their medical and travel insurances.
  • The training fee includes the training, course materials, books or periodicals relevant for the class, study visit to local host organizations, pick up and transfer from Suvannabhummi International Airport Bangkok and AIT.

Stay In Touch

Please fill out all information below and you will receive an email within a 24 hour period for any further questions please fillup the form and our scheduling department and they will assist you.