Instructions

Module 4: Using Built-in
Functions
In the module you will explore the
use of built-in functions for returning
computed or special values in the
SELECT list or in the WHERE
clause. Functions include math
functions, string functions and
system functions. There are other
types of functions that will be
mentioned, but not discussed in
detail. You will also learn how to
combine rows of data into a single
group, providing summary
information for the group such as
SUM, MIN or MAX.
Lessons
− Getting started with scalar
functions
− Grouping aggregated results
− Lab: Built-in functions
After completing this module,
students will be able to:
− Write queries using scalar
functions
− Write queries using aggregate
functions
− Use GROUP BY to combine
data into groups based on a
common column value
Understand how HAVING is used
to filter groups of rows
Module 5: Modifying Data
In this module, you will learn the T-
SQL statements for modifying table
data including UPDATE, DELETE
and MERGE as well as various
options for INSERT including
creating a new table with data from
an existing table. You will also look
at how to have the system
automatically supply values for
columns as the data is inserted.
Lessons
− Inserting data into tables
− Modifying and deleting data
Lab: Modify data
After completing this module,
students will be able to:
− Insert data into an existing
table
− Specify that a column should
be automatically populating
with an IDENTITY or a
SEQUENCE value
− Modify data using the
UPDATE statement
− Delete data using the DELETE
statement
− Modify data using MERGE to
synchronize two tables
This course has no associated exam.