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

# Cloud lab charges will be extra. Our technical consultant will share actual lab charges with you.

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


Select Trainer for Demo


Ajaz Ahmed
Certification:
From
Professional Experience
Training Experience

Qualification
Bachelor of Science

Skills
Oracle 9i, 10g, 11i, 12c , Oracle DBA, Oracle e-Business Suit , Oracle Fusion, Oracle SOA, PL/SQl, SQL, WebLogic, Oracle BI Foundation, Oracle DB 10g, Oracle DB 11g, Oracle DB 12c, Oracle Exalytics, Oracle Forms, Oracle Fusion Middleware home,

Profile
Brief about yourself Read More...
RATING & REVIEWS
Bhawna Gunwani
Certification:
From
Professional Experience
Training Experience

Qualification
MCA

Skills
.NET, ADO.NET, ASP.NET, ASP.NET MVC, C#.NET , C, C++ , Data Structure, Database, HTML5, JQuery , JSON, Node.js, Oracle, Oracle 9i, 10g, 11i, 12c , Oracle DBA, PL/SQl, Python, SQL, WCF, WPF,

Profile
6+ Years of Experience in Training Industry with a clear and depth understanding of student handling, learning needs, data analysis, content delivery, content management and process orientation. Specialties Programming and Technologies : C, C++, Data Structure, C#.Net, VB.Net, Asp.Net, Asp.Net MVC, WCF, WPF, Entity Framework, NHibernate, Web Services, Web API, AngularJS, AJAX, JavaScript. RDBMS : Oracle SQL and PL/SQL, Oracle DBA Workshop I and II, OBIEE, Microsoft SQL Server and T-SQL, SQL DBA etc. Read More...
RATING & REVIEWS
Kiran Kumar
Certification: MCP , MCTS
From
Professional Experience
Training Experience

Qualification
MCA

Skills
.NET, Angular JS, MVC, PL/SQl,

Profile
Microsoft Certified and Professional Trainer with an experience of 9+ years. Trained 100s of batches online, classroom Read More...
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
Lakshmi
Certification: RHCSA , RHCE
From
Professional Experience
Training Experience

Qualification
BSC.,DAST.,MT.,PGDCA,ADCA.,MCA

Skills
C, C++ , Java Script, MongoDB, Oracle 9i, 10g, 11i, 12c , PL/SQl, Red Hat , Redhat Gluster, SQL, RHCE, RHCSA,

Profile
Over 15 years of experience in Training and 12+ ye ars of experience in corporate training for Oracle and RedHat certification program. Read More...
RATING & REVIEWS
Mukesh.goel
Certification:
From
Professional Experience
Training Experience

Qualification
MCA

Skills
.NET, ADO.NET, AJAX, Angular JS, ASP.NET, ASP.NET MVC, C#.NET , HTML, HTML5, Java Script, Microsoft Azure, Microsoft SQL Server , MS Office, PL/SQl, MVC 6, Node.js v7,

Profile
RATING & REVIEWS
Pankaj Singh
Certification:
From
Professional Experience
Training Experience

Qualification
BCA

Skills
.NET, ADO.NET, AJAX, Android, Android NDK, Angular JS, Apache Cordova, ASP.NET, ASP.NET MVC, C#.NET , C, C++ , IIS, J2SE, Java , Java Script, Java SE, JDBC , JQuery , JSON, JSP , Linux , MariaDB, Microsoft Access , Microsoft Visual Studio, Microsoft Windows , MongoDB, MS Office, MVC, MySQL , Netbeans, Node.js, PHP, PL/SQl, Postgre SQL, Python, SHELL, SQL, SQLite, SQLyog, Swift, Ubuntu, UNIX, VB.Net, VISUAL BASIC, Web Development, Windows Mobile, WPF, X-Code, Xamarin,

Profile
Good Exp. in .Net Training include asp.net webform s, Mvc,ajax,ado.net,c#,ef,store apps and xamarin apps. I used to give training in c#,Vb.net,asp.net,wpf,wcf,mvc 5 and mvc 6,entity framework,silverlight, Windows Store Apps. Read More...
RATING & REVIEWS
RAZA AHMAD KHAN
Certification:
From
Professional Experience
Training Experience

Qualification
M.Tech

Skills
Hibernate, Java , PL/SQl, Spring, Spring AOP, MVC,

Profile
Brief about yourself Read More...
RATING & REVIEWS
Shrirang Mukund Garge
Certification: Oracle Certified Associate (OCA) , Certified Scrum Master (CSM) , Hortonworks Certified Developer (HDPCD)
From
Professional Experience
Training Experience

Qualification
MBA

Skills
Big Data, Business Intelligence, Certified Scrum Master (CSM), IBM Cognos, Informatica, Oracle, PL/SQl,

Profile
Hortonworks certified developer. Certified Scrum Master. Oracle Certified Associate. Total 15 years of IT experience. Around 4 years of experience in the areas of Data Warehousing and Data Migration using PL/SQL, BI, Informatica, Cognos. Read More...
RATING & REVIEWS
Ankita Agrawal
I joined Rave as a fresher and I was totally new to the IT industry. The kind of support I got from him was terrific. Anyone can learn from him the art of "Staying Calm and Cool" irrespective of the situation. One very good thing about him is he believes in giving timely Feedback to his juniors which helps his juniors to learn more and more and to improve performance. And yes , he is a dependable person. I am sure he will be a pillar for any organization he joins.
Ravi Mittal
I worked with Shrirang for closed to 5 years. He is someone who you can bank on. Once he gets his arms around a process he follows it to the minutest detail. He was a very calm demeanor. Great person to know and work with.
Cyril Rayan
Shrirang is an excellent program manager and has a strong team to deliver great results. He has great expertise in software projects and can deliver extremely well.
Anand Jain
Shrirang is a person with a broad vision and clear mindset. He always aim to the best possible results by getting his team involved in making decisions and put their best efforts in place. He is confident and a person full of business knowledge as well as capabilities of leading a team and himself.
Pallavi Bakliwal
I had the opportunity of working with Shrirang at Rave for 4 years. He is methodical, organized and very committed towards the job he undertakes. He has always demonstrated a high degree of expertise and his ability to connect with people, inspire and motivate them is incredible. He is always around to help people and he is the best manager one can ever work with.
Pallavi Bakliwal
I had the opportunity of working with Shrirang at Rave for 4 years. He is methodical, organized and very committed towards the job he undertakes. He has always demonstrated a high degree of expertise and his ability to connect with people, inspire and motivate them is incredible. He is always around to help people and he is the best manager one can ever work with.
Ankit Johari
Working with Shrirang was a great phase of my life. He is always supportive and helpful in the difficult times. He is one of the good and skillful manager I have worked in...
Sankalp Shekhar
Shrirang, a great colleague and a peer who you could look up-to for counsel. With his acute understanding in Agile methodology, he has been delight as a Scrum Master to work along. His understanding and standards of work quality, has always been motivating to bring the best out of the resources.
Aliakbar Badshah
I had the pleasure of working with Shrirang at Rave Infosys. I have learn lots of things from start to end of my career in Rave. He is a good project manager, director and also a good person.
Ashok Patidar
I have worked with Shrirang for more than 1 year. It was really a pleasure working under his guidance in Rave Infosys. It’s an honor and privilege for me realizing that I have worked with an exceptional director. No Doubt, he is an outstanding leader, a person and a friend. I highly recommend him to work with.
Sandeep Patle
Still I can remember that 1 year of Span. Working under Mr.Shrirang, was a great Experience for me and my Team. Though we had too much pressure from client but Shrirang handled it quite nicely. He is one of the Best Managers that I ever seen in 5 years of my career. I could remember his words "Family is very important than Office !!!"
Ankita choudhary
I started my career from Rave and I was fortunate to have Shrirang as my manager. He guided and motivated me and all the people working under him and with him whenever required. He is very detail oriented, hardworking and a good team leader. He is a great person and an outstanding director and mentor.
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