In this video, Adam walks you through the steps of downloading and restoring the sample database to your SQL Server instance so you can follow along throughout the course. Scripts shown on-screen are collected in the course exercise files and illustrate the start and end state for each video. These scripts can be copied and run in a query editor such as SQL Server Management Studio.
- [Instructor] I'll be sharing the various Python scripts and other code files for this course, and you can follow along by downloading a copy from the course overview page. Inside of the Exercise Files folder is a folder for each chapter of the course, and inside of there are the individual script files. Some of these are named Start, and these'll correspond to the state of the file at the start of each movie, and others have the name Complete. This'll be the final text that's shown at the end of each movie. You can open these up in any text editor and copy the text out to your clipboard, and then paste into your SQL query editor. I'm going to be using SQL Server Management Studio for that, or you could also use Azure Data Studio, whichever one you feel more comfortable with. The other thing that you're going to need in order to follow along is the sample database. For that, I'm going to be using Microsoft's Wide World Importer sample database, and you can get a copy of that from the github page, at github.com/microsoft/sql-server-samples. Then on this page, I'm going to scroll down and find the link for the Wide World Importer sample database version 1.0, and then on this page I'll scroll down, and I'll find the link for the WideWorldImporters-Full.bak file. This is a database backup file that we can restore on our SQL Server instance. Now I've already downloaded it, so let's go ahead and go through the process of restoring it. I'm going to open up the Downloads folder on my computer, I'll find the file, and cut it to my clipboard. Then I'll go into my C drive, into Program Files, Microsoft SQL Server, then the folder that represents your server instance, then MSSQL, and finally, Backup. If you see this message that says you don't currently have permission to access the folder, just press the Continue button, and you should be let in, then I'll right-click and paste in the backup file. Then we can open up Management Studio. From here, I'll right-click on the Databases folder in the Object Explorer window, choose Restore Database, we're going to pull this database from a device, and then click on the ellipses button over here on the right. Next our backup media is going to be a file, I'll press Add. That'll place us into the Backup folder, where I put in the backup file that we just copied in, I'll select it, and press OK, I'll press OK again, and OK again to restore the backup. When the restoration completes, you'll have your own copy of the Wide World Importers database over here, and you can expand it to see the different data tables that are inside of this database. And now you'll be ready to use that data with Python.
- Analyzing SQL Server data with Python
- Installing Machine Learning Services
- Writing Python scripts for SQL Server
- Python packages and libraries
- Producing graphics with Matplotlib
- Processing tabular data
- Creating a SQL stored procedure
- Creating an external data science client