Chapter 25

Ten Retrieval Tips


Bullet Verifying the structure of your database

Bullet Using test databases

Bullet Scrutinizing any queries containing joins

Bullet Examining queries containing subselects

Bullet Using GROUP BY with the SET functions

Bullet Being aware of restrictions on the GROUP BY clause

Bullet Using parentheses in expressions

Bullet Protecting your database by controlling privileges

Bullet Backing up your database regularly

Bullet Anticipating and handling errors

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

Get SQL For Dummies, 9th Edition now with the O’Reilly learning platform.

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