Here is another popular lab from Hands-On-Lab library: SQL Server Data Types – Part 2.
Data types are used to defined what type of data a column can store. As like in any other language SQL server also has data types. This lab is divided into five exercise. In this first exercise we will learn about HIERARCHYID datatype. In the second exercise we will learn various numeric datatypes. In the third exercise we learn about BINARY and VARBINARY datatypes and performance differences between them. In the fourth exercise we will learn SQL_VARIANT, TABLE, UNIQUEIDENTIFIER datatypes. In the fifth exercise, we will learn about spatial datatypes such GEOMETRY and GEOGRAPHY data types.
Exercise 1: HIERARCHYID Data Type
Exercise 2: Numeric Data Types
Exercise 3: BINARY and VARBINARY Data Types
Exercise 4: SQL_VARIANT, TABLE and UNIQUEIDENTIFIER data types
Exercise 5: Introduction to Spatial Data Types
SQLMaestros Hands-On-Labs enables the practical way of learning. 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. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.