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

Querying SQL Server with Transact-SQL

2days
Training code
utsqlal

Upcoming sessions

This course is currently not scheduled

Subscribe to waiting list

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

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.