From the course: Microsoft SQL Server 2022 Essential Training
Unlock this course with a free trial
Join today to access over 24,100 courses taught by industry experts.
Install a sample database - SQL Server Tutorial
From the course: Microsoft SQL Server 2022 Essential Training
Install a sample database
- Learning about SQL Server is often easier when you have lots of data to peruse or can dig into an existing database to see how it was put together. Microsoft provides an example database that's useful to have on hand for experimentation or to explore topics in database development. Let me show you how you can add it to your SQL Server instance. The process starts at Microsoft's SQL Server Samples GitHub page at this URL. Here, you'll find the Wide World Importers sample database that's frequently used in Microsoft's own example documentation. On this page, you'll just scroll down until you find the Wide World Importers-Full.bak file. This is a database backup that we can restore on our own instance of SQL Server. I'll go ahead and click the link to download the file to my system. Once that's done, we need to move this file into a specific location on our hard drive. I'll go ahead and close my web browser and…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Create the first database7m 55s
-
(Locked)
Database configuration options7m 29s
-
(Locked)
Table structures5m 23s
-
(Locked)
Create a simple table8m 8s
-
(Locked)
Edit a table's structure2m 56s
-
(Locked)
Enter data into a table using the GUI4m 10s
-
(Locked)
Import data from CSV files8m 49s
-
(Locked)
Create tables from flat files4m 44s
-
(Locked)
Install a sample database3m 33s
-
-
-
-
-
-
-
-