PL Sql Course Training

PL Sql Course Training

  • Introduction To SQL
    1. Introduction to Databases
    2. Understanding DBMS vs RDBMS
    3. Gone through SQL Standards
    4. Sub-languages of SQL
    5. Difference between 10g vs 11g vs 12c
    6. Installation of 12c
    7. About SQL*Plus and use of developer tool
    8. Data types in Oracle
    9. Operators in Oracle
  • 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. Data filtering and sorting within a single table
    5. Clauses and its types in Oracle
    6. Where clause
    7. Having clause
    8. From clause
    9. Group by clause
    10. Order by clause
    11. Using clause
    12. Constraint clause
    13. For update clause
    14. Table creation using CREATE statement
    15. Creating table from another table
  • Working With DDL 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 within a record using UPDATE command
    5. Deleting a particular record from a table
    6. How to declare column-level constraints?
    7. How to declare row-level constraints?
    8. How to add constraints to an existing table?
    9. Types of integrity constraints
    10. Not null
    11. Unique key
    12. Primary key
    13. Referential integrity
    14. Check integrity
    15. How to enable and disable constraints?
    16. How to get information about constraints?
  • Data Aggregation
    1. Working with aggregate functions
    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
  • Set Operators And Pseudo Columns
    1. How to use set operators in 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 subqueries
    2. Using different types of subqueries
    3. Single row subqueries
    4. Multi-row subqueries
    5. Nested queries
    6. Multi-column subqueries
    7. Correlated subqueries
  • Design Of Schema Objects
    1. Creating and working with Views
    2. Working with Synonyms
    3. Creating Index and clusters
    4. Working with materialized views
  • Introduction To PL/SQL
    1. Informal introduction to PL/SQL
    2. Advantages of PL/SQL
    3. Datatypes in PL/SQL
    4. Program structure of PL/SQL
    5. Embedding SQL statements
    6. Using conditional statements and loops
  • Creating And Using Cursors
    1. What is a cursor?
    2. How to create a cursor?
    3. Using cursors in PL/SQL
    4. How to create an explicit cursor?
    5. Creation of for loop cursor
    6. What are cursor parameters?
    7. How to use the for update clause?
    8. What are 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
    5. SQLCODE vs SQLERRM
    6. Pragma EXCEPTION_INIT
  • 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 functions
    2. How to create functions?
    3. Difference between procedures and functions
    4. How to use inline functions?
    5. Creating & Using Packages
    6. What is a Package?
    7. Reasons to use packages
    8. What is package specification?
    9. What is package body?
    10. How to instantiate a package?
    11. How to initialize instantiated package?
    12. What are all the package states?
  • Triggers In PL/SQL
    1. How to create triggers?
    2. Benefits of triggers
    3. How to trigger a trigger?
    4. Using DML triggers & DDL triggers
    5. How to audit a database using triggers?
    6. What are database-level triggers?
  • Collections In PL/SQL
    1. What is a collection?
    2. How to use arrays?
    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