Project Description

PL-SQL TRAINING

Detailed Course Content

What is PL-SQL?

PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. PL/SQL program units are compiled by the Oracle Database server and stored inside the database and at run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency. PL/SQL automatically inherits the robustness, security, and portability of the Oracle Database.

PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections

PL/SQL DEVELOPER TRAINING

1.Basic PL/SQL  block programming structure           –sample pl/sql program
2.Cursor                                                                                 –type of cursors:implicit,explicit
3.Trigger                                                                                –types :row-level,statement level
4.Function and procedure
5.Loop structure                                                                 –while,do while,for
6.Conditional statements                                                –if –else,if elsif

Introduction to Programming Languages

  • Introduction to PL/SQL
  • The Advantages of PL/SQL
  • PL/SQL Architecture
  • PL/SQL Data types
  • Variable and Constants
  • Using Built_in Functions
  • Conditional and Unconditional Statements
  • Simple if, if… else, nested if..else, if..else Ladder
  • Selection Case, Simple Case, GOTO Label and EXIT
  • Iterations in PL/SQL
  • Simple LOOP,WHILE LOOP,FOR LOOP and NESTED LOOPS
  • SQL within PL/SQL
  • Composite Data types (Complete)

Cursor Management in PL/SQL

  • Implicit Cursors
  • Explicit Cursors
  • Cursor Attributes
  • Cursor with Parameters
  • Cursors with LOOPs Nested Cursors
  • Cursors with Sub Queries
  • Cursors
  • Record and PL/SQL Table Types
  • Advanced PL/SQL

Procedures in PL/SQL :

  • STORED PROCEDURES
  • PROCEDURE with Parameters (IN,OUT and IN OUT)
  • POSITIONAL Notation and NAMED Notation
  • Procedure with Cursors
  • Dropping a Procedure
  • Functions in PL/SQL :
  • Difference between Procedures and Functions
  • User Defined Functions
  • Nested Functions
  • Using stored function in SQL statements
  • Packages in PL/SQL :
  • Creating PACKAGE Specification and PACKAGE Body
  • Private and Public Objects in PACKAGE
  • EXCEPTIONS in PL/SQL :

Types of exceptions :

  • User Defined Exceptions
  • Pre Defined Exceptions
  • RAISE_APPLICATION_ERROR
  • PRAGMA_AUTONOMOUS_TRANSACTION
  • SQL Error Code Values
  • Database Triggers in PL/SQL :

Types of Triggers

  • Row Level Triggers
  • Statement Level Triggers
  • DDL Triggers
  • Trigger Auditing

 File Input/Output :

  • PL/SQL file I/O (Input/Output)
  • Using UTL_FILE Package
  • Implementing Object Technology

What is Object Technology ?

  • OOPS-Object Instances
  • Creation of objects
  • Creating User Defined Data Types
  • Creating Object Tables
  • Inserting rows in a table using Objects
  • Retrieving data from Object based Tables
  • Calling a Method
  • Indexing Abstact Data type Attributes

 Using LOBS

  • Large Objects (LOBS)
  • Creating Tables-LOB
  • Working with LOB values
  • Inserting, Updating & Deleting Values in LOBs
  • Populating Lobis DBMS_LOB Routines
  • Using B-FILE

 Using Collections

  • Advantages of collection
  • Ref cursor (Dynamic Cursor)
  • Weak ref cursor
  • Strong ref cursor
  • Nested Tables VARRAYS or VARYING arrays
  • Creating tables using nested tables
  • Inserting, updating & deleting Nested 

Table records

  • Nested table in PL/SQL
  • Oracle Database Architecture
  • Introduction to Oracle Database Architecture
  • Physical structures Logical structures
  • DB Memory Structures Background Process
  • 2 Tire, 3 Tire, N-Tier Architecture
  • Advanced Features

9i Joines

  • New Date function
  • Rename column
  • Inner Join/Natural Join
  • Left Outer Join/Right Outer Join
  • Full Outer Join
  • Multiple Inserts
  • Insert All Command
  • Merge statement
  • NVL2(), NULLIF(), COALESCE()
  • CASE expression of Select Command
  • Temporary Tables/Global Tables
  • New Function EXTRACT()
  • Autonomous Traction
  • Pragma _ Autonomous_ Transaction()
  • Bulk Collect
  • About Flash Back Queries
  • Dynamic SQL
  • New data types, Flash back Command
  • Purge Command, Recyclebin
  • Regular expressions, DML Error Logging
  • Data Pump, Virtual Columns
  • Read only tables, Cross tab Views using
  • Pivot/Unpivot operators, Follows Clause
  • Compound triggers, New data types 

 DBA CONCEPTS

  • Database
  • Tablespace
  • Types of tablespaces
  • Data files /Se

PL-SQL TRAINER DETAILS

Role : Senior Software Developer
Experience : 10+ Yrs of IT Experience across MNC Companies
Technologies : SQL, PL-SQL, T-SQL, SQL Server, Oracle, BI Tools,….etc
About Trainer :

OCP Certified Trainer with 10+ Years of diversified experience in designing, building and managing database applications. Proficient working experience  on Oracle SQL and PL-SQL Development and in-depth knowledge on developing stored procedures and triggers, Managing and creating database sequence, creating and deploying packages, Improving data security and performance, SQL Statement Tuning.  Passionate about training and sharing knowledge.

Certifications : Oracle Certified Associate – PL-SQL Developer
Oracle Certified Professional – SQL Developer
Oracle Database Expert – Database SQL
                            

Trainings and Batches

Mode of Training

Numaware provides the following list of trainings according to Trainee or Colleges or Organization preference

  • Classroom Training
  • Online Training
  • Corporate Training
  • Campus Training
  • University Training
  • Virtual Instructor-Led Training
  • Instructor-led Live Classroom Training

Batches Available

We are Flexible with following list of batches as per the student requirements and availability.

  • Regular Batch
  • Weekend Batch
  • Weekday Batch
  • Fast-Track Batch
  • One to One Batch
  • Customized Batch

Flexible Timings

Numaware providing Flexible timings to schedule the Batches according to student-preferred timings at either Morning or Evening

  • Morning : 6.00 AM to 12.00PM
  • Evening : 3.00 PM to 10.00PM

Affordable Fees

We Charge very nominal, least and best price for all trainings when compared to Market or any other institutes with good quality standards and no compromise on commitment of providing Quality of Training.

Digital and Flexible Payment Options are available with Numaware Technologies Pvt. Ltd

  • Cash with Invoice
  • Credit-Card Pay
  • Debit-Card Pay
  • Any Digital-Pay
  • Account Transfer
  • Pay-Tm Transfer

Note: Fee will be finalized after demo session as per the Trainer suggestions and Student requirement.

Numaware Benefits

Numaware Technologies Pvt. Ltd is one of the best training institutes in Bangalore, offering Job demanding IT courses, Niche skills for working professionals, fresher’s, and students to ensure a successful future. We offer 100% placement support, cost-effective courses, real-time project experience, resume support, interview support and more. Our courses will equip you to get jobs in top MNCs and launch a successful career.

TRAINING BENEFITS in Numaware Technologies :

  • Training with IT Industry experts and Certified professional s working in MNC Companies.
  • Importance given to both theory and practice
  • Hands-on experience in real-time projects
  • Assistance in all stages of getting a job
  • Proven track record
  • Limited students in a batch
  • Flexible timings
  • Certification support

STUDENT BENEFITS in Numaware Technologies:

  • Post-training and on-job support
  • Backup classes for missed sessions
  • Remote lab facility, Wi-Fi access and LED TV projection
  • Mock exams and interviews for real-life simulation experience
  • Affordable fees with 2 easy installments

PLACEMENT BENEFITS in Numaware Technologies:

  • Our recruitment team will send you for interviews till you get placed
  • Frequently asked interview Q & A will be shared
  • Resume build support from industry professionals
  • We train you with real cases studies for interviews
  • Emphasis on practical knowledge in everything

Job Demanding Courses

Numaware Trainings is a Platform for Learning Technologies

Learn what really matters

Just work hard and focus on your job… because luck truly favors the prepared!!
All the best for your career

Oracle PL-SQL Training |Best Oracle PL-SQL Training Institute in Bangalore |Best Oracle PL-SQL Training Institute in Marathahalli |Best Oracle PL-SQL Training Institute in India |Oracle PL-SQL Online Training |Best Oracle PL-SQL Online Training Institute in Bangalore |Best Oracle PL-SQL Online Training Institute in Marathahalli |Best Oracle PL-SQL Online Training Institute in India |Oracle PL-SQL Corporate Training |PL-SQL  Training | Best PL-SQL  Training Institute in Bangalore |Best PL-SQL  Training Institute in Marathahalli |Best PL-SQL  Training Institute in India |PL-SQL  Online Training |Best PL-SQL  Online Training Institute in Bangalore |Best PL-SQL  Online Training Institute in Marathahalli |Best PL-SQL  Online Training Institute in India |PL-SQL  Corporate Training | PL-SQL Job Support.