-
MODULES
11-
Introduction to Microsoft SQL Server 2016 30 minLecture1.1
-
Introduction to T-SQL Querying 30 minLecture1.2
-
Writing SELECT Queries 30 minLecture1.3
-
Querying Multiple Tables 30 minLecture1.4
-
Sorting and Filtering Data 30 minLecture1.5
-
Working with SQL Server 2016 Data Types 30 minLecture1.6
-
Using DML to Modify Data 30 minLecture1.7
-
Using Built-In Functions 30 minLecture1.8
-
Grouping and Aggregating Data 30 minLecture1.9
-
Using Subqueries 30 minLecture1.10
-
Using Set Operators 30 minLecture1.11
-
Working with SQL Server 2016 Data Types
This module explains the data types SQL Server uses to store data. It introduces the many types of numeric and special-use data types. It also explains conversions between data types, and the importance of type precedence.
Lessons
- Introducing SQL Server 2016 Data Types
- Working with Character Data
- Working with Date and Time Data
Lab : Working with SQL Server 2016 Data Types
After completing this module, you will be able to:
- Describe numeric data types, type precedence and type conversions.
- Write queries using character data types.
- Write queries using date and time data types.