Main Menu

Credit Cards

Our Partners


Authorized Pearson Vue Test Center



TESDA

Contest

  

Hands On IT TRAINING

Oracle Database 11g


26


Course Duration: 30 hours

Course Description:

The trainees should be able to configure, maintain, and administrate this powerful, enterprise-scale,and  globally-popular database.

Chapter 1

Critical Database Concepts
  • Oracle Database 11g Architecture Options
  • Installing Oracle Database 11g and Creating a Database
  • Upgrading to Oracle Database 11g
  • Planning Oracle Applications—Approaches, Risks, and Standards

Chapter II

SQL and SQL*Plus
  • The Basic Parts of Speech in SQL
  • Basic SQL*Plus Reports and Commands
  • Getting Text Information and Changing It
  • Searching for Regular Expressions
  • Playing the Numbers
  • Dates: Then, Now, and the Difference
  • Conversion and Transformation Functions
  • Grouping Things Together
  • When One Query Depends upon Another
  • Some Complex Possibilities
  • Changing Data: insert, update, merge, and delete
  • DECODE and CASE: if, then, and else in SQL
  • Creating and Managing Tables, Views, Indexes, Clusters, and Sequences
  • Partitioning
  • Basic Oracle Security

Chapter III

Beyond the Basics
  • Advanced Security—Virtual Private Databases
  • Advanced Security: Transparent Data Encryption
  • Working with Tablespaces
  • Using SQL*Loader to Load Data
  • Using Data Pump Export and Import
  • Accessing Remote Data
  • Using Materialized Views
  • Using Oracle Text for Text Searches
  • Using External Tables
  • Using Flashback Queries
  • Flashback—Tables and Databases
  • SQL Replay

Chapter IV

PL/SQL
  • An Introduction to PL/SQL
  • Online Application Upgrades
  • Triggers
  • Procedures, Functions,
    and Packages
  • Using Native Dynamic SQL and DBMS
  • PL/SQL Tuning

Chapter V

Object-Relational Databases
  • Implementing Object Types, Object Views, and Methods
  • Collectors (Nested Tables and Varying Arrays)
  • Using Large Objects
  • Advanced Object-Oriented Concepts

Chapter VI

Java in Oracle
  • An Introduction to Java
  • JDBC Programming
  • Java Stored Procedures

Other Short Courses..


What do you think?

Leave a Question

 



Inquiries


@ Joshua Romeo

Ang fee is 10500 pesos in cash. Ipopost po namin aming June and July schedule soon. Keep posted for the updates.
Kailan ang training for June and july 2017 and HM?
@ MARLON TOYAOAN

The fee is 10500 pesos in cash.
Hi, How much is he training fee for oracle 11g? Thank you.
Ask ko po ung scheduled for the training ng oracle 11g.tnx po
  
CNCTC Live Chat Inquiry

Subscribe

Stay Informed Subscribe

Name *

Email *