Connor McDonald

Connor Mcdonald 300x300

Connor McDonald

Developer Advocate

Oracle Corporation

Biography

Connor McDonald is a 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 has three times won the Best Speaker award by the UK Oracle User Group, and was awarded a Lifetime Achievement award by the UKOUG in 2016.

Papers

Public speaking- The new skill set for modern IT professionals

Event: Virtual Connect 2020
Stream: Architecture, Cloud Database & Technology

The days of sitting in a room and doing nothing else but write code are disappearing. Software development has always mean to be a collaborative activity, and finally we are bringing technically minded people closer to business representative and customers to build better products and have less project failures. But that means your skill set now needs the ability to present your ideas to a group of stakeholders. The session will give tips and techniques on giving a talk, preparing your slides, avoiding nerves, and avoiding disasters, as well as tips for how we’ll be giving talk for the foreseeable future – namely, virtually over platforms such as Zoom, Teams, GoToMeeting etc.

PL/SQL Still the best data language ever invented

Event: Virtual Connect 2020, Virtual Connect 2020-Development
Stream: Architecture, Cloud Database & Technology

Another year goes by, and most likely, another data access framework has been invented. It will claim to be the fastest, smartest way to talk to the database, and just like all those that came before it, it will not be. Because the best database access tool has been there for more than 30 years now, and that is PL/SQL. Although we all sometimes fall prey to the mindset of “Oh look, a shiny new tool, we should start using it,” the performance and simplicity of PL/SQL remains unmatched. This session looks at the failings of other data access languages, why even a cursory knowledge of PL/SQL will make you a better developer, and how to get the most out of PL/SQL when it comes to database performance.

Partitioning…Bigger and Better

Event: Virtual Connect 2020, Virtual Connect 2020-Development
Stream: Architecture, Cloud Database & Technology

Partitioning came along way back in Oracle 8.0, and it is often thought that (perhaps with the exception of interval partitioning in 11g), not much has happened in terms of the functionality. But hidden away from the marketing hype, is a plethora of improvements that have come to partitioning from 12c all the way up to 19c. This session will look at those enhancement to ensure that you get the maximum return on your partitioning option investment.

Building Successful Applications on the Autonomous Database

Event: Virtual Connect 2020, Virtual Connect 2020-Development
Stream: Architecture, Cloud Database & Technology

Well done! You’ve come up with the killer idea for 2021. You’ve got the best UI design anyone has ever seen! Your modern application ticks all the boxes — serverless, functional, Kubernetes, microservices, API-based, the list goes on. It runs on every OS and every type of device. But unfortunately, all of this counts for absolutely NOTHING if your data access is slow or buggy. But an Autonomous database will fix all that right? Only if you understand the fundamentals of how SQL is processed by the database. For novice developers, SQL can be hard to understand and sometimes totally hidden from view under an ORM. Let’s peel back the covers to show how SQL is processed, how to avoid getting hacked, and how to get data back to your application in a snappy fashion.

25 years of tips and tricks

Event: Virtual Connect 2020, Virtual Connect 2020-Development
Stream: Architecture, Cloud Database & Technology

Your database skill set is more than what you have been read in the documentation, or on blogs, or on StackOverflow.  It is the knowledge from trial and error, experimentation and sometimes painful failures.  And that takes time, a long time. But this session will fast track that path. I’ll share with you a collection of hints, tips, tools, features and techniques that over the years I’ve either seen, built myself or simply picked up from the smartest people in the community.