Techsage | Oracle

Oracle

Oracle Database : PL/SQL Basic & Advance Training

Techsage which is an IT training Institute ISO Certified provides you plethora of IT programs which are in high market demand these days like JAVA, Cloud Computing, VMware and many more. Out of which one of them is Oracle which has many options in it like Oracle RAC, DBA, SQL, PL etc and each has its own value in the market.

Oracle PL/SQL comes after Oracle Database. The basic structure of PL/SQL has been made using different keywords block like Begin, Declare, and Exception. Keywords Block is defined as executable block, declaration block.

Benefits of PL/SQL:

Operation of procedural construction with SQLt
Standard programs development
Improved performances
Integration with Oracle tools
Applications Portability
Exceptions handling

Key Features of Oracle Database: PL/SQL Basic & Advance Training are:

Design POC (Proof of Concept): This process is used to ensure the feasibility of the client application.
Video Recording of every session will be provided to candidates.
Live Project Based Training.
Job-Oriented Course Curriculum.
Course Curriculum is approved by Hiring Professionals of our client.
Post Training Support will helps the associate to implement the knowledge on client Projects.
Certification Based Training are designed by Certified Professionals from the relevant industries focusing on the needs of the market & certification requirement.
Interview calls till placement.

Course Content - PL/SQL BASIC & ADVANCE TRAINING

Introduction to PL/SQL - More
- PL/SQL Overview
- List the benefits of PL/SQL Subprograms
- Overview of the Types of PL/SQL blocks
- Create a Simple Anonymous Block
- Generate the Output from a PL/SQL Block
- Overview of the development environments: SQL Developer, SQL Plus
PL/SQL Programming Concepts Review - More
- Identify PL/SQL block structure
- Create procedures
- Create functions
- List restrictions and guidelines on calling functions from SQL expressions
- Create packages
- Review of implicit and explicit cursors
- List exception syntax
- Identify the Oracle supplied packages
Designing PL/SQL Code - More
- Describe the predefined data types
- Create subtypes based on existing types for an application
- List the different guidelines for cursor design
- Cursor variables
Using Collections - More
- Overview of collections
- Use Associative arrays
- Use Nested tables
- Use VARRAYs
- Compare nested tables and VARRAYs
- Write PL/SQL programs that use collections
- Use Collections effectively
Manipulating Large Objects - More
- Describe a LOB object
- Use BFILEs
- Use DBMS_LOB.READ and DBMS_LOB.WRITE to manipulate LOBs
- Create a temporary LOB programmatically with the DBMS_LOB package
- Introduction to SecureFile LOBs
- Use SecureFile LOBs to store documents
- Convert BasicFile LOBs to SecureFile LOB format
- Enable reduplication and compression
Using Advanced Interface Methods - More
- Calling External Procedures from PL/SQL
- Benefits of External Procedures
- C advanced interface methods
- Java advanced interface methods
Performance and Tuning - More
- Understand and influence the compiler
- Tune PL/SQL code
- Enable intra unit inlining
- Identify and tune memory issues
- Recognize network issues
Improving Performance with Caching - More
- Describe result caching
- Use SQL query result cache
- PL/SQL function cache
- Review PL/SQL function cache considerations
Analyzing PL/SQL Code - More
- Finding Coding Information
- Using DBMS_DESCRIBE
- Using ALL_ARGUMENTS
- Using DBMS_UTILITY.FORMAT_CALL_STACK
- Collecting PL/Scope Data
- The USER/ALL/DBA_IDENTIFIERS Catalog View
- DBMS_METADATA Package
Profiling and Tracing PL/SQL Code - More
- Tracing PL/SQL Execution
- Tracing PL/SQL: Steps
Implementing VPD with Fine-Grained Access Control - More
- Understand how fine-grained access control works overall
- Describe the features of fine-grained access control
- Describe an application context
- Create an application context
- Set an application context
- List the DBMS_RLS procedures
- Implement a policy
- Query the dictionary views holding information on fine-grained access
Safeguarding Your Code Against SQL Injection Attacks - More
- SQL Injection Overview
- Reducing the Attack Surface
- Avoiding Dynamic SQL
- Using Bind Arguments
- Filtering Input with DBMS_ASSERT
- Designing Code Immune to SQL Injections
- Testing Code for SQL Injection Flaws
PL/SQL Identifiers - More
- List the different Types of Identifiers in a PL/SQL subprogram
- Usage of the Declarative Section to Define Identifiers
- Use of variables to store data
- Scalar Data Types
- %TYPE Attribute
- Bind Variables
- Sequences in PL/SQL Expressions
Write Executable Statements - More
- Basic PL/SQL Block Syntax Guidelines
- How to comment code?
- SQL Functions in PL/SQL
- Data Type Conversion
- Nested Blocks
- Operators in PL/SQL
Interaction with the Oracle Server - More
- SELECT Statements in PL/SQL to Retrieve data
- Data Manipulation in the Server Using PL/SQL
- The SQL Cursor concept
- Learn to use SQL Cursor Attributes to Obtain Feedback on DML
- How to save and discard transactions?
Control Structures - More
- Conditional processing Using IF Statements
- Conditional processing Using CASE Statements
- Simple Loop Statement
- While Loop Statement
- For Loop Statement
- The Continue Statement
Usage of Composite Data Types - More
- PL/SQL Records
- The %ROWTYPE Attribute
- Insert and Update with PL/SQL Records
- Associative Arrays (INDEX BY Tables)
- INDEX BY Table Methods
- INDEX BY Table of Records
Explicit Cursors - More
- Understand Explicit Cursors
- Declare the Cursor
- How to open the Cursor?
- Fetching data from the Cursor
- How to close the Cursor?
- Cursor FOR loop
- Explicit Cursor Attributes
- FOR UPDATE Clause and WHERE CURRENT Clause
Exception Handling - More
- What are Exceptions?
- Handle Exceptions with PL/SQL
- Trap Predefined Oracle Server Errors
- Trap Non-Predefined Oracle Server Errors
- Trap User-Defined Exceptions
- Propagate Exceptions
- RAISE_APPLICATION_ERROR Procedure
Stored Procedures and Functions - More
- What are Stored Procedures and Functions?
- Differentiate between anonymous blocks and subprograms
- Create a Simple Procedure
- Create a Simple Procedure with IN parameter
- Create a Simple Function
- Execute a Simple Procedure
- Execute a Simple Function.

For more information about the training you can Contact US