Chapter 9. Mastering MySQL
Chapter 8 provided you with a good grounding in the practice of using relational databases with SQL. Youâve learned about creating databases and the tables that comprise them, as well as inserting, looking up, changing, and deleting data.
With that knowledge under your belt, itâs time to look at how to design databases for maximum speed and efficiency. For example, how do you decide what data to place in which table? Well, over the years, a number of guidelines have been developed thatâif you follow themâensure that your databases will be efficient and capable of scaling as you feed them more and more data.
Get Learning PHP, MySQL, JavaScript, and CSS, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.