Oracle PL/SQL by Example, 5th Edition

Benjamin Rosenzweig

Elena Rakhimov

Oracle PL/SQL by Example, 5th Edition — View larger

If You're an Educator

If You're a Student

Overview

Description

This tutorial is an integrated learning solution that teaches all the Oracle PL/SQL skills students will need, hands-on, through real-world labs, extensive examples, exercises, and projects. Completely updated for Oracle 12c, it covers all the fundamentals, from PL/SQL syntax and program control through packages and optimization. Concepts are thoroughly explained, then illustrated via examples and interactive labs. At the end of each chapter there is a "Test Your Thinking" section made up of a series of projects designed to solidify all of the skills learned in the chapter.

New to This Edition

Expands on the material covered in the previous editions of the book--more examples as well as imore depth and complexity, especially the latter chapters which focus on the advanced features of PL/SQL.
Chapter 10--extended to cover error reporting available with PL/SQL. Its main focus will be on the UTL_CALLSTACK package that has been introduced in Oracle 12c.
Chapter 18 --expanded to cover a new Oracle 12c feature introduced specifically for the bulk operations, FETCH FIRST
Chapter 25 is a new chapter that focuses on the optimization of the PL/SQL code. While it does not contain any new features specific to 12c, all the features and techniques employ new features introduced in 11g. This chapter will demonstrate to the readers how to analyze PL/SQL code and determine potential performance bottlenecks
This edition will again use the "CTA Schema" set of tables as basis for the hands-on examples and exercises. This schema represents imaginary application system that tracks students, their enrollments and grades, and was formally used by the CTA (Computer Technology and Application) program at Columbia University. The schema is provided as a set of files that can be downloaded into the reader's database so that he/she may be able to participate in the book examples.

Order

Pearson offers affordable and accessible purchase options to meet the needs of your students. Connect with us to learn more.

K12 Educators: Contact your Savvas Learning Company Account General Manager for purchase options. Instant Access ISBNs are for individuals purchasing with credit cards or PayPal.
Savvas Learning Company is a trademark of Savvas Learning Company LLC.

Digital

book cover — Oracle PL/SQL by Example, 5th Edition

Rosenzweig & Rakhimov

©2015 | Pearson

Format	ePub
ISBN-13:	9780133798531
Online purchase price	$47.99	Students, buy or rent this eText
Availability	Live

Paper

Format	Paper
ISBN-13:	9780133796780
Suggested retail price	$59.99
Availability	This item is currently unavailable for purchase on our websites. Instructors, you may still place orders with your bookstore.

About the Author(s)

Benjamin Rosenzweig is a Senior Project Manager at Misys Financial Software, where he has worked since 2002. Prior to that he was a principal consultant for more than three years at Oracle Corporation in the Custom Development Department. His computer experience ranges from creating an electronic Tibetan—English Dictionary in Kathmandu, Nepal, to supporting presentation centers at Goldman Sachs and managing a trading system at TIAA-CREF. Benjamin has been an instructor at the Columbia University Computer Technology and Application program in New York City since 1998. In 2002 he was awarded the “Outstanding Teaching Award” from the Chair and Director of the CTA program. He holds a B.A. from Reed College and a certificate in database development and design from Columbia University. His previous books with Prentice Hall are Oracle Forms Developer: The Complete Video Course (2000), and Oracle Web Application Programming for PL/SQL Developers (2003).

Elena Rakhimov has more than twenty years of experience in database architecture and development in a wide spectrum of enterprise and business environments ranging from non-profit organizations to Wall Street to her current position with a prominent software company where she heads up the database team. Her determination to stay “hands-on” notwithstanding, Elena managed to excel in the academic arena having taught relational database programming at Columbia University’s highly esteemed Computer Technology and Applications program. She was educated in database analysis and design at Columbia University and in applied mathematics at Baku State University in Azerbaijan. She currently resides in Vancouver, Canada.