Welcome to SQLMaestros Hands-On-Labs

SQLMaestros Hands-On-Labs are packaged in multiple volumes based on roles (DBA, DEV & BIA). Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. SQLMaestros Hands-On-Labs enables the practical way of learning. With our HOL documents you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. The best way to learn is to do-it-yourself, so please stop being lazy and start practicing.

You can purchase one or more ready volumes (predefined) that you are interested in or just purchase selected labs of your choice (whatever your need is). When you make a purchase, we send you a download link and you own the labs (and scripts) for a lifetime. Yes, this is not a subscription service, you own what you buy and it remains with you for life. Isn’t that amazing? Our customers and the community is loving this option.

For Frequently Asked Questions, please Click Here

Free Hands-On-Labs

Download free labs. Try before you buy.

Lab TitleDownload
SSIS Data Flow Transformations – Part 1
Download
SQL Server Extended Events Basics
Download
SQL Server Temporary Tables and Table Variables
Download

 

Purchase Option 1: Buy volumes (see below table)
Purchase Option 2: Buy selected labs (see end of table)


VolumeLabs IncludedPrice
DBA Volume 1

dba 1
  1. Auditing in SQL Server
  2. Backup and Restore Enhancements in SQL Server 2014
  3. Concurrency Problems in SQL Server
  4. DBCC Commands in SQL Server
  5. Delayed Durability in SQL Server 2014
  6. Fixing SQL Server Database Corruption
  7. Improving SQL Server Query Performance with Indexes – Part 1
  8. Introduction to R Services
  9. Managing System Databases in SQL Server
  10. Monitoring SQL Server with Extended Events
  11. SQL Server Memory – Monitoring Buffer Pool

Total Labs: 11

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
DBA Volume 2

dba 2
  1. Improving SQL Server Query Performance with Indexes – Part 2
  2. Moving User Databases in SQL Server
  3. New Security Features in SQL Server 2016
  4. Non-Clustered ColumnStore Indexes in SQL Server 2014
  5. Partitioning in SQL Server
  6. Query Store, Live Query Statistics and Live Query Plans
  7. SQL Server Backup and Restore
  8. SQL Server Basic Query Tuning Techniques
  9. SQL Server Change Data Capture
  10. SQL Server Clustered Index Internals
  11. Migrating On-Premise SQL Server Database To Azure SQL Database

Total Labs: 11

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
DBA Volume 3

dba 3
  1. Securing SQL Server – Part 1
  2. SQL Server Advanced Index Operations
  3. SQL Server Data Encryption
  4. SQL Server Database Maintenance
  5. SQL Server Deadlock Basics
  6. SQL Server Extended Events Basics
  7. SQL Server Latches
  8. SQL Server Non-Clustered Index Internals
  9. SQL Server Parameter Sniffing
  10. SQL Server Point-In-Time Recovery
  11. SQL Server Showplan Operators – Part 1

Total Labs: 11

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
DBA Volume 4

dba 4
  1. SQL Server Deadlock Types
  2. SQL Server Heap Internals
  3. SQL Server Policy Based Management
  4. SQL Server Resource Governor
  5. SQL Server Showplan Operators – Part 2
  6. SQL Server Statistics Internals
  7. SQL Server Storage Internals – Part 1
  8. Temporal Tables in SQL Server 2016 – Part 1
  9. SQL Server Transaction Log Management
  10. SQL Server Wait Types – Part 1

Total Labs: 10

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
DBA Volume 5

dba 5
  1. SQL Server Transaction Log Internals – Part 1
  2. SQL Server Wait Types – Part 2
  3. SQL Server Plan Cache Recompilation and Reuse
  4. Stretch Database
  5. SQL Server Storage Internals – Part 2
  6. Temporal Tables in SQL Server 2016 – Part 2
  7. Troubleshooting Metadata Corruption in SQL Server
  8. Troubleshooting SQL Server with WinDbg
  9. Using Query and Table Hints in SQL Server
  10. SQL Server Thread Life Cycle
  11. SQL Server Tempdb

Total Labs: 11

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
DBA Volume 6

dba 6
  1. Analyzing Minimally Logged Operations in SQL Server
  2. Securing Azure SQL Databases
  3. Constraints in SQL Server
  4. Delete vs Truncate in SQL Server
  5. Logical and Physical Query Processing in SQL Server
  6. Optimizing SQL Server Stored Procedures
  7. SQL Server Advanced Aggregations
  8. SQL Server Advanced Query Tuning
  9. SQL Server DML Optimization
  10. SQL Server Dynamic SQL
  11. SQL Server Execution Plans

Total Labs: 11

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
DEV Volume 1

dev 1
  1. Working with NULL in SQL Server
  2. Concurrency Problems in SQL Server
  3. Improving SQL Server Query Performance with Indexes – Part 1
  4. Introduction to R Services
  5. New Security Features in SQL Server 2016
  6. Non-Clustered ColumnStore Indexes in SQL Server 2014
  7. Partitioning in SQL Server
  8. Query Store, Live Query Statistics and Live Query Plans
  9. SQL Server Basic Query Tuning Techniques
  10. SQL Server Change Data Capture

Total Labs: 10

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
DEV Volume 2

dev 2
  1. Improving SQL Server Query Performance with Indexes – Part 2
  2. SQL Server Backup and Restore
  3. SQL Server Clustered Index Internals
  4. SQL Server Data Encryption
  5. SQL Server Deadlock Basics
  6. SQL Server Heap Internals
  7. SQL Server Non-Clustered Index Internals
  8. SQL Server Parameter Sniffing
  9. SQL Server Showplan Operators – Part 1
  10. SQL Server Statistics Internals

Total Labs: 10

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
DEV Volume 3

dev 3
  1. SQL Server Advanced Index Operations
  2. SQL Server Deadlock Types
  3. SQL Server Showplan Operator – Part 2
  4. SQL Server Plan Cache Recompilation and Reuse
  5. Stretch Database
  6. Temporal Tables in SQL Server 2016 – Part 1
  7. Temporal Tables in SQL Server 2016 – Part 2
  8. Using Query and Table Hints in SQL Server
  9. Constraints in SQL Server
  10. Delete vs Truncate in SQL Server

Total Labs: 10

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
DEV Volume 4

dev 4
  1. Deleting Data in SQL Server
  2. Error Handling in SQL Server
  3. Inserting Data in SQL Server
  4. JSON Support in SQL Server 2016
  5. LAG and LEAD Functions in SQL Server
  6. Logical and Physical Query Processing in SQL Server
  7. Merging Data in SQL Server
  8. OFFSET and FETCH in SQL Server
  9. SQL Server Thread Life Cycle
  10. SQL Server Tempdb

Total Labs: 10

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
DEV Volume 5

dev 5
  1. Optimizing SQL Server Stored Procedures
  2. Pivoting in SQL Server
  3. Working With SEQUENCE in SQL Server
  4. SQL Server Advanced Aggregations
  5. SQL Server Advanced Query Tuning
  6. SQL Server Data Types – Part 1
  7. SQL Server DDL Triggers
  8. SQL Server DML Optimization
  9. SQL Server Dynamic SQL
  10. SQL Server Execution Plans

Total Labs: 10

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
DEV Volume 6

dev 6
  1. SQL Server Aggregations
  2. SQL Server Data Types – Part 2
  3. SQL Server DML Triggers
  4. SQL Server Joins
  5. SQL Server Ranking Functions
  6. SQL Server Set Operators
  7. SQL Server Stored Procedures
  8. SQL Server Temporary Tables and Table Variables
  9. Subqueries in SQL Server
  10. Table Expressions in SQL Server

Total Labs: 10

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
DEV Volume 7

dev 7
  1. SQL Server Performance Tuning using Trace Flags
  2. SQL Server Temporary Tables
  3. TOP and APPLY Operators in SQL Server
  4. Updating Data in SQL Server
  5. User Defined Functions in SQL Server
  6. Views in SQL Server
  7. Working with Date and Time Datatypes in SQL Server
  8. XML and Xquery in SQL Server
  9. SQL Server Extended Events Basics

Total Labs: 9

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
BIA Volume 1

bia 1
  1. Advanced Data Cleansing In SSIS
  2. Error and EventHandling in SSIS
  3. Slowly Changing Dimension In SSIS
  4. SSIS Data Flow Transformations Part 1
  5. SSIS Data Loading – Part 1
  6. Task Group Sequence and For loop Containers in SSIS
  7. Sales Dashboard in Power BI
  8. Streaming Data From SQL Server To Power BI
  9. Deploying Predictive Model As Web Service with Azure ML Studio

Total Labs: 9

Regular Price: USD 99
Offer Price: USD 24

Buy Now
   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
BIA Volume 2

bia 2
  1. Calling WebService From SSIS
  2. Implementing Incremental Data Load and Inner Join in SSIS
  3. SSIS Data Flow Transformations Part 2
  4. SSIS Foreach Loop Container
  5. Financial Dashboard in Power BI
  6. Power BI Administration
  7. Shape and Transform Data in Power BI
  8. Web and Social Analytics Dashboard in Power BI
  9. Implementing Linear Regression with Azure Machine Learning Studio

Total Labs: 9

Regular Price: USD 99
Offer Price: USD 24

Buy Now[/fusion_button]   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
BIA Volume 3

bia 3
  1. Managing Relationships in Power BI
  2. Predicting Diamond Rates with Azure ML Studio
  3. Create and Manage Azure SQL Data Warehouse
  4. Load Data into SQL Data Warehouse with Data Factory
  5. Azure SQL Database Backup and Restore
  6. Move Data Between On-Premise and Cloud using Azure Data Factory
  7. Transform Data in Azure Data Factory using Visual Studio – Hive Activity
  8. Transform Data Using Azure Data Factory

Total Labs: 8

Regular Price: USD 99
Offer Price: USD 24

Buy Now[/fusion_button]   

By purchasing this volume, you get to download the mentioned labs and associated scripts. You get to keep them forever.
Do you just need a few selected labs instead of a whole volume? No worries. You can purchase a single lab @ USD 4. Buy as many as you want, you can choose depending on your need.

Regular Price: USD 15. Offer Price: USD 4

Lab TitleCategoriesBuy Now
Auditing in SQL ServerAdministration, SQL ServerBuy Now
Backup and Restore Enhancements in SQL Server 2014Administration, SQL Server 2014Buy Now
Concurrency Problems in SQL ServerAdministration, SQL ServerBuy Now
DBCC Commands in SQL ServerAdministration, SQL ServerBuy Now
Delayed Durability in SQL Server 2014Administration, SQL ServerBuy Now
Fixing SQL Server Database CorruptionAdministration, SQL ServerBuy Now
Improving SQL Server Query Performance with Indexes - Part 1Administration, SQL ServerBuy Now
Improving SQL Server Query Performance with Indexes - Part 2Administration, SQL ServerBuy Now
Introduction to R ServicesAdministration, SQL Server, SQL Server 2016Buy Now
Managing System Databases in SQL ServerAdministration, SQL ServerBuy Now
Monitoring SQL Server with Extended EventsAdministration, SQL ServerBuy Now
Moving User Databases in SQL ServerAdministration, SQL ServerBuy Now
New Security Features in SQL Server 2016Administration, SQL Server 2016Buy Now
Non-Clustered ColumnStore Indexes in SQL Server 2014Administration, SQL Server 2014Buy Now
Partitioning in SQL ServerAdministration, SQL ServerBuy Now
Query Store, Live Query Statistics and Live Query PlansAdministration, SQL Server 2016Buy Now
Securing SQL Server - Part 1Administration, SQL ServerBuy Now
SQL Server Advanced Index OperationsAdministration, SQL ServerBuy Now
SQL Server Backup and RestoreAdministration, SQL ServerBuy Now
SQL Server Basic Query Tuning TechniquesAdministration, SQL ServerBuy Now
SQL Server Change Data CaptureAdministration, SQL ServerBuy Now
SQL Server Clustered Index InternalsAdministration, SQL ServerBuy Now
SQL Server Data EncryptionAdministration, SQL ServerBuy Now
SQL Server Database MaintenanceAdministration, SQL ServerBuy Now
SQL Server Deadlock BasicsAdministration, SQL ServerBuy Now
SQL Server Deadlock TypesAdministration, SQL ServerBuy Now
SQL Server Extended Events BasicsAdministration, SQL ServerBuy Now
SQL Server Heap InternalsAdministration, SQL ServerBuy Now
SQL Server LatchesAdministration, SQL ServerBuy Now
SQL Server Non-Clustered Index InternalsAdministration, SQL ServerBuy Now
SQL Server Parameter SniffingAdministration, SQL ServerBuy Now
SQL Server Point-In-Time RecoveryAdministration, SQL ServerBuy Now
SQL Server Policy Based ManagementAdministration, SQL ServerBuy Now
SQL Server Resource GovernorAdministration, SQL ServerBuy Now
SQL Server Showplan Operator - Part 2Administration, SQL ServerBuy Now
SQL Server Showplan Operators - Part 1Administration, SQL ServerBuy Now
SQL Server Statistics InternalsAdministration, SQL ServerBuy Now
SQL Server Storage Internals - Part 1Administration, SQL ServerBuy Now
SQL Server Storage Internals - Part 2Administration, SQL ServerBuy Now
SQL Server Transaction Log Internals - Part 1Administration, SQL ServerBuy Now
SQL Server Transaction Log ManagementAdministration, SQL ServerBuy Now
SQL Server Wait Types - Part 1Administration, SQL ServerBuy Now
SQL Server Wait Types - Part 2Administration, SQL ServerBuy Now
SQL Server Plan Cache Recompilation and ReuseAdministration, SQL ServerBuy Now
Stretch DatabaseAdministration, SQL Server, SQL Server 2016Buy Now
Temporal Tables in SQL Server 2016 - Part 1Administration, SQL Server 2016Buy Now
Temporal Tables in SQL Server 2016 - Part 2Administration, SQL Server 2016Buy Now
Troubleshooting Metadata Corruption in SQL ServerAdministration, SQL ServerBuy Now
Troubleshooting SQL Server with WinDbgAdministration, SQL ServerBuy Now
Using Query and Table Hints in SQL ServerAdministration, SQL ServerBuy Now
SQL Server Thread Life CycleAdministration, SQL ServerBuy Now
SQL Server TempdbAdministration, SQL ServerBuy Now
SQL Server Memory - Monitoring Buffer PoolAdministration, SQL ServerBuy Now
Analyzing Minimally Logged Operations in SQL ServerDevelopment, SQL ServerBuy Now
Constraints in SQL ServerDevelopment, SQL ServerBuy Now
Delete vs Truncate in SQL ServerDevelopment, SQL ServerBuy Now
Deleting Data in SQL ServerDevelopment, SQL ServerBuy Now
Error Handling in SQL ServerDevelopment, SQL ServerBuy Now
Inserting Data in SQL ServerDevelopment, SQL ServerBuy Now
JSON Support in SQL Server 2016Development, SQL Server 2016Buy Now
LAG and LEAD Functions in SQL ServerDevelopment, SQL ServerBuy Now
Logical and Physical Query Processing in SQL ServerDevelopment, SQL ServerBuy Now
Merging Data in SQL ServerDevelopment, SQL ServerBuy Now
OFFSET and FETCH in SQL ServerDevelopment, SQL ServerBuy Now
Optimizing SQL Server Stored ProceduresDevelopment, SQL ServerBuy Now
Pivoting in SQL ServerDevelopment, SQL ServerBuy Now
Working With SEQUENCE in SQL ServerDevelopment, SQL ServerBuy Now
SQL Server Advanced AggregationsDevelopment, SQL ServerBuy Now
SQL Server Advanced Query TuningDevelopment, SQL ServerBuy Now
SQL Server AggregationsDevelopment, SQL ServerBuy Now
SQL Server Data Types - Part 1Development, SQL ServerBuy Now
SQL Server Data Types - Part 2Development, SQL ServerBuy Now
SQL Server DDL TriggersDevelopment, SQL ServerBuy Now
SQL Server DML OptimizationDevelopment, SQL ServerBuy Now
SQL Server DML TriggersDevelopment, SQL ServerBuy Now
SQL Server Dynamic SQLDevelopment, SQL ServerBuy Now
SQL Server Execution PlansDevelopment, SQL ServerBuy Now
SQL Server JoinsDevelopment, SQL ServerBuy Now
SQL Server Performance Tuning using Trace FlagsDevelopment, SQL ServerBuy Now
SQL Server Ranking FunctionsDevelopment, SQL ServerBuy Now
SQL Server Set OperatorsDevelopment, SQL ServerBuy Now
SQL Server Stored ProceduresDevelopment, SQL ServerBuy Now
SQL Server Temporary Tables and Table VariablesDevelopment, SQL ServerBuy Now
SQL Server Temporary TablesDevelopment, SQL ServerBuy Now
Subqueries in SQL ServerDevelopment, SQL ServerBuy Now
Table Expressions in SQL ServerDevelopment, SQL ServerBuy Now
TOP and APPLY Operators in SQL ServerDevelopment, SQL ServerBuy Now
Updating Data in SQL ServerDevelopment, SQL ServerBuy Now
User Defined Functions in SQL ServerDevelopment, SQL ServerBuy Now
Views in SQL ServerDevelopment, SQL ServerBuy Now
Working with Date and Time Datatypes in SQL ServerDevelopment, SQL ServerBuy Now
Working with NULL in SQL ServerDevelopment, SQL ServerBuy Now
XML and Xquery in SQL ServerDevelopment, SQL ServerBuy Now
Advanced Data Cleansing In SSISSSISBuy Now
Calling WebService From SSISSSISBuy Now
Error and EventHandling in SSISSSISBuy Now
Implementing Incremental Data Load and Inner Join in SSISSSISBuy Now
Slowly Changing Dimension In SSISSSISBuy Now
SSIS Data Flow Transformations Part 1SSISBuy Now
SSIS Data Flow Transformations Part 2SSISBuy Now
SSIS Data Loading - Part 1SSISBuy Now
SSIS Foreach Loop ContainerSSISBuy Now
Task Group Sequence and For loop Containers in SSISSSISBuy Now
Financial Dashboard in Power BIPower BIBuy Now
Managing Relationships in Power BIPower BIBuy Now
Power BI AdministrationPower BIBuy Now
Sales Dashboard in Power BIPower BIBuy Now
Shape and Transform Data in Power BIPower BIBuy Now
Streaming Data From SQL Server To Power BIPower BIBuy Now
Web and Social Analytics Dashboard in Power BIPower BIBuy Now
Deploying Predictive Model As Web Service with Azure ML StudioMachine LearningBuy Now
Implementing Linear Regression with Azure Machine Learning StudioMachine LearningBuy Now
Predicting Diamond Rates with Azure ML StudioMachine LearningBuy Now
Create and Manage Azure SQL Data WarehouseAzure SQL Data WarehouseBuy Now
Load Data into SQL Data Warehouse with Data FactoryAzure Data Factory, Azure SQL Data WarehouseBuy Now
Azure SQL Database Backup and RestoreAzure SQL DatabaseBuy Now
Migrating On-Premise SQL Server Database To Azure SQL DatabaseAzure SQL DatabaseBuy Now
Securing Azure SQL DatabasesAzure SQL DatabaseBuy Now
Move Data Between On-Premise and Cloud using Azure Data FactoryAzure Data FactoryBuy Now
Transform Data in Azure Data Factory using Visual Studio - Hive ActivityAzure Data FactoryBuy Now
Transform Data Using Azure Data FactoryAzure Data FactoryBuy Now
Buy Now