Level: Introductory
David Dye
Sergeant
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