From the course: Implementing a Data Warehouse SQL Server 2019

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Create a data warehouse in SQL Server

Create a data warehouse in SQL Server - SQL Server Tutorial

From the course: Implementing a Data Warehouse SQL Server 2019

Start my 1-month free trial

Create a data warehouse in SQL Server

“

- [Narrator] A data warehouse is created just like any other database in Sequel Server. We use the same SQL commands that you're probably already familiar with in order to create the database, build the fact and dimension tables, and join them together with relationships. So let's get started with a new data warehouse here in Management Studio, by creating a database for a company called KinetEco. To do that, I'll come over here to the Object Explorer pane, and right-click on the Databases folder, and choose New Database. I'll give the database a name, KinetEcoDW. Then for the row file and the log file, we could set the size to something larger than the default of 8 megabytes, if you have any idea about how much space you're going to need. But the auto growth settings will automatically size the files as needed to fit the data. And because the data file will only be growing when the ETL process loads data into the data…

Contents