Call Us: +32 2 466 00 16
Email: info@u2u.be
Follow Us:

Querying SQL Server with Transact-SQL

3days
Training code
UTSQL
Book this course

Module 1: Introduction to Transact-SQL

The following topics are covered in this module:

  • The Transact-SQL Programming Language
  • Types of Transact-SQL Statements
  • Transact-SQL Syntax Elements
  • Using SQL Server Books Online

Module 2: Using Transact-SQL Querying Tools

The following topics are covered in this module:

  • Using Management Studio
  • Using the graphical query builder in Management Studio
  • Using the sqlcmd Utility
  • Executing Transact-SQL Statements
  • Creating and Executing Transact-SQL Scripts

Module 3: Retrieving Data

The following topics are covered in this module:

  • Retrieving Data by Using the SELECT Statement
  • Filtering Data
  • Formatting Result Sets
  • How Queries Are Processed
  • Performance Considerations
  • Retrieving Data and Manipulating Result Sets

Module 4: Grouping and Summarizing Data

The following topics are covered in this module:

  • Listing the TOP n Values
  • Using Aggregate Functions
  • GROUP BY Fundamentals
  • Generating Aggregate Values Within Result Sets
  • Using the HAVING, ROLLUP and CUBE Clauses
  • Grouping and Summarizing Data

Module 5: Joining Multiple Tables

The following topics are covered in this module:

  • Using Aliases for Table Names
  • Combining Data from Multiple Tables
  • Combining Multiple Result Sets
  • Querying Multiple Tables

Module 6: Working with Subqueries

The following topics are covered in this module:

  • Introduction to Subqueries
  • Using a Subquery as a Derived Table
  • Using a Subquery as an Expression
  • Using a Subquery to Correlate Data
  • Using the EXISTS and NOT EXISTS Clauses
  • Working with Subqueries

Module 7: Modifying Data

The following topics are covered in this module:

  • Using Transactions
  • Inserting Data
  • Deleting Data
  • Updating Data
  • Performance Considerations
  • Modifying Data

Module 8: T-SQL extensions

The following topics are covered in this module:

  • OUTER APPLY and CROSS APPLY
  • PIVOT and UNPIVOT statement
  • Common table expressions
  • Writing recursive queries
  • Using structured error handling (TRY/CATCH)
  • Using the OVER-clause
  • Windowing functions

Module 9: Introduction to Programming Objects

The following topics are covered in this module:

  • Displaying the Text of a Programming Object
  • Introduction to Views
  • Advantages of Views
  • Creating Views
  • Introduction to Stored Procedures
  • Introduction to Triggers
  • Introduction to User-defined Functions
  • Working with Views

The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. The course covers querying SQL Server 2008 and higher versions as well as Azure SQL Databases.

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries, but have no or very limited experience in writing T-SQL SELECT statements.

This course requires no special skills.

© 2018 U2U All rights reserved.