Technology Services Calendar

Back to Listing

Querying Microsoft SQL Server 2016 with Transact-SQL

Event Type
Conference/Workshop
Sponsor
FAST3/Webstore Training Services
Location
UIUC -- location to be announced
Date
May 7, 2019 - May 9, 2019   1:00 - 5:00 pm  
Speaker
Phil Nyman
Cost
$199
Registration
WebStore Registration Form
Contact
FAST3 Training Center
E-Mail
training@illinois.edu
Phone
217-333-6285
Views
8
Originating Calendar
FAST3 Training

This seven-hour course provides an introduction to the Microsoft Transact-SQL query language and detailed, hands-on experience writing SELECT queries. This course should be attended by those who have a need to write or understand / modify existing SELECT queries. We will use  SQL Server 2016 but the concepts apply to all versions of MS SQL server and other relational databases. Attendees will learn about the structure of the Transact-SQL query language; the ways that queries may be issued to SQL Server; how to write and troubleshoot SELECT queries; how to work with date, time and string character data formats; how to group data and perform statistical summarizations; how to construct sub-queries to break down complex queries; and how to use standard table joins to retrieve data from multiple tables.

Prerequisites: Familiarity with MS Windows OS; basic familiarity with relational database concepts (tables, relationships).

Hours: 7

link for robots only