{"product_id":"real-world-sql-and-pl-sql-advice-from-the-experts","title":"Real World SQL and Pl\/Sql: Advice from the Experts","description":"\u003cb\u003ePublisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.\u003c\/b\u003e\u003cp\u003e\u003cstrong\u003e\u003cbr\u003e\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eMaster the Underutilized Advanced Features of SQL and PL\/SQL\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eThis hands-on guide from Oracle Press shows how to fully exploit lesser known but extremely useful SQL and PL\/SQL features―and how to effectively use both languages together. Written by a team of Oracle ACE Directors, \u003cem\u003eReal-World SQL and PL\/SQL: Advice from the Experts\u003c\/em\u003e features best practices, detailed examples, and insider tips that clearly demonstrate how to write, troubleshoot, and implement code for a wide variety of practical applications. The book thoroughly explains underutilized SQL and PL\/SQL functions and lays out essential development strategies. Data modeling, advanced analytics, database security, secure coding, and administration are covered in complete detail.\u003c\/p\u003e\u003cp\u003eLearn how to: \u003c\/p\u003e\u003cp\u003e- Apply advanced SQL and PL\/SQL tools and techniques\u003cbr\u003e- Understand SQL and PL\/SQL functionality and determine when to use which language\u003cbr\u003e- Develop accurate data models and implement business logic\u003cbr\u003e- Run PL\/SQL in SQL and integrate complex datasets\u003cbr\u003e- Handle PL\/SQL instrumenting and profiling\u003cbr\u003e- Use Oracle Advanced Analytics and Oracle R Enterprise\u003cbr\u003e- Build and execute predictive queries\u003cbr\u003e- Secure your data using encryption, hashing, redaction, and masking\u003cbr\u003e- Defend against SQL injection and other code-based attacks\u003cbr\u003e- Work with Oracle Virtual Private Database\u003c\/p\u003e\u003cp\u003eCode examples in the book are available for download at www.MHProfessional.com.\u003c\/p\u003e\u003cp\u003eTAG: For a complete list of Oracle Press titles, visit www.OraclePressBooks.com\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the Author\u003c\/b\u003e\u003cbr\u003eArup Nanda, Oracle ACE Director (New York, United States), has been working with Oracle database and PL\/SQL for 20 years and counting. He has written 6 books, published 500] articles, presented 300+ sessions, and delivered training seminars in 22 countries.\u003cp\u003eBrendan Tierney, Oracle ACE Director (Dublin, Ireland), has been working with the Oracle Database and development tools since 1992. He is principal consultant with Oralytics. He is the author of 2 books by Oracle Press, \u003cem\u003ePredictive Analytics using Oracle Data Miner\u003c\/em\u003e and \u003cem\u003eOracle R Enterprise: Harnessing the Power of R in the Oracle Database\u003c\/em\u003e. \u003c\/p\u003e\u003cp\u003eHeli Helskyaho, Oracle ACE Director (Helsinki, Finland), has been working in IT since 1990 and Oracle products since 1993. She is the spokesperson\/ambassador of the EMEA Oracle User Group and a frequent speaker in many conferences. She is the author of \u003cem\u003eOracle SQL Developer Data Modeler for Database Design Mastery\u003c\/em\u003e (Oracle Press 2015) and one of the first winners of Oracle Database Developer Choice Award in Database Design category in 2015.\u003c\/p\u003e\u003cp\u003eAlex Nuijten, Oracle ACE Director (Oosterhout, Netherlands), is a consultant at Ordina Oracle Solutions. He is a frequent contributor to Oracle-related publications and is co-author of Oracle APEX Best Practices.\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eMartin Widlake, Oracle ACE Director (London, United Kingdom), is an independent Oracle consultant who specializes in database performance, PL\/SQL development, and VLDBs. He has been working with Oracle technologies for 23 years and counting\u003c\/p\u003e\u003cbr\u003e","brand":"McGraw-Hill Companies","offers":[{"title":"Default Title","offer_id":50333936451858,"sku":"9781259640971","price":52.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_33a384c6-15b3-4270-aa22-0bd9878e72cc.jpg?v=1727881496","url":"https:\/\/surprise-castle.myshopify.com\/products\/real-world-sql-and-pl-sql-advice-from-the-experts","provider":"Surprise Castle","version":"1.0","type":"link"}