PL/SQL Interview Questions with Examples

Oracle PL/SQL Interview preparation with Examples Complete Guide
3.6 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
200 students enrolled
Instructed by Kish Sat IT & Software / Other
$19
$20
5% off
Take This Course
  • Lectures 30
  • Length 4.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

Course Description

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 -

  • Basic Interview Questions: This will present 18 most frequently asked questions will answers and examples.
  • These questions covers most of the main topics in SQL and PLSQL.
  • DBMS_JOB: This presents the main subprograms provided by package DBMS_JOB with examples.
  • DBMS_RANDOM: This presents the main subprograms provided by package DBMS_RANDOM with examples.
  • DBMS_OUTPUT: This presents the main subprograms provided by package DBMS_RANDOM with examples.
  • UTL_FILE: This presents the main subprograms provided by package DBMS_RANDOM with examples.
  • DBMS_SQL: It will provide you with basic understanding of Dynamic SQL and describe some of the subprograms with examples.
  • DBMS_PIPE:
  • DBMS_UTILITY
  • DBMS_LOB
  • CURSORS: This details on the use of cursors, types with examples
  • BULK OPERATIONS: This is majorly an important topic if you are preparing for an interview. You may find detailed explanation with examples in tutorial.
  • MATERIALISED VIEWS
  • AUTONOMOUS TRANSACIONS: This is a good topic frequently asked during interviews. You can understand it well while going through tutorial
  • TRIGGERS: This details on the use of Trigger, its types with examples
  • Performance Tuning: Last but not least, we will cover -DBMS_PROFILER, EXPLAIN PLAN & ORACLE HINTS

What are the requirements?

  • Basics of PLSQL

What am I going to get from this course?

  • Better understand most important concepts
  • Answer most frequently asked Interview questions
  • You will able to explain using practical knowledge
  • Answer confidently with full hands on on each topic

What is the target audience?

  • Any one who is planning to get the basic overview of PLSQL
  • Any one who is in initial phase of learning PLSQL
  • Any one who is preparing for interview for ORACLE PLSQL

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to course
Introduction
Preview
04:02
Section 2: Important Questions with Answers
Important Questions with Answers Part 1
Preview
06:56
Important Questions with Answers Part 2
07:28
Important Questions with Answers Part 3
09:18
Important Questions with Answers Part 4
10:40
Important Questions with Answers Part 5
07:29
Section 3: Q&A for Materialized View & Autonomous Transaction with Examples
Autonomous Transaction
07:34
Autonomous Transaction SQL
Article
Materialized View
10:14
Section 4: Q&A for Cursors - REF Cursors - Bulk Operations
Cursor Part 1
06:41
Cursor Part 2
10:13
Cursor Part 3
11:45
Cursor Part 4
07:03
Bulk Operations
05:58
Section 5: Q&A on Triggers with Examples
Trigger Part 1
10:41
Trigger Part 2
11:29
Trigger Part 3
07:46
Section 6: DBMS_SQL - Important Oracle Supplied Package
IMPORTANT - DBMS_SQL Part 1
10:18
IMPORTANT - DBMS_SQL Part 2
11:40
IMPORTANT - DBMS_SQL Part 3
07:18
Section 7: Performance Tunning - MUST know for Interview
EXPLAIN PLAN - Concepts with Examples
11:40
Oracle Hints - Mostly used in Real time Projects
05:31
Section 8: Q&A on Oracle Supplied Packages - Most IMPORTANT
IMPORTANT - DBMS_PIPE
08:27
DBMS_UTILITY
11:00
DBMS_PROFILER
10:32
DBMS_LOB
12:34
DBMS_JOB
11:19
DBMS_RANDOM
07:39
DBMS_OUTPUT
11:38
UTL_FILE
10:08

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kish Sat, Senior Software Enginner/Data Architect/Project Manager

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.

Ready to start learning?
Take This Course