Oracle Advanced PL/SQL Developer Professional Guide

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



Bookstore > Books > Oracle Advanced PL/SQL Developer Professional Guide

Oracle Advanced PL/SQL Developer Professional Guide

Free Download
Buy
Preview
Price$35.99 - $79.09
eBookFree
Rating
AuthorSaurabh K. Gupta
PublisherPackt Publishing
Published2012
Pages440
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101849687226
ISBN-139781849687225
EBook Hardcover Paperback

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.




5 5 74

Similar Books


Oracle PL/SQL Language Pocket Reference, 4th Edition

Oracle PL/SQL Language Pocket Reference, 4th Edition

by Steven Feuerstein, Bill Pribyl, Chip Dawes

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. A companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming, this concise guide boils down the most vital PL/SQL inf...

Price:  $5.98  |  Publisher:  O'Reilly Media  |  Release:  2007

Oracle PL/SQL Language Pocket Reference, 5th Edition

Oracle PL/SQL Language Pocket Reference, 5th Edition

by Steven Feuerstein, Bill Pribyl, Chip Dawes

Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c.Whether you're a developer or database administrator, when you need answers quickly, the Oracle PL/SQL La...

Price:  $12.49  |  Publisher:  O'Reilly Media  |  Release:  2015

Oracle PL/SQL Programming, 6th Edition

Oracle PL/SQL Programming, 6th Edition

by Steven Feuerstein, Bill Pribyl

Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle's powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1.Hundreds of thousands of PL/SQL developer...

Price:  $50.42  |  Publisher:  O'Reilly Media  |  Release:  2014

Professional Oracle 8i Application Programming with Java, PL/SQL and XML

Professional Oracle 8i Application Programming with Java, PL/SQL and XML

by Michael Awai

This book is for professional Oracle database programmers who need a comprehensive roadmap of the new programming possibilities with Oracle 8i. On the other hand, if you are already developing with Java and XML this book will show you how to exploit PL/SQL and the enterprise features of Oracle 8i in optimally distributing your n-tier appl...

Price:  $32.50  |  Publisher:  Wrox  |  Release:  2000

Learning Oracle PL/SQL

Learning Oracle PL/SQL

by Bill Pribyl, Steven Feuerstein

PL/SQL, Oracle's programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL, with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control - all clo...

Price:  $40.74  |  Publisher:  O'Reilly Media  |  Release:  2001

Oracle PL/SQL Recipes

Oracle PL/SQL Recipes

by Josh Juneau, Matt Arena

Oracle PL/SQL Recipes is your go to book for PL/SQL programming solutions. It takes a task-oriented approach to PL/SQL programming that lets you quickly look up a specific task and see the pattern for a solution. Then it's as simple as modifying the pattern for your specific application and implementing it. And you're done and h...

Price:  $39.36  |  Publisher:  Apress  |  Release:  2010

Beginning Oracle PL/SQL, 2nd Edition

Beginning Oracle PL/SQL, 2nd Edition

by Donald Bales

Beginning Oracle PL/SQL gets you started in using the built-in language that every Oracle developer and database administrator must know. Oracle Database is chock-full of built-in application features that are free for the using, and PL/SQL is your ticket to learning about and using those features from your own code. With it, you can cent...

Price:  $13.64  |  Publisher:  Apress  |  Release:  2015

Implementing Oracle API Platform Cloud Service

Implementing Oracle API Platform Cloud Service

by Andrew Bell, Sander Rensen, Luis Weir, Phil Wilkins

Implementing Oracle API Platform Cloud Service moves from theory to practice using the newest Oracle API management platform. This critical new platform for Oracle developers allows you to interface the complex array of services your clients expect in the modern world.First, you'll learn about Oracle's new platform and get an ov...

Price:  $49.99  |  Publisher:  Packt Publishing  |  Release:  2018