Sample databases

The first step is to set up sample databases. For this to happen, we need to install SQL Server Management Studio (SSMS). This program is freely available from Microsoft at https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms.

Starting SSMS, connect to your server and right-click on the Databases folder in the Object Explorer. Select Import Data-tier Application... from the contextual menu, as shown in the following screenshot:

The Import Data-tier Application wizard will open. Click on Next.

In the Import Settings step, make sure that the option Import from local disk is selected, and click ...

Get Hands-On Data Warehousing with Azure Data Factory 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.