Real World SQL and PL/SQL: Advice from the Experts

Real World SQL and PL/SQL: Advice from the Experts

By: Heli Helskyaho (author), Martin Widlake (author), Arup Nanda (author), Brendan Tierney (author), Alex Nuijten (author)Paperback

Up to 1 WeekUsually despatched within 1 week

£31.19 RRP £47.99  You save £16.80 (35%) With FREE Saver Delivery


Develop, debug, and deploy secure data-centric programs using SQL and PL/SQL This comprehensive Oracle Press guide shows how to exploit the little known but extremely useful SQL and PL/SQL features to develop powerful applications-and how to effectively use both the languages together. Readers will learn to compare and contrast the standards and determine which-or a blend of the two-is optimal under any set of circumstances. Real World SQL and PL/SQL: Advice from the Experts focuses on practical, day-to-day operations and tasks taken up in complex projects. The authors provide best practices, real-world examples, and insider tips that clearly demonstrate, step-by-step, how to best implement code for a wide variety of applications that need to be both performant and secure. The book fully explains advanced SQL techniques, essential advanced PL/SQL development and tools, data modeling, advanced analytics using both Oracle-supplied tools and embedded R, and secure coding. Offers unique, highly-integrated coverage of both SQL and PL/SQL All code in the book is available for download and ready to implement Written by a team of Oracle ACE Directors some of whom are members of the Oak Table Network

About Author

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. Heli Helskyaho has a masters degree in computer science from Helsinki University and specializes in databases. Heli is also an Oracle ACE director and has been a frequent speaker at many conferences. She has worked in IT since 1990 and with Oracle products since 1993. She has been in several positions, but each role has always included database design. Heli has been an Oracle Designer user since 1996 and a Oracle SQL Developer Data Modeler user since 2010. Heli is an active member in Oracle user groups community, including Oracle User Group Finland as well as EMEA Oracle user groups community (EOUC) where she has served as their spokesperson/ambassador since 2007. Heli is also the CEO for Miracle Finland Oy. Heli believes that creating good database design and documentation reduces performance problems and makes solving them easier. You can follow her on Twitter @helifromfinland or read her blog on


Part 1: The Importance of SQL, PL/SQL and a Good Data Model Chapter 1: SQL, PL/SQL and When to Use Which Chapter 2: Expert Data Modeling and Implementing Business Logic Part 2: Underutilized Advanced SQL Functionality Chapter 3: Handling Advanced and Complex Datasets Chapter 4: Regular Expressions Chapter 5: Edition Based Redefinition Part 3: Essential Everyday Advanced PL/SQL Chapter 6: Running PL/SQL in SQL Chapter 7: Instrumenting, Profiling and Debugging PL/SQL Chapter 8: Dynamic SQL Chapter 9: PL/SQL for Database Management Part 4: Advanced Analytics Chapter 10: In-Database Data Mining Using Oracle Data Mining Chapter 11: Oracle R Enterprise Chapter 12: Predictive Queries Part 5: Database Security Chapter 13: Redaction and masking Chapter 14: Encryption and hashing Chapter 15: SQL Injection & Code Security Chapter 16: Virtual Private Databases (VPD)

Product Details

  • ISBN13: 9781259640971
  • Format: Paperback
  • Number Of Pages: 736
  • ID: 9781259640971
  • weight: 1043
  • ISBN10: 1259640973

Delivery Information

  • Saver Delivery: Yes
  • 1st Class Delivery: Yes
  • Courier Delivery: Yes
  • Store Delivery: Yes

Prices are for internet purchases only. Prices and availability in WHSmith Stores may vary significantly