Appendix CSQL Code Used in Try This Exercises

Copyright © 2009 by The McGraw-Hill Companies. Click here for terms of use.

In the Try This exercises throughout this book, you created a number of SQL statements that allowed you to define database objects in the INVENTORY database, modify those objects, insert data into the tables that you created, retrieve that data, and update and delete the data. The statements are included here so that you can see the progression of the statements as you move through the Try This exercises and also so that you can reference them as necessary in case you need to redo certain elements of an exercise. In addition, I've provided the SQL statements (in a consolidated form) used to create the INVENTORY database and ...

Get SQL: A Beginner's Guide, Third Edition, 3rd 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.