SQL Server: Transact-SQL Basic Data Retrieval

Learn how to construct SELECT statements to retrieve data from SQL Server databases, applicable for developers from SQL Server 2005 onwards
More
Learn how to construct SELECT statements to retrieve data from SQL Server databases, applicable for developers from SQL Server 2005 onwards
More
Introduction
3m 45s
Introduction 0m 41s Aggregate Functions 1m 10s Demo: Aggregate Functions 6m 26s Aggregate Functions (2) 0m 54s Demo: Aggregate Functions (2) 2m 23s Mathematical Functions 1m 10s Demo: Mathematical Functions 3m 57s OVER Clause 0m 40s Ranking Functions 0m 54s Demo: Ranking Functions 5m 30s Conversion Functions 1m 11s Demo: Conversion Functions 4m 15s Validating Data Types 0m 21s Demo: Validating Data Types 1m 48s System Time Functions 0m 58s Demo: System Time Functions 1m 38s Returning Date and Time Parts 0m 52s Demo: Returning Date and Time Parts 2m 25s Constructing Date and Time Values 0m 38s Demo: Constructing Date and Time Values 1m 24s Constructing Date and Time Values (2) 0m 26s Demo: Constructing Date and Time Values (2) 1m 40s Calculating Time Differences 0m 27s Demo: Calculating Time Differences 1m 42s Modifying Dates 0m 47s Demo: Modifying Dates 3m 58s Logical Functions 0m 43s Demo: Logical Functions 1m 42s Logical Functions (2) 0m 30s Demo: Logical Functions (2) 2m 52s Working with NULL 0m 47s Demo: Working with NULL 2m 30s String Functions 0m 38s Demo: String Functions 1m 28s String Functions (2) 0m 41s Demo: String Functions (2) 2m 5s String Functions (3) 0m 30s Demo: String Functions (3) 0m 54s String Functions (4) 0m 21s Demo: String Functions (4) 1m 0s String Functions (5) 0m 52s Demo: String Functions (5) 5m 48s String Functions (6) 0m 51s Demo: String Functions (6) 3m 34s Analytic Functions 0m 42s Demo: Analytic Functions 7m 34s Analytic Functions (2) 1m 11s Demo: Analytic Functions (2) 6m 20s Course Summary 0m 42s
If you need to retrieve data from a SQL Server database then you need to know how to use the SELECT statement. This course starts with the basics of a SELECT statement and its various sub-clauses, and progresses to how to select from multiple data sources in the same statement and a comprehensive section on the functions available to manipulate, aggregate, and convert data during the select operation. More then fifty demos help to give you a thorough understanding of how to perform these essential operations, all using a freely-available demo environment that you're shown how to set up and configure. This course is perfect for developers who need to query SQL Server databases to retrieve data, from complete beginners through to more experienced developers who can use some of the modules as reference material. The information in the course applies to all versions from SQL Server 2005 onwards.

Learn by doing. Use hands-on exercise files to follow along with the course and practice concepts as you’re watching them. Sign up now to enhance your training.

Start free trial

Course transcripts are the written form of the course audio. You can use transcripts to just read the audio, or to search for terms or phrases to find where they are discussed in the training. Sign up to try them now.

Start free trial

Ask questions, read feedback from other learners and share your input, all in our discussion forums. Sign up now to join our community of learners, course authors and friendly support staff.

Start free trial

You’ve completed the course but did you master it? Test yourself with questions that gauge your understanding of the material and show you what to brush up on. Sign up to get started.

Start free trial
Table of Contents
Introduction
3m 45s
Introduction 0m 41s Aggregate Functions 1m 10s Demo: Aggregate Functions 6m 26s Aggregate Functions (2) 0m 54s Demo: Aggregate Functions (2) 2m 23s Mathematical Functions 1m 10s Demo: Mathematical Functions 3m 57s OVER Clause 0m 40s Ranking Functions 0m 54s Demo: Ranking Functions 5m 30s Conversion Functions 1m 11s Demo: Conversion Functions 4m 15s Validating Data Types 0m 21s Demo: Validating Data Types 1m 48s System Time Functions 0m 58s Demo: System Time Functions 1m 38s Returning Date and Time Parts 0m 52s Demo: Returning Date and Time Parts 2m 25s Constructing Date and Time Values 0m 38s Demo: Constructing Date and Time Values 1m 24s Constructing Date and Time Values (2) 0m 26s Demo: Constructing Date and Time Values (2) 1m 40s Calculating Time Differences 0m 27s Demo: Calculating Time Differences 1m 42s Modifying Dates 0m 47s Demo: Modifying Dates 3m 58s Logical Functions 0m 43s Demo: Logical Functions 1m 42s Logical Functions (2) 0m 30s Demo: Logical Functions (2) 2m 52s Working with NULL 0m 47s Demo: Working with NULL 2m 30s String Functions 0m 38s Demo: String Functions 1m 28s String Functions (2) 0m 41s Demo: String Functions (2) 2m 5s String Functions (3) 0m 30s Demo: String Functions (3) 0m 54s String Functions (4) 0m 21s Demo: String Functions (4) 1m 0s String Functions (5) 0m 52s Demo: String Functions (5) 5m 48s String Functions (6) 0m 51s Demo: String Functions (6) 3m 34s Analytic Functions 0m 42s Demo: Analytic Functions 7m 34s Analytic Functions (2) 1m 11s Demo: Analytic Functions (2) 6m 20s Course Summary 0m 42s
Description
If you need to retrieve data from a SQL Server database then you need to know how to use the SELECT statement. This course starts with the basics of a SELECT statement and its various sub-clauses, and progresses to how to select from multiple data sources in the same statement and a comprehensive section on the functions available to manipulate, aggregate, and convert data during the select operation. More then fifty demos help to give you a thorough understanding of how to perform these essential operations, all using a freely-available demo environment that you're shown how to set up and configure. This course is perfect for developers who need to query SQL Server databases to retrieve data, from complete beginners through to more experienced developers who can use some of the modules as reference material. The information in the course applies to all versions from SQL Server 2005 onwards.
Exercise Files

Learn by doing. Use hands-on exercise files to follow along with the course and practice concepts as you’re watching them. Sign up now to enhance your training.

Start free trial
Transcript

Course transcripts are the written form of the course audio. You can use transcripts to just read the audio, or to search for terms or phrases to find where they are discussed in the training. Sign up to try them now.

Start free trial
Discussion

Ask questions, read feedback from other learners and share your input, all in our discussion forums. Sign up now to join our community of learners, course authors and friendly support staff.

Start free trial
Knowledge Check

You’ve completed the course but did you master it? Test yourself with questions that gauge your understanding of the material and show you what to brush up on. Sign up to get started.

Start free trial
Course info
Level
Beginner
Rating
(634)
Duration
3h 53m
Released
31 Jul 2012
Course authors

Joe Sack is a Principal Software Architect in the SQL Customer Advisory (SQLCAT) Team at Microsoft. With over 18 years of experience in the industry, Joe is an author and speaker, specializing in performance tuning, high availability and disaster recovery.

Share course