This section contains the SQL code to create the databases used in each lesson, along with objects such as tables, views, stored procedures, triggers, and functions, and, lastly, the BCP script to import data from the text files in the zip file in this section.

The HOBBY_SHOP database is also included but not used in this module. It would be a good idea to create triggers similar to the ones in the lessons, but against the HOBBY_SHP database, which has more data.

Below is a breakdown of the databases used in each lesson:

M4 L1 - TEST DB

M4 L2 - TEST DB

M4 L3 - TEST DB

M4 L4 - TEST DB

M4 L5 - TEST DB

M4 L6 - TEST DB

M4 L7 - TEST DB

M4 L8 - TEST DB

M4 L9 - InventoryM4 DB, all tables created in example script

M4 L10 - TEST DB

M4 L10 - TEST DB

M4 L11 - TEST DB