DP-080 Querying Data with Microsoft Transact-SQL

TEMATYKA ZAJĘĆ

• Module 1: Getting Started with Transact-SQL
  Introduction to Transact-SQL
  Using the SELECT statement
  Lab: Get started with SQL Server query tools and writing queries in T-SQL

• Module 2: Sorting and Filtering Query Results
  Sorting query results
  Filtering the data
  Lab: Sort and filter data returned by SELECT queries

• Module 3: Using Joins and Subqueries
  Using JOIN operations
  Using subqueries
  Lab: Write queries with JOIN operations
  Lab: Write SELECT statements using subqueries

• Module 4: Using Built-in Functions
  Getting started with scalar functions
  Grouping aggregated results
  Lab: Built-in functions

• Module 5: Modifying Data
  Inserting data into tables
  Modifying and deleting data
  Lab: Modify data