Price: AED 320

    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   
    Updated on 08 November, 2015

    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.

    Vision

    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
    Are you from IT Sharks ? Claim your course!
    Courses you can instantly connect with... Do an online course on Oracle starting now. See all courses

    Is this the right course for you?

    Didn't find what you were looking for ?

    or