Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Now days it is very common that you will be asked Oracle PLSQL and performance tunning questions at any Interviews for ETL developer or Database Developer or any other positions related to ETL jobs.
You can take this course weather you want to learn PLSQL quickly but practical way or you preparing for Interviews. This course covers all PLSQL topics along with examples using real time development tools like SQL Developer. I have created all these important topics very carefully and after several years of experience in Database field which will bring you lot of confidence.
This course mainly includes various questions asked during Interview for Oracle SQL and PL SQL related positions.
Each session explains the concept by providing explanation and examples.
Course includes all questions with explanation using real world practical examples.
Also it includes explanation for inbuilt Oracle supplied packages and the subprograms provided by them. You can get the good understanding of topics which are explained with number of examples.
Also Course includes some performance tuning concepts like EXPLAIN_PLAN, Oracle hints etc.
Topics Covered -
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction to course|
|Section 2: Important Questions with Answers|
Important Questions with Answers Part 1Preview
Important Questions with Answers Part 2
Important Questions with Answers Part 3
Important Questions with Answers Part 4
Important Questions with Answers Part 5
|Section 3: Q&A for Materialized View & Autonomous Transaction with Examples|
Autonomous Transaction SQL
|Section 4: Q&A for Cursors - REF Cursors - Bulk Operations|
Cursor Part 1
Cursor Part 2
Cursor Part 3
Cursor Part 4
|Section 5: Q&A on Triggers with Examples|
Trigger Part 1
Trigger Part 2
Trigger Part 3
|Section 6: DBMS_SQL - Important Oracle Supplied Package|
IMPORTANT - DBMS_SQL Part 1
IMPORTANT - DBMS_SQL Part 2
IMPORTANT - DBMS_SQL Part 3
|Section 7: Performance Tunning - MUST know for Interview|
EXPLAIN PLAN - Concepts with Examples
Oracle Hints - Mostly used in Real time Projects
|Section 8: Q&A on Oracle Supplied Packages - Most IMPORTANT|
IMPORTANT - DBMS_PIPE
For the past 20 years, I have been working as Sr. Software Developer/Data Architect/Project Manager for various starting and large companies in several different domains.
I am a life-long learner. I love learning new topics and techniques.
I like research. I spend hours each week researching and keeping up on the latest trends in all of the fields that I operate in.