Oracle PL/SQL Interview questions - Basic to Advanced

Focused View

Lokanath Giri

2:43:28

28 View

1. Overview

1. Course Content.mp4

05:43

2. PLSQL Basic

1. Introduction.mp4

22:00

2. Control Structurer and Loops.mp4

07:02

3. Cursors.mp4

10:11

4. Exception handling.mp4

14:59

5. Procedure and Function - Part I.mp4

09:52

6. Procedure and Function - Part II.mp4

09:52

7. Packages.mp4

08:29

8. Trigger - Part I.mp4

07:18

9. Trigger - Part II.mp4

15:11

3. PLSQL Advanced

1. Collections - Composite datatypes.mp4

05:21

2. Dynamic SQL.mp4

12:58

3. Object Dependencies.mp4

10:48

4. Bulk Collect.mp4

08:26

5. Table and Pipeline Function.mp4

06:15

6. Advanced Features of PLSQL in Oracle 21c.mp4

09:03

Description

150+ Interview Questions

What You'll Learn?

Basic questions on PL/SQL
Control Structurer and Loops
Cursors
Exception handling
Procedure and Function
Packages
Trigger
Collections - Composite datatypes
Dynamic SQL
Object Dependencies
Bulk Collect
Tuning PL/SQL code
Advanced features in new release - 21c

Who is this for?

Anyone preparing for PL/SQL interviews

What You Need to Know?

Should have basic knowledge on SQL

More details

Description
Are you a DBÂ developer, ETL Developer, QAÂ professionals, DBA - Database Administrator preparing PL/SQL interview. it is the comprehensive course, strategically crafted to prepare individuals for success in PL/SQL interviews. This course is meticulously designed to cover a spectrum of advanced PL/SQL concepts, ensuring participants are well-equipped to tackle challenging interview questions with confidence. From the foundational principles of PL/SQL, including variables, loops, and control structures, to more intricate topics such as exception handling, stored procedures, and triggers, participants will receive a thorough understanding of the intricacies of Oracle's powerful database programming language.
Our course goes beyond the basics by diving into advanced topics like optimization techniques, performance tuning, and best practices for efficient PL/SQL code. The curriculum is enriched with real-world scenarios and practical examples, offering hands-on experience that mirrors the challenges often encountered in PL/SQL interviews. Participants will engage in coding exercises and mock interview sessions, enabling them to sharpen their problem-solving skills and enhance their ability to articulate solutions to complex PL/SQL challenges.
This course is an invaluable resource for individuals seeking to not only deepen their technical expertise but also enhance their interview preparedness. Whether you are a seasoned developer aiming to refresh your skills or a job seeker looking to stand out in PL/SQL interviews, this course provides the necessary knowledge and practical insights to excel in the dynamic realm of database programming.

Trainer Credentials
Having 19+ years of experience in SQL and PL/SQL. An Oracle Certified Professions (OCP)
Oracle Technology Network (OTN) Points: 12,975 Level: Master

I have conducted more than 100+ Interviews.
Most importantly I myself attended 30+ interviews and kept the interview questions from different Interviewers.
That will be big boast to understand how different interviewer asked questions and what are the frequently asked questions.

Anyone DBÂ developer, ETL Developer, QAÂ professionals preparing PL/SQL interview.
There are around 150+ mostly asked questions from simple to expert level are discussed. It also includes 21c

I have kept related questions together so that one can easily memorize.

Category wise weightage
Basic and Advanced Topics = 60%
Coding Practice = 25%
Real life scenarios = 10%
Advanced features as part of new release = 5%

Covered PL/SQL topics from Basics to Advanced

Basic and Advanced Topics
Introduction
Control Structurer and Loops
Cursors
Exception handling
Procedure and Function
Packages
Trigger
Collections - Composite datatypes
Dynamic SQL
Object Dependencies
Bulk Collect
Tuning PL/SQL stored procedures
Table function and piping
Advanced feature of PL/SQL in Oracle 21c
Who this course is for:
Anyone preparing for PL/SQL interviews

User Reviews

Rating

average 0

Total votes0

Focused display

Pl/SQL

Lokanath Giri

Instructor's Courses

Lokanath is an OCP - Oracle Certified Professional having 19+ Years of hands-on experience as an Architect in wide spectrum of Oracle-Related technologies in development, maintenance and migration projects in client server (OLTP), data warehousing (OLAP). His expertise is basically on SQL, PLSQL, Data Modeling, Data quality, Data migration in Business Intelligence domain.He worked in companies like Bosch, Ocwen Financials, CMC and ITC Infotech.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.