Prerequisites for running the exercises
This book covers many illustrations and examples of working with SQL and improving your overall writing and performance. To make this simple for all our users, we have chosen to use the Wide World Importers sample databases available from Microsoft. Depending on the nature of the query that we are constructing and providing examples for, one of the two databases provided by Microsoft will be used. There is a data warehouse sample as well as an operational database sample that we will be working on, as noted here:
WideWorldImportersWideWorldImportersDW
There are two recommended ways to work through the examples in this book, depending on your access to Azure. We will walk through the installation path and plan for both patterns using the data warehouse database as our example. You will be able to follow the same instructions using the matching operational database. Bear in mind that this means you will have two databases in...
