Oracle Database

IT Sharks

Updated on 08 November, 2015
Price: EGP 600

Course details

Part 1: Oracle SQL

Fundamental  I:

  1. CH1  : Introduction to Oracle Database
  2. CH2  : Retrieving Data Using the SQL SELECT Statement  
  3. CH3  : Learn to Restrict and Sort Data  
  4. CH4  : Using Single Row Functions to Customize Output  
  5. CH5  : Aggregate Data Using the Group Functions
  6. CH6  : Display Data From Multiple Tables  
  7. CH7  : Use Subqueries To Solve Queries  
  8. CH8  : The Set Operators    
  9. CH9  : Data Manipulation Statements
  10. CH10 : Use of DDL Statements to Create and Manage Tables
  11. CH11 : Other Schema Objects  

Fundamental  II : Advanced SQL

  1. CH1  : introduction to DBA(Control User Access) 
  2. CH2  : Mangement of Schema Objects 
  3. CH3  : Manage Objects with Data Dictionary Views 
  4. CH4  : Manipulating Large Data Sets
  5. CH5  : Data Management in different Time Zones  
  6. CH6  : Retrieve Data Using Sub-queries 
  7. CH7  : Hierarchical Retrieval  

Part 2: Oracle Pl/SQL

PL/SQL Fundamentals:

  1. CH1  : Introduction to PL/SQL  
  2. CH2  : Declaring PL/SQL Identifiers
  3. CH3  : Writing Executable Statements  
  4. CH4  : Interacting with the Oracle Server  
  5. CH5  : Control Structures  
  6. CH6  : Composite Data Types  
  7. CH7  : Explicit Cursors  
  8. CH8  : Exceptions Handling  

PL/SQL Program Units:

  1. CH1  : Stored Procedures 
  2. CH2  : Stored Functions and Debugging Subprograms
  3. CH3  : packages
  4. CH4  : triggers   

About IT Sharks

We_They has a Great Expertise, with deep Knowledge of fundamental in IT Training Courses, They offer excellent opportunities for everyone, whether you’re at the beginning of your career, or if you’re already a professional looking to enhance your qualifications. No matter where you are professionally, We_They are tailor made to fit your needs and fill the gap betTheyen higher education and job markets.


We_They Vision is to be a leading IT Training Centers, They aim to providing trainee with the skills needed to find a job in today’s market. And offer an excellent opportunities for everyone, like you, to realize their dreams.

See all IT Sharks courses

Contact information not available.

Are you from IT Sharks ? Claim your course!
Courses you can instantly connect with...
Oracle Database 11g: Introduction to SQL New Horizons Egypt Oracle Database 11g: Administration Workshop I Release 2 New Horizons Egypt Oracle Database 11g: Data Guard Administration Release 2 New Horizons Egypt

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?