Oracle PL SQL

About Course - PL / SQL

Oracle SQL is basic learning platform to get in IT, which is easy to learn.Oracle SQL is easy for any support project for initial stage which get into IT carrier. In case you want to grow for development environment than its entry for programming. Oracle SQL is command based language. Now a day’s SQL is basic skill set forany IT/NON IT folks, it’s always helpful for any functional, supportand technical consultant.

Curriculum

  • Describing PL/SQL
  • Describing the Use of PL/SQL for the Developer and the Database Administrator
  • Explaining the Benefits of PL/SQL
  • PL/SQL program constructs
  • PL/SQL anonymous block structure
  • Subprogram block structure
  • Course objectives and overview
  • Recognizing the Basic PL/SQL Block and its Sections
  • Describing the significance of variables in PL/SQL
  • Distinguishing Between PL/SQL and NON-PL/SQL Variables
  • %TYPE and %ROWTYPE Attributes
  • Recognizing the Significance of the Executable Section
  • Writing Statements Within the Executable Section
  • Describing the Rules of Nested Blocks
  • Executing and Testing a PL/SQL Block Using Coding Conventions
  • Writing Successful SELECT statement in PL/SQL
  • Declaring the Data Type and Size of PL/SQL Variable Dynamically
  • Writing Data Manipulation Language (DML) Statement in PL/SQL
  • Controlling Transactions in PL/SQL
  • Identifying the users and Types Of control Structures
  • Constructing the IF statement
  • Constructing and Identifying Different Loop Statement
  • Controlling Block Flow using Nested Loops and Labels
  • PLSQL Record
  • PLSQL Table
  • Using PL/SQL Record Variable
  • Distinguish Between the Implicit and Explicit Cursor
  • Writing a cursor FOR Loop
  • Defining the Uses of Procedures
  • Recognizing Unhandled Exceptions
  • Listing and Using Different Types of PL/SQL Exception Handlers
  • Describe the Uses of Procedure
  • Create Procedure
  • Create Procedure with argument
  • Invoke Procedure
  • Remove Procedure
  • Sub Procedure
  • Describe the Uses of Function
  • Create Function
  • Create Function with arguments
  • Invoke Function
  • Remove Function
  • Differentiate between Procedure and Function
  • Sub Function
  • Describe Packages
  • Create Packages
  • Local Variables
  • Invoke Objects in Package
  • Remove Package
  • Describe different types of triggers
  • Database triggers and their use
  • Create database triggers
  • Drop database triggers
  • Analyze Command
  • TKProf Utility
  • Writing Optimized SQL Statements