very good
PL/SQL Mastery Course
Master PL/SQL and become a database expert.
Teaching & Academics,Online Education,PL/SQL
Lectures -78
Duration -9 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
No application in the modern era is possible without utilizing databases. Experts in databases are in greater demand everywhere in the world. And this course aims to close that gap. The purpose of this PL/SQL course is to better prepare learners for their academic and professional endeavors.
PL/SQL Course Overview
You will learn to use PL/SQL statements to build business logic using Cursors, Procedures, Functions, and Triggers in this course. To make learning engaging and interesting, several examples are used to illustrate each of these principles.
The course's key merit is that it clearly explains each concept using real-world examples. It is designed for beginners and will help them advance from being a PL/SQL novice to an expert. Learners will master PL/SQL in this course using Oracle, the most popular database software worldwide.
Goals
Prepare for DBMS.
Learn the basics of PL/SQL, from its syntax and concepts to its advanced features.
Develop skills needed to use PL/SQL to build business logic, such as using cursors, procedures, functions, and triggers.
Prepare for a career in database development or other related fields.
Prerequisites
Basic understanding of SQL.
![PL/SQL Mastery Course PL/SQL Mastery Course](https://d3mxt5v3yxgcsr.cloudfront.net/courses/3696/course_3696_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Basics of PL/SQL
6 Lectures
-
PL/SQL Introduction 07:29 07:29
-
Architecture of PL/SQL 03:27 03:27
-
PL/SQL Language Elements 05:26 05:26
-
Structure of PL/SQL Block 02:54 02:54
-
Demonstartion of Live SQL (Software used for execution of code) 04:03 04:03
-
Reading Material for Section-1
Section2:
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Conditional, Looping and Sequential Statements.
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Exception Handling
12 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Cursor Handling
14 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Sub Programs
15 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Trigger
16 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Dr. Parteek Bhatia](https://www.tutorialspoint.com/assets/profiles/260109/profile/200_214668-1604765555.jpg)
Dr. Parteek Bhatia
Parteek Bhatia is a Professor in the Department of Computer Science and Engineering and Former Associate Dean of Student Affairs at Thapar Institute of Engineering and Technology, Patiala. Currently acting as Visiting Professor at the Department of Computer Science, Whitman College, Walla Walla, WA, USA. He is the recipient of the Young Faculty Research Fellowship from the Ministry of Electronics & Information Technology, Govt. of India.
He is a Postdoctorate from Tel Aviv University, Israel, and a former Visting Professor at LAMBDA Lab, Tel Aviv University, Israel.
He has earned his BTech from SLIET and MS from BITS Pilani. He is a doctorate in the field of NLP from Thapar University and a post-doctorate from Tel Aviv University, Israel.
He has published more than 100 research papers and articles in Journals, Conferences, and Magazines of repute. He is a winner of the Gold Medal at the International competition UNL Olympiad II, UNL Olympiad III, and UNL Olympiad IV conducted by the UNDL Foundation in the years 2013 and 2014.
He is a well-known author and published textbooks in Databases and Data Mining. His latest book, “Data Mining and Data Warehousing: Principles and Practical Techniques,” was Published by Cambridge University Press in 2019. He is the author of popular books like “Simplified Approach to DBMS”, “Simplified Approach to Visual Basic” and “Simplified Approach to Oracle,” and “NoSQL in a Day”.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Feedbacks
Thank you!
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)