PL/SQL Certificate Course
BLOCK STRUCTURE, DATA TYPES, PACKAGES, TRIGGERS, EXCEPTION HANDLING
Our PL/SQL course makes you familiar on learning all aspects like database tools, query language, sub-programs, syntax query, basic and advanced DML, and scripting. You will also get an full exposure through real-world projects to gain industry experience.
Mode of Class
- Online / Offline
Course Duration
- 45 days
Job Placed Students
- 300+
Overview
Cloud Professional Technology offers the best PL/SQL Training course in hyderabad. Our PL/SQL online training course will prepare you with the complete skills needed to create, implement, and manage robust database applications using Oracle Database tools. Some of the topics covered are Basic Procedural Language/Structured Query Language, subprograms, sections, and syntax query, DML, advanced DML, and scripting. The entire training is in line with the Oracle PL/SQL certification.
Our expert trainers will help you to master PL SQL advanced features, from performance to maintainability to the application code architecture. Our best online classes help you to gain a precise knowledge of PL SQL language, architecture, interactions with the SQL engine, data types, and much more. You’ll also gain practical exposure to various industry-based projects during the training.
Comprehensive Curriculum
An interactive curriculum is designed to build the capacity of all learners and practitioners to provide the best learning experience. This new resource, Enhancing and Implementing Learning online, includes a series of sessions with interactive modules that enable practitioners to determine what assets they already have in place, identify gaps, and outline concrete next steps for creating or strengthening their skills.
Personalised Mentorship
Cloud Professional Technologies is an online program crafted to guide as academic development and help them make informed decisions about their career. This Mentorship Programme identifies the strengths, weaknesses, and interests of practitioners and provides them with the necessary assistance for certification programs and job assistance. The emphasis is on helping people discover their inherent potential by guiding them through their journey, helping them choosing the best career path.
Dedicated Carrer Assistance
Amid an increasingly demanding economic and business climate, job placement support has become an important duty for Institute. Cloud Professional Technologies makes efforts toward career design and job placement support from the early stages of course, based on a clear understanding of the types of job candidates who are sought by employers, and who are in step with times. We offer a wide range of courses for engaging in more practical job-seeking activities and strategies for employment interviews
PL/SQL — OVERVIEW
Features of PL/SQL
Advantages of PL/SQL
2. PL/SQL — ENVIRONMENT SETUP
Text Editor
3. PL/SQL — BASIC SYNTAX
4. PL/SQL — DATA TYPES
PL/SQL Scalar Data Types and Subtypes
PL/SQL Numeric Data Types and Subtypes
PL/SQL Character Data Types and Subtypes
PL/SQL Boolean Data Types
PL/SQL Datetime and Interval Types
PL/SQL Large Object (LOB) Data Types
PL/SQL User-Defined Subtypes
NULLs in PL/SQL
5. PL/SQL — VARIABLES
Variable Declaration in PL/SQL
Initializing Variables in PL/SQL
Variable Scope in PL/SQL
Assigning SQL Query Results to PL/SQL Variables
6. PL/SQL — CONSTANTS AND LITERALS
Declaring a Constant
The PL/SQL Literals
7. PL/SQL — OPERATORS
Arithmetic Operators Relational Operators Comparison Operators Logical Operators PL/SQL Operator Precedence
8. PL/SQL — CONDITIONS
IF-THEN Statement IF-THEN-ELSE Statement IF-THEN-ELSIF Statement CASE Statement Searched CASE Statement Nested IF-THEN-ELSE Statements
9. PL/SQL — LOOPS
Basic Loop Statement
WHILE LOOP Statement
FOR LOOP Statement
Reverse FOR LOOP Statement
Nested Loops Labeling a PL/SQL Loop
The Loop Control Statements
EXIT Statement
The EXIT WHEN Statement
CONTINUE Statement
GOTO Statement
10. PL/SQL — STRINGS
Declaring String Variables
PL/SQL String Functions and Operators
11. PL/SQL — ARRAYS
Creating a V array Type
12. PL/SQL — PROCEDURES
Parts of a PL/SQL Subprogram
Creating a Procedure
Executing a Standalone Procedure
Deleting a Standalone Procedure
Parameter Modes in PL/SQL Subprograms
Methods for Passing Parameters
13. PL/SQL — FUNCTIONS
Creating a Function
Calling a Function
PL/SQL Recursive Functions
14. PL/SQL — CURSORS
Implicit Cursors
Explicit Cursors
Declaring the Cursor
Opening the Cursor
Fetching the Cursor
Closing the Cursor
15. PL/SQL — RECORDS
Table-Based Records
Cursor-Based Records
User-Defined Records
16. PL/SQL — EXCEPTIONS
Syntax for Exception Handling
Raising Exceptions
User-defined Exceptions
Pre-defined Exceptions
17. PL/SQL — TRIGGERS
Creating Triggers
Triggering a Trigger
18. PL/SQL — PACKAGES
Package Specification
Package Body
Using the Package Elements
19. PL/SQL — COLLECTIONS
Index-By Table
Nested Tables
Collection Methods
Collection Exceptions
20. PL/SQL — TRANSACTIONS
Starting and Ending a Transaction
Committing a Transaction
Rolling Back Transactions
Automatic Transaction Control
21. PL/SQL — DATE & TIME
Field Values for Datetime and Interval Data Types
The Datetime Data Types and Functions
The Interval Data Types and Functions
22. PL/SQL — DBMS OUTPUT
DBMS_OUTPUT Subprograms
23. PL/SQL — OBJECT-ORIENTED
Instantiating an Object
Member Methods
Using Map method
Using Order method
Inheritance for PL/SQL Objects
Abstract Objects in PL/SQL
"Our SQL / PLSQL trainers are certified professionals fromOracle University & PHD PG holders from UNIVERSITY OF TEXAS are industry experts having 10+ years of experience”
Check out Other Courses
Get in Touch
We’ll respond for all your queries
Call us : +95 020 58585
+955 343 2702
Email : cpt@learnittechnologies.com
learnittechnologies1@gmail.com