{"product_id":"9781430225102","title":"Oracle SQL Recipes: A Problem-Solution Approach","description":"\u003cp\u003eHave you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you from that drudgery by providing tested and working examples of SQL used to solve common problems faced by developers and database administrators on a daily basis. When you're under pressure to get results fast, \u003cem\u003eOracle SQL Recipes\u003c\/em\u003e is there at your side.\u003c\/p\u003e \u003cul\u003e  \u003cli\u003eExample-based, providing quality solutions to everyday problems \u003c\/li\u003e  \u003cli\u003eRespects your time by putting solutions first and keeping discussions short \u003c\/li\u003e  \u003cli\u003eSolves the most commonly encountered SQL problems \u003c\/li\u003e \u003c\/ul\u003e What you’ll learn\u003cul\u003e  \u003cli\u003eRecognize common query patterns and apply their corresponding solutions. \u003c\/li\u003e  \u003cli\u003eSolve common reporting problems such as sorting rows into buckets. \u003c\/li\u003e  \u003cli\u003eTroubleshoot SQL performance problems. \u003c\/li\u003e  \u003cli\u003eCreate and manage database objects such as tables, indexes, and views. \u003c\/li\u003e  \u003cli\u003eWork with XML and tree-structured data. \u003c\/li\u003e  \u003cli\u003eTake advantage of analytic functions, regular expressions, hierarchical query support, and other powerful aspects of Oracle SQL. \u003c\/li\u003e \u003c\/ul\u003e Who this book is for      \u003cp\u003e     \u003cem\u003eOracle SQL Recipes\u003c\/em\u003e is written for developers and database administrators who write SQL to run against an Oracle database. It is further written for those whose time is precious, and who just wish for a good example to help them get on with their work. If you want to spend your time writing SQL rather than reading about it, then this is the right book for you.       \u003c\/p\u003e     Table of Contents\u003col\u003e  \u003cli\u003eThe Basics \u003c\/li\u003e  \u003cli\u003eSummarizing and Aggregating Data \u003c\/li\u003e  \u003cli\u003eQuerying from Multiple Tables \u003c\/li\u003e  \u003cli\u003eCreating and Deriving Data \u003c\/li\u003e  \u003cli\u003eCommon Query Patterns \u003c\/li\u003e  \u003cli\u003eWorking with Date and Time Values \u003c\/li\u003e  \u003cli\u003eStrings \u003c\/li\u003e  \u003cli\u003eWorking with Numbers \u003c\/li\u003e  \u003cli\u003eManaging Transactions \u003c\/li\u003e  \u003cli\u003eData Dictionary \u003c\/li\u003e  \u003cli\u003eCommon Reporting Problems \u003c\/li\u003e  \u003cli\u003eCleansing Data \u003c\/li\u003e  \u003cli\u003eTree-Structured Data \u003c\/li\u003e  \u003cli\u003eWorking with XML Data \u003c\/li\u003e  \u003cli\u003ePartitioning \u003c\/li\u003e  \u003cli\u003eLOBs \u003c\/li\u003e  \u003cli\u003eDatabase Administration \u003c\/li\u003e  \u003cli\u003eObject Management \u003c\/li\u003e  \u003cli\u003eSQL Monitoring and Tuning \u003c\/li\u003e  \u003cli\u003eDatabase Troubleshooting \u003c\/li\u003e \u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47127552786672,"sku":"9781430225102","price":34.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430225102_p0.jpg?v=1763751794","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430225102","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}