Advanced Oracle PL/SQL Developer's Guide - Second Edition

Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c

Advanced Oracle PL/SQL Developer's Guide - Second Edition

Saurabh K. Gupta

10 customer reviews
Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c
Mapt Subscription
FREE
$30.00/m after trial
eBook
$33.60
RRP $47.99
Save 29%
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 subscription 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 subscription 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 subscription reader
$0.00
$33.60
$59.99
$29.99 p/m after trial
RRP $47.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


Advanced Oracle PL/SQL Developer's Guide - Second Edition Book Cover
Advanced Oracle PL/SQL Developer's Guide - Second Edition
$ 47.99
$ 33.60
Oracle Advanced PL/SQL Developer Professional Guide Book Cover
Oracle Advanced PL/SQL Developer Professional Guide
$ 35.99
$ 25.20
Buy 2 for $35.00
Save $48.98
Add to Cart

Book Details

ISBN 139781785284809
Paperback428 pages

Book Description

Oracle Database is one of the most popular databases and allows users to make efficient use of their resources and to enhance service levels while reducing the IT costs incurred. Oracle Database is sometimes compared with Microsoft SQL Server, however, Oracle Database clearly supersedes SQL server in terms of high availability and addressing planned and unplanned downtime. Oracle PL/SQL provides a rich platform for application developers to code and build scalable database applications and introduces multiple new features and enhancements to improve development experience.

Advanced Oracle PL/SQL Developer's Guide, Second Edition is a handy technical reference for seasoned professionals in the database development space. This book starts with a refresher of fundamental concepts of PL/SQL, such as anonymous block, subprograms, and exceptions, and prepares you for the upcoming advanced concepts. The next chapter introduces you to the new features of Oracle Database 12c, not limited to PL/SQL. In this chapter, you will understand some of the most talked about features such as Multitenant and Database In-Memory. Moving forward, each chapter introduces advanced concepts with the help of demonstrations, and provides you with the latest update from Oracle Database 12c context. This helps you to visualize the pre- and post-applications of a feature over the database releases. By the end of this book, you will have become an expert in PL/SQL programming and will be able to implement advanced concepts of PL/SQL for efficient management of Oracle Database.

Table of Contents

What You Will Learn

  • Learn and understand the key SQL and PL/SQL features of Oracle Database 12c
  • Understand the new Multitenant architecture and Database In-Memory option of Oracle Database 12c
  • Know more about the advanced concepts of the Oracle PL/SQL language such as external procedures, securing data using Virtual Private Database (VPD), SecureFiles, and PL/SQL code tracing and profiling
  • Implement Virtual Private Databases to prevent unauthorized data access
  • Trace, analyze, profile, and debug PL/SQL code while developing database applications
  • Integrate the new application development features of Oracle Database 12c with the current concepts
  • Discover techniques to analyze and maintain PL/SQL code
  • Get acquainted with the best practices of writing PL/SQL code and develop secure applications

Authors

Table of Contents

Book Details

ISBN 139781785284809
Paperback428 pages
Read More
From 10 reviews

Read More Reviews

Recommended for You

Oracle Advanced PL/SQL Developer Professional Guide Book Cover
Oracle Advanced PL/SQL Developer Professional Guide
$ 35.99
$ 25.20
Oracle Business Intelligence Enterprise Edition 12c - Second Edition Book Cover
Oracle Business Intelligence Enterprise Edition 12c - Second Edition
$ 51.99
$ 36.40
RESTful Java Web Services - Third Edition Book Cover
RESTful Java Web Services - Third Edition
$ 35.99
$ 25.20
Learning Spring Boot 2.0 - Second Edition Book Cover
Learning Spring Boot 2.0 - Second Edition
$ 35.99
$ 25.20
Mastering Java 9 Book Cover
Mastering Java 9
$ 35.99
$ 25.20
Implementing Oracle Integration Cloud Service Book Cover
Implementing Oracle Integration Cloud Service
$ 43.99
$ 30.80