Pay Fees After Satisfaction With Interview Guidence

Oracle(Pl/Sql) Syllabus Download

  • History and Features of Java
  • Difference between JDK,JRE and JVM
  • Variable and Data Type
  • If-If,Else If,If-Else,Switch Case
  • For,While,Do While,Foreach Loop
  • Array
  • Type Casting
  • Object Oriented Programming in Java
  • Class Object and Method
  • Constructors
  • Inheritance
  • Polymorphism
  • This and Super
  • Static and Final
  • Type Casting
  • Abstract Class And Interface
  • Nested Classes and Anonymous Class
  • Command Line Arguments
  • Packages
  • Oracle PL/SQL
  • Basics of PL/SQL
  • PL/SQL architecture
  • PL/SQL and SQL*Plus
  • PL/SQL Basics
  • Variables
  • Constants
  • Datatypes
  • Error messages � user_errors and show errors
  • PL/SQL wrapper utility
  • PL/SQL structures
  • Simple blocks
  • Control structures
  • PL/SQL records
  • 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
  • Declaring Variables and Constants
  • Executing a PL/SQL Block
  • Error checking � exception handling
  • Defining exceptions
  • Using the when others clause
  • Ensuring complete error checking
  • Passing error messages to calling routine
  • Boolean logic in PL/SQL
  • Identifying the Uses and Types of Control Structures
  • Constructing an IF Statement
  • Constructing and Identifying Different Loop Statements
  • Controlling Block Flow Using Nested Loops and Labels
  • Using Logic Tables
  • If-then-else structure
  • Testing for numbers characters and Booleans
  • Cursors in PL/SQL
  • Cursor basics
  • History and Features of Java
  • Difference between JDK,JRE and JVM
  • Variable and Data Type
  • If-If,Else If,If-Else,Switch Case
  • For,While,Do While,Foreach Loop
  • Array
  • Type Casting
  • Object Oriented Programming in Java
  • Class Object and Method
  • Constructors
  • Inheritance
  • Polymorphism
  • This and Super
  • Static and Final
  • Type Casting
  • Abstract Class And Interface
  • Nested Classes and Anonymous Class
  • Command Line Arguments
  • Packages
  • Using a cursor for a multi-row SQL query
  • Iteration in PL/SQL
  • For loop
  • While loop
  • PL/SQL tables
  • Defining PL/SQL tables
  • Reasons to use PL/SQL tables
  • Populating a PL/SQL table
  • Retrieving from a PL/SQL table
  • Dynamic SQL in PL/SQL
  • Introduction to the dbms_sql package
  • Creating a dynamic SQL statement
  • Nested blocks in PL/SQL
  • Creating nested blocks
  • Understanding scope in nested blocks
  • Triggers in PL/SQL
  • Triggers and database events
  • Defining a trigger
  • Timing a trigger
  • Enabling and disabling a trigger
  • Stored procedures, functions and packages
  • Basics of stored procedures
  • Basics of functions
  • Basics of packages
  • Defining stored procedures & functions
  • Function and stored procedures prototypes
  • Passing arguments to functions and stored procedures
  • Recompiling functions and stored procedures
  • Package forward declaration
  • Package dependency
  • Package overloading
  • Listing package information
  • Bulking in PL/SQLv
  • Bulk queriesv
  • Bulk DML (forall statement)
  • Using cursor attributes
  • Analyzing impact of bilk operationsDatabase with MySQL
  • Our Courses

  • C/C++ RS: 3500
  • CORE JAVA, J2EERS: 5500
  • HTML5,CSS3,JQUERY,PHPRS: 6000
  • WordpressRS: 5000
  • C SHARPRS: 4500
  • ASP.NETRS: 5000
  • AndroidRS: 7000
  • ASP Dot Net MVCRS: 8000
  • Unix/LinuxRS: 5000
  • Oracle(SQl)RS: 4000
  • Oracle(PL/SQl)RS: 5000
  • InformaticaRS: 12000
  • Jquery & Java ScriptRS: 4000
  • Spoken EnglishRS: 4000
  • Aptitude RS: 4000