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

Get SQL For Dummies, 8th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.