Oracle SQL and PL/SQL Course

This Training course is designed to provide candidates a strong foundation on Oracle SQL and Pl/SQL.

Purpose of this Course is to help Fresher,Any Graduate and Post Graduate This course begins by assuming you have no experience with Oracle SQL and PL/SQL. ,After completion of this course,Candidate will able to perform L1 and L2 Task easily in Company Plus, you will have a great foundation when preparing for the Oracle Certification exam


  1. Introduction to SQL
  2. SQL DataType
  3. Writing Basic SQL SELECT Statements
  4. Restricting and Sorting Data
  5. Single-Row Functions
  6. Displaying Data from Multiple Tables
  7. Aggregating Data Using Group Functions
  8. Subqueries
  9. Manipulating Data
  10. Creating and Managing Tables
  11. Including Constraints
  12. Creating Views
  13. Other Database Objects like SEQUENCE,INDEX,SYNONYMS,Database Link
  14. Controlling User Access,Privilage
  15. Enhancements to the GROUP BY Clause
  16. Advanced Subqueries
  17. Hierarchical Queries
  18. Extensions to DML and DDL Statements

Oracle PL/SQL

  1. Introduction to PL/SQL
  2. What Is PL/SQL?
  3. The Origins of PL/SQL
  4. Creating and Running PL/SQL Code
  5. PL/SQL Program Structure
  6. Loop Basics
  7. Exception Handlers
  8. PL/SQL Program Data
  9. Strings
  10. Numbers
  11. Records
  12. Collections
  13. Miscellaneous Datatypes
  14. SQL in PL/SQL
  15. Data Retrieval
  16. Procedures, Functions, and Parameters
  17. Packages
  18. Triggers
  19. Managing PL/SQL Code
  20. I/O and PL/SQL

Oracle Forms

Oracle Forms Developer 10g: Build Internet Applications

  1. Introducing Oracle Forms Developer and Forms Services
  2. Grid Computing
  3. Oracle 10g Products
  4. Oracle Application Server 10g Architecture
  5. Benefits and Components of Oracle Developer Suite 10g
  6. Running a Forms Developer Application
  7. Working in the Forms Developer Environment
  8. Creating Forms Modules
  9. Working with Data Blocks and Frames
  10. Working with Input Items
  11. Working with Non Input Items
  12. Working with Windows and Canvases
  13. Producing Triggers
  14. Debugging Triggers
  15. Adding Functionality to Items
  16. Run-Time Messages and Alerts
  17. Query Triggers
  18. Validation
  19. Navigation
  20. Transaction Processing
  21. Sharing Objects and Code
  22. Using WebUtil to Interact with the Client
  23. Introducing Multiple Form Applications

Oracle Reports

Oracle Reports Developer 10g: Build Reports

  1. Introduction to Oracle Reports Developer
  2. Business Intelligence
  3. Enterprise Reporting
  4. Oracle Reports Developer
  5. Oracle Database 10g
  6. Oracle Developer Suite 10g
  7. Oracle Application Server 10g
  8. OracleAS Reports Services
  9. OracleAS Reports Services Architecture for the Web
  10. Designing and Running Reports
  11. Exploring Oracle Reports Developer
  12. Creating a Paper Report
  13. Enhancing a Basic Paper Report
  14. Managing Report Templates
  15. Creating a Web Report
  16. Enhancing Reports Using the Data Model: Queries and Groups
  17. Enhancing Reports Using the Data Model: Data Sources
  18. Enhancing Reports Using the Data Model: Creating Columns
  19. Enhancing Reports Using the Paper Layout
  20. Controlling the Paper Layout: Common Properties
  21. Controlling the Paper Layout: Specific Properties
  22. Web Reporting
  23. Extending Functionality Using XML
  24. Creating and Using Report Parameters
  25. Embedding a Graph in a Report
  26. Enhancing Matrix Reports
  27. Coding PL/SQL Triggers
  28. Extending Functionality Using the SRW Package
  29. Maximizing Performance Using
  30. OracleAS Reports Services
  31. Building Reports: Efficiency Guidelines
  32. Working with SQL Worksheet
  33. Using SQL Developer

Basic Unix Command

  1. Introduction of UNIX/Linux
  2. Basic Unix Commands
  3. File and folder Permissions
  4. Redirect ,Append and Pipe
  5. Unix text Editors and Cron Job
  6. User Management

Quick Enquiry