Staff Training

Back to Listing

SQL: Querying Microsoft SQL Server 2008 with Transact-SQL

Event Type
Conference/Workshop
Sponsor
FAST3/Webstore Training Services
Location
UIUC -- location to be announced
Date
Oct 22, 2012   9:00 am - 5:00 pm   (M) lunch on own
Speaker
Phil Nyman
Cost
$199 faculty/staff/students
Registration
FAST3 Registration Form
E-Mail
training@illinois.edu
Phone
(217) 333-6285
Views
1939
Originating Calendar
WebStore/FAST3 Training

This one-day course provides an introduction to the MS Transact-SQL query language and detailed, hands-on experience writing SELECT queries. This course should be attended by those who are in a position to write or understand / modify existing SELECT queries. We will use MS SQL Server 2008, but the concepts apply to all relational databases. Attendees will learn about the structure of the Transact-SQL query language; the ways that queries may be issued to MS 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.

link for robots only