PRESENTATION: Demystifying the Relational Database
Directions: Take I-285 to Cobb Parkway/US-41. Go south & turn left on Akers Mill Rd. At the 2nd traffic light, go left into Cobb Galleria, then an immediate left into the parking garage. Enter the 600 bldg & tell security you’re there for AtlantaPHP, 14th floor.
Map Link: https://goo.gl/maps/N2F52DZs9Cs (parking deck entrance, 600 building is due north of the deck)
Presentation by Brian Deshong, Director of Engineering at ShootProof, @bdeshong
When: Thursday, January 5th, 2017 — 7pm-9pm
Please RSVP at: https://www.meetup.com/atlantaphp/events/236389820/
Databases are an incredible resource to have at at your disposal when building and running web applications. They tend to be large, powerful machines that we can just shovel data into. But do we always treat them with the care and respect that they deserve? Do we use them efficiently, and to their fullest potential?
In this talk, we will discuss how you can use relational databases to their full potential while ensuring that they’re always being used efficiently and with care. Along the way, we’ll talk about how to troubleshoot and avoid common pitfalls. We will cover a wide array of topics, such as data modeling best practices, using joins, and using referential integrity. We will also wade into more advanced topics, such as using stored procedures, using triggers, tuning queries, and even replication. We’ll briefly discuss the various relational databases available, as well as how cloud providers come into play.
About Brian: Brian is Director of Engineering at ShootProof, an Atlanta-based company building web-based tools for professional photographers. Brian has spent over 15 years in the industry, primarily building and maintaining web applications of all shapes and sizes. He has spent many of his years in highly-trafficked environments, working primarily with the LAMP stack, Oracle, and, more recently, Amazon Web Services. He has always been deeply involved in infrastructure and systems administration, which has given him a very broad skill set. He has also spent a number of years developing for Apple platforms.
He lives in suburban Atlanta with his wife and daughter.
Mini-talk: John Corry on StatsD and Datadog
Food provided by Pardot Engineering (@pardoteng)
