May 2003
Intermediate to advanced
592 pages
14h 28m
English
This chapter picks up where its predecessor left off, discussing more advanced SQL and MySQL topics. While the basics of both technologies will certainly get you by, it’s these more complex features that will take your Web applications to the next level.
I’ll begin by discussing database design in greater detail, using a content management system as an example. This naturally leads into the SQL topic of joins, an integral part of any relational database. The bulk of the material will then introduce some of MySQL’s built-in functions. Finally, you’ll learn about indexes and how to change the structure of existing tables.
Read now
Unlock full access