loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Oracle 11g SQL , PL/SQL

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Surya Reddy

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Oracle 11g   SQL , PL/SQL

Oracle 11g SQL , PL/SQL

Online Instructor led Course

Platform: Webex or Skype

12,000

3 Reviews
7 Interested

About the Course


All Oracle session will be covered with real time scenarios along with a real time project explanation.

Topics Covered

:::…Oracle…:::
Database Introduction
Data
Database
Database Management System
Types of Databases
ER-Model
Accessing the Database
Environments to access database
Toad
Sql Developer
Sql Navigator
Sql * Plus

SQL
Accessing the Databases using SQL
Data types
Database Objects
Types of Database Objects in SQL
Tables
Views
Types of Views
Difference between Normal Views and Materialized Views
Sequences
Synonyms
Indexes
Clusters
Data Dictionary Tables or Meta Data Tables
Types of SQL Statements
DDL
DML
DQL/DRL
DCL
TCL
Dual Table
SQL Operators
Arithmetic Operators
Comparison/Relational Operators
Logical Operators
SQL Special Operators

Functions
Single-Row Functions& Types
Multi-Row Functions& Types
Joins
Oracle Joins
ANSI Joins
Sub Queries
Types Of Sub Queries
Advanced Sub Queries
Set Operators
Pseudo Columns
Pseudo Columns
Types of Pseudo Columns
Rowid
Rownum
Nextval
Currval
Level
Top-N & Bottom-N Analysis
Hierarchal Queries
Analytic Functions
Cube
Rollup
Grouping
Rank
Dense Rank
Over
And more

PL/SQL
Difference between SQL and PL/SQL
Advantages of using PL/SQL
Types of PL/SQL Programs
Displaying Outputs in PL/SQL
Variables
Usage of Variables
Scope of Variables
Types of Variables
Using DML Statements in PL/SQL program
Using DQL Statements in PL/SQL Program
Non-PL/SQL Variables
Conditional Statements
Iterative Statements
Composite Data Types
Records
Collections
Cursors
Types of Cursors
Cursor Attributes
Writing Cursors using Iterative Statements
Parameterized Cursor
Static Cursor
Dynamic/Ref Cursor
Pragma
Types of Pragmas
Pragma Exception_Init
Pragma Autonomous_Transaction
Pragma Serially_Reusable
Pragma Restrict Reference
Exceptions
Types of Exceptions
Using Exception_Init
Difference between dbms_output.put_line and raise_application_error in Exceptions
Procedures
Compilation and Execution of Procedures
Types of Parameters in Procedures
Calling one procedure from another procedure
Using Pragma Autonomous Transaction
Functions
Compilation and Execution of Functions
Types of Parameters in Functions
Difference between Procedures and Functions
Packages
Compilation and Execution of a Package
Private Sub Program
Triggers
Types of Triggers
Mutating Trigger
Advanced PL/SQL
Bulk Fetching
Dynamic SQL
And more

Who should attend

Anybody

Pre-requisites

Computer with net

What you need to bring

Notebook

Key Takeaways

FAQ
Real Time Scenarios
Mock Interviews
Real time Assignments
Reviews

Recommendations & reviews from previous Customers:

K Nikhitha

"Had a great knowledge from Surya sir. Real time examples is the added advantage. Over all content is delivered well and very dedicated training class. Highly Recommended!!! "

attended Oracle 11g SQL , PL/SQL


Divya ..

"MR.Surya is very good trainer in oracle sql & plsql..before i joined in his class i did not have any idea about query writing..after his classes today i can write queries on my own... he got lot of patience and good knowledge on subject "

attended Oracle 11g SQL , PL/SQL


Snr

"He is teaching basic and advance concepts like spoon feeding. And teaching every concept with real time usage. "

attended Oracle 11g SQL , PL/SQL


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Recommendations & reviews from previous Customers:

K Nikhitha

"Had a great knowledge from Surya sir. Real time examples is the added advantage. Over all content is delivered well and very dedicated training class. Highly Recommended!!! "

attended Oracle 11g SQL , PL/SQL


Divya ..

"MR.Surya is very good trainer in oracle sql & plsql..before i joined in his class i did not have any idea about query writing..after his classes today i can write queries on my own... he got lot of patience and good knowledge on subject "

attended Oracle 11g SQL , PL/SQL


Snr

"He is teaching basic and advance concepts like spoon feeding. And teaching every concept with real time usage. "

attended Oracle 11g SQL , PL/SQL


Date and Time

Not decided yet.

About the Trainer

Surya N Reddy picture
I've 6+ years of experience as corporate trainer and software developer.
Seats Left-

Students Interested 7

Course Id: 15786