RailsConf 2019 - Database Design for Beginners by David Copeland

David Copeland explains the fundamentals of database design, schema management, and SQL best practices for beginners.

RailsConf 2019 - Database Design for Beginners by David Copeland _______________________________________________________________________________________________ Cloud 66 - Pain Free Rails Deployments Cloud 66 for Rails acts like your in-house DevOps team to build, deploy and maintain your Rails applications on any cloud or server. Get $100 Cloud 66 Free Credits with the code: RailsConf-19 ($100 Cloud 66 Free Credits, for the new user only, valid till 31st December 2019) Link to the website: cloud66.com/rails?utm_source=-&utm_medium=-&utm_campaign=Rai… Link to sign up: app.cloud66.com/users/sign_in?utm_source=-&utm_medium=-&utm_… _______________________________________________________________________________________________ Rails’ migrations were a revelation when Rails came out, as it provided a way to manage your database schema, but also included many wonderful defaults that made all Rails developers pretty good at database schema design! But these defaults are just the beginning. Properly modeling your database can bring many benefits, such as fewer bugs, more reliable insights about your users or business, and developer understanding. We’ll talk about what makes a good database design by understanding the concept of normalization and why a properly normalized database yields benefits.