Oracle Course Training

Oracle Course Training

  • Introduction To SQL
    1. Data Retrieval Techniques
    2. Working with DDL Commands
    3. Working with DML Commands
    4. Integrity Constraints
    5. Built In Functions
    6. Data Aggregation
    7. Importance Of Join
    8. Set Operators & Pseudo Columns
    9. Sub Queries
  • PL/SQL (Procedural Language Extension To SQL)
    1. Introduction To PL/SQL
    2. Creating & Using Cursors
    3. Understanding Exception Handling
    4. Creation Of Stored Procedures
    5. Creating & Using Functions
    6. Creating & Using Packages
    7. Triggers In PL/SQL
    8. Collections In PL/SQL
    9. Difference between 10g vs 11g vs 12c
    10. Installation of 12c
    11. About SQL*Plus and use of developer tool
    12. Datatypes in Oracle
    13. Operators in Oracle
    14. Understanding Schema design and objects
  • Data Retrieval Techniques
    1. How to use select statement in different ways to retrieve records?
    2. Working with Column alias
    3. Working with Table alias
    4. Clauses and its types in oracle
      • Where clause
      • Having clause
      • From clause
      • Group by clause
      • Order by clause
      • Using clause
      • Constraint clause
      • For update clause
  • Working With DDL Commands
    1. Table creation using CREATE statement
    2. Creating table from another table
    3. Dropping a table using DROP command
    4. Altering the column of a table
    5. Modifying the column datatype in a table
    6. Renaming the column of a table
    7. Renaming an entire table
    8. Using truncate command
    9. Difference between Delete and Truncate command
  • Working With DML Commands
    1. How to copy data from one table to another table?
    2. How to copy the structure alone from a table?
    3. Different types of inserting row to an existing table
    4. Updating any value of with in a record using UPDATE command
    5. Deleting a particular record from a table
    6. Integrity Constraints
    7. How to declare column level constraints?
    8. How to declare row level constraints?
    9. How to add constraints to an existing table?
    10. Types of integrity constraints
    11. Not null
    12. Unique key
    13. Primary key
    14. Referential integrity
    15. Check integrity
    16. How to enable and disable constraints?
    17. How to get information about constraints?
  • Built In Functions
    1. Understanding Single row functions
    2. How to use single row functions using dummy table?
    3. Types of single row functions
    4. String functions
    5. Date functions
    6. Mathematical functions
    7. Conversion functions
    8. Special functions
    9. Analytical functions
  • Data Aggregation
    1. Working with aggregate function
    2. Count()
    3. Sum()
    4. Max()
    5. Min()
    6. Avg()
    7. Working with group by clause
    8. Working with having clause
    9. Difference between WHERE and HAVING clause
  • Importance Of JOIN
    1. Understanding joins and its uses
    2. Types of joins
    3. Equi join
    4. Non - equi join
    5. Self join
    6. Outer join
    7. Left & Right outer join
    8. Full outer join
    9. Cross join
  • Set Operators And Pseudo Columns
    1. How to use set operators in a single table content?
    2. Working with set operator types
    3. UNION
    4. UNION ALL
    5. INTERSECT
    6. MINUS
    7. Working with pseudo columns using the following
    8. ROWID
    9. ROWNUM
  • Sub Queries
    1. Importance of sub queries
    2. Using different types of sub queries
    3. Single row sub queries
    4. Multi row sub queries
    5. Nested queries
    6. Multi column sub queries
    7. Correlated sub queries
  • Database Transaction And Security
    1. Working with data query language using TCL
    2. Working with data control language commands
    3. Use of commit and rollback
    4. Use of savepoint and set transaction
    5. How to give system privileges to an user?
    6. How to invoke and revoke object privileges?
    7. How to create users and roles?
  • Design Of Schema Objects
    1. Creating and working with Views
    2. Working with Synonyms
    3. Creating Index and clusters
    4. Working with in materialized view
  • Creating And Using Cursors
    1. What is cursor?
    2. How to create cursor?
    3. Using cursors in PL/SQL
    4. How to create explicit cursor?
    5. Creation of for loop cursor
    6. What are cursor parameters?
    7. How to use for update clause?
    8. What is ref cursors?
    9. How to use implicit cursors?
  • Understanding Exception Handling
    1. What is an Exception?
    2. Describing Exception types
    3. Handling system defined exceptions
    4. Handling user defined exceptions?
  • Creation Of Stored Procedures
    1. Creating procedures in Pl/SQL
    2. Working with procedure parameters
    3. IN parameter
    4. OUT parameter
    5. INOUT parameter
    6. How to create procedures with cursors
    7. How procedures return records?
  • Creating & Using Functions
    1. Importance of function
    2. How to create functions?
    3. Difference between procedures and functions
    4. How to use inline functions?
  • Creating & Using Packages
    1. What is a Package?
    2. Reasons to use packages
    3. What is package specification?
    4. What is package body?
    5. How to instantiate package?
    6. How to initialize instantiated package?
    7. What are all the package state?
  • Triggers In PL/SQL
    1. How to create triggers?
    2. Benefits of trigger
    3. How to trigger a trigger?
    4. Using DML trigger & DDL trigger
    5. How to audit database using triggers?
    6. What are database level trigger?
  • Collections In PL/SQL
    1. What is collection?
    2. How to use Varrays?
    3. Using nested tables
    4. How to use index by value?
    5. Listing types of collection methods.

Let's Start The Training Today!

For more information for contact us

+91 9167041980