 Название: Mastering PL/SQL Through Illustrations: From Learning Fundamentals to Developing Efficient PL/SQL Blocks
Автор: B. Chandra
Издательство: BPB Publications
Год: 2021
Страниц: 262
Язык: английский
Формат: pdf
Размер: 10.3 MB
Mastering PL/SQL using various database tables.
PL/SQL stands for Procedural Language extensions to the Structured Query Language (SQL). PL/SQL can be easily integrated with SQL which is the most popular database language. PL/SQL adds procedural constructs to SQL for overcoming the limitations of SQL and is completely portable. PL/SQL is now a technology present in most Oracle servers and products.
The book extensively covers both the fundamentals and advanced topics in PL/SQL which makes it a unique read both for beginners and developers/database administrators who want to master PL/SQL. The best part of the book is that it contains practical examples for every concept in PL/SQL. Illustrative PL/SQL blocks using database tables have also been provided in the book.
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. 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.
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.
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
Скачать Mastering PL/SQL Through Illustrations: From Learning Fundamentals to Developing Efficient PL/SQL Blocks
|
Навигация
Вход на сайт
Реклама
Mastering PL/SQL Through Illustrations: From Learning Fundamentals to Developing Efficient PL/SQL Blocks 
