Catálogo de publicaciones - libros

In this chapter, you’ve taken a whirlwind tour through the DDL “subset” of SQL, yet you’ve hardly scratched the surface. As I noted at the beginning of the chapter, if you look at the scripts provided in the code download, you’ll see that even for this small database, the scripts are complex—certainly more complex than you’ve seen here.

You’ve looked at the basics of DDL, and you’ve seen how to create, modify, and delete databases and tables in both SQL Server and MySQL. You’ve also seen how you can create indexes on tables and relationships between the different tables in the database.

Remember the following points when using DDL:

You’ve just about finished with your look at databases, and in the next chapter you’ll learn about several topics that will improve how you handle databases. You’ll look at concurrency, caching, transactions, and multiple result sets and see that these more advanced topics can improve the Web sites that you’re building quite dramatically.

In this chapter, we’ve looked at a few topics that will broaden your knowledge and help you build better Web sites. Here, you learned the following:

This chapter completes this book’s coverage of specific techniques for building data-driven Web sites. The next and final chapter provides some guidance on how to put it all together into a well-designed and well-implemented application.

In this chapter, we’ve looked at a few topics that will broaden your knowledge and help you build better Web sites. Here, you learned the following:

This chapter completes this book’s coverage of specific techniques for building data-driven Web sites. The next and final chapter provides some guidance on how to put it all together into a well-designed and well-implemented application.