Writing Anonymous Blocks
TYPE and ROWTYPE declarations
Implicit and Explicit Cursors
Cursor Manipulation statements
OPEN FETCH CLOSE EXIT WHEN
Creating and Calling Procedures
Creating and Calling Functions
Format of standard packages in an application
Spec and Body
NOCOPY hint theory
CALLing procedures from triggers
Problem Statement: How to manipulate data using DML transactions?
Description: Use PL SQL to implement DML transactions on a database. Through this project, you’ll learn about data manipulation language (DML) and triggers used while executing operations. You’ll work with various DML operations like Insert, update, delete, and select which when fired on a table or view.
Problem statement: How to use Oracle PL SQL to prepare detailed patients health report based on disparate datasets?
Description: Create tables and columns based on various entities and learn to write SQL queries for data extraction. Also, you’ll prepare patient’s health-related detailed reports, medications taken based on adverse conditions, and more.
After completion of this course, you'll gain knowledge on all the major core concepts, and they are listed below:
There are no prerequisites for learning this course. However, some fundamental knowledge of DBMS will be beneficial.
The skills that the candidate will learn after completion of this training course are as follows:
18 Sep, 2020 - 18 Oct, 2020
30 Sep, 2020 - 15 Oct, 2020
03 Oct, 2020 - 07 Nov, 2020
04 Oct, 2020 - 03 Nov, 2020
07 Oct, 2020 - 22 Oct, 2020
10 Oct, 2020 - 14 Nov, 2020
Our Oracle PL SQL course covers all the topics that are required to clear Oracle PL SQL certification. Trainer will share Oracle PL SQL certification guide, Oracle PL SQL certification sample questions, Oracle PL SQL certification practice questions.
Trusted By Companies Worldwide & 4,10,350+ Learners
Yes, you get two kinds of discounts. They are group discount and referral discount. Group discount is offered when you join as a group, and referral discount is offered when you are referred from someone who has already enrolled in our training.
The trainer will give Server Access to the course seekers, and we make sure you acquire practical hands-on training by providing you with every utility that is needed for your understanding of the course.
The trainer is a certified consultant and has significant amount of experience in working with the technology.
Yes, we accept payments in two installments.
If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.
User Reviews on popular courses
Very good learning Experience with Mindmajix. I learned Oracle PL/SQL Online Training. It contains well structured PL/SQL content help me to get vast knowledge. Thanks to the mindmajix for their 24*7 support and Expert trainers.
I am so happy towards Learning Oracle PL SQL training at MindMajix. It's very well organized and explained every question which I asked without any hesitation. Many Thanks for the Training Team for their 24*7 support and Expert trainers
I am especially happy to see the kind of in-depth coverage and the comprehensive nature of the Oracle PL/SQL crash course. Thanks to the Mindmajix for their quality training to master in Oracle PL/SQL. Go with Mindmajix for better training.
I took Oracle PL/SQL online classes with Mindmajix. The course content was excellent, and the trainer was highly professional. I heartily thank Mindmajix for helping me to make my career.
I took .NET training from Mindmajix. I must say the course content was highly qualitative and the trainer covered all concepts. Overall it was a good experience with Mindmajix.
Thank You for the sessions that helped me gaining knowledge in Spotfire training. Trainer's experience helped me to get the detailed information regarding the key concepts and challenging tasks in real-time. Thanks once again.
Perfect sessions to know all the key concepts of Spotfire certification training. Thanks to the support team as well. Thanks to Mindmajix.