Training Institute In Bhopal |DreamSoft Systems

ORACLE & PL/SQL Course Contents

  • Introduction
  • Writing a Basic SQL Statement
  • Restricting and Sorting Data
  • Single Row Functions
  • Displaying Data from Multiple Tables
  • Aggregating Data by Using Group Functions
  • Writing Subqueries
  • Producing Readable Output with SQL*Plus
  • Manipulating Data
  • Creating and Managing Tables
  • Including Constraints
  • Creating Views
  • Other Database Objects, Synonym, Sequences, Indexes
  • Controlling User Access
  • Using Set Operators
  • Oracle 9i Datetime Functions
  • Enhancements to the GROUP BY Clause
  • Advanced Subqueries
  • Hierarchical Retrieval
  • Oracle9i Extensions to DML and DDL Statements
  • Introduction to PL/SQL
  • Control statements
  • Data types, variables, constants
  • Functions
  • Procedures
  • Cursors
  • Packages
  • Triggers

Course Duration : 60 Hrs

Daily Two Hours, 3 days a week

Contact immediately for special offer - Click here