Querying Data with T-SQL
Lecture
Sam Nasr
Beginner
1 h 37 m
2019-11-25
Lecture Overview
This course serves as an introduction to the T-SQL programming language. This course is designed to give students a strong foundation in the T-SQL language which is used by all variants of SQL Server both on-premises and in the cloud.

Related Learning Path(s):
Introduction to Relational Databases
Objectives
  • Describe T-SQL, sets and predicate logic.
  • Write single and multi-table SELECT statements.
  • Apply filtering and sorting to SELECT statements.
  • Describe how SQL Server uses data types.
  • Write Data Manipulation Language statements.
  • Write queries using basic aggregations.
  • Understand Cursor usage in T-SQL
Lecture Modules

This module will discuss basic SELECT statements and predicate logic, using logical operators to filter results, sorting data with ORDER BY, limiting result sets with TOP, eliminating duplicates with DISTINCT, column and table aliases, and using CASE expressions for conditional execution.


Try Risk Free

Start a free trial

Skill Me Up subscriptions include unlimited access to on-demand courses with live lab lab environments with our Real Time Labs feature for hands-on lab access.

Subscription Benefits
  • Access to Real Time Lab environments and lab guides
  • Course Completion Certificates when you pass assessments
  • MUCH MORE!