Course Batch Starts, Timing, Price & Enroll

Program Duration Batch Starts Time Price Enroll Book free demo
Weekend
30 Hrs Weekend Evening-Batch USD 500
INR 20000
Enroll Now Book free demo class
Weekend
30 Hrs Weekend Morning-Batch USD 500
INR 20000
Enroll Now Book free demo class
Weekdays
30 Hrs Weekdays Morning-Batch USD 500
INR 20000
Enroll Now Book free demo class
Weekdays
30 Hrs Weekdays Evening-Batch USD 500
INR 20000
Enroll Now Book free demo class

About Course

The best suited audience to attend this course can be -

Application Developers
System Analysts
Business Analysts
Database Administrators
Data Warehouse Administrator
Business / Project Heads
Technical Consultant
Portal Developer
This course is designed to introduce you about the fundamentals of PL/SQL. This course will help you to understand how to use PL/SQL with real-world scenarios. The key points which will be in focus during the PL/SQL Fundamental training can be-
To describe and introduce various features of PL/SQL with syntax.
To design anonymous block using PL/SQL.
To write PL/SQL code and control code flow like loops, control structures and explicit cursors.
To handle runtime errors and trapping exceptions
To work with stored procedures and functions.
After completing this course you will be able to handle a RDBMS using PL/SQL queries in an effective way by ensuring reliability, security and high performance. You will learn how to optimize workloads of a RDBMS and how to deliver a higher service quality. This course will help you to learn -
Features and Syntax of PL/SQL
Designing and executing anonymous block in PL/SQL
Write PL/SQL code to interface with the database
Handling runtime errors and trapping exception
Working with stored procedures and functions
A prior knowledge of SQL Fundamental, familiarity with programming languages and data processing concepts is required to start and understand the PL/SQL.

CURRICULUM

PL/SQL

  • 1.1 Course Objectives, Course Agenda and Class Account Information
  • 1.2 Describe the Human Resources (HR) Schema
  • 1.3 Identify the Appendices Used in this Course
  • 1.4 Introduction to PL/SQL Development Environments
  • 1.5 Oracle Database 12c SQL Documentation and Additional Resources
  • 2.1 Understanding the benefits and structure of PL/SQL
  • 2.2 Examining PL/SQL Blocks
  • 2.3 Generating output messages in PL/SQL
  • 3.1 Identify valid and invalid identifiers
  • 3.2 Declare and initialize variables
  • 3.3 List and describe various data types
  • 3.4 Identify the benefits of using the %TYPE attribute
  • 3.5 Declare, use, and print bind variables
  • 4.1 List Lexical Units in a PL/SQL Block
  • 4.2 Use SQL Functions in PL/SQL
  • 4.3 Use Data Type Conversion
  • 4.4 Use Nested Blocks as Statements
  • 4.5 Reference an Identifier Value in a Nested Block
  • 4.6 Qualify an Identifier with a Label
  • 4.7 Use Operators in PL/SQL
  • 4.8 Using Sequences in PL/SQL Expressions
  • 5.1 Identify and use the SQL Statements in PL/SQL
  • 5.2 Retrieve Data in PL/SQL with the SELECT statement
  • 5.3 Avoid Errors by Using Naming Conventions When Using Retrieval and DML Statements
  • 5.4 Manipulate Data in the Server Using PL/SQL
  • 5.5 The SQL Cursor concept
  • 5.6 Use SQL Cursor Attributes to Obtain Feedback on DML
  • 5.7 Save and Discard Transactions
  • 6.1 Control PL/SQL Flow of Execution
  • 6.2 Conditional processing Using IF and CASE Statements
  • 6.3 Handle Nulls to Avoid Common Mistakes
  • 6.4 Build Boolean Conditions with Logical Operators
  • 6.5 Use Iterative Control with Looping Statements
  • 7.1 Learn the Composite Data Types of PL/SQL Records and Tables
  • 7.2 Use PL/SQL Records to Hold Multiple Values of Different Type
  • 7.3 Inserting and Updating with PL/SQL Records
  • 7.4 Use INDEX BY Tables to Hold Multiple Values of the Same Data Type
  • 8.1 Define Cursors
  • 8.2 Explain Explicit Cursor Operations
  • 8.3 Controlling Explicit Cursors
  • 8.4 Use Explicit Cursors to Process Rows
  • 8.5 Cursors and Records
  • 8.6 Cursor FOR Loops Using Subqueries
  • 8.7 Explicit Cursor Attributes
  • 8.8 The %NOTFOUND and %ROWCOUNT Attributes
  • 9.1 Define Exception
  • 9.2 Handling Exceptions with PL/SQL
  • 9.3 Predefined Exceptions
  • 9.4 Trapping Predefined and Non-predefined Oracle Server Errors
  • 9.5 Functions that Return Information on Encountered Exceptions
  • 9.6 Trapping User-Defined Exceptions
  • 9.7 Propagate Exceptions
  • 9.8 Basic RAISE Statement
  • 10.1 Overview of Stored Procedures and Functions
  • 10.2 Differentiate between anonymous blocks and subprograms
  • 10.3 Show the CREATE OR REPLACE PROCEDURE | FUNCTION
  • 10.4 Understand the Header Area of a Stored Procedure and Function
  • 10.5 Create Simple Procedures and Functions
  • 10.6 Create a Simple Procedure with an IN Parameter
  • 10.7 Execute a Procedure and a Function

Exam & Certification


POWER OF CHOOSING YOUR TRAINER - TAKE DEMO FROM 3 TRAINERS AND SELECT


Kiran Kumar
MC
From
Professional Experience

Subject Expertise
.NET

Certification

Profile
Microsoft Certified and Professional Trainer with an experience of 9+ years. Trained 100s of batches online, classroom
RATING & REVIEWS
Praneet Pabolu
I would highly recommend kiran, he is a person with a detailed knowledge on Microsoft technologies. His teaching style is very good, clears any doubt in a friendly way.
Naresh pydi
I am strongly recommended kiran. He is very friendly and you can learn so many good things from him.
Arun Kumar
A Person with a great skill in terms of training with latest Microsoft technologies and a very grounded person with a lot of patience.
venkatesh allika
Immense interactions: got us thinking, engaged and awake kiran is a very good trainer - he is engaging &Very enteraining, thought provoking and both understands as well as uses adult learning techniques
Sanjay Kumar singh
BE Computer Science
From
Professional Experience

Subject Expertise
Oracle

Certification

Profile
Developed IVR application using 3rd party service(plivo)- Moving IVR from third party service to in-house FreeSwitch- Defined design of payment gateway services.
RATING & REVIEWS
Ashok Kumar Bolisetti
M Tech IIT
From
Professional Experience

Subject Expertise
AJAX

Certification

Profile
Senior Software engineer with 7 years of product development experience in agile methodologies.Having good knowledge on Java/J2EE, Design Patterns,RESTWeb Services ,Spring ,Hibernate,AngularJS ,Portlets ,data Structures and Algorithms.
RATING & REVIEWS
Venkata B
MS CSC
From
Professional Experience

Subject Expertise
Database

Certification

Profile
I am a full stack developer, Iam an expert level developer in Oracle SQL PL/SQL, Python, Unix Shell ScriptingMid level developer in Java, PHP, JS,MySQL.
RATING & REVIEWS
Bhavesh Kavar
B.E. I.T.
From
Professional Experience

Subject Expertise
Java

Certification

Profile
A Passionate, Hands-on Professional, I have over 4 months of experience in Java Development covering multiple technologies.
RATING & REVIEWS
Sajal Agarwal
MCA
From
Professional Experience

Subject Expertise
Oracle ERP

Certification

Profile
I have 4+ yrs exp in SQL,PL/SQL and Oracle Apps Development. I have good knowledge in SQL, PL/SQL,AdvancePL/SQL,Oracle Apps technical, Interface and workflow and form personalization.
RATING & REVIEWS
Prashanth K
MCA
From
Professional Experience

Subject Expertise
Database

Certification

Profile
With 3+ years experience, working as Oracle DBA / Developer freelancer Consultant & as well giving corporate training in class and online.
RATING & REVIEWS
Ridam Chopra
B.Tech
From
Professional Experience

Subject Expertise
ASP.NET

Certification

Profile
Specialties: I like programming in ASP.NET and Oracle I work in the Business Development department and try to bring projects related mainly to Web Designing/Development and I-Phone Applications through freelance websites.
RATING & REVIEWS
Vivek Agarwal
Msc IT
From
Professional Experience

Subject Expertise
Data Structure

Certification

Profile
Corporate Trainer cum Consultant Corporate Trainer Skills : RDBMS Oracle 11g DBA Oracle 12c DBA PLSQL 11g PLSQL 12c SQL LINUX ADMIN Unix Shell Script Oracle RAC MySQL Development MSSQL DBA POSTGRESQL DBA
RATING & REVIEWS
T, Sanjay
M.E. (Computers)
From
Professional Experience

Subject Expertise
.NET

Certification

Profile
RATING & REVIEWS
Ratna Patel
Diploma in IT
From
Professional Experience

Subject Expertise
AJAX

Certification

Profile
10+ experience in Corporate Training on JAVA,J2EE,HTML 4/5 , CSS3, jQuery,Angular JS, Struts 1.0/2.0 , Hibernate , Spring frameworks,AJAX ,Weblogic Administration, Hadoop .Handling session Face to Face / Online .Working as interview / job support consultant.
RATING & REVIEWS
Koteswara Rao Ummaneni
Master of Computer Science (MCA)
From
Professional Experience

Subject Expertise
Oracle EAM

Certification

Profile
RATING & REVIEWS
Bhagyalaxmi Reddy
BE
From
Professional Experience

Subject Expertise
Oracle 9i, 10g, 11i, 12c

Certification

Profile
I have 5 Years + hands on experience on Oracle ( SQL , PL SQL), and Leading a team of Online trainers for Informatica, Testing tools, Cognos ,Datastage & Life Coaching Connect with me if you or your organization looking for the above services either online or at your Organizations.
RATING & REVIEWS
Harvinder Kaur
B.tech Computer Science
From
Professional Experience

Subject Expertise
MySQL

Certification

Profile
RATING & REVIEWS
Disclaimer

** The above course information is taken from Oracle.

* Money Back Guarantee till demo and 1st class of the course.


Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.
FOLLOW US