Many programmers struggle when accessing data in relational databases. Either the database doesn’t provide fast performance, doesn’t meet the needs, is filled with illogical data, or is far more complicated that the problem it was intended to solve. But why? As it turns out, the classic standards of database design and normalization really are a “gold standard” that many struggle with, either because they don’t know what the standards are, don’t want to apply them to their designs because they seem old-fashioned, or are handed an application that has an already completed but inadequate design.
In Part 2 of this 2 part series, we provide an overview of how to design a relational database, allowing your data structures to ease your job instead of make it harder. You’ll be able to use SQL naturally so that the query engine can better optimize your SQL code without you needing to spend a lot of time thinking about it.
(Click here for Part 1 )
By attending this session, you’ll spend less time fiddling with messy SQL code, like SUBSTRING(column,3,1) = 'A', that is killing your performance, and more time solving high-value customer problems. Join us!
Interested in additional SentryOne webinars? Check our webinar library.