This session is great for Developers who have not had much training on database and for DBAs who are usually concerned with keeping servers up and running, but not done much database design. We’ll cover a variety of topics, such as:
What are the basics of tables and indexes? How do data type choices directly impact the size, I/O burden, and performance of applications?
What are the most common database design issues that surface in application code? How can you detect them?
What are the primary techniques database designers use to improve performance when optimizing a database design?
If you are a DBA, do you have scripts you can run to perform these checks? If you are a Dev, do you know which common design choices are actually pitfalls? If not, then you should attend! This session takes you through a variety of demos that show what sort of anti-patterns are common in applications you buy on the open market, how to detect them and, when possible, how to refactor those problems. Don’t miss out!