{"product_id":"oracle-pl-sql-for-dbas-9780596005870","title":"Oracle PL\/SQL for DBAs","description":"\u003cp\u003e • Author(s): Arup Nanda\u003cbr\u003e • Publisher: O'Reilly Media\u003cbr\u003e • Publisher Imprint: O'Reilly Media\u003cbr\u003e • BISAC: Languages - SQL\u003c\/p\u003e\u003cp\u003ePL\/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. \u003c\/p\u003e\u003cp\u003e Until now, there has not been a book focused squarely on the language topics of special concern to DBAs \u003ci\u003eOracle PL\/SQL for DBAs\u003c\/i\u003e fills the gap. Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples, it contains: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eA quick tour of the PL\/SQL language, providing enough basic information about language fundamentals to get DBAs up and running\u003c\/li\u003e \u003cli\u003eExtensive 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\u003c\/li\u003e \u003cli\u003eMethods for DBAs to improve query and database performance with cursors and table functions\u003c\/li\u003e \u003cli\u003eCoverage of Oracle scheduling, which allows jobs such as database monitoring and statistics gathering to be scheduled for regular execution\u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003e 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, \u003ci\u003eOracle Magazine 2003\u003c\/i\u003e DBA of the Year, and Steven Feuerstein, the world's foremost PL\/SQL expert and coauthor of the classic reference, \u003ci\u003eOracle PL\/SQL Programming\u003c\/i\u003e. \u003c\/p\u003e\u003cp\u003e 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.\u003c\/p\u003e","brand":"O'Reilly Media","offers":[{"title":"Paperback","offer_id":45116037628055,"sku":"9780596005870","price":3244.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0666\/3471\/1191\/files\/9780596005870.webp?v=1767271304","url":"https:\/\/atlanticbooks.com\/products\/oracle-pl-sql-for-dbas-9780596005870","provider":"Atlantic Books","version":"1.0","type":"link"}