HOLs

Home/HOLs

Hands-On-Lab: SSIS Data Loading – Part 1

Hello Friends, Here is another popular lab from Hands-On-Lab library: SSIS Data Loading – Part 1. Extracting and loading data is one of the first step in an ETL process. SSIS allows to extract and load data from many different data sources. However, in this lab, we’ll learn to extract data from Excel and XML [...]

Hands-On-Lab: SSIS Data Flow Transformations – Part 2

Hello Friends, Here is another popular lab from Hands-On-Lab library: SSIS Data Flow Transformations – Part 2. The Fuzzy lookup transformation is used to perform data cleansing such as standardizing data, correcting data or finding missing values. The Fuzzy grouping transformation is used to find duplicate records. In the first exercise, we’ll use Fuzzy lookup [...]

Hands-On-Lab: SSIS Data Flow Transformations – Part 1

Hello Friends, Here is another popular lab from Hands-On-Lab library: SSIS Data Flow Transformations – Part 1. Data Flow Task is used to move data from a source to a destination while applying various transformations on the data being moved as and when required. The lab talks about available sources, transformations and destinations available in [...]

Hands-On-Lab: Slowly Changing Dimensions in SSIS

Hello Friends, Here is another popular lab from Hands-On-Lab library: Slowly Changing Dimensions in SSIS. A dimension is considered to be a Slowly Changing Dimensions in SSIS when the attributes change over a period of time. The SCD are categorized based on the methodology of historical records maintenance. Slowly Changing Dimensions in SSIS transformation helps [...]

Hands-On-Lab: Implementing Incremental Data Load and Inner Join in SSIS

Hello Friends, Here is another popular lab from Hands-On-Lab library: Implementing Incremental Data Load and Inner Join in SSIS. In this Lab, we’ll learn about two of the most used transformation in SSIS, Lookup and Merge Join Transformations. In the first exercise, we’ll learn to implement incremental data load using Lookup Transformation. Incremental data load [...]

Hands-On-Lab: Error and Event Handling in SSIS

Hello Friends, Here is another popular lab from Hands-On-Lab library: Error and Event Handling in SSIS. In this lab, we’ll learn to effectively use precedence constraints, implement error and event handling and logging. Precedence Constraints are the arrows used to connect two or more tasks in Control Flow and Data Flow. Precedence constraints govern the [...]

Hands-On-Lab: Calling Web Service From SSIS

Hello Friends, Here is another popular lab from Hands-On-Lab library: Calling Web Service From SSIS. In this lab, we’ll learn how to call a web service from SSIS. In the first exercise, we will learn how to use SSIS inbuilt component Web Service Task to call the Web Service and get the data in XML [...]

Hands-On-Lab: Advanced Data Cleansing In SSIS

Hello Friends, Here is another popular lab from Hands-On-Lab library: Advanced Data Cleansing In SSIS. In this lab, we’ll learn to implement DQL Cleansing transformation and the DQS knowledge base to clean dirty data. DQS Cleansing transformation helps in cleansing the dirty data. It takes the knowledge base created in the Data Quality client with [...]

Hands-On-Lab: XML and Xquery in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: XML and Xquery in SQL Server. Extensive markup language(XML) is a language used to encode the documents in such a way that both Humans and Machines can read the data. XML was designed to store and transport the data. XQuery is a query used to [...]

Hands-On-Lab: Working with NULL in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Working with NULL in SQL Server. NULL is not a value, it only means that a value was not provided when the row was created. Special attentions need to be taken into account when dealing with nulls in SQL Server. One needs to remind that [...]

Hands-On-Lab: Working with Date and Time Datatypes in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Working with Date and Time Datatypes in SQL Server. This lab focusses on date and time datatypes and functions available in SQL Server and how to effectively use the functions to solve real-world problems. The lab is divided into four exercise. In the first exercise, [...]

Hands-On-Lab: Views in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Views in SQL Server. In Transact-SQL (T-SQL) a view allows us to create a virtual representation of table whose contents are defined by the query. The query that defines the view can be joined from one or more tables. Once a view is created we [...]

Hands-On-Lab: User Defined Functions in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: User Defined Functions in SQL Server. In Transact-SQL (T-SQL) User-Defined Functions allows to define our own function to perform logical calculations and it returns the result set of an action as a value. Scalar User-Defined Function, Inline table valued function and Multi-statement table valued function [...]

Hands-On-Lab: Updating Data in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Updating Data in SQL Server. In Transact-SQL (T-SQL) UPDATE allows us to change the existing data in a table. This lab is divided into seven exercises explaining different ways to update the data. In first exercise we will learn to update a column data using [...]

Hands-On-Lab: TOP and APPLY Operators in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: TOP and APPLY Operators in SQL Server. In Transact-SQL (T-SQL) TOP allows us to limit the number of rows from the query result-set. The APPLY operator allows us to invoke a table-valued functions for each row returned by the outer table expression of a query. [...]

Hands-On-Lab: Table Expressions in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Table Expressions in SQL Server. In Transact-SQL (T-SQL), Table Expressions holds the query expressions as a relational table for data manipulation. This lab is divided into nine exercises explaining different scenarios where table expressions are useful. Exercise 1: Derived Tables with Inline column aliases Exercise [...]

Hands-On-Lab: Subqueries in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Subqueries in SQL Server. Transact-SQL (T-SQL) supports writing queries with in queries or nested inside a SELECT, INSERT, UPDATE and DELETE. This lab is divided into five exercises. In the first exercise we will look at self-contained scalar subquery, problems that it can solve and [...]

Hands-On-Lab: SQL Server Temporary Tables

Hello Friends, Here is another popular lab from Hands-On-Lab library: SQL Server Temporary Tables. In Transact-SQL (T-SQL), temporary tables let users store and process intermediate results. Users can perform all the operations on temporary tables as like in SQL server tables. This lab is divided into seven exercises. In the first exercise, we will learn [...]

Hands-On-Lab: SQL Server Temporary Tables and Table Variables

Hello Friends, Here is another popular lab from Hands-On-Lab library: SQL Server Temporary Tables and Table Variables. As a TSQL Developer or DBA, while writing TSQL code for the business login or DBA maintenance tasks, we come across the situation to work on temporary data. To accomplish this, we generally use temporary table or table [...]

Hands-On-Lab: SQL Server Stored Procedures

Hello Friends, Here is another popular lab from Hands-On-Lab library: SQL Server Stored Procedures. A Stored Procedure is a group of one or more T-SQL statements into a logical unit. Stored Procedure accepts three types of parameters input parameters, output parameters and table-valued input parameters. 1. Input parameters pass data into a stored procedure and [...]