O'Reilly logo

SQL For Dummies, 8th Edition by Allen G. Taylor

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

Chapter 24

Ten Retrieval Tips

In This Chapter

arrow Verifying the structure of your database

arrow Using test databases

arrow Scrutinizing any queries containing joins

arrow Examining queries containing subselects

arrow Using GROUP BY with the SET functions

arrow Being aware of restrictions on the GROUP BY clause

arrow Using parentheses in expressions

arrow Protecting your database by controlling privileges

arrow Backing up your database regularly

arrow Anticipating and handling errors

A database can be a virtual treasure trove of information, ...

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