Oracle Training

Oracle is made up of a set of processes running in your operating system. These processes manage how data is stored and how it is accessed. Oracle is a program that is running in the background, maintaining your data for you and figuring out where it should go on your hard drive.

x

Programme Outcome:

    Introduction to Oracle Database
        Basic of relational database
        Different types of SQL statements
     
    SQL SELECT Statement
        List the capabilities of SQL SELECT statements
        Select All Columns
        Select Specific Columns
        Arithmetic Operators and Operator Precedence
     
    Restrict and Sort Data
        Describe WHERE clause
        Comparison operators and logical operators
        Describe ORDER BY clause
     
    Single-Row Functions
        Differences between single row and multiple row functions
        String manipulation functions
        Describe ROUND, TRUNC, and MOD functions
        Arithmetic with date
        Manipulate dates with the DATE functions
     
    Conversion Functions and Conditional Expressions
        Describe TO_CHAR and TO_DATE functions
        Handle NULL values
        Use conditional IF THEN ELSE logic in a SELECT statement
     
    Group Functions – Aggregate the data
        Describe the use of the aggregation functions
        Describe GROUP BY clause
        Describe HAVING clause
     
    Joins – Get data from multiple tables
        Access data from more than one     table
        Type of joins – Self joins, Outer joins, equi joins
     
    Sub-queries
        Describe the types of problem that sub-queries can solve
        Describe sub-queries
        List the types of sub-queries
        Explain single-row and multiple-row sub-queries
        
    SET Operators in Oracle
        Describe the SET operators
        Control the ordering
     
    Data Manipulation Statements
        Describe different type of DML statement
        Describe INSERT statement
        Describe UPDATE statement
        Describe DELETE statement
        Describe COMMIT and ROLLBACK statements
        Explain read consistency
     
    DDL Statements - Create and Manage Tables
        Categorize the main database objects
        Review the table structure
        List the data types
        Add constraints to the table
        
    Schema Objects in Oracle
        Simple and Complex view
        Retrieve data from views
        Explain Sequences
        Explain Indexes
        Explain Synonyms
        
    Control User Access
        Type of privileges - system privileges and object privileges
        Describe Users and Roles
        Grant System Privileges
        Grant Object Privileges
        How to pass on privileges
        Revoke Object Privileges
        
    Schema Objects management
        Add, Modify, and Drop a Column
        Add, Drop, and Defer a Constraint
        Enable and Disable a Constraint?
        Flashback
        
    Data Dictionary Views
        Data dictionary - Overview
        USER_OBJECTS and ALL_OBJECTS Views
        Query the dictionary views for constraint information
x

Duration

30 Hrs

x

Schedule

1.5 Hrs (Monday - Fridays)

2.5 Hrs (Saturday & Sunday)

Contact Us

Verify Captcha Code:


Can't read the image? click
Dwarka Centre

A-66 , 2nd & 3rd floor, Sector 7, Dwarka , New Delhi-110075

011-45613139,

9999-850-802

Vikaspuri Centre

545 ,2nd Floor , Site-1,Opposite Metro Pillar -624 ,Vikas Puri , New Delhi-110018

011-40536990,

8459-394-957