Absolute Beginner’s Guide to Databases

Chapter 9. SQL—Going Beyond the Basics

CHAPTER HIGHLIGHTS:

• Organize Output II: Use the Group By Clause

• Use Aggregate Functions

• Filter Results II: Use the Having Clause

• Filter Results III: Create Parameterized SQL Statements

• Modify Data with the Insert, Update, and Delete Statements

• What You Have Learned

In the last chapter, you were introduced to one of the most powerful programming languages in existence—SQL. SQL is the language of databases. If you are going to be a database application developer, it is a language you will need to learn and understand. In the previous chapter, you learned how to select and organize data from multiple tables. In this chapter, you will take those skills a few steps further by learning how to aggregate and summarize ...