Please enable Javascript, which is required for this site.
sqlserver-dataretrieval

SQL Server: Transact-SQL Basic Data Retrieval

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.

Authored by: Joe Sack
Duration: 3h 53m
Level: Beginner
Released: 8/1/2012
Features: Closed captions
Course Rating:
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using:  {{getCurrentPlayerName()}}  [Change]
expand all | collapse all Progress Duration
This module is unavailableIntroduction
 You have not watched this Module. 00:03:45
Introduction
You have not watched this Clip. 02:06
Course Structure
You have not watched this Clip. 01:39
This module is unavailableSetting Up a Transact-SQL Learning Environment
 You have not watched this Module. 00:36:14
Introduction
You have not watched this Clip. 01:02
SQL Server 2012 Express with Tools
You have not watched this Clip. 01:01
SQL Server 2012 Express Abridged Requirements
You have not watched this Clip. 01:47
Demo: Checking Hardware and OS Specifications
You have not watched this Clip. 00:59
Demo: Checking .NET 3.5 SP1 Prerequisites
You have not watched this Clip. 01:55
Demo: Installing SQL Server 2012 Express with Tools
You have not watched this Clip. 07:33
SQL Server Management Studio (SSMS)
You have not watched this Clip. 00:53
Demo: Using SSMS
You have not watched this Clip. 03:26
SQL Server Data Tools (SSDT)
You have not watched this Clip. 01:20
Demo: Installing SSDT
You have not watched this Clip. 02:36
AdventureWorks Sample Database
You have not watched this Clip. 00:39
Demo: Attaching the AdventureWorks Sample Database
You have not watched this Clip. 05:20
Basic Data Retrieval
You have not watched this Clip. 00:44
Demo: Execute a Data Retrieval Query in SSMS
You have not watched this Clip. 03:35
Demo: Execute a Data Retrieval Query in SSDT
You have not watched this Clip. 03:24
This module is unavailableWriting a Basic SELECT Statement
 You have not watched this Module. 00:51:17
Introduction
You have not watched this Clip. 01:17
Thinking in 'Sets'
You have not watched this Clip. 01:04
Where to Begin?
You have not watched this Clip. 00:31
SELECT Clause
You have not watched this Clip. 01:08
Demo: SELECT Clause
You have not watched this Clip. 03:05
Column Aliases
You have not watched this Clip. 00:45
Demo: Column Aliases
You have not watched this Clip. 01:44
Identifiers
You have not watched this Clip. 00:53
Demo: Regular versus Delimited Identifiers
You have not watched this Clip. 02:45
Semicolon Statement Terminator
You have not watched this Clip. 00:32
FROM Clause
You have not watched this Clip. 00:44
Demo: FROM Clause
You have not watched this Clip. 03:40
Table Aliases
You have not watched this Clip. 00:56
Demo: Table Aliases
You have not watched this Clip. 01:50
Expressions, Operators, Predicates
You have not watched this Clip. 00:42
WHERE Clause
You have not watched this Clip. 00:44
Demo: WHERE Clause
You have not watched this Clip. 03:54
DISTINCT
You have not watched this Clip. 00:35
Demo: DISTINCT
You have not watched this Clip. 02:44
TOP
You have not watched this Clip. 01:13
Demo: TOP
You have not watched this Clip. 02:02
GROUP BY Clause
You have not watched this Clip. 00:38
Demo: GROUP BY Clause
You have not watched this Clip. 03:40
HAVING Clause
You have not watched this Clip. 00:34
Demo: HAVING Clause
You have not watched this Clip. 03:24
ORDER BY Clause
You have not watched this Clip. 00:58
Demo: ORDER BY Clause
You have not watched this Clip. 02:15
Query Paging
You have not watched this Clip. 00:55
Demo: Query Paging
You have not watched this Clip. 01:52
Binding Order
You have not watched this Clip. 00:31
Demo: Binding Order
You have not watched this Clip. 01:27
Best Practice: Commenting Your Code
You have not watched this Clip. 01:07
Demo: Commenting Your Code
You have not watched this Clip. 01:08
This module is unavailableQuerying Multiple Data Sources
 You have not watched this Module. 00:49:30
Introduction
You have not watched this Clip. 00:53
Inner Joins
You have not watched this Clip. 00:55
Demo: Inner Joins
You have not watched this Clip. 03:20
Outer Joins
You have not watched this Clip. 01:02
Outer Joins (2)
You have not watched this Clip. 00:37
Demo: Outer Joins
You have not watched this Clip. 05:00
Cross Joins
You have not watched this Clip. 00:38
Demo: Cross Joins
You have not watched this Clip. 02:10
Self Joins
You have not watched this Clip. 00:30
Demo: Self Joins
You have not watched this Clip. 01:55
Equi vs. Non-Equi Joins
You have not watched this Clip. 00:39
Demo: Equi vs. Non-Equi Joins
You have not watched this Clip. 01:31
Multi-Attribute Joins
You have not watched this Clip. 00:20
Demo: Multi-Attribute Joins
You have not watched this Clip. 02:51
Joining More than Two Tables
You have not watched this Clip. 00:38
Demo: Joining More than Two Tables
You have not watched this Clip. 04:24
CROSS APPLY Operator
You have not watched this Clip. 00:40
Demo: CROSS APPLY and OUTER APPLY Operator
You have not watched this Clip. 04:13
Joining Sub-Queries
You have not watched this Clip. 00:16
Defining the Sub-Query
You have not watched this Clip. 00:48
Demo: Using Sub-Queries
You have not watched this Clip. 02:58
UNION Operator
You have not watched this Clip. 01:12
Demo: UNION Operator
You have not watched this Clip. 02:54
INTERSECT and EXCEPT
You have not watched this Clip. 00:47
Demo: INTERSECT and EXCEPT Operators
You have not watched this Clip. 02:57
Data Types and Joining Tables
You have not watched this Clip. 01:07
Introduction to Common Table Expressions
You have not watched this Clip. 00:34
Demo: Introduction to Common Table Expressions
You have not watched this Clip. 03:41
This module is unavailableUsing Functions
 You have not watched this Module. 01:32:30
Introduction
You have not watched this Clip. 00:41
Aggregate Functions
You have not watched this Clip. 01:10
Demo: Aggregate Functions
You have not watched this Clip. 06:26
Aggregate Functions (2)
You have not watched this Clip. 00:54
Demo: Aggregate Functions (2)
You have not watched this Clip. 02:23
Mathematical Functions
You have not watched this Clip. 01:10
Demo: Mathematical Functions
You have not watched this Clip. 03:57
OVER Clause
You have not watched this Clip. 00:40
Ranking Functions
You have not watched this Clip. 00:54
Demo: Ranking Functions
You have not watched this Clip. 05:30
Conversion Functions
You have not watched this Clip. 01:11
Demo: Conversion Functions
You have not watched this Clip. 04:15
Validating Data Types
You have not watched this Clip. 00:21
Demo: Validating Data Types
You have not watched this Clip. 01:48
System Time Functions
You have not watched this Clip. 00:58
Demo: System Time Functions
You have not watched this Clip. 01:38
Returning Date and Time Parts
You have not watched this Clip. 00:52
Demo: Returning Date and Time Parts
You have not watched this Clip. 02:25
Constructing Date and Time Values
You have not watched this Clip. 00:38
Demo: Constructing Date and Time Values
You have not watched this Clip. 01:24
Constructing Date and Time Values (2)
You have not watched this Clip. 00:26
Demo: Constructing Date and Time Values (2)
You have not watched this Clip. 01:40
Calculating Time Differences
You have not watched this Clip. 00:27
Demo: Calculating Time Differences
You have not watched this Clip. 01:42
Modifying Dates
You have not watched this Clip. 00:47
Demo: Modifying Dates
You have not watched this Clip. 03:58
Logical Functions
You have not watched this Clip. 00:43
Demo: Logical Functions
You have not watched this Clip. 01:42
Logical Functions (2)
You have not watched this Clip. 00:30
Demo: Logical Functions (2)
You have not watched this Clip. 02:52
Working with NULL
You have not watched this Clip. 00:47
Demo: Working with NULL
You have not watched this Clip. 02:30
String Functions
You have not watched this Clip. 00:38
Demo: String Functions
You have not watched this Clip. 01:28
String Functions (2)
You have not watched this Clip. 00:41
Demo: String Functions (2)
You have not watched this Clip. 02:05
String Functions (3)
You have not watched this Clip. 00:30
Demo: String Functions (3)
You have not watched this Clip. 00:54
String Functions (4)
You have not watched this Clip. 00:21
Demo: String Functions (4)
You have not watched this Clip. 01:00
String Functions (5)
You have not watched this Clip. 00:52
Demo: String Functions (5)
You have not watched this Clip. 05:48
String Functions (6)
You have not watched this Clip. 00:51
Demo: String Functions (6)
You have not watched this Clip. 03:34
Analytic Functions
You have not watched this Clip. 00:42
Demo: Analytic Functions
You have not watched this Clip. 07:34
Analytic Functions (2)
You have not watched this Clip. 01:11
Demo: Analytic Functions (2)
You have not watched this Clip. 06:20
Course Summary
You have not watched this Clip. 00:42