Amazon Prime Free Trial
FREE Delivery is available to Prime members. To join, select "Try Amazon Prime and start saving today with FREE Delivery" below the Add to Cart button and confirm your Prime free trial.
Amazon Prime members enjoy:- Cardmembers earn 5% Back at Amazon.com with a Prime Credit Card.
- Unlimited FREE Prime delivery
- Streaming of thousands of movies and TV shows with limited ads on Prime Video.
- A Kindle book to borrow for free each month - with no due dates
- Listen to over 2 million songs and hundreds of playlists
Important: Your credit card will NOT be charged when you start your free trial or if you cancel during the trial period. If you're happy with Amazon Prime, do nothing. At the end of the free trial, your membership will automatically upgrade to a monthly membership.
-26% $54.23$54.23
Ships from: Amazon.com Sold by: Amazon.com
$8.98$8.98
FREE delivery January 30 - February 4
Ships from: ThriftBooks-Atlanta Sold by: ThriftBooks-Atlanta
Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
Follow the authors
OK
Real World SQL and PL/SQL: Advice from the Experts 1st Edition
Purchase options and add-ons
Publisher'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.
Master the Underutilized Advanced Features of SQL and PL/SQL
This 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, Real-World SQL and PL/SQL: Advice from the Experts 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.
Learn how to:
• Apply advanced SQL and PL/SQL tools and techniques
• Understand SQL and PL/SQL functionality and determine when to use which language
• Develop accurate data models and implement business logic
• Run PL/SQL in SQL and integrate complex datasets
• Handle PL/SQL instrumenting and profiling
• Use Oracle Advanced Analytics and Oracle R Enterprise
• Build and execute predictive queries
• Secure your data using encryption, hashing, redaction, and masking
• Defend against SQL injection and other code-based attacks
• Work with Oracle Virtual Private Database
Code examples in the book are available for download at www.MHProfessional.com.
TAG: For a complete list of Oracle Press titles, visit www.OraclePressBooks.com
- ISBN-109781259640971
- ISBN-13978-1259640971
- Edition1st
- PublisherMcGraw Hill
- Publication dateAugust 2, 2016
- LanguageEnglish
- Dimensions7.38 x 1.66 x 9.13 inches
- Print length736 pages
Similar items that may deliver to you quickly
From the brand
-
As a leading global education company, our mission is to partner with educators, learners, and professionals to help them access all the value that education can offer, no matter where their starting points may be.
For over 130 years, we have never stopped innovating to meet the ever-changing needs of educators and learners around the world – and will continue to support and celebrate their efforts every step of the way.
-
Editorial Reviews
From the Publisher
Brendan 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, Predictive Analytics using Oracle Data Miner and Oracle R Enterprise: Harnessing the Power of R in the Oracle Database.
Heli 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 Oracle SQL Developer Data Modeler for Database Design Mastery (Oracle Press 2015) and one of the first winners of Oracle Database Developer Choice Award in Database Design category in 2015.
Alex 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.
Martin 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
About the Author
Arup 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.
Brendan 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, Predictive Analytics using Oracle Data Miner and Oracle R Enterprise: Harnessing the Power of R in the Oracle Database.
Heli 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 Oracle SQL Developer Data Modeler for Database Design Mastery (Oracle Press 2015) and one of the first winners of Oracle Database Developer Choice Award in Database Design category in 2015.
Alex 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.
Martin 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
Martin Widlake is an independent Oracle consultant, specialising in database performance, PL/SQL development and VLDBs. He has been working with Oracle technologies for over two decades and shares his experience & knowledge when presenting at conferences and user groups several times a year, both across the UK and internationally. Martin is an Oracle ACE and also a proud member of the Oak Table Network.
Brendan Tierney, Oracle ACE Director, is an independent consultant and lectures on Data Mining and Advanced Databases in the Dublin Institute of Technology in Ireland. He is an Oracle ACE Director and has extensive experience working in the areas of Data Mining, Data Warehousing, Data Architecture and Database Design. Brendan has worked on projects in Ireland, UK, Belgium and USA and has been working with the Oracle database and tools since 1992. Brendan is the editor of the UKOUG Oracle Scene magazine and deputy chair of the OUG Ireland BI SIG. Brendan is a regular speaker at conferences across Europe and the USA, including Oracle Open World. In addition to his presentations Brendan has written technical articles for OTN, Oracle Scene, IOUG SELECT Journal and ODTUG Technical Journal. He is author of the Oracle Press book titled, Predictive Analytics using Oracle Data Miner.
Product details
- ASIN : 1259640973
- Publisher : McGraw Hill; 1st edition (August 2, 2016)
- Language : English
- Paperback : 736 pages
- ISBN-10 : 9781259640971
- ISBN-13 : 978-1259640971
- Item Weight : 2.4 pounds
- Dimensions : 7.38 x 1.66 x 9.13 inches
- Best Sellers Rank: #4,318,775 in Books (See Top 100 in Books)
- #60 in Oracle Databases
- #802 in SQL
- #1,805 in Database Storage & Design
- Customer Reviews:
About the authors
Heli Helskyaho holds a Master’s degree (Computer Science) in University of Helsinki and she is specialized on databases. Heli is also an Oracle ACE Director, an Oracle Groundbreaker Ambassador, and a frequent speaker in many conferences. She has been working on IT since 1990 and with Oracle products since 1993. She has been in several positions but every role has always included database design. Heli has been an Oracle Designer user since 1996 and a Data Modeler user since 2010. She is also the CEO for Miracle Finland Oy.
Brendan Tierney, Oracle ACE Director, is an independent consultant and lectures on Data Mining and Advanced Databases in the Dublin Institute of Technology in Ireland. He has 23+ years of extensive experience working in the areas of Data Mining, Data Warehousing, Data Architecture and Database Design. Brendan has worked on projects in Ireland, UK, across Europe, Canada and USA. Brendan is the editor of the UKOUG Oracle Scene magazine and deputy chair of the OUG Ireland BI SIG. Brendan is a regular speaker at conferences across Europe and the USA and has written technical articles for OTN, Oracle Scene, IOUG SELECT Journal and ODTUG Technical Journal.
twitter : @brendantierney
blog : www.oralytics.com
Customer reviews
- 5 star4 star3 star2 star1 star5 star52%17%31%0%0%52%
- 5 star4 star3 star2 star1 star4 star52%17%31%0%0%17%
- 5 star4 star3 star2 star1 star3 star52%17%31%0%0%31%
- 5 star4 star3 star2 star1 star2 star52%17%31%0%0%0%
- 5 star4 star3 star2 star1 star1 star52%17%31%0%0%0%
Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them.
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness.
Learn more how customers reviews work on AmazonTop reviews from the United States
There was a problem filtering reviews right now. Please try again later.
- Reviewed in the United States on February 5, 2018There is a lot of good ideas in this book. And Nanda shows you how they can be implemented.
Every time I read this book, I pick up something new.
This book is readable with great examples and walk-through.
Top reviews from other countries
- Amazon CustomerReviewed in Canada on March 20, 2018
4.0 out of 5 stars Good reference guide and resource book
This book covers a wide variety of topics related to Oracle database programming, focusing on features that are often overlooked or underused. It was interesting to read the book and learn more about Oracle, although I'm not sure how much I'll actually use the different features that were covered. Some of the features that were covered aren't available in Oracle Express so I wasn't able to try them out, which was disappointing.
- Jack XiuReviewed in Canada on April 29, 2021
3.0 out of 5 stars Good contents, poor codes.
Author(s) took deep dives into SQL and PL/SQL. The contents are more than awesome. However, the coding style is terrible. I can't see indentations at all. It is a torture to read the codes in this book.