Chapter 24
Ten Retrieval Tips
In This Chapter
Verifying the structure of your database
Using test databases
Scrutinizing any queries containing joins
Examining queries containing subselects
Using GROUP BY with the SET functions
Being aware of restrictions on the GROUP BY clause
Using parentheses in expressions
Protecting your database by controlling privileges
Backing up your database regularly
Anticipating and handling errors
A database can be a virtual treasure trove of information, ...
Get SQL For Dummies, 8th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
