Structuring Databases For Apps

Applications are just user interfaces powered by databases. Every tweet, picture upload, email, and bank transaction are just pieces of data sitting in a database somewhere.

This book teaches the fundamental knowledge and skills to design any application or system: table design, querying with SQL, and forming data relationships.

These concepts are applicable to any relational database or framework ORM built on top of one.

Throughout this book we build an employee directory. Each chapter poses an example scenario and then explains the underlying table structure and SQL needed to properly form these relationships. Work alongside the book and test your knowledge with practice questions at the end of the chapter.

Every query or structure shown in a chapter is also included in a matching SQL file free with your download.

Contents

• Intro - Why is this important?
• Setup & Installation
• Introduction to Databases and SQL (skippable if you already know it)
• One to One ("Belongs to")
• Many to Many ("Has and belongs to many")
• Polymorphic (and its pitfalls)
• Self Join
• JSON Columns
• Indexes
• Data Cleanup
• Conclusion

Refund Policy

If you're not 100% satisfied with the purchase, or it's not what you were expecting, just reply to the download email within 30 days for a full refund. No questions asked.

What others are saying