View on GitHub

DP-080: Querying Data with Microsoft Transact-SQL

Companion material and resources for the course 'Endpoint Administrator' delivery by Ricardo Cabral

Back to main


Sample databases

Contains sample databases for Microsoft’s SQL databases include SQL Server, Azure SQL Database, and Azure SQL Data Warehouse.


The new sample database for SQL Server 2016 and Azure SQL Database. It illustrates the core capabilities of SQL Server 2016 and Azure SQL Database, for transaction processing (OLTP), data warehousing and analytics (OLAP) workloads, as well as hybrid transaction and analytics processing (HTAP) workloads.


Sample data warehouse that illustrates loading data into Azure SQL Data Warehouse.


Sample databases and Analysis Services models for use with SQL Server.

AdventureWorks sample databases backup

OLTP Data Warehouse Lightweight
AdventureWorks2022.bak AdventureWorksDW2022.bak AdventureWorksLT2022.bak
AdventureWorks2019.bak AdventureWorksDW2019.bak AdventureWorksLT2019.bak
AdventureWorks2017.bak AdventureWorksDW2017.bak AdventureWorksLT2017.bak
AdventureWorks2016.bak AdventureWorksDW2016.bak AdventureWorksLT2016.bak
AdventureWorks2016_EXT.bak AdventureWorksDW2016_EXT.bak N/A
AdventureWorks2014.bak AdventureWorksDW2014.bak AdventureWorksLT2014.bak
AdventureWorks2012.bak AdventureWorksDW2012.bak AdventureWorksLT2012.bak
AdventureWorks2008R2.bak AdventureWorksDW2008R2.bak N/A

Return to top Back to main