SQL Server Sample Databases (經典 / 示範資料庫)

Hi, Do you have a minute to talk about Northwind Database?

Sure, What do you want to know?

Well, I’m curious about how it works and what kind of data it contains.

OK, let me give you a brief overview. Northwind Database is a sample database that was originally created by Microsoft.

Really? What was the purpose of creating it?

It was used as a basis for their tutorials in a variety of database products for decades. The database contains sales data for a fictitious company called Northwind Traders.

Wow, that sounds interesting. What kind of products does Northwind Traders sell?

They sell specialty foods from around the world. You can find products like cheese, tea, seafood, spices and more in their database.

That makes me hungry. How do they import and export these products?

They have suppliers and customers in different countries. The database has tables for suppliers, customers, orders, products and more.

Hi, Do you have some time to talk about Adventure Works Database?

Hi, Sure, I do. What do you want to talk about?

Well, I’m interested in learning more about this database and how to use it.

OK, let me give you some background information. Adventure Works Database is a sample database that was created by Microsoft.

Really? What was the reason for creating it?

It was designed to provide an example of an online transaction processing (OLTP) database. It supports a fictitious multinational manufacturing company called Adventure Works Cycles.

Wow, that sounds cool. What kind of products does Adventure Works Cycles make?

They make bicycles and bicycle components You can find products like frames, wheels, brakes and more in their database.

That sounds fun. How do they sell and deliver these products?

They have customers and vendors in different countries. The database has tables for customers, vendors, sales orders, purchase orders and more.

I see. How can I access this database?

Well, if you have SQL Server installed on your computer, you can download it from GitHub by following the instructions there. Or you can create it on Azure SQL Database by using the sample option.

Thanks for the tips. Do you use this database often?

Yes, I do. It’s very helpful for practicing SQL queries and learning about OLTP databases.

Hi, Do you know what Wide World Importers is?

Hi, Yes, I do. It’s a sample database for SQL Server.

Really? What kind of data does it contain?

It contains data about a fictitious company that imports and sells novelty goods. The company has customers and suppliers around the world.

Hi, Do you know what Consoto University is?

Hi, Yes, I do. It’s a fictitious organization that Microsoft uses as an example company name and domain name.

Really? What is the purpose of using it?

It’s used for demonstrating various features and technologies of Microsoft products. For example, it’s used for showing how to use ASP.NET Core and related technologies.

That sounds interesting. How can I learn more about it?

Well, if you are interested in ASP.NET Core development, you can check out this GitHub repository that contains a demo application for Consoto University. It shows how to use different concepts and techniques in a larger context.