{"product_id":"9781449378998","title":"Oracle PL\/SQL for DBAs: Security, Scheduling, Performance \u0026 More","description":"\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\u003eUntil 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\n\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\n\u003cli\u003eMethods for DBAs to improve query and database performance with cursors and table functions\u003c\/li\u003e\n\u003cli\u003eCoverage of Oracle scheduling, which allows jobs such as database monitoring andstatistics gathering to be scheduled for regular execution\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eUsing 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\u003eDBAs 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, Incorporated","offers":[{"title":"Default Title","offer_id":47128407671024,"sku":"9781449378998","price":35.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781449378998_p0.jpg?v=1763828903","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781449378998","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}