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

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 master’s 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 helifromfinland.wordpress.com. 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.

• Part 1: The Importance of SQL, PL/SQL and a Good Data ModelChapter 1: SQL, PL/SQL and When to Use WhichChapter 2: Expert Data Modeling and Implementing Business Logic Part 2: Underutilized Advanced SQL FunctionalityChapter 3: Handling Advanced and Complex DatasetsChapter 4: Regular ExpressionsChapter 5: Edition Based Redefinition Part 3: Essential Everyday Advanced PL/SQLChapter 6: Running PL/SQL in SQLChapter 7: Instrumenting, Profiling and Debugging PL/SQLChapter 8: Dynamic SQLChapter 9: PL/SQL for Database Management Part 4: Advanced AnalyticsChapter 10: In-Database Data Mining Using Oracle Data MiningChapter 11: Oracle R EnterpriseChapter 12: Predictive Queries Part 5: Database SecurityChapter 13: Redaction and maskingChapter 14: Encryption and hashingChapter 15: SQL Injection & Code SecurityChapter 16: Virtual Private Databases (VPD)