{"product_id":"9781430234869","title":"Expert PL\/SQL Practices: for Oracle Developers and DBAs","description":"\u003cp\u003e\u003cem\u003eExpert PL\/SQL Practices\u003c\/em\u003e is a book of collected wisdom on PL\/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you’ll face as a PL\/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of code that you write.\u003c\/p\u003e\u003cp\u003eThe path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you’ve reached that point with PL\/SQL, then let the authors of \u003cem\u003eExpert PL\/SQL Practices\u003c\/em\u003e show you how to combine syntax and mechanics with features and techniques to really make the language sing. You’ll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects.\u003c\/p\u003e\u003cp\u003eThese authors are passionate about PL\/SQL and the power it places at your disposal. They want you to succeed, to know all that PL\/SQL can offer. Let \u003cem\u003eExpert PL\/SQL Practices\u003c\/em\u003e open your eyes to the full power of Oracle’s world-class language for the database engine. \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eGoes beyond the manual to cover good techniques and best practices \u003c\/li\u003e\n\u003cli\u003eDelivers knowledge usually gained only by hard experience \u003c\/li\u003e\n\u003cli\u003eCovers the functionality that distinguishes PL\/SQL as a powerful and scalable programming language for deploying logic inside the database engine \u003c\/li\u003e\n\u003c\/ul\u003eWhat you’ll learn\u003cul\u003e   \u003cli\u003eLearn when PL\/SQL is best used, and when to avoid it \u003c\/li\u003e   \u003cli\u003eMove data efficiently using bulk SQL operations \u003c\/li\u003e   \u003cli\u003eWrite code that scales through pipelining, parallelism, and profiling \u003c\/li\u003e   \u003cli\u003eChoose the right PL\/SQL cursor type for any given application \u003c\/li\u003e   \u003cli\u003eReduce coding errors through sound development practices such as unit-testing \u003c\/li\u003e   \u003cli\u003eCreate and execute SQL and PL\/SQL dynamically at runtime \u003c\/li\u003e  \u003c\/ul\u003e  Who this book is for      \u003cp\u003e     \u003cem\u003eExpert PL\/SQL Practices\u003c\/em\u003e is for PL\/SQL developers who want to develop deep expertise in key aspects of the language and its use in database programming. Any developer writing code against Oracle’s class-leading database engine will find value from the collected wisdom in this book. Some knowledge of PL\/SQL is assumed. Readers should at least be past the beginning stage with the language.         \u003c\/p\u003e     Table of Contents\u003col\u003e   \u003cli\u003eDo Not Use \u003c\/li\u003e   \u003cli\u003eDynamic SQL: Handling the Unknown \u003c\/li\u003e   \u003cli\u003ePL\/SQL and Parallel Processing \u003c\/li\u003e   \u003cli\u003eWarnings and Conditional Compilation  \u003c\/li\u003e   \u003cli\u003ePL\/SQL Unit Testing \u003c\/li\u003e   \u003cli\u003eBulk SQL Operations \u003c\/li\u003e   \u003cli\u003eKnow Your Code  \u003c\/li\u003e   \u003cli\u003eContract-Oriented Programming \u003c\/li\u003e   \u003cli\u003ePL\/SQL from SQL \u003c\/li\u003e   \u003cli\u003eChoosing the Right Cursor \u003c\/li\u003e   \u003cli\u003ePL\/SQL Programming in the Large \u003c\/li\u003e   \u003cli\u003eEvolutionary Data Modeling \u003c\/li\u003e   \u003cli\u003eProfiling for Performance \u003c\/li\u003e   \u003cli\u003eCoding Conventions and Error Handling \u003c\/li\u003e   \u003cli\u003eDependencies and Invalidations \u003c\/li\u003e  \u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47174989709552,"sku":"9781430234869","price":38.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430234869_p0.jpg?v=1763750225","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430234869","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}