LNT 0008 — Querying Data with Transact-SQL
This course is designed to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines, namely, Database Administration, Database Development, and Business Intelligence. Write SELECT queries, query multiple tables, sort and filter data, use built-in functions, group and aggregate data types, work with table expressions and set operators, and program with T-SQL. Prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality; working knowledge of relational databases.