O'Reilly logo

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Fourth edition by John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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” ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required