What I Wish Someone Told Me About SQL Database Design

By Scott Keck-Warren

As shocking as this may be, not every team has a dedicated database administrator. I’ve never worked on a team that has had someone solely focused on making sure our queries are performant, and our tables are structured perfectly with all the forms of normalization being applied. Like many developers, I have had to learn difficult lessons about database design the hard way when under a lot of pressure to get something that’s broken fixed. In this article, we will go over how to normalize our database, how to use indexes to improve our performance and discuss using constraints to make sure that the data entered into our database follows our business rules. Knowing these three things will make our lives as developers who also administer databases easier.

Read in Full

This article was originally published in the October 2021 issue of php[architect] magazine. To read the complete article please subscribe or purchase the complete issue.

Leave a comment

Use the form below to leave a comment: