UrbanPro
true

Deepak

Oracle Database Trainer

Chinchwad, Pune, India - 411057

Verified Certified 103 Students

Contact
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.

Teaches

Oracle Training
24 Students

UrbanPro Certified Tutor

For 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 11g DBA, Oracle 10g DBA, Oracle Database 12c

Oracle Developer Certification Taught

Oracle Developer OCP, Oracle Developer OCA, Oracle Developer OCM

Oracle Products taught

Oracle Developer, Oracle Database, Oracle PL/SQL

Teaching Experience in detail in Oracle Training

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
14 Students

Excellence Award Winner 2016

PL/SQL

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
1 Student

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
2 Students

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

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

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

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

4.9 out of 5 66 reviews

Deepak https://p.urbanpro.com/tv-prod/member/photo/1707470-small.jpg Chinchwad
4.90566
Deepak
M

Oracle PL/SQL

"It was great experience to learn from Deepak sir he had taught with great enthusiasm also he had given various assignments which was very helpful to get my dream job. Thanks Deepak sir for mentoring me.😇 "

Deepak
M

Oracle PL/SQL

"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

PL/SQL

"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

PL/SQL

"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

PL/SQL

"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. "

Deepak
S

PL/SQL

"One of the best tutor for Oracle-PlSQL, He has got tremendous knowledge in oracle Technologies. The Best part is teaching with the Real - Time scenario's. One who is looking for Job change /Switch. Deepak Sir is best point of contact you can trust on. "

Reply by Deepak

Thank you Samar, And congratulation for new job ... all the best

Deepak
A

PL/SQL

"From the day 1 it was great experience. I was not confident earlier then he gave me proper coaching and helped me to excel myself in pl/sql domain. He assisted me to understand each and every topic indepth. Best tutor for the pl/sql. "

Deepak
M

PL/SQL

"Taught with real time example. Better understanding. Indepth knowledge an excellent teaching skills. Lucky to have tutor like him. "

Deepak
S

PL/SQL

"A very Good teacher. Get to know the Concepts in a very better way and Clear. Strongly recommend to attend pl/sql classes. "

Reply by Deepak

Thanks Sayali.. All the best

Deepak
M

PL/SQL

"Deepak Sir is an expert when it comes to SQL and PL/SQL. He uses simple example to real life examples when teaching PL SQL. I would definitely recommend the course. "

Deepak
P

Oracle Training

""Thanks Deepak sir for everything. He is very knowledgeable teacher I have ever come across. He understands each and every topic with best real time example and starts teaching from scratch for SQL and PLSQL topics. I recommend to all guys who are looking to join plsql course to join with Deepak sir. Satisfied with his teaching". "

Reply by Deepak

Congratulations for a new job... All the best

Deepak
S

PL/SQL

"I really learn a lot from Deepek Sir. Real time experience, examples and many more. Go for it, Deepak sir is excellent choice to learn SQL, PLSQL. "

Deepak
A

SQL Programming

"Deepak is a very talented and knowledgeable teacher I have ever come across. He understands the teaching level from where he should start and tries to explain the things with the best and easy examples. Thank you Deepak and if anyone interested to gain a good knowledge on batabase please get in touch with him. You will never regret your decision, that is for sure. "

Deepak
S

Oracle PL/SQL

"Thanks Sir For Everything. With your support I got Job As PL/SQL developer. He has very good knowledge on PL/SQL an other too. I seriously recommend to all guys who looking for PL/SQL coaching and also If want to crack interview an get to placed ASAP then go For this don't waste time in any Institute they don't teach you real time scenario. Urban Pro for giving me a wonderful platform to reach the professionals. I am extremely satisfied with Urban Pro portal. "

Deepak
R

Oracle Database

"I/P = Dedication + lot of assignments + Hard-work O/P = I have job with good knowledge. Really Thank you Sir for Every thing. Highly Recommended. "

Have you attended any class with Deepak?

Answers by Deepak (35)

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

yes
Answers 1 Comments
Dislike Bookmark

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

to export and import data
Answers 1 Comments
Dislike Bookmark

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

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 Learn IT Courses/Oracle Training/Oracle Database +1 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 DBA OCP and Oracle Training. Deepak is located in Chinchwad, Pune. Deepak takes 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 66 reviews till now with 100% positive feedback.

X

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.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

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