On Demand
Oracle PL-SQL Training & Certification
Get Trained & Get Certified in PL-SQL
Students Enrolled
0
+
Ratings for this course
What you'll learn?
- Declaring Variables.
- Writing Executable Statement.
- Interacting with orcale server.
- Composite Data Types.
Description
In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL). The purpose of PL/SQL is to combine database language and procedural programming language.
Ideal Candidates for This Course:
- Freshers.
- Database Developers working with Oracle,Sybase DB2.
- Mainframe developers working with IBM mainframe or AS400.
- Mainframe developers working with IBM mainframe or AS400.
- Application Developers working with JAVA,C# etc.
Curriculum
Total Hours
0
Hours
Oracle PL-SQL
Module 1: Introduction
- Describing PL/SQL
- Use of PL/SQL for Developers and DBAs
- Benefits of PL/SQL
- PL/SQL Program Constructs
- PL/SQL Anonymous Block Structure
- Subprogram Block Structure
- Course Objectives and Overview
Module 2: Declaring Variables
- Recognizing the Basic PL/SQL Block and its Sections
- Significance of Variables in PL/SQL
- Difference Between PL/SQL and Non-PL/SQL Variables
- %TYPE and %ROWTYPE Attributes
Module 3: Writing Executable Statements
- Significance of the Executable Section
- Writing Statements in the Executable Section
- Rules of Nested Blocks
- Executing and Testing a PL/SQL Block
- Coding Conventions
Module 4: Interacting with the Oracle Server
- Writing SELECT Statements in PL/SQL
- Declaring Variable Data Types Dynamically
- Writing DML Statements in PL/SQL
- Controlling Transactions in PL/SQL
Module 5: Writing Control Structures
- Identifying Uses and Types of Control Structures
- Constructing IF Statements
- Loop Statements (FOR, WHILE)
- Nested Loops and Labels
Module 6: Composite Data Types
- PL/SQL Record
- PL/SQL Table
Module 7: Writing Explicit Cursors
- Using PL/SQL Record Variable
- Implicit vs Explicit Cursor
- Cursor FOR Loop
Module 8: Handling Exceptions
- Defining the Uses of Procedures.
- Recognizing Unhandled Exceptions.
- Listing and Using Different Types of PL/SQL Exception Handlers.
Module 9: Creating Procedures
- Describe the Uses of Procedure.
- Create Procedure.
- Create Procedure with argument.
- Invoke Procedure.
- Remove Procedure.
- Sub Procedure.
Module 10: Creating Functions
- Describe the Uses of Function.
- Create Function.
- Create Function with arguments.
- Invoke Function.
- Remove Function.
- Differentiate between Procedure and Function.
- Sub Function.
Module 11: Creating Packages
- Describe Packages.
- Create Packages.
- Local Variables.
- Invoke Objects in Package.
- Remove Package.
Module 12: Creating Database Triggers
- Describe different types of triggers.
- Database triggers and their use.
- Create database triggers.
- Drop database triggers.
Module 13: SQL Tuning
- Analyze Command.
- TKProf Utility.
- Writing Optimized SQL Statements.
Course Features
- Duration: 80 hours
- Training Type: Classroom & Online
- Students Enrolled: 5500+
- Certificate: Yes
- Batch Available: Mon-Sun
- 100% Placement Support: Yes
Salary Scale
Maximum
10 LPA
70%
Average
4 LPA
50%
Minimum
2.5 LPA
30%
Job Role
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
Training Option
- Live-Online Instructor Led Training
- 100+ lab assignments & Quizzes
- 24/7 Lab access on Rooman Cloud Lab
- Labs Designed & Mentorship support by Industry Experts
- 5 capstone projects
- Live-Online sessions with Industry Experts & Subject Matter Expert from Rooman
- Access to Recorded Session of Live-Online Classes available 24/7
- Industry Recognized Course Completion Certificate
- Interview Preparation & Placement Support
- In-Person Classroom based Training conducted by Subject Matter Expert
- Flexibility to attend classes at any of our 50+ Centers PAN India
- Hands-on experience at our state-of-the-art Lab
- 100+ lab assignments & Quizzes
- 24/7 Lab access on Rooman Cloud Lab
- Labs Designed & Mentorship support by Industry Experts
- 5 Capstone & 1 real-world project
- Exclusive sessions with Industry & Subject Matter Expert
- Access to Recorded Session of Live-Online Classes available 24/7
- Industry Recognized Course Completion Certificate
- Interview Preparation & Placement Support
- Access to Campus Placement drives
- 1 year access to our LMS
Our Alumni
Exam Partner
FAQ
Item #1
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.