14 Working with Databases

Chapter Objectives

In this chapter you will learn . . .

This chapter covers the core principles of relational Database Management Systems (DBMSs), which are essential components of most dynamic websites. We will cover the essential, core concepts that you will need to know to build dynamic, database-driven sites. To begin, you will learn about Structured Query Language (SQL), which is the standard way for working with relational databases. Finally, the chapter will cover NoSQL, a newer approach to working with data. Databases taught at the university level go far beyond the scope of this practical, hands-on chapter. We cannot hope to cover all database concepts, and so we focus on key terms, principles, and tools that allow you to get working with databases right away. Nonetheless, this is among the lengthiest chapters in the book; this material is, however, essential for creating any dynamic website.