SQL Server: Transact-SQL Basic Data Retrieval [2012, ENG]

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

SQL Server: Transact-SQL Basic Data Retrieval

Год выпуска: 2012
Производитель: pluralsight-training.net
Автор: Joe Sack
Продолжительность: 03:53:19
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: 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.
[spoiler="Содержание"]
Introduction 00:03:45
Introduction 02:06
Course Structure 01:39

Setting Up a Transact-SQL Learning Environment 00:36:14
Introduction 01:02
SQL Server 2012 Express with Tools 01:01
SQL Server 2012 Express Abridged Requirements 01:47
Demo: Checking Hardware and OS Specifications 00:59
Demo: Checking .NET 3.5 SP1 Prerequisites 01:55
Demo: Installing SQL Server 2012 Express with Tools 07:33
SQL Server Management Studio (SSMS) 00:53
Demo: Using SSMS 03:26
SQL Server Data Tools (SSDT) 01:20
Demo: Installing SSDT 02:36
AdventureWorks Sample Database 00:39
Demo: Attaching the AdventureWorks Sample Database 05:20
Basic Data Retrieval 00:44
Demo: Execute a Data Retrieval Query in SSMS 03:35
Demo: Execute a Data Retrieval Query in SSDT 03:24

Writing a Basic SELECT Statement 00:51:20
Introduction 01:17
Thinking in 'Sets' 01:07
Where to Begin? 00:31
SELECT Clause 01:08
Demo: SELECT Clause 03:05
Column Aliases 00:45
Demo: Column Aliases 01:44
Identifiers 00:53
Demo: Regular versus Delimited Identifiers 02:45
Semicolon Statement Terminator 00:32
FROM Clause 00:44
Demo: FROM Clause 03:40
Table Aliases 00:56
Demo: Table Aliases 01:50
Expressions, Operators, Predicates 00:42
WHERE Clause 00:44
Demo: WHERE Clause 03:54
DISTINCT 00:35
Demo: DISTINCT 02:44
TOP 01:13
Demo: TOP 02:02
GROUP BY Clause 00:38
Demo: GROUP BY Clause 03:40
HAVING Clause 00:34
Demo: HAVING Clause 03:24
ORDER BY Clause 00:58
Demo: ORDER BY Clause 02:15
Query Paging 00:55
Demo: Query Paging 01:52
Binding Order 00:31
Demo: Binding Order 01:27
Best Practice: Commenting Your Code 01:07
Demo: Commenting Your Code 01:08

Querying Multiple Data Sources 00:49:30
Introduction 00:53
Inner Joins 00:55
Demo: Inner Joins 03:20
Outer Joins 01:02
Outer Joins (2) 00:37
Demo: Outer Joins 05:00
Cross Joins 00:38
Demo: Cross Joins 02:10
Self Joins 00:30
Demo: Self Joins 01:55
Equi vs. Non-Equi Joins 00:39
Demo: Equi vs. Non-Equi Joins 01:31
Multi-Attribute Joins 00:20
Demo: Multi-Attribute Joins 02:51
Joining More than Two Tables 00:38
Demo: Joining More than Two Tables 04:24
CROSS APPLY Operator 00:40
Demo: CROSS APPLY and OUTER APPLY Operator 04:13
Joining Sub-Queries 00:16
Defining the Sub-Query 00:48
Demo: Using Sub-Queries 02:58
UNION Operator 01:12
Demo: UNION Operator 02:54
INTERSECT and EXCEPT 00:47
Demo: INTERSECT and EXCEPT Operators 02:57
Data Types and Joining Tables 01:07
Introduction to Common Table Expressions 00:34
Demo: Introduction to Common Table Expressions 03:41

Using Functions 01:32:30
Introduction 00:41
Aggregate Functions 01:10
Demo: Aggregate Functions 06:26
Aggregate Functions (2) 00:54
Demo: Aggregate Functions (2) 02:23
Mathematical Functions 01:10
Demo: Mathematical Functions 03:57
OVER Clause 00:40
Ranking Functions 00:54
Demo: Ranking Functions 05:30
Conversion Functions 01:11
Demo: Conversion Functions 04:15
Validating Data Types 00:21
Demo: Validating Data Types 01:48
System Time Functions 00:58
Demo: System Time Functions 01:38
Returning Date and Time Parts 00:52
Demo: Returning Date and Time Parts 02:25
Constructing Date and Time Values 00:38
Demo: Constructing Date and Time Values 01:24
Constructing Date and Time Values (2) 00:26
Demo: Constructing Date and Time Values (2) 01:40
Calculating Time Differences 00:27
Demo: Calculating Time Differences 01:42
Modifying Dates 00:47
Demo: Modifying Dates 03:58
Logical Functions 00:43
Demo: Logical Functions 01:42
Logical Functions (2) 00:30
Demo: Logical Functions (2) 02:52
Working with NULL 00:47
Demo: Working with NULL 02:30
String Functions 00:38
Demo: String Functions 01:28
String Functions (2) 00:41
Demo: String Functions (2) 02:05
String Functions (3) 00:30
Demo: String Functions (3) 00:54
String Functions (4) 00:21
Demo: String Functions (4) 01:00
String Functions (5) 00:52
Demo: String Functions (5) 05:48
String Functions (6) 00:51
Demo: String Functions (6) 03:34
Analytic Functions 00:42
Demo: Analytic Functions 07:34
Analytic Functions (2) 01:11
Demo: Analytic Functions (2) 06:20
Course Summary 00:42
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: WMV
Видео: WMV3, 1024x768, 15 fps, ~140 kbps
Аудио: WMA v2, 44100Hz, 128 kb/s, Stereo
[spoiler="Скриншоты"]

[/spoiler]