Querying Data with Microsoft Transact-SQL (Fundamentals) DP-080

Module 1Getting Started with Transact -SQL

• Basic knowledge of the Microsoft Windows operating system and its core
• functionality.
• SQL (T - SQL) language, as
• well as general properties and terminology of relational databases. This module will also
• introduce the basic SELECT statement for retrieving data from a table.
• Lessons
• Introduction to Transact - SQL
• Using the SELECT statement
• Lab : Get started with SQL Server query tools and writing queries in T - SQL

Module 2Sorting and Filtering Query Results

• In the module you will learn how to control what data is returned, the order in which it is
• returned. You will use the ORDER BY clause, with and without paging. You will learn
• about various kinds of filters that can be used in the WHERE clause to control which data
• rows are returned. You will also learn how to manage the results by removing duplicates
• with DISTINCT.
• Lessons
• Sorting query results
• Filtering the data
• Lab : Sort and filter data returned by SELECT queries

Module 3Using Joins and Subqueries

• In this module, you will explore T- SQL queries which access data from multiple tables with
• various kinds of JOIN operations and simple subqueries.
• Lessons
• Using JOIN operations
• Using subqueries
• Lab : Write queries with JOIN operations
• Lab : Write SELECT statements using subqueries

Module 4Using 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 funct ions,
• 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 SU M, MIN or
• MAX.
• Lessons
• Getting started with scalar functions
• Grouping aggregated results
• Lab : Built - in functions

Module 5Modifying Data

• In this module, you will learn the T - SQL statements for modifying table data including
• UPDATE, DELETE and MERGE as w ell 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