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

By Saurabh K. Gupta


Advanced Oracle PL/SQL Developer's Guide - Second Edition - Saurabh K. Gupta
  • Title: Advanced Oracle PL/SQL Developer's Guide - Second Edition
  • By: Saurabh K. Gupta
  • Release Date: 2016-02-15
  • Genre: Databases

More by Saurabh K. Gupta : Advanced Oracle PL/SQL Developer's Guide - Second Edition


Related Books

Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c About This Book • Learn advanced application development features of Oracle Database 12c and prepare for the 1Z0-146 examination • Build robust and secure applications in Oracle PL/SQL using the best practices • Packed with feature demonstrations and illustrations that will help you learn and understand the enhanced capabilities of Oracle Database 12c Who This Book Is For This book is for Oracle developers responsible for database management. Readers are expected to have basic knowledge of Oracle Database and the fundamentals of PL/SQL programming. Certification aspirants can use this book to prepare for 1Z0-146 examination in order to be an Oracle Certified Professional in Advanced PL/SQL. 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 In Detail 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. Style and approach The book follows the structure of the Oracle Certification examination but doesn't restrict itself to the exam objectives. Advanced concepts have been explained in an easy-to-understand style, supported with feature demonstrations and case illustrations.


Search
Recent Posts
Blockchain For Dummies
The Definitive Guide to DAX
Big Data Analytics
Access 2010 All-in-One For Dummies
Microsoft Office Access 2007 All-in-One Desk Reference For Dummies
SQL All-in-One For Dummies
Access 2013 All-in-One For Dummies
FileMaker Pro Design and Scripting For Dummies
Microsoft Access 2010 In Depth
FileMaker 12 In Depth, 2/e
Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies
Oracle 11g For Dummies
FileMaker 12 Developers Reference: Functions, Scripts, Commands, and Grammars
SQL in 30 Pages
Access 2010 Bible
The Data Warehouse Toolkit
Data Warehousing For Dummies
Learning SQL
Crystal Reports 10 For Dummies
SysML Distilled
DAX Patterns 2015
MySQL 5 Essentials
SQL QuickStart Guide
Teradata 14 Certification Study Guide - Basics
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
Using Microsoft Access 2010, Enhanced Edition
The Data Warehouse Lifecycle Toolkit
Developing Analytic Talent
Crystal Reports 2008 For Dummies
Microsoft® Access® 2013 Step by Step
Statistics for Big Data For Dummies
High Performance MySQL
Take Control of Getting Started with DEVONthink 2, Third Edition
Access 2013 For Dummies
Learning MySQL
Pro Tableau
R for Everyone
Mastering Blockchain
Beginning Database Design Solutions
Blockchain: A Practical Guide to Developing Business, Law, and Technology Solutions
Agile Analytics: A Value-Driven Approach to Business Intelligence and Data Warehousing
Fundamentals of Deep Learning
Databases Demystified, 2nd Edition
The Data Warehouse ETL Toolkit
The Microsoft Data Warehouse Toolkit
FileMaker & You
Blockchain Basics
SQL Queries for Mere Mortals
Teradata 14 Certification Study Guide - SQL
Microsoft Office Access 2007 Forms, Reports, and Queries
Teach Yourself VISUALLY Access 2013
Data Mining
Marketing Analytics
Beginning Microsoft SQL Server 2012 Programming
FileMaker Pro 13 Absolute Beginner's Guide
Nmap 6: Network Exploration and Security Auditing Cookbook
Practical PostgreSQL
Oracle PL/SQL in 10 Minutes, Sams Teach Yourself
Microsoft Access 2013 Plain & Simple
Access 2013 Absolute Beginner's Guide
Data Mining For Dummies
Oracle Database 12c SQL
Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition
MASTER DATA MANAGEMENT AND DATA GOVERNANCE, 2/E
RabbitMQ in Action
Database Design for Mere Mortals®: A Hands-On Guide to Relational Database Design, 2/e
Pro SQL Server 2008 Service Broker
Crystal Reports XI Official Guide
아마존 웹 서비스를 다루는 기술
Professional Microsoft SQL Server 2014 Administration
Microsoft® Access® 2013 Inside Out
Professional Microsoft SQL Server 2012 Integration Services
Big Data MBA
가장 빨리 만나는 Docker
Microsoft® Access® 2010 Step by Step
Professional Microsoft SQL Server 2012 Reporting Services
Applied Predictive Analytics
Microsoft® Access® 2010 VBA Programming Inside Out
SharePoint 2010 Issue Tracking System Design, Create, and Manage
Oracle Database 11g & MySQL 5.6 Developer Handbook
The Data Model Resource Book
Big Data, Data Mining, and Machine Learning
Database Design and Relational Theory
Building Blockchain Projects
Tableau 9: The Official Guide (Enhanced Edition)
T-SQL Querying
Oracle SQL By Example, 4/e
Database MS Access 2016 Level 1
Professional Microsoft SQL Server 2014 Integration Services
Database MS Access 2016 Level 2
Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
Oracle Database 12c: Install, Configure & Maintain Like a Professional
Mastering PostgreSQL 10
Beginning Database Design
Learning PostgreSQL 10 - Second Edition
Text Analytics with Python
Rapid Development
The Data Model Resource Book, Volume 1
Microsoft SQL Server 2012 Unleashed
Scientific Database And Programming Examples Using Php,mysql,xml,matlab,python,perl