-
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
-
Using Built-In Functions
This module introduces the use of functions that are built in to SQL Server Denali, and will discuss some common usages including data type conversion, testing for logical results and nullability.
Lessons
- Writing Queries with Built-In Functions
- Using Conversion Functions
- Using Logical Functions
- Using Functions to Work with NULL
Lab : Using Built-In Functions
After completing this module, you will be able to:
- Write queries with built-in scalar functions.
- Use conversion functions.
- Use logical functions.
- Use functions that work with NULL.