Oracle Advanced PL/SQL Developer Professional Guide
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.
Download free tutorial in PDF (440 pages) created by Saurabh K. Gupta .
| Pages | 440 |
|---|---|
| Size | |
| File type | |
| Downloads | 796 |
| Created | 2021-05-15 |
| License | Free |
| Author(s) | Saurabh K. Gupta |
Others related eBooks about Oracle Advanced PL/SQL Developer Professional Guide
-
MySQL – Create Database free PDF
Download free course MySQL – Create Database free PDF, pdf file on 3 pages by tutorialkart.com....
-
SQL in 21 days
This tutorial is for people who want to learn the fundamentals of Structured Query Language (SQL) , a complete training courses under 412 pages for download ....
-
Microsoft SQL Server Notes for Professionals
Download free course Microsoft SQL Server Notes for Professionals, pdf file on 285 pages by Stack Overflow Community....
-
SQL Server Concurrency
Download free course SQL Server Concurrency, pdf file on 181 pages by Kalen Delaney....
-
Guide Microsoft Access 2010
This document is a quick tutorial guide about Microsoft Access 2010 to learn how to store informations in an easily retrievable form....
-
Graph Databases For Beginners
Whether you're a business executive or a seasoned developer, something has led you on the ..., download free Graph Databases tutorial in PDF (46 pages) created by Bryce Merkl Sasaki ....
-
Graph Databases, 2nd Edition
Discover how graph databases can help you manage and query highly connected data. With thi..., download free Graph Databases tutorial in PDF (238 pages) created by ....
-
SQL Server Hardware
Download free course SQL Server Hardware, pdf file on 318 pages by Glen Berry....
-
MongoDB tutorial for professionals
Download free MongoDB tutorial course in PDF, training file in 23 chapters and 73 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
-
SQL Notes for Professionals
SQL is a standard language for storing, manipulating and retrieving data in relational databases....