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

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

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