Session

Excel: The Accidental DBA - Hacking CRUD with VBA, SQL, and AI Sidekicks


Excel, the beloved spreadsheet tool, has been secretly aspiring to be a database admin all along. In this one-hour session, we'll embark on a thrilling journey to transform Excel into the DBA interface it was never meant to be, but always dreamed of becoming.

Armed with the power of VBA and SQL, we'll hack our way through CRUD (Create, Read, Update, Delete) operations, turning Excel into a data management superhero. But fear not, you won't be alone in this adventure! Large Language Models (LLMs) will be your trusty AI sidekicks, providing coding assistance, performance boosts, and witty banter along the way.

Through live demonstrations and hands-on examples, you'll learn to wield VBA and SQL like a pro, while LLMs guide you in implementing logging and error trapping, ensuring your CRUD operations are bulletproof and maintainable.

Join us for this hilarious and educational session, where we'll unleash Excel's inner DBA and prove that spreadsheets can handle data management tasks with style and grace. Get ready to level up your Excel skills and become the accidental DBA you never knew you wanted to be!

Excel will earn it's title as a database, no apologies made

James Reeves

Crafting Data Magic with ADHD-Powered Focus: Architecting Insights and Embracing the Chaos

Chester, United Kingdom

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top