#No.1 in Pune for Oracle SQL | PL-SQL | DBA Training and Certification for Professionals and Corporate's In Pune

Declaring Variables.
Writing Executable Statement.
Interacting with orcale server.
Composite Data Types.

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.

Freshers.
Database Developers working with Oracle,Sybase DB2.
Mainframe developers working with IBM mainframe or AS400.
Application Developers working with JAVA,C# etc.

Total hours: 80hrs

Describing PL/SQL.
Describing the Use of PL/SQL for the Developer and the Database Administrator.
Explaining the Benefits of PL/SQL.
PL/SQL program constructs.
PL/SQL anonymous block structure.
Subprogram block structure.
Course objectives and overview.

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.
%TYPE and %ROWTYPE Attributes.

Recognizing the Significance of the Executable Section.
Writing Statements Within the Executable Section.
Describing the Rules of Nested Blocks.
Executing and Testing a PL/SQL Block Using Coding Conventions.

Writing Successful SELECT statement in PL/SQL.
Declaring the Data Type and Size of PL/SQL Variable Dynamically.
Writing Data Manipulation Language (DML) Statement in PL/SQL.
Controlling Transactions in PL/SQL.

Identifying the users and Types Of control Structures.
Constructing the IF statement.
Constructing and Identifying Different Loop Statement.
Controlling Block Flow using Nested Loops and Labels.

PLSQL Record.
PLSQL Table.

Using PL/SQL Record Variable.
Distinguish Between the Implicit and Explicit Cursor.
Writing a cursor FOR Loop.

Defining the Uses of Procedures.
Recognizing Unhandled Exceptions.
Listing and Using Different Types of PL/SQL Exception Handlers.

Describe the Uses of Procedure.
Create Procedure.
Create Procedure with argument.
Invoke Procedure.
Remove Procedure.
Sub Procedure.

Describe the Uses of Function.
Create Function.
Create Function with arguments.
Invoke Function.
Remove Function.
Differentiate between Procedure and Function.
Sub Function.

Describe Packages.
Create Packages.
Local Variables.
Invoke Objects in Package.
Remove Package.

Describe different types of triggers.
Database triggers and their use.
Create database triggers.
Drop database triggers.

Analyze Command.
TKProf Utility.
Writing Optimized SQL Statements.

4

Course Rating

5 stars

77 %
4 stars

54 %
3 stars

14 %
2 stars

5 %
1 stars

2 %

Duration 80 hours
Training Type Classroom & Online
Fees Rs. 12K
Students Enrolled 5500+
Certificate Yes
Batch Available Mon-Sun
100% Placement Support Yes

Become a Teacher, Share your knowledge

Create an online video course, reach students across the globe, and earn money

Contact Us

© Copyright 2020. Systems and Networks Technologies Training Institute.