From the course: Introduction to Data Warehouses

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

How to create a data warehouse using SQL Server

How to create a data warehouse using SQL Server

From the course: Introduction to Data Warehouses

Start my 1-month free trial Buy for my team

How to create a data warehouse using SQL Server

“

- [Instructor] Now, as we have installed SQL Server and SSMS successfully, hence, it's a time to create our first data warehouse. So let me open the SSMS. For that, go down to your Windows search bar, type in SSMS and it'll show you SQL Server Management Studio. Click open. It'll ask you this server name and authentication. Keep everything default, because at the time of installation we have not given anything. So now on the left-hand side you can see that our database server is got connected. Now go to this database, right click and create new database. Let's take an example of a retail data warehouse. So give the database name as Retail Data Warehouse. Now we will add three tables in inside this data warehouse. For that, just expand the database, go to Retail Data Warehouse, right click on the tables and select new table. It'll ask you the column name. Give the column name as product ID, which is of type…

Contents