goodrich-topline-image

Courses We Offered

ORACLE

1. RDBMS
  • Introduction to RDBMS
  • Differentiating DBMS & RDBMS
  • Codd’s Rules
  • 2. SCHAMA OBJECTS IN SQL
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Control Language (DCL)
  • Transaction Control Language (TCL)
  • 3. OPERATORS IN SQL
  • Arithmetic operators
  • Relational operators
  • Logical operators
  • Set Operators
  • 4. FUNCTIONS IN SQL
  • Single Row Functions
  • Numeric Functions
  • String Functions
  • Date Functions
  • Conversion Functions
  • Group Functions
  • Nesting Functions
  • 5. CLAUSES IN SQL
  • Using the WHERE Clause
  • ORDER BY Clause
  • Sorting by Multiple Columns
  • HAVING
  • 6. CONSTRAINTS
  • Not Null Constraint
  • Unique Constraint
  • Primary Key Constraint
  • Referential Integrity Constraint
  • Check Constraint
  • 7. INDEXES
  • Simple Index
  • Complex Index
  • INDEX BY Tables
  • Using INDEX BY Table Methods
  • INDEX BY Table of Records
  • 8. SYNONYMS
    9. SEQUENCES
    10. VIEWS
  • Read only Views
  • Updateable Views
  • 11. CLUSTERS
    12. JOINS
  • Cartesian Products
  • Retrieving Records with Equijoins
  • Using Table Aliases
  • Joining More than Two Tables
  • Non-Equijoins
  • Outer Joins
  • Self Joins
  • Creating Cross Joins
  • Creating Natural Joins
  • Creating Joins with the USING Clause
  • Retrieving Records with the USING Clause
  • Retrieving Records with the ON Clause
  • Creating Three-Way Joins with the ON Clause
  • LEFT OUTER JOIN
  • RIGHT OUTER JOIN
  • FULL OUTER JOIN
  • 13. SUB QUERIES & NESTED QUERIES
    14. GRANT & REVOKE PRIVILEGES

    PL/SQL

    1. ARCHITECTURE OF PL/SQL
    2. STRUCTURE (SKELETON ) OF PL/SQL
    3. OPERATORS IN PL/SQL
  • Arithmetic Operators
  • Comparision Operators
  • Logical Operators
  • 4. CONTROL STATEMENTS IN PL/SQL
  • Various forms of if
  • CASE expressions
  • 5. ITERATIVE CONTROL : LOOP STATEMENTS
  • Basic Loops
  • WHILE Loops
  • FOR LOOPS
  • Nested Loops
  • 6. EXCEPTION HANDLING
  • Handling Exceptions with PL/SQL
  • Exception Types
  • Implicitly raised
  • Explicitly raised
  • Trapping Exceptions
  • Predefined Exceptions
  • Non predefined Error
  • Functions for Trapping Exceptions
  • User-Defined Exceptions
  • Propagating Exceptions
  • RAISE_APPLICATION_ERROR
  • 7. ATTRIBUTES IN PL/SQL
  • % type
  • % rowtype
  • 8. CURSORS IN PL/SQL
  • About Cursors
  • Implicit cursors
  • Explicit cursors
  • Declaring the cursor
  • Opening the cursor
  • Fetching the data from the cursor
  • Explicit Cursor Attributes
  • Cursors and Records
  • Cursor For Loops
  • 9. ADVANCED EXPLICIT CURSOR CONCEPTS
  • Cursor with Parameters
  • The FOR UPDATE Clause
  • The WHERE CURRENT OF Clause
  • Cursors with Sub queries
  • 10. PROCEDURES IN PL/SQL
  • PL/SQL Program Constructs
  • Overview of Subprograms
  • Block Structure for Anonymous PL/SQL Blocks
  • PL/SQL Subprograms
  • Developing Subprograms by Using iSQL*Plus
  • Invoking Stored Procedures and Functions
  • Creating Procedures
  • Formal parameters VS Actual parameters
  • Creating Procedures with Parameters (IN,OUT,INOUT)
  • Declaring Subprograms
  • Invoking a Procedure from Another Procedure
  • Handled Exceptions
  • Un-Handled Exceptions
  • Removing Procedures
  • 11. FUNCTIONS IN PL/SQL
  • Creating Functions
  • Executing Functions
  • Invoking Functions in SQL Expressions
  • Restrictions on Calling Functions from SQL Expressions
  • Removing Functions
  • Comparing Procedures and Functions
  • 12. PACKAGES IN PL/SQL
  • Advantages of Packages
  • Components of a Package
  • Referencing Package Objects
  • Developing a Package
  • Creating the Package Specification
  • Declaring Public Constructs
  • Creating the Package Body
  • Public and Private Constructs
  • Invoking Package Constructs
  • Declaring a Bodiless Package
  • Removing Packages
  • Overloading
  • Using Forward Declarations
  • Creating a One--Time--Only Procedure
  • Using the DBMS_SQL Package
  • Dynamic SQL Using EXECUTE IMMEDIATE
  • Using the DBMS_DDL Package
  • 13. MANIPULATING LARGE OBJECTS
  • Contrasting LONG and LOB data types
  • Managing Internal LOB’s
  • Managing BFILES
  • DBMS_LOB_WRITE and DBMS_LOB_READ
  • Creating a Temporary LOB
  • 14. TRIGGERS
  • Database triggers
  • Creating DML Statement triggers
  • Using Conditional Predicates
  • Creating DML ROW Trigger
  • Using OLD and NEW Qualifiers
  • Restricting a ROW Trigger
  • Differentiating Between Database Triggers and Stored Procedures
  • Managing Triggers
  • Drop trigger
15. ORDBMS CONCEPTS

We Offered

  • Workshops
  • Live Projects
  • Digital Marketing
  • Online Training
  • Application Development
  • Website Development
  • Placement Assistance
  • Off-Campus Seminars

Recent News

  • Demo on every Saturday @ 10am

Get in Touch

Goodrich IT Solutions,
2nd Floor, Maruthi Complex,
Opp. R.S. Brothers, KPHB,
Hyderabad - 500 072

Mobile No. :+91 9885811057
Land Line: +91 4065889933
Email:sathesh@goodrichitsolutions.com