Oracle Advanced PL/SQL Developer Professional Guide

Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination with this book and ebook

Oracle Advanced PL/SQL Developer Professional Guide

Saurabh K. Gupta

1 customer reviews
Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination with this book and ebook
Mapt Subscription
FREE
$0.00/m after trial
eBook
$10.00
RRP $35.99
Save 72%
Print + eBook
$59.99
RRP $59.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$59.99
$29.99 p/m after trial
RRP $35.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


Oracle Advanced PL/SQL Developer Professional Guide Book Cover
Oracle Advanced PL/SQL Developer Professional Guide
$ 35.99
$ 10.00
Instant Oracle Database and PowerShell How-to Book Cover
Instant Oracle Database and PowerShell How-to
$ 19.99
$ 10.00
Buy 2 for $20.00
Save $35.98
Add to Cart

Book Details

ISBN 139781849687225
Paperback440 pages

Book Description

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension language for SQL and the Oracle relational database. Server-side PL/SQL is stored and compiled in the Oracle Database and runs within the Oracle executable. With this guide Oracle developers can work towards accomplishing Oracle 11g Advanced PL/SQL Professional certification, which is the second milestone for developers working at the Associate level.

The Oracle Advanced PL/SQL Developer Professional Guide helps you master advanced PL/SQL concepts. Besides the clear and precise explanation on advanced topics, it also contains example code and demonstrations, which gives a sense of application and usage to readers.

The book gives a deep insight that will help transform readers from mid-level programmers to professional database developers. It aims to cover the advanced features of PL/SQL for designing and optimizing PL/SQL code.

This book starts with an overview of PL/SQL as the programming database language and outlines the benefits and characteristics of the language. The book then covers the advanced features that include PL/SQL code writing using collections, tuning recommendations using result caching, implementing VPD to enforce row level security, and much more. Apart from programming, the book also dives deep into the usage of the development tool SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection.

Table of Contents

What You Will Learn

  • Get to grips with using Advanced Interface Methods
  • Learn to implement VPD with Fine Grained Access Control
  • Make use of Collections and learn data caching techniques in PL/SQL programs
  • Protect PL/SQL code from injection attacks
  • Learn to use Result caching to tune PL/SQL code
  • Demonstrate tracing and profiling features in PL/SQL
  • Get started with SecureFiles for advanced storage options

Authors

Table of Contents

Book Details

ISBN 139781849687225
Paperback440 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

Instant Oracle Database and PowerShell How-to Book Cover
Instant Oracle Database and PowerShell How-to
$ 19.99
$ 10.00
Instant Pentaho Data Integration Kitchen Book Cover
Instant Pentaho Data Integration Kitchen
$ 19.99
$ 10.00
Designing Next Generation Web Projects with CSS3 Book Cover
Designing Next Generation Web Projects with CSS3
$ 26.99
$ 10.00
Oracle Data Guard 11gR2 Administration : Beginner's Guide  Book Cover
Oracle Data Guard 11gR2 Administration : Beginner's Guide
$ 35.99
$ 10.00
Oracle Enterprise Manager 12c Administration Cookbook Book Cover
Oracle Enterprise Manager 12c Administration Cookbook
$ 29.99
$ 10.00
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide Book Cover
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
$ 35.99
$ 10.00