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.