Mastering PL/SQL Through Illustrations

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.

Tagline

Mastering PL/SQL using various database tables

Key Features

• 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.

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.

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

Dr. B. Chandra is an Adjunct Professor at the School of IT, Indian Institute of Technology, Delhi from Jan 2017. She served the computer Science Group of the Department of Maths, IIT Delhi as a senior professor from 1979 till June 2016. During her tenure she was the Head of the Department for three years and was deeply involved in the curriculum of M.Tech program in Maths and Computing. She was the chief data scientist at Sprinklr Solns for more than a year from August 2016. and subsequent to this till recently as a consultant in Machine Learning at Netomi. Her specialization areas include Databases, Distributed databases and Machine Learning. She has immense experience in teaching Database Management course at IIT Delhi apart from teaching other courses in computer science for more than 25 years for a large number of students. The topics covered in the database course included SQL, PL/SQL, Distributed databases apart and basics of databases. She has guided a number of PhD students in these areas at IIT Delhi. She has published more than 100 research papers in reputed International journals in the areas mentioned above. She has authored three books. She is a senior member of IEEE Computer society.

She has been a Visiting Professor for a year with the Graduate School of Business, University of Pittsburgh, Pittsburgh, USA and for a year at Penn State University, University Park, USA. She has also been a Visiting Scientist at NIST, Maryland and INRIA, France.

Your LinkedIn Profile: https://www.linkedin.com/in/dr-b-chandra-192523141/