Workshop in English - US at Longhorn PHP Conference 2019
View Slides: https://www.slideshare.net/MarkNiebergall/relational-database-design-bootcamp
Checkout the code: https://github.com/mbniebergall/database-bootcamp
Short URL: https://joind.in/talk/9d7a6 (QR-Code (opens in new window))
Nearly every application uses some sort of data storage. Proper data structure can lead to increased performance, reduced application complexity, and ensure data integrity. Foreign keys, indexes, and correct data types truly are your best friends when you respect them and use them for the correct purposes. Structuring data to be normalized and with the correct data types can lead to significant performance increases. Learn how to structure your tables to achieve normalization, performance, and integrity, by building a database from the ground up during this tutorial.
Comments are closed.
Very good entry level database design tutorial. I know Mark ran out of time and therefore we did not cover some of the topics at the end of the session. I wish the level would have been more intermediate.
I 2nd @MarionSartor! Thank you for the data modeling refresher, Mark. I really appreciate it. You simplified it - the complete opposite of my DA Manager :-)