Workshops, Friends of SQL Server, For Database Administrators, For IT Professionals

SQM04 Workshop: T-SQL for the Report Writer


1:00PM - 5:00PM

Level: Introductory

David Dye


Cape Coral Police Department

This four hour workshop is targeted for the analysts who are required to create reports against SQL Server databases. The workshop focuses on writing efficient T-SQL queries to return data sets for any reporting solution, SSRS, Crystal Reports, Active Reports, etc. This workshop will serve as an introduction to T-SQL’s DQL, Data Query Language, and is meant for anyone who has a general knowledge of SQL Server.

The workshop will cover:

  • An introduction to T-SQL
  • T-SQL querying tools
  • Basic T-SQL syntax
  • Basic SELECT statements
  • Filter results
  • Joining tables
  • Aggregating values
  • String functions