In this video, Adam introduces his SQL Server environment to show the server version he's working with. He also shows where to get the two sample databases from the Microsoft GitHub repository that is used throughout the course.
- [Instructor] If you'd like to follow along on your own computer, then you're going to need access to a SQL Server instance and Management Studio. I'm going to be using SQL Server 2019 and Management Studio version 18, but you can use whatever's easily available. You will need a couple of sample databases and you can see I have mine installed right over here. You can get your own copies from the Microsoft SQL Server samples repository on GitHub. From this URL, you're going to scroll down a little bit and we're going to follow the links for both the wide-world importers database as well as AdventureWorks database. Let's start with wide-world importers. I'll click on that link and then scroll down on this page. We'll find the link for the latest release here. And then on this page we'll scroll down a little bit, and I'll find the link to the WideWorldImportersDW, for data warehouse, dash Full.bak file. Go ahead and download that to your computer. Then we'll click on the back button a couple of times to go back to that first page, and we'll follow a similar path for AdventureWorks. We'll go into the AdventureWorks page and scroll down here. Then I'll find the link to download the backup files and click that. And this time I'll scroll down and I'll find the link to the AdventureWorksDW2017.bak file. Go ahead and download that one as well. These two databases will give us two different looks to the examples of data warehouse implementations that we can compare. Once they're downloaded, you need to move them into the SQL Server backup folder. You can find that by starting at your C: drive and going into Program Files, then into Microsoft SQL Server, then into the folder that represents your server instance. Mine is simply called MSSQLSERVER. There we'll go into the MSSQL folder and then finally into Backup. This is where you'll paste the copies of your two backup files that we just downloaded. Now we can restore them in Management Studio. To do that, you'll right click on the Databases folder, choose Restore Database, then switch over to the Source as a Device and click on the ellipses button on the right. I'll click the Add button on this window and then I'll choose the first backup file. Let's start with AdventureWorks and press OK. Now press OK one more time here and then OK again to restore the database. You'll do the same thing for the wide-world importers backup. Now I've already restored both of those, so I'm just going to press the Cancel button here. That'll set up your database server with the two sample databases. The last thing that you'll need for the course are the exercise files that I provided. I've gone ahead and placed a copy of those here on my desktop. Once you've got everything setup, you'll be ready to follow along as we explore data warehouses in SQL Server.
- Transactional databases vs. data warehouses
- Star and snowflake schemas
- Creating a data warehouse
- Designing tables and views
- Rebuilding columnstore indexes
- Creating an Azure SQL Data Warehouse
- Establishing control flow beyond ETL
- Enforcing data quality
- Configuring Master Data Services
- Consuming data from the warehouse in BI services