UrbanPro
true
true

Deepak

Chinchwad, Pune, India - 411057

Deepak Oracle trainer in Pune

Platinum

Deepak

Oracle Database Trainer

Chinchwad, Pune, India - 411057.

101 Students taught

5.0

UrbanPro Rating
Referral Discount: Get ₹ 500 off when you make a payment to start classes. Get started by Booking a Demo.

Details verified of Deepak

Identity

Education

Know how UrbanPro verifies Tutor details

Identity is verified based on matching the details uploaded by the Tutor with government databases.

Overview

I am having 9 + Years of experience in MNC IT company.
I am working as a Team Lead - Oracle Project/Data-ware Housing. I am giving training for Oracle, SQL, PL/SQL, Unix Shell Scripting and Reporting Tool. I will help the Student to find perfect IT job and help them to get placed.
My aim is not only provide training but also to helps student real-time scenario project.
I want to help student for resume building and job seeking(Interview Question, Solution, Refer,etc.).

Benefits:
- Apart from this, there will be a session on real-world scenarios.
- No time constrained
- Best practice code
- Help in Searching Job
- Help for Interview question and In Resume
- Code debugging and understanding
- Real-time Sample Code
- Data warehousing concepts
- Help For Oracle Certifications.

Intro Video

  • Oracle Training , Database Training +6

Languages Spoken

Hindi

English

Marathi

Education

Pune

Bachelor of Engineering (B.E.)

Address

Chinchwad, Pune, India - 411057

Verified Info

ID Verified

Education Verified

Phone Verified

Email Verified

Report this Profile

Is this listing inaccurate or duplicate? Any other problem?

Please tell us about the problem and we will fix it.

Please describe the problem that you see in this page.

Type the letters as shown below *

Please enter the letters as show below

Oracle Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Oracle Training

9

Oracle Database Versions

Oracle Database 12c, Oracle 10g DBA, Oracle 11g DBA

Oracle Developer Certification Taught

Oracle Developer OCM, Oracle Developer OCP, Oracle Developer OCA

Oracle Products taught

Oracle PL/SQL, Oracle Database, Oracle Developer

Teaching Experience in detail in Oracle Training

Oracle syllabus SQL Contents * Oracle History * Oracle Architecture - SGA - PGA * The detailed overview of SQL * Different types of SQL - DDL - DML - TCL - DCL * SQL commands for different types of SQL * Practical Implementation of each command * Row filtration using WHERE clause in SQL * Data Types available in SQL * Sorting methods using ORDER BY clause in SQL * Operators available in SQL * Precedence of Operators * Various SQL Functions - Character - Number - Date Conversion -Aggregate - General Functions * GROUP BY and HAVING clauses of SQL * Set operators - UNION - UNION ALL - INTERSECT - MINUS * Oracle Joins - Equijoin - Non-equijoin - Self-join -Natural join -Cross join - Outer join - Left Outer - Right Outer -Full outer - Inner join - Using clause - On clause * All subqueries - Subqueries on multiple columns (Pairwise Comparision) - Subqueries in the FROM clause - Correlated SUB Query - Scalar Subqueries * Top N analysis * WITH clause introduction * EXISTS and NOT EXISTS operators * Global Temporary Tables * ANALYTICAL FUNCTION : - RANK - DENSE_RANK, - FIRST - LAST - LAG - LEAD - LISTAGG - ROLLUP - CUBE - grouping_id - Rowid vs RowNum * Views - Let's modify an existing view - Create View from more than 1 Table * Materialised view - Build - Refresh Mode - Materialized view log * High water mark PL/SQL * Introduction – PL/SQL Architecture * Declaring Variables PLSQL block * Writing Executable Statements * Interacting with Oracle Server * Writing Control Structures * Comments in PLSQL * Variable Scope * Using GOTO * Using the CASE Statement * Using the If-Then-Else * Using the If-Then-Else * Working with LOOPS * Continue Statement * Working with Composite Data Types Cursor * Cursors Implicit * Understanding the Concept and Purpose of Explicit Cursors * Learn about Cursor Attributes * Creating and Using Cursor Parameters * Cursors with Records * Looping with Cursors Exceptions * Difference between Global vs Local Objects and Exceptions * Handling Exceptions * What Are the Types of Exceptions * Creating User-Defined Exceptions * Using SQLCODE and SQLERRM Objects Procedures & Functions * Creating Procedures * Input and Output of procedures * Understanding the Parameter Specification * Standalone procedures * Creating Functions * Managing Subprograms * Overloading the Subprograms * What are Functions & Procedures and Why We Use Creating Packages * Creating & Using & Modifying & Removing the Packages * Visibility of Package Objects * Illegal Object Reference & Forward Declaration * Package Initialization * How Can I Find the Packages? Triggers * Creating Database Triggers * Types of triggers * Statement & Row Level Triggers * Using New & Old Qualifiers in Triggers * Using RAISE_APPLICATION_ERROR Procedure in Triggers * Using WHEN Clause in Triggers * INSTEAD OF Triggers * Exploring & Managing the Triggers * Compound Triggers * Handling Mutating Table Errors Advance PL/SQL What is SQL Tuning and Why to Do That? * How an SQL Statement is Processed * What is "cost" in detail * Plan Generator * Execution Plan and Explain Plan in Details * V$SQL_PLAN View Indexes * Table Access Full * Table Access by ROWID * Index Unique Scan Oracle Database Architecture * PGA * SGA * Shared Pool * Buffer Cache * Redo Log Buffer Tuning : * Collection * Introduction to BULK COLLECT feature * Implementation of BULK COLLECT in PLSQL program * FOR ALL loop with BULK COLLECT * Dynamic SQL * Partitioning * Ref Cursors * Understanding of PLSQL Tables * Arrays * Nested Tables * Associative arrays * Some part of tuning * Bind variable * Function based index * Some part of Hints About Me: Having 9 + Years of experience in MNC IT company I am working as Team Lead - Oracle Project. I am providing training for Oracle, SQL, PL/SQL, Advanced PL/SQL, And Unix Shell. I am providing classroom training as well as On-line training. There are a lot of assignments which will you understand database flow and work in the Software industry.

Gallery (21)

oracle Intro

oracle

Introduction to Databases

oracle architecture

architecture

architecture

plsql

plsql cursor

oracle

oracle

oracle

oracle Intro

olap vs oltp

+12 Photos

Documents (18)

oracle Intro

Memory managment

Oracle physical stru

oracle architecture

dataware

dataware

dataware

dataware

Oracle Database Basic Command

+9 Docs

Reviews (65)

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

4.9 out of 5.0 65 reviews

Deepak https://s3-ap-southeast-1.amazonaws.com/tv-prod/member/photo/1707470-small.jpg Chinchwad
4.90565
Deepak
M

"Your passion for what you do has helped me find my own passion. Thank you for being such an inspiration to me. Highly recommended to all. "

Deepak
K

"I would like to say and that is Deepak is a great mentor who can guide you technically as well as personally and make you a skilled person. Just don't lose your hope and study hard. "

Reply by Deepak

Congrats Kamal for Job, Stay connected and feel free to contact if any Help needed.

Deepak
P

"I done my PLSQL classes, It was really a good experience. Dipak Sir provided me a excellent platform to learn and gain enough knowledge in plsql course . Trainer was good and the trainer had enough knowledge and experience in the field of plsql. I would definitely suggest it for the enthusiasts who are willing to gain knowledge in the field of SQL and PLSQL. Highly Recommended. "

Reply by Deepak

Congrats for Job. All the best.

Deepak
R

"All the sessions were properly planned. The classroom experience was good with all the topics of the course being covered. Enough time was given for theory as well as practice. Doubts were addressed promptly. "

Have you attended any class with Deepak? Write a Review

FAQs

1. Which classes do you teach?

I teach Database Training, Oracle Certification, Oracle DBA OCP, Oracle Training, PL/SQL, RDBMS, SQL Programming and Tableau Classes.

2. Do you provide a demo class?

Yes, I provide a free demo class.

3. How many years of experience do you have?

I have been teaching for 9 years.

Answers by Deepak (35)

Answered on 31/07/2017 IT Courses/SQL Programming

Can I change the SQL server to big data?

yes
Answers 1 Comments
Dislike Bookmark

Answered on 31/07/2017 IT Courses/SQL Programming

How can an Excel user use SQL in his work for his present company?

to export and import data
Answers 1 Comments
Dislike Bookmark

Answered on 31/07/2017 IT Courses/SQL Programming

How can I get a job in MS SQL as a fresher?

as fresher you never not to know which technology you will get job. it s on company requirement .
Answers 1 Comments
Dislike Bookmark

Answered on 19/10/2016 IT Courses/Oracle Training/Oracle Database IT Courses

Oak Ridge Automatic Computer and Logical Engine .....
Answers 20 Comments
Dislike Bookmark
Oracle Training 5.0

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Oracle Training

9

Oracle Database Versions

Oracle Database 12c, Oracle 10g DBA, Oracle 11g DBA

Oracle Developer Certification Taught

Oracle Developer OCM, Oracle Developer OCP, Oracle Developer OCA

Oracle Products taught

Oracle PL/SQL, Oracle Database, Oracle Developer

Teaching Experience in detail in Oracle Training

Oracle syllabus SQL Contents * Oracle History * Oracle Architecture - SGA - PGA * The detailed overview of SQL * Different types of SQL - DDL - DML - TCL - DCL * SQL commands for different types of SQL * Practical Implementation of each command * Row filtration using WHERE clause in SQL * Data Types available in SQL * Sorting methods using ORDER BY clause in SQL * Operators available in SQL * Precedence of Operators * Various SQL Functions - Character - Number - Date Conversion -Aggregate - General Functions * GROUP BY and HAVING clauses of SQL * Set operators - UNION - UNION ALL - INTERSECT - MINUS * Oracle Joins - Equijoin - Non-equijoin - Self-join -Natural join -Cross join - Outer join - Left Outer - Right Outer -Full outer - Inner join - Using clause - On clause * All subqueries - Subqueries on multiple columns (Pairwise Comparision) - Subqueries in the FROM clause - Correlated SUB Query - Scalar Subqueries * Top N analysis * WITH clause introduction * EXISTS and NOT EXISTS operators * Global Temporary Tables * ANALYTICAL FUNCTION : - RANK - DENSE_RANK, - FIRST - LAST - LAG - LEAD - LISTAGG - ROLLUP - CUBE - grouping_id - Rowid vs RowNum * Views - Let's modify an existing view - Create View from more than 1 Table * Materialised view - Build - Refresh Mode - Materialized view log * High water mark PL/SQL * Introduction – PL/SQL Architecture * Declaring Variables PLSQL block * Writing Executable Statements * Interacting with Oracle Server * Writing Control Structures * Comments in PLSQL * Variable Scope * Using GOTO * Using the CASE Statement * Using the If-Then-Else * Using the If-Then-Else * Working with LOOPS * Continue Statement * Working with Composite Data Types Cursor * Cursors Implicit * Understanding the Concept and Purpose of Explicit Cursors * Learn about Cursor Attributes * Creating and Using Cursor Parameters * Cursors with Records * Looping with Cursors Exceptions * Difference between Global vs Local Objects and Exceptions * Handling Exceptions * What Are the Types of Exceptions * Creating User-Defined Exceptions * Using SQLCODE and SQLERRM Objects Procedures & Functions * Creating Procedures * Input and Output of procedures * Understanding the Parameter Specification * Standalone procedures * Creating Functions * Managing Subprograms * Overloading the Subprograms * What are Functions & Procedures and Why We Use Creating Packages * Creating & Using & Modifying & Removing the Packages * Visibility of Package Objects * Illegal Object Reference & Forward Declaration * Package Initialization * How Can I Find the Packages? Triggers * Creating Database Triggers * Types of triggers * Statement & Row Level Triggers * Using New & Old Qualifiers in Triggers * Using RAISE_APPLICATION_ERROR Procedure in Triggers * Using WHEN Clause in Triggers * INSTEAD OF Triggers * Exploring & Managing the Triggers * Compound Triggers * Handling Mutating Table Errors Advance PL/SQL What is SQL Tuning and Why to Do That? * How an SQL Statement is Processed * What is "cost" in detail * Plan Generator * Execution Plan and Explain Plan in Details * V$SQL_PLAN View Indexes * Table Access Full * Table Access by ROWID * Index Unique Scan Oracle Database Architecture * PGA * SGA * Shared Pool * Buffer Cache * Redo Log Buffer Tuning : * Collection * Introduction to BULK COLLECT feature * Implementation of BULK COLLECT in PLSQL program * FOR ALL loop with BULK COLLECT * Dynamic SQL * Partitioning * Ref Cursors * Understanding of PLSQL Tables * Arrays * Nested Tables * Associative arrays * Some part of tuning * Bind variable * Function based index * Some part of Hints About Me: Having 9 + Years of experience in MNC IT company I am working as Team Lead - Oracle Project. I am providing training for Oracle, SQL, PL/SQL, Advanced PL/SQL, And Unix Shell. I am providing classroom training as well as On-line training. There are a lot of assignments which will you understand database flow and work in the Software industry.

PL/SQL Classes 5.0

Excellence Award Winner 2016

Best PL/SQL Classes Teacher in Pune

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in PL/SQL Classes

9

Teaching Experience in detail in PL/SQL Classes

Oracle syllabus SQL Contents * Oracle History * Oracle Architecture - SGA - PGA * The detailed overview of SQL * Different types of SQL - DDL - DML - TCL - DCL * SQL commands for different types of SQL * Practical Implementation of each command * Row filtration using WHERE clause in SQL * Data Types available in SQL * Sorting methods using ORDER BY clause in SQL * Operators available in SQL * Precedence of Operators * Various SQL Functions - Character - Number - Date Conversion -Aggregate - General Functions * GROUP BY and HAVING clauses of SQL * Set operators - UNION - UNION ALL - INTERSECT - MINUS * Oracle Joins - Equijoin - Non-equijoin - Self-join -Natural join -Cross join - Outer join - Left Outer - Right Outer -Full outer - Inner join - Using clause - On clause * All subqueries - Subqueries on multiple columns (Pairwise Comparision) - Subqueries in the FROM clause - Correlated SUB Query - Scalar Subqueries * Top N analysis * WITH clause introduction * EXISTS and NOT EXISTS operators * Global Temporary Tables * ANALYTICAL FUNCTION : - RANK - DENSE_RANK, - FIRST - LAST - LAG - LEAD - LISTAGG - ROLLUP - CUBE - grouping_id - Rowid vs RowNum * Views - Let's modify an existing view - Create View from more than 1 Table * Materialised view - Build - Refresh Mode - Materialized view log * High water mark PL/SQL * Introduction – PL/SQL Architecture * Declaring Variables PLSQL block * Writing Executable Statements * Interacting with Oracle Server * Writing Control Structures * Comments in PLSQL * Variable Scope * Using GOTO * Using the CASE Statement * Using the If-Then-Else * Using the If-Then-Else * Working with LOOPS * Continue Statement * Working with Composite Data Types Cursor * Cursors Implicit * Understanding the Concept and Purpose of Explicit Cursors * Learn about Cursor Attributes * Creating and Using Cursor Parameters * Cursors with Records * Looping with Cursors Exceptions * Difference between Global vs Local Objects and Exceptions * Handling Exceptions * What Are the Types of Exceptions * Creating User-Defined Exceptions * Using SQLCODE and SQLERRM Objects Procedures & Functions * Creating Procedures * Input and Output of procedures * Understanding the Parameter Specification * Standalone procedures * Creating Functions * Managing Subprograms * Overloading the Subprograms * What are Functions & Procedures and Why We Use Creating Packages * Creating & Using & Modifying & Removing the Packages * Visibility of Package Objects * Illegal Object Reference & Forward Declaration * Package Initialization * How Can I Find the Packages? Triggers * Creating Database Triggers * Types of triggers * Statement & Row Level Triggers * Using New & Old Qualifiers in Triggers * Using RAISE_APPLICATION_ERROR Procedure in Triggers * Using WHEN Clause in Triggers * INSTEAD OF Triggers * Exploring & Managing the Triggers * Compound Triggers * Handling Mutating Table Errors Advance PL/SQL What is SQL Tuning and Why to Do That? * How an SQL Statement is Processed * What is "cost" in detail * Plan Generator * Execution Plan and Explain Plan in Details * V$SQL_PLAN View Indexes * Table Access Full * Table Access by ROWID * Index Unique Scan Oracle Database Architecture * PGA * SGA * Shared Pool * Buffer Cache * Redo Log Buffer Tuning : * Collection * Introduction to BULK COLLECT feature * Implementation of BULK COLLECT in PLSQL program * FOR ALL loop with BULK COLLECT * Dynamic SQL * Partitioning * Ref Cursors * Understanding of PLSQL Tables * Arrays * Nested Tables * Associative arrays * Some part of tuning * Bind variable * Function based index * Some part of Hints About Me: Having 9 + Years of experience in MNC IT company I am working as Team Lead - Oracle Project. I am providing training for Oracle, SQL, PL/SQL, Advanced PL/SQL, And Unix Shell. I am providing classroom training as well as On-line training. There are a lot of assignments which will you understand database flow and work in the Software industry.

SQL Programming Training 5.0

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in SQL Programming Training

9

Teaching Experience in detail in SQL Programming Training

Oracle syllabus SQL Contents * Oracle History * Oracle Architecture - SGA - PGA * The detailed overview of SQL * Different types of SQL - DDL - DML - TCL - DCL * SQL commands for different types of SQL * Practical Implementation of each command * Row filtration using WHERE clause in SQL * Data Types available in SQL * Sorting methods using ORDER BY clause in SQL * Operators available in SQL * Precedence of Operators * Various SQL Functions - Character - Number - Date Conversion -Aggregate - General Functions * GROUP BY and HAVING clauses of SQL * Set operators - UNION - UNION ALL - INTERSECT - MINUS * Oracle Joins - Equijoin - Non-equijoin - Self-join -Natural join -Cross join - Outer join - Left Outer - Right Outer -Full outer - Inner join - Using clause - On clause * All subqueries - Subqueries on multiple columns (Pairwise Comparision) - Subqueries in the FROM clause - Correlated SUB Query - Scalar Subqueries * Top N analysis * WITH clause introduction * EXISTS and NOT EXISTS operators * Global Temporary Tables * ANALYTICAL FUNCTION : - RANK - DENSE_RANK, - FIRST - LAST - LAG - LEAD - LISTAGG - ROLLUP - CUBE - grouping_id - Rowid vs RowNum * Views - Let's modify an existing view - Create View from more than 1 Table * Materialised view - Build - Refresh Mode - Materialized view log * High water mark PL/SQL * Introduction – PL/SQL Architecture * Declaring Variables PLSQL block * Writing Executable Statements * Interacting with Oracle Server * Writing Control Structures * Comments in PLSQL * Variable Scope * Using GOTO * Using the CASE Statement * Using the If-Then-Else * Using the If-Then-Else * Working with LOOPS * Continue Statement * Working with Composite Data Types Cursor * Cursors Implicit * Understanding the Concept and Purpose of Explicit Cursors * Learn about Cursor Attributes * Creating and Using Cursor Parameters * Cursors with Records * Looping with Cursors Exceptions * Difference between Global vs Local Objects and Exceptions * Handling Exceptions * What Are the Types of Exceptions * Creating User-Defined Exceptions * Using SQLCODE and SQLERRM Objects Procedures & Functions * Creating Procedures * Input and Output of procedures * Understanding the Parameter Specification * Standalone procedures * Creating Functions * Managing Subprograms * Overloading the Subprograms * What are Functions & Procedures and Why We Use Creating Packages * Creating & Using & Modifying & Removing the Packages * Visibility of Package Objects * Illegal Object Reference & Forward Declaration * Package Initialization * How Can I Find the Packages? Triggers * Creating Database Triggers * Types of triggers * Statement & Row Level Triggers * Using New & Old Qualifiers in Triggers * Using RAISE_APPLICATION_ERROR Procedure in Triggers * Using WHEN Clause in Triggers * INSTEAD OF Triggers * Exploring & Managing the Triggers * Compound Triggers * Handling Mutating Table Errors Advance PL/SQL What is SQL Tuning and Why to Do That? * How an SQL Statement is Processed * What is "cost" in detail * Plan Generator * Execution Plan and Explain Plan in Details * V$SQL_PLAN View Indexes * Table Access Full * Table Access by ROWID * Index Unique Scan Oracle Database Architecture * PGA * SGA * Shared Pool * Buffer Cache * Redo Log Buffer Tuning : * Collection * Introduction to BULK COLLECT feature * Implementation of BULK COLLECT in PLSQL program * FOR ALL loop with BULK COLLECT * Dynamic SQL * Partitioning * Ref Cursors * Understanding of PLSQL Tables * Arrays * Nested Tables * Associative arrays * Some part of tuning * Bind variable * Function based index * Some part of Hints About Me: Having 9 + Years of experience in MNC IT company I am working as Team Lead - Oracle Project. I am providing training for Oracle, SQL, PL/SQL, Advanced PL/SQL, And Unix Shell. I am providing classroom training as well as On-line training. There are a lot of assignments which will you understand database flow and work in the Software industry.

Database Training classes 5.0

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Database Training classes

9

Teaching Experience in detail in Database Training classes

Oracle syllabus SQL Contents * Oracle History * Oracle Architecture - SGA - PGA * The detailed overview of SQL * Different types of SQL - DDL - DML - TCL - DCL * SQL commands for different types of SQL * Practical Implementation of each command * Row filtration using WHERE clause in SQL * Data Types available in SQL * Sorting methods using ORDER BY clause in SQL * Operators available in SQL * Precedence of Operators * Various SQL Functions - Character - Number - Date Conversion -Aggregate - General Functions * GROUP BY and HAVING clauses of SQL * Set operators - UNION - UNION ALL - INTERSECT - MINUS * Oracle Joins - Equijoin - Non-equijoin - Self-join -Natural join -Cross join - Outer join - Left Outer - Right Outer -Full outer - Inner join - Using clause - On clause * All subqueries - Subqueries on multiple columns (Pairwise Comparision) - Subqueries in the FROM clause - Correlated SUB Query - Scalar Subqueries * Top N analysis * WITH clause introduction * EXISTS and NOT EXISTS operators * Global Temporary Tables * ANALYTICAL FUNCTION : - RANK - DENSE_RANK, - FIRST - LAST - LAG - LEAD - LISTAGG - ROLLUP - CUBE - grouping_id - Rowid vs RowNum * Views - Let's modify an existing view - Create View from more than 1 Table * Materialised view - Build - Refresh Mode - Materialized view log * High watermark PL/SQL * Introduction – PL/SQL Architecture * Declaring Variables PLSQL block * Writing Executable Statements * Interacting with Oracle Server * Writing Control Structures * Comments in PLSQL * Variable Scope * Using GOTO * Using the CASE Statement * Using the If-Then-Else * Using the If-Then-Else * Working with LOOPS * Continue Statement * Working with Composite Data Types Cursor * Cursors Implicit * Understanding the Concept and Purpose of Explicit Cursors * Learn about Cursor Attributes * Creating and Using Cursor Parameters * Cursors with Records * Looping with Cursors Exceptions * Difference between Global vs Local Objects and Exceptions * Handling Exceptions * What Are the Types of Exceptions * Creating User-Defined Exceptions * Using SQLCODE and SQLERRM Objects Procedures & Functions * Creating Procedures * Input and Output of procedures * Understanding the Parameter Specification * Standalone procedures * Creating Functions * Managing Subprograms * Overloading the Subprograms * What are Functions & Procedures and Why We Use Creating Packages * Creating & Using & Modifying & Removing the Packages * Visibility of Package Objects * Illegal Object Reference & Forward Declaration * Package Initialization * How Can I Find the Packages? Triggers * Creating Database Triggers * Types of triggers * Statement & Row Level Triggers * Using New & Old Qualifiers in Triggers * Using RAISE_APPLICATION_ERROR Procedure in Triggers * Using WHEN Clause in Triggers * INSTEAD OF Triggers * Exploring & Managing the Triggers * Compound Triggers * Handling Mutating Table Errors Advanced PL/SQL What is SQL Tuning and Why to Do That? * How an SQL Statement is Processed * What is "cost" in detail * Plan Generator * Execution Plan and Explain Plan in Details * V$SQL_PLAN View Indexes * Table Access Full * Table Access by ROWID * Index Unique Scan Oracle Database Architecture * PGA * SGA * Shared Pool * Buffer Cache * Redo Log Buffer Tuning : * Collection * Introduction to BULK COLLECT feature * Implementation of BULK COLLECT in PLSQL program * FOR ALL loop with BULK COLLECT * Dynamic SQL * Partitioning * Ref Cursors * Understanding of PLSQL Tables * Arrays * Nested Tables * Associative arrays * Some part of tuning * Bind variable * Function based index * Some part of Hints Having 9 + Years of experience in MNC IT company I am working as Team Lead - Oracle Project. I am providing training for Oracle, SQL, PL/SQL, Advanced PL/SQL, And Unix Shell. I am providing classroom training as well as On-line training. It's one to one training. There are a lot of assignments, which will Stausent understand database flow and work in the Software industry. My aim is not only to provide training but also to help a student in a real-time scenario project.

Oracle DBA OCP Training 5.0

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Oracle DBA OCP Training

9

Teaching Experience in detail in Oracle DBA OCP Training

Oracle syllabus SQL Contents * Oracle History * Oracle Architecture - SGA - PGA * The detailed overview of SQL * Different types of SQL - DDL - DML - TCL - DCL * SQL commands for different types of SQL * Practical Implementation of each command * Row filtration using WHERE clause in SQL * Data Types available in SQL * Sorting methods using ORDER BY clause in SQL * Operators available in SQL * Precedence of Operators * Various SQL Functions - Character - Number - Date Conversion -Aggregate - General Functions * GROUP BY and HAVING clauses of SQL * Set operators - UNION - UNION ALL - INTERSECT - MINUS * Oracle Joins - Equijoin - Non-equijoin - Self-join -Natural join -Cross join - Outer join - Left Outer - Right Outer -Full outer - Inner join - Using clause - On clause * All subqueries - Subqueries on multiple columns (Pairwise Comparision) - Subqueries in the FROM clause - Correlated SUB Query - Scalar Subqueries * Top N analysis * WITH clause introduction * EXISTS and NOT EXISTS operators * Global Temporary Tables * ANALYTICAL FUNCTION : - RANK - DENSE_RANK, - FIRST - LAST - LAG - LEAD - LISTAGG - ROLLUP - CUBE - grouping_id - Rowid vs RowNum * Views - Let's modify an existing view - Create View from more than 1 Table * Materialised view - Build - Refresh Mode - Materialized view log * High water mark PL/SQL * Introduction – PL/SQL Architecture * Declaring Variables PLSQL block * Writing Executable Statements * Interacting with Oracle Server * Writing Control Structures * Comments in PLSQL * Variable Scope * Using GOTO * Using the CASE Statement * Using the If-Then-Else * Using the If-Then-Else * Working with LOOPS * Continue Statement * Working with Composite Data Types Cursor * Cursors Implicit * Understanding the Concept and Purpose of Explicit Cursors * Learn about Cursor Attributes * Creating and Using Cursor Parameters * Cursors with Records * Looping with Cursors Exceptions * Difference between Global vs Local Objects and Exceptions * Handling Exceptions * What Are the Types of Exceptions * Creating User-Defined Exceptions * Using SQLCODE and SQLERRM Objects Procedures & Functions * Creating Procedures * Input and Output of procedures * Understanding the Parameter Specification * Standalone procedures * Creating Functions * Managing Subprograms * Overloading the Subprograms * What are Functions & Procedures and Why We Use Creating Packages * Creating & Using & Modifying & Removing the Packages * Visibility of Package Objects * Illegal Object Reference & Forward Declaration * Package Initialization * How Can I Find the Packages? Triggers * Creating Database Triggers * Types of triggers * Statement & Row Level Triggers * Using New & Old Qualifiers in Triggers * Using RAISE_APPLICATION_ERROR Procedure in Triggers * Using WHEN Clause in Triggers * INSTEAD OF Triggers * Exploring & Managing the Triggers * Compound Triggers * Handling Mutating Table Errors Advance PL/SQL What is SQL Tuning and Why to Do That? * How an SQL Statement is Processed * What is "cost" in detail * Plan Generator * Execution Plan and Explain Plan in Details * V$SQL_PLAN View Indexes * Table Access Full * Table Access by ROWID * Index Unique Scan Oracle Database Architecture * PGA * SGA * Shared Pool * Buffer Cache * Redo Log Buffer Tuning : * Collection * Introduction to BULK COLLECT feature * Implementation of BULK COLLECT in PLSQL program * FOR ALL loop with BULK COLLECT * Dynamic SQL * Partitioning * Ref Cursors * Understanding of PLSQL Tables * Arrays * Nested Tables * Associative arrays * Some part of tuning * Bind variable * Function based index * Some part of Hints About Me: Having 9 + Years of experience in MNC IT company I am working as Team Lead - Oracle Project. I am providing training for Oracle, SQL, PL/SQL, Advanced PL/SQL, And Unix Shell. I am providing classroom training as well as On-line training. There are a lot of assignments which will you understand database flow and work in the Software industry.

RDBMS Training 5.0

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in RDBMS Training

9

Tableau Training 5.0

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Tableau Training

4

Teaching Experience in detail in Tableau Training

good

Answers by Deepak (35)

Answered on 31/07/2017 IT Courses/SQL Programming

Can I change the SQL server to big data?

yes
Answers 1 Comments
Dislike Bookmark

Answered on 31/07/2017 IT Courses/SQL Programming

How can an Excel user use SQL in his work for his present company?

to export and import data
Answers 1 Comments
Dislike Bookmark

Answered on 31/07/2017 IT Courses/SQL Programming

How can I get a job in MS SQL as a fresher?

as fresher you never not to know which technology you will get job. it s on company requirement .
Answers 1 Comments
Dislike Bookmark

Answered on 19/10/2016 IT Courses/Oracle Training/Oracle Database IT Courses

Oak Ridge Automatic Computer and Logical Engine .....
Answers 20 Comments
Dislike Bookmark

Contact

Load More

Deepak describes himself as Oracle Database Trainer. He conducts classes in Database Training, Oracle Certification and Oracle DBA OCP. Deepak is located in Chinchwad, Pune. Deepak takes at students Home, Regular Classes- at his Home and Online Classes- via online medium. He has 9 years of teaching experience . Deepak has completed Bachelor of Engineering (B.E.) from Pune. He is well versed in Hindi, English and Marathi. Deepak has got 65 reviews till now with 100% positive feedback.

X
X

Post your Learning Need

Let us shortlist and give the best tutors and institutes.

or

Send Enquiry to Deepak

Let Deepak know you are interested in their class

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more