Home  |  Contact Us

  +91 11-28526055
+91-9818963397

                   

     

Home About us Franchise Forum Career Contact us Image Gallery Why Ativs Blog

Holidays
15/08/2016
This is to inform you all concern that the centre will remain close on 15/08/2016 on occasion of Independence day . ATIVS wishes you happy Independence day...
 

Oracle Course Syllabus

 

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

View More

 

Name

Email

Degree

Phone

Course

City

Message

  
 
Home || About us || Career || Contact us || Franchise
Address : RZ-51 A Street No. - 14, Vashisht Park, Pankha Road in Front of IETE, New delhi-110046, Contact us : +91 11-28526055, 9818963397, 9311363834, Email us     : info@ativs.com, infoativs@yahoo.com
© Copyright @ 2016, ATIVS Institute , All Rights Reserved.