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 January 5th, 2017 presentation, Brian Deshong discusses 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, he talks about how to troubleshoot and avoid common pitfalls. Brian covers a wide array of topics, such as data modeling best practices, using joins, and using referential integrity. He also wades into more advanced topics, such as using stored procedures, using triggers, tuning queries, and even replication. Briefly discussed is 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.