Session Number: 8090
Sub-Categorization: DB Dev
Session Type: Tips, Techniques and Tuning
Primary Presenter: Connor McDonald [Developer Advocate - Oracle]
Time: Jun 24, 2019 (02:15 PM - 03:15 PM)
Room: 6B, Level 6
Speaker Bio: Connor McDonald is an Oracle developer advocate for Oracle Corporation. Over the past 25 years, he has worked with systems in Australia, the United Kingdom, southeast Asia, western Europe, and the United States. He has co-authored three books and has been a popular speaker at Oracle conferences around the world, specializing in topics regarding the database engine and PL/SQL. He won the Oracle Code Speaker award in 2018, has three times won the Best Speaker award from the UK Oracle User Group, and was awarded a Lifetime Achievement award from the UKOUG in 2016.
Technologies or Products Used: Database, SQL
Session Summary for Attendees: Coding is great fun, but we do it to explore complex algorithms, build beautiful applications, and deliver fantastic solutions for our customers, not just to do boring data processing. By expanding our knowledge of SQL facilities, we can let all the boring work be handled via SQL rather than a lot of middle-tier code, and we can get performance benefits as an added bonus. This session highlights some SQL techniques to solve problems that would otherwise require a lot of complex coding, freeing up your time to focus on the delivery of great applications.