SQL and PL/SQL for Oracle Developers

Instructor Profile


Our Oracle PL/SQL instructor is a highly experienced professional working with Oracle Database Applications for more than 10 Years. He has extensive experience in writing complex programming interfaces between different functional systems, coding and tuning SQL and PL/SQL programs in various lines of businesses.

 

Course Contents


This packaged course covers both SQL and PL/SQL training and covers the following topics:

  • Database Management Systems
  • Introduction to Oracle RDBMS
  • Communicating using SQL
    • DDL, DML, DCL and more..
    • Arithmetic Operators
    • Operator Precedence
  • Filtering Data
  • SQL Functions
    • Text Functions
    • Number Functions
    • Date Function
  • Aggregation Functions
  • Transformation Functions
  • Joins and Sub Queries
  • Roles and Privilege
  • Introduction to Oracle PL/SQL
  • PL/SQL Program Structure
  • Writing PL/SQL Programs
  • Data Types
  • Variable Declarations
  • Controlling the Program Flow
  • Using Composite Data Types
  • Working with cursors
  • Exception Handling
  • Procedures and Functions
  • Creating and working with Packages
  • Oracle Delivered Packages

Class Schedule


Please use the contact us form to register for the next batch.

If you are in a group of 3 or more, the training can be arranged at your preferred time and pace. For customized training programs for individuals, groups & companies, please contact us.

Audience


This packaged course will be useful for the following category of people who wants to learn Oracle SQL and PL/SQL.

  • Non-Oracle Developers (e.g.Microsoft VB Developers, .NET Developers, JAVA Developers) who want to learn Oracle Technologies
  • Fresh IT graduates who want to make a career in Oracle Technologies

Pre-requisites


  • This course is designed for individuals who are new to Information Technologies and Database applications. Hence no Pre-requisites have been set for this course.

If you are not sure whether you should be doing this course, please contact us and we will schedule a one-to-one discussion with you to understand your requirements and advise you accordingly.

Training Methodology


This training will be through live online class with voice & presentation. Please refer to our section How-it-works to know more about the training methodology.

At the end of a chapter there are lab exercises that a participant need to complete. For these lab excercises, participants will be provided access to an Oracle Database Server. This Oracle Server will be available to you 24 hours a day for the entire duration of your course.

There will be a maximum of only 5 participants per batch.

Training Duration


The total training duration is 42 hours divided in 21 sessions with 1 hour of theory and 1 hour of guided practical per session.

At the end of the each theory session, you are expected to finish all the lab exercises before next session.  

If required, at the end of the course, each participant can have dedicated one-on-one session of 2 hours with the instructor for clarifying any doubt or asking any questions.

Register Now


Click on the "Pay Now" button to register for Programming in Oracle PL/SQL. Clicking on the following button will re-direct you to our payment page where you can pay using credit card. Once the payment is received, we will get in touch with you with further details.