Oracle PL/SQL for DBAs

Security, Scheduling, Performance & More

Nonfiction, Computers, Programming, Programming Languages, SQL, Database Management, Data Processing
Cover of the book Oracle PL/SQL for DBAs by Arup Nanda, Steven Feuerstein, O'Reilly Media
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Arup Nanda, Steven Feuerstein ISBN: 9781449378998
Publisher: O'Reilly Media Publication: October 31, 2005
Imprint: O'Reilly Media Language: English
Author: Arup Nanda, Steven Feuerstein
ISBN: 9781449378998
Publisher: O'Reilly Media
Publication: October 31, 2005
Imprint: O'Reilly Media
Language: English

PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur.

Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap. Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples, it contains:

  • A quick tour of the PL/SQL language, providing enough basic information about language fundamentals to get DBAs up and running
  • Extensive coverage of security topics for DBAs: Encryption (including both traditional methods and Oracle's new Transparent Data Encryption, TDE); Row-Level Security(RLS), Fine-Grained Auditing (FGA); and random value generation
  • Methods for DBAs to improve query and database performance with cursors and table functions
  • Coverage of Oracle scheduling, which allows jobs such as database monitoring andstatistics gathering to be scheduled for regular execution

Using Oracle's built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM,DBMS_SCHEDULING) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world's foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming.

DBAs who have not yet discovered how helpful PL/SQL can be will find this book a superb introduction to the language and its special database administration features. Even if you have used PL/SQL for years, you'll find the detailed coverage in this book to be an invaluable resource.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur.

Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap. Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples, it contains:

Using Oracle's built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM,DBMS_SCHEDULING) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world's foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming.

DBAs who have not yet discovered how helpful PL/SQL can be will find this book a superb introduction to the language and its special database administration features. Even if you have used PL/SQL for years, you'll find the detailed coverage in this book to be an invaluable resource.

More books from O'Reilly Media

Cover of the book Java Database Best Practices by Arup Nanda, Steven Feuerstein
Cover of the book Droid X: The Missing Manual by Arup Nanda, Steven Feuerstein
Cover of the book Flex 3 Cookbook by Arup Nanda, Steven Feuerstein
Cover of the book Das Buch zum iPhone 5s und 5c by Arup Nanda, Steven Feuerstein
Cover of the book MongoDB and PHP by Arup Nanda, Steven Feuerstein
Cover of the book eBay Commerce Cookbook by Arup Nanda, Steven Feuerstein
Cover of the book Think Perl 6 by Arup Nanda, Steven Feuerstein
Cover of the book Using Mac OS X Lion Server by Arup Nanda, Steven Feuerstein
Cover of the book Effective UI by Arup Nanda, Steven Feuerstein
Cover of the book DVD Studio Pro 3: In the Studio by Arup Nanda, Steven Feuerstein
Cover of the book X Power Tools by Arup Nanda, Steven Feuerstein
Cover of the book Web Mapping Illustrated by Arup Nanda, Steven Feuerstein
Cover of the book OS X Mountain Lion Pocket Guide by Arup Nanda, Steven Feuerstein
Cover of the book Building Social Web Applications by Arup Nanda, Steven Feuerstein
Cover of the book macOS Sierra: The Missing Manual by Arup Nanda, Steven Feuerstein
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy