My Account

FAST3 Training Logo

Querying Microsoft SQL Server 2016 & Oracle with Transact-SQL Training

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

Description

CUSTOM COURSE FOR SPONSORED PROGRAMS ADMINISTRATION

 

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.

Comparisons will be made to the Oracle PL/SQL querying language that highlight similarities and differences.

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

Hours: 7


Webstore
Product Categories
My Account