System information

31
CHAPTER 3
Database Fundamentals
This chapter provides a quick overview of relational database concepts and terms. It describes
what a database is and how it is organized. It also discusses the Structured Query Language (SQL)
that you use to interact with databases.
Contents
About database basics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
About SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Using SQL with ColdFusion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
About database basics
Even though you do not need a thorough understanding of database management systems to
create ColdFusion applications, you must understand some basic concepts and techniques about
databases. The information in this chapter will help you get started using ColdFusion.