Hannah Pate
Software Engineer at Relativity
Chicago, Illinois, United States
It's me, that person that really likes SQL. You know the type. Excited at fixing a deadlock, types out their queries instead of using that fancy front end you're developing, writes out BEGIN TRANS ROLLBACK before anything else.
Yeah, that's the one. And I'm here to talk to you about SQL like that person who just started a new diet and hasn't realized that you're tired of hearing about it.
Area of Expertise
Topics
SQL 201: How I learned to stop worrying and love the database
You have mastered the simple SELECT. JOINs aren't so scary any more. And you've been experimenting with the GROUP BY clause (don't worry, I won't tell). You're ready for the next step: SQL 201. It's time to optimize those queries and decode the deadlock graph. Ever heard of an INDEX? You will.
You're done with simple CRUD queries. Now it's time to get more advanced and see SQL for the beautiful language it is.
SELECT devs.*
FROM ConferenceAttendees devs
WHERE SqlExperence = 'Beginner'
AND SqlInterest >= 'Hell Yeah'
This session is aimed at beginner developers or mid-level developers who are new to SQL development topics like deadlocks.
Deadlocked and Loaded
You've designed a beautifully parallelized process, truly a marvel to behold. Oh no! A wild SQL DEADLOCK appears. It uses ROLLBACK. It's super effective!
Let's get locked and loaded to learn the in's and out's of the deadlock graph, common deadlock scenarios, and how to fix them.
This session is aimed at beginner developers or mid-level developers who are new to SQL development topics like deadlocks.
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