In this video, Adam walks through the process of obtaining and installing the example database, Wide World Importers, from Microsoft’s Github repository.
- [Instructor] Since we'll be exploring many different facets of SQL Server it'll be helpful to have a database full of tables and records that are disposal to play around with. Microsoft provides an example database for exactly these sorts of reasons and it's used in a variety of examples an tutorials found throughout the Microsoft training materials. You can find information about the database which follows the fictitious Wide World Importers Company at this website here. After you've read about the company switch over to the github page to download your own copy of the backup database. On this page I'll scroll down and find the version that we're interested in.
There's several different versions that correspond to the different editions of SQL Server. This first one here is for the evaluation, developer and enterprise editions. And then we also have one down here that'll be for the standard edition which will also work for Express. Inside of each of these sections there's actually two different files. One of them ends in a DW which stands for data warehouse. That's a function that we're not going to be concerned with in this course so let's just go ahead and just focus on the other file. In my case, I want the one for the developer edition so I'll download this one here called WideWorldImporters-full.bak. I'll click on it and it'll download into the default downloads folder on my computer.
Once it's done downloading we need to move it into a location that SQL Server can access. To do that we'll go out to file explorer. Then we'll go into our downloads folder and find the file we just downloaded. I'll right click on it and choose cut to cut it to the clipboard. Then we'll browse out to our local C drive, we'll go into program files and then Microsoft SQL Server. It's under there you'll see lots of different folders and we want to find the folder that corresponds to the incense of SQL Server that we're going to be using. Now in my case, that's a folder called MSSQL13.SQL_2016.
The name of my incense is SQL_2016. You might see some similarly named file folders here. For instance this one here called MSRS and this one here called MSAS. These stand for analysis services and reporting services. These are different functions within SQL Server. For now, I'm going to focus on the one in the server folder itself which is this one here. I'll double click on it to go inside of it and then inside the MSSQL folder I'll find a folder called backup. The first time I try and go in here it's going to tell me that I don't have permissions to access the folder but I can go ahead and press continue to get access.
I'll press continue and that'll let me in. Then I'll simply right click and choose paste to past in our backup file. Next we need to load this backup and we'll do that inside of SQL Server Management Studio. After logging in to Management Studio with my administrator account I'll right click on the databases folder and choose restore database. Then, we'll choose our source as a device and we'll come over to the far right hand side and press the build button with the three ellipsis dots. That'll allow us to specify a backup media type as a file and we'll press add. That should drop us right back into that backup folder that we were just in.
And we can choose the WideWorldImporters-full.bak file. Go ahead and press okay and that'll get added to the backup media list. I'll press the okay button and SQL Server will go ahead and process that file and we'll press okay one more time. That'll go through the process of restoring the the backup database. We can see a progress bar at the top of the screen to keep our eye on the status. Then when it's done we should get this message that says the database was restored successfully. Go ahead and press the okay button and then expand the databases folder inside of the object explorer on the left side of the screen. We should now see a new database here for Wide World Importers.
We'll use this database in addition to some other temporary databases throughout this course.
Note: This course will also help you prepare for the Developing Microsoft SQL Server Databases exam—a crucial component of the MCSA: Solutions Associate certification. Find out more about the certification at https://www.microsoft.com/en-us/learning/exam-70-762.aspx.
- Creating and altering tables
- Creating calculated columns
- Implementing advanced features like temporary tables, table variables, and compression
- Working with database views
- Ensuring data integrity through constraints
- Creating secure user accounts
- Implementing data types
- Writing stored procedures
- Creating in-memory tables
- Indexing and index optimization
- Optimizing query performance
- Designing and implementing user-defined functions (UDFs)
- Monitoring database performance