For the most part, we have tried to keep conventions in this book as simple as possible. Many new terms are identified and are printed in italics. In the listings, all code that you type in (Input) appears in boldface monospace . Output appears in standard monospace. SQL code and keywords have been placed in uppercase for your convenience and general consistency. For example: SELECT * FROM PRODUCTS_TBL; PROD_ID PROD_DESC COST ---------- ------------------------------------ 11235 WITCHES COSTUME 29.99 222 PLASTIC PUMPKIN 18 INCH 7.75 13 FALSE PARAFFIN TEETH 1.1 90 LIGHTED LANTERNS 14.5 15 ASSORTED COSTUMES 10 9 CANDY CORN 1.35 6 PUMPKIN CANDY 1.45 87 PLASTIC SPIDERS 1.05 119 ASSORTED MASKS 4.95 9 rows selected. The following special design features enhance the text: There are syntax boxes to draw your attention to the syntax of the commands discussed during each hour . SELECT [ ALL * DISTINCT COLUMN1, COLUMN2 ] FROM TABLE [ , TABLE2 ]; | Notes are provided to expand on the material covered in each hour of the book. | | Cautions are provided to warn the reader about "disasters" that could occur and certain precautions that should be taken. | | Tips are also given to supplement the material covered during appropriate hours of study. | |