Mastering PL/SQL Through Illustrations
From Learning Fundamentals to Developing Efficient PL/SQL Blocks
About the Book
Mastering PL/SQL using various database tables
â— Creating PL/SQL blocks using database tables.
â— Cursors and Cursor For loops.
â— Functions and Procedures in PL/SQL.
â— Triggers and Packages.
â— Exceptions in PL/SQL.
â— Collections and its methods.
This book helps you to improve your employability and job market so that you can sprint towards a rewarding career in the area of databases. . You will learn PL/SQL starting from fundamentals to advanced level. The detailed description of Cursors will enable you to write professional codes using Cursors in PL/SQL. You will learn how to raise exceptions when errors are encountered, create Triggers before/after a DML operation, create Functions /Procedures and packages.. By the end of the book, you will be able to use collections and also write advanced PL/SQL blocks using database tables with ease.
What will you learn
â— Get an overview of Control Structures and Loops in PL/SQL.
â— Understand the working of Cursors and Cursor FOR LOOPS.
â— Learn how to create triggers, packages, functions and procedures in PL/SQL.
â— Learn how to handle errors by raising Exceptions.
â— Learn how to use Collections in PL/SQL.
Who this book is for
This book is for those who want to learn PL/SQL and its applications in depth. It is also best suited for professionals looking to pursue a career in the area of databases as a Database Administrator /Developer.
Table of Contents
1. Introduction to Pl/Sql
2. Pl/Sql Control Structures
3. Loops in Pl/Sql
4. Cursors in Pl/Sql
5. Exceptions in Pl/Sql
6. Procedures in Pl/Sql
7. Functions in Pl/Sql
8. Triggers in Pl/Sql
9. Packages in Pl/Sql
10. Pl/Sql Collections
BPB is Asia's largest publishers of Computer & IT books. For the last 63 years BPB has been a friend, philosopher and guide for programmers, developers, hardware technicians, IT Professionals who have made things happen in the IT World.
Our students work
with the Best
Master prominent technologies at full length and become a valued certified professional.Explore Now