SQL: A Beginner's Guide, Fourth Edition, 4th Edition

Appendix C

SQL Code Used in Try This Exercises

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 populate the tables with data. You might find that as you work your way through ...