Show all products
Public > Software > Microsoft Products

My Account

WebStore

Querying Microsoft SQL Server 2016 with Transact-SQL Training
$199.00
Microsoft Corporation
Eligibility: Guests, UIUC Allied persons, UIUC Faculty and Staff and UIUC Students.
Querying Microsoft SQL Server 2016 with Transact-SQL Training
Select Querying Microsoft SQL Server 2016 with Transact-SQL
Total Price:$199.00
Email training@illinois.edu or call 217-244-9041 for dates of the next offering of this course.
Payment Type: Credit Card

Description

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 understand, modify or write SELECT queries. We will use  SQL Server 2016 but the concepts apply to all versions of MS SQL server and to 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

Contact FAST3 (training@illinois.edu) or Phil Nyman (217-244-9041) to discuss course availability or scheduling.

Additional Information

Workshop Details:
Location: Illini Hall (725 S Wright St), Suite 26 (lower level) - Map it

Add this class to your calendar:
Browse to the WebStore Events Calendar, select your course, select the calendar symbol calendar image, select your calendar format, open the file, and save the item to your calendar.

Parking:
Parking in the heart of campus is scarce. We suggest that you walk or take public transportation (www.cumtd.com). City meters (restricted to 2 hrs) are available on the street at both locations. There are a few campus meters in the parking lot between Coble Hall and Swanlund Administration Building on John Street and in the parking structure at Sixth & John. Please note that parking fees are the responsibility of the class participant. WebStore is not responsible for parking tickets or towing fees of vehicles belonging to class participants. Please read all parking signs!

Training policies and other information