Duration

30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)


Enroll Now

Request more information




PL SQL

PL/SQL is an integration of procedural languages within the syntax of SQL statements. Using oracle database server, the Pl/SQL programs are compiled and further stored inside databases. Both PL/SQL and SQL are executed at the run-time within the same server process to bring optimal efficiency. The PL/SQL engine is used to process the PL/SQL statements or codes which are stored on either the client system or client side or the database or server-side.

The PL/SQL language includes procedural elements like conditions and loops to allow repetitive functions and conditional processing. Procedures and functions can be easily created and triggered along with declaration of constants and variables. Additionally, PL/SQL works analogously with the embedded procedural languages which are associated with other RDBMS such as Sybase ASE and Microsoft SQL server. The PL/SQL sybtax is modeled on that of Ada with Pascal as the root language. Consequently, PL/SQL resembles Pascal in a lot of ways.


The given course on PL/SQL is highly comprehensive with focus on application and implementation. It will be beneficial if the students have a basic understanding of RDBMS, source code, text editor and program execution. Additionally, a basic understanding of SQL or other programming languages will be an added advantage for the students in order to keep pace with this training program.


DATABASE DESIGN

  • Database Models
  • Beginnings
  • Some Introductory Terminology
  • Codd's 12 Rules
  • Normalization
  • First Normal Form
  • Higher Order Normal Forms

ORACLE STANDARD INTERFACES

  • SQL
  • SQL*Plus
  • Oracle Architecture
  • Interfaces to Oracle
  • Command Line Interface
  • Viewing a Sample Table
  • The Graphic al User Interface
  • The SQL Buffer
  • The Web-Based Interface
  • Describe

THE SAMPLE DATABASE

  • The Entity Relationship Model
  • Entity Relationship Diagrams
  • The Sample Database
  • ER Diagram for Sample Database
  • Creating the Sample Data
  • Viewing Sample Data
  • Data Types of the Sample Data

DATA DEFINITION LANGUAGE

  • Categories of SQL Statements
  • Oracle Datatypes
  • The CREATE Statement
  • The DROP Command
  • The ALTER Command
  • Integrity Constraints
  • Entity Integrity Constraints
  • Referential Integrity Constraints
  • Modifying Table to Use Constraints
  • Checking Constraints
  • The Data Dictionary

DATA MANIPULATION LANGUAGE

  • DML Statements
  • The SELECT Statement
  • The INSERT Statement
  • The DELETE Statement
  • The UPDATE Statement
  • More SQL*Plus Commands

TRANSACTION CONTROL

  • Transactions
  • Command Classification
  • Savepoints
  • The SET TRANSACTION Command

SQL OPERATORS

  • Simple Selects
  • Comparison Operators
  • IN and NOT IN Operators
  • BETWEEN Operator
  • The LIKE Operator
  • Logical Operators
  • IS NULL and IS NOT NULL
  • ANY
  • ALL

SQL FUNCTIONS

  • Introduction
  • The DISTINCT Keyword
  • Aliases
  • Miscellaneous Functions
  • Mathematical Functions
  • String Functions
  • Date Functions
  • Conversion Functions
  • Pseudo Columns

JOINING TABLES

  • Joins
  • Cartesian Product
  • Inner Joins
  • Equi-Join
  • Table Aliases
  • Non-Equi Join
  • Non-Key Join
  • Reflexive Join
  • Natural Join
  • Outer Joins
  • Right Outer Join
  • Left Outer Join
  • Full Outer Join
  • Oracle-Specific Syntax for Outer Joins

SET OPERATORS

  • Introduction
  • Selection Criteria
  • Union
  • Union All
  • Intersect
  • Minus

SQL SUBQUERIES

  • Introduction
  • Using a Sub query with a DML Statement
  • Typical Subqueries
  • Subquery Operators
  • Standard vs.Correlated Subqueries
  • Correlated Subquery Example
  • Predicate Operators

GROUPS

  • SQL Statements
  • GROUP BY Clause
  • Having Clause
  • Order of a SELECT Statement

MORE DATABASE OBJECTS

  • More Database Objects
  • Relational Views
  • Updating a View
  • Create or Replace
  • Forcing a View
  • The Data Dictionary Revisited
  • Indexes
  • Synonyms

REPORTS

  • Report Features
  • Session Control
  • The SET Command
  • The COLUMN Command
  • The BREAK Command
  • The COMPUTE Command

INTRODUCTION

  • SQL vs. PL/SQL
  • A Few Simple Examples
  • Saving Procedures
  • A More Complete Picture
  • Comments
  • Variable Substitution
  • Simple Exception Handling
  • Advantages of PL/SQL
  • Assignments

DECLARATIONS AND DATA TYPES

  • Declarations
  • Standard Data Types
  • Initialization
  • Variable Names
  • Specialized Data Types - %TYPE
  • Specialized Data Types - %ROWTYE
  • Building Yo ur Own Data Types - Records
  • A Quick look at Loops
  • Arrays
  • Tables
  • Nested Blocks

LANGUAGE COMPONENTS

  • Introduction
  • Assignments
  • Decision Making Statements
  • Simple Loops
  • Loops - for
  • Loops - ind efinite
  • Loops - while
  • Simple Loops
  • Nested Loops
  • Boolean Variables
  • PL/SQL Relational Operators
  • PL/SQL Logical Operators
  • The CASE Construct

CURSORS

  • Introduction
  • Cursor Manipulation
  • Using the Cursor
  • For Loops Cursors
  • Cursor Attributes
  • Cursor Parameters
  • Nested Cursors
  • Cursor Exceptions

EXCEPTIONS

  • Errors in Programs
  • Run Time Exceptions
  • Oracle Built In Exceptions
  • Unnamed Exceptions
  • Built in Exception Functions
  • Creating Your Own Exceptions
  • Building Non Terminating Exceptions

FUNCTIONS AND PROCEDURES

  • Introduction
  • Creating a Procedure
  • Example Procedure
  • Using Parameters
  • Functions
  • Procedures and Exceptions

AN SQL AND SQL*PLUS REFERENCE

  • DDL Statements
  • DML Statements
  • Transaction Control Statements
  • Operators
  • Common SQL*Plus Commands

The tutorial is structured while keeping in mind the software professionals willing to learn procedural SQL language to implement in various RDBMS. Database management is and always will be a highly promising domain of work which pushes individuals with competencies to greater heights in their careers. PL/SQL is an extremely versatile and powerful language which can be implemented in various database management platforms to create extremely usable database management systems which can be deployed in enterprises locally or on the cloud. Consequently, individuals well versed in PL/SQL will find themselves with plethora of opportunities in the industry in various domains both IT and non-IT .

1. Are lab-sessions available after theory sessions?

We provide online lab facilities to all our students, wherever possible & applicable, using a combination of one or more options, including global ASP setups, live-environments, real-time simulations, training-videos, PPTs, Screenshots and others.

2. Who and how qualified are the instructors?

All our instructors go through a rigorous and multiple processes of filtering and selection before they are appointed by us. Only the most qualified, most experienced and best suited candidates are chosen as instructors.

3.What are the machine requirements for the course?

You must have a fairly good desktop PC or laptop. You can even access these courses on your tabs or smart phones. For PCs and laptops the configuration should be at-least an Intel Pentium processor, 4GB of RAM and 50 to 100 GB of free hard disk space. You must also have a good and steady WiFi internet connection which works at 3G or 4G speeds.

4.How will I undergo practical training in the course?

Depending on the type of lab facilities available for the course you have enrolled in for our instructor would be happy to help you in your lab sessions.

5.What is the process to get my questions/queries answered?

Get in touch with your trainer. You can also consult your batch-mates. We believe in collaborative and practical learning.

6.Can a free demo session be provided?

We do not provide free demo sessions.

7.Will there be a provision for repetition if I miss a class?

We encourage our trainees to attend all sessions. If you have missed a session we will try out best to update you on it, if possible. Else you will need to pay a small fee to have a repeat session arranged specifically for you.

8.Does your organization provide assistance in job hunting?

We are connected across the industry in India and abroad. We will pass on any job openings from our customer to our trainees. But we are not a manpower placement provider.

9.How and where can I make the payment?

You can pay using any credit or debit card in India or abroad. You can also pay using your PayPal account.

10. Will practice material or tests be also provided with the course?

Yes. As required & as applicable.

11.What is the minimum or maximum batch size?

Minimum/maximum batch sizes vary from course to course, depending upon a number of factors. It can vary from as few as 2 to as many as a few hundred, in some cases. But that number does not impact the quality of training that we deliver due to our tight quality-control mechanisms.

All trainees will be provided with a course participation and completion certificate by Aurelius Corporate Solutions. Please note, we are an independent provider of learning solutions. We are not affiliated in any manner to any company or organization.

Copyright © 2016 Aurelius Corporate Solutions Pvt. Ltd. All Rights Reserved.