SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition

In Closing

“That is what learning is. You suddenly understand something you’ve understood all your life, but in a new way.”

—DORIS LESSING

You now have all the tools you need to query or change data in a database successfully. You’ve learned how to create both simple and complex SELECT statements and how to work with various types of data. You’ve also learned how to filter data with search conditions, work with multiple tables using JOINs, and produce statistical information by grouping data. You learned how to update, add, and delete data in your tables. And finally, you learned to “think out of the box” to build solutions to “NOT” and “AND” problems, use condition testing, work with unlinked tables, perform complex grouping, and look at “windows” ...