Oracle 12c PL/SQL Online Training

Oracle 12c PL/SQL Online Training Course Content

PL/SQL Online Training Content : Introduction

PL/SQL – 15 Classes

  • PL/SQL Introduction
  • Commands – DDL, DML, TCL, DCL
  • Data Types
  • Clauses- WHERE, GROUP BY, HAVING, ORDER BY
  • Constraints
  • Operators
  • Functions
  • Joins
  • Sub Queries
  • Other DB Objects – Views, Sequences, Synonym, Index, Type

PL/SQL – 12 Classes

  • Introduction
  • PL/SQL Block – Structure
  • PL/SQL Block – Types
  • Control Structures – Conditional, Iterative
  • Procedures
  • Functions
  • Cursor
  • Exception
  • Packages
  • Triggers

PL/SQL : Advanced – 13 Classes

  • Group by clause – Enhancement
  • Hirarchical Queries – Connect by clause
  • Materialized View
  • Multi Table Insert
  • Object Type
  • Table Partitions
  • With Clause – Usage
  • Analytical Functions
  • Regular Expressions
  • Oracle Directory
  • Virtual Column
  • Dynamic SQL – Execute Immediate
  • UTL_File
  • Bulk Collect / Bulk Bind
  • Collections – PL/SQL Table/Record
  • Data Dictionary Views
HOMEWHY USOUR STRATEGY
PROJECT SUPPORTBLOGBECOME AN Instructor
CONTACT USWEB DESIGNINGOUR SERVICES
LEARNER SIGN UPTRAINER SIGN UPREFER A FRIENDSITEMAP
Copy rights © HyderabadSys.com