O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required