@ CHARUSAT
Workforce Development Program

The demand for IT professionals is growing at an exponential rate.

Oracle Corporation launched the workforce development program (WDP) to address the skill shortage challenges in the global Information Technology (IT) industry. With this program, oracle also strives to meet the need for accessible and low cost IT skills training. The WDP enables participating educational institution to deliver oracle through full-time part-time programs for students in their local communities.

Oracle Academy

The Oracle Academy is a partnership between Oracle and Institutes, designed to equip students with database, SQL, Java programming, and general business skills. Oracle works directly with participating institutes to provide extensive teacher training, ongoing professional development and support, a state-of-the-art curriculum, and an online learning and development environment.

Oracle Academy grants certificates from Oracle University which are needed in the business field that help applicants enhance their skills as well as find job opportunities in both the Egyptian and Middle East Markets. The certificates are given in the fields of Oracle Technology and Oracle e-Business.

Oracle Academy Training Plan is an integrated solution that will provide you with the education components you will need to be successful with the technology you have selected.

The Oracle Academy prepares students for information technology (IT) careers and provides teachers with world-class training and professional development opportunities by granting software, curriculum, and certification resources to colleges and universities.

  • Authorized oracle training leading to oracle certification
  • Courseware from oracle
  • Hands-on experience on Oracle software
  • Discount vouchers for students on examination fees
  • Participation certification after completion of each module
  • Student-centered curriculum. The professionally designed curriculum is geared to meet the learning needs of high school students. Students reinforce concepts through real-world projects. Advanced students can prepare for the Oracle 9i SQL certification exam.
  • Students, who wish to pursue professional certification, receive a 50 percent discount on select self-guided exam preparation packages.
  • Discounts on learning tools, preparation materials, and exams help you test and expand your knowledge.
  • Students can test their knowledge against professional standards and save 40 percent, with a discount voucher toward select Oracle Certified Professional exams.
  • WDP Student Kit per WDP student
  • Oracle WDP Membership
  • A part of the Global Oracle University website
  • Oracle WDP Training provider
  • Usage of the Oracle software for training
  • Special OCP examination fees for Instructors
  • Faculty assistance through Technology Based self paced training CDs
  • A new line of business
  • High return on investment
  • Breakeven point – low
  • Association with one of the largest Global Brand
  • Positioning of the college – Global
  • Word of Mouth among students improves
  • Potential increase in earning power
  • Globally recognized industry certification
  • Competitive edge, differentiation & credibility
  • Use of certification logos
  • Join member community of more than 135,000 IT professional worldwide for networking and continuous learning
  • Courses at a glance

    Introduction to 9i SQL

  • Writing a Basic SQL Statement
  • Restricting and Sorting Data
  • Displaying Data from Multiple Tables
  • Aggregating Data by Using Group Functions
  • Writing Subqueries
  • Producing Readable Output with iSQL*Plus
  • Manipulating Data
  • Creating and Managing Tables
  • Including Constraints
  • Creating Views
  • Controlling User Access
  • Using Set Operators
  • Hierarchical Retrieval
  • Oracle9i Database Administration Fundamental I

    This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database tasks.

  • Identifying database administrative users
  • Managing an Oracle Instance
  • Creating a Database
  • Using the Data Dictionary
  • Maintaining the Control File
  • Describing storage hierarchy
  • Establishing the difference between SYSTEM and Non-SYSTEM tablespaces
  • Storage Structures and Relationships
  • Managing Undo Data
  • Understanding the difference between automatic undo management and manual undo management
  • Creating and maintaining UNDO tablespaces
  • Managing Tables
  • Managing Indexes
  • Oracle9i Database Administration Fundamental II

    Develop your ability to manage the industry's most advanced information system. Learn several methods to backup and to recover your Oracle database

  • Basic Oracle Net Architecture
  • Basic Oracle Net Services Server-Side Configuration
  • Basic Oracle Net Services Client-Side Configuration
  • Usage and Configuration of the Oracle Shared Server
  • Backup and Recovery Overview
  • Instance and Media Recovery Structures
  • Oracle Recovery Manager (RMAN) Overview and Configuration
  • User-Managed Backups
  • RMAN Backups
  • User-Managed Complete Recovery
  • RMAN Complete Recovery
  • User-Managed Incomplete Recovery
  • RMAN Repository Maintenance
  • Transporting Data Between Databases - Import, Export, guidelines
  • Oracle9i Database Performance Tuning

    Database performance tuning is critical to any effective information system

  • Overview of Oracle 9i Database Performance Tuning
  • Diagnostic and Tuning Tools
  • Database Configuration and I/O Issues
  • Tuning the Shared Pool
  • Tuning the Buffer Cache
  • Dynamic Instance Resizing
  • Sizing Other SGA Structures
  • Tuning the Oracle Shared Server
  • Optimizing Sort Operations
  • Using Resource Manager
  • SQL Statement Tuning
  • Using Oracle Blocks Efficiently
  • Using Oracle Data Storage Structures Efficiently
  • Monitoring and Detecting Lock Contention
  • Introduction to 9i SQL

  • Same as DBA track
  • Oracle9i: Program with PL/SQL
  • This course is a foundation of basic knowledge, which they can build upon as they work toward a career as an Oracle Application

  • Overview of PL/SQL Programs
  • Creating Procedures
  • Creating Packages
  • More Package Concepts
  • Creating Database Triggers
  • More Trigger Concepts
  • Creating Functions
  • Managing Subprograms
  • Oracle Supplied Packages
  • Manipulating Large Objects
  • Managing Dependencies
  • Oracle9i Forms Developer: Builds Internet Application

    This course teaches you to develop and deploy Internet applications using Oracle9i Forms. Working in a rapid development environment, participants learn how to customize forms through user input items and how to control data access by creating event-related triggers

  • Introduction to Oracle Forms Developer and Oracle Forms Services
  • Running a Forms Developer Application
  • Working in the Forms Developer Environment
  • Creating a Basic Form Module
  • Working with Data Blocks and Frames
  • Working with Text Items
  • Creating LOVs and Editors
  • Creating Additional Input Items
  • Creating Noninput Items
  • Working with Other Canvas Types
  • Introduction to Triggers – Producing, Debugging & Adding Function
  • Runtime Messages and Alerts
  • Query Triggers
  • Writing Flexible Code
  • Select a training path befitting your career
  • Address your skill gaps with training and practice
  • Earn a credential to establish credibility for your skill level (OCP)