ONLINE & SELF-DIRECTED: Querying MS SQL Server 2016 with Transact-SQL Training
This seven-hour, hands-on, online, self-directed course offers the same content and exercises as the long-running face-to-face classroom course. The course provides an introduction to the Microsoft Transact-SQL query language and detailed, hands-on experience writing SELECT queries. Intended for those without previous experience with the T-SQL language but 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
This offering is for the Urbana-Champaign campus. Please contact FAST3 (training@illinois.edu) or Phil Nyman (217-244-9041) to discuss course availability or scheduling for the UIC or UIS campuses.