SQL Server Questions and Answers [2012, ENG] torrent

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

SQL Server Questions and Answers

Год выпуска: 2012
Производитель: pluralsight-training.net
Автор: Dave, Kumar
Продолжительность: 2:13:00
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: This course is designed to help you better understand how to use SQL Server effectively. The course presents many of the common misconceptions about SQL Server, and then carefully debunks those misconceptions with clear explanations and short but compelling demos, showing you how SQL Server really works. This course is for anyone working with SQL Server databases who wants to improve her knowledge and understanding of this complex platform.
[spoiler="Содержание"]
Introduction 00:00:54
Introduction 00:54

Retrieving IDENTITY value using @@IDENTITY 00:08:36
Misconception 00:23
Resolution 00:25
Demo 06:09
Additional Info 01:13
Summary 00:26

Concepts Related to Identity Values 00:04:12
Misconception 00:32
Resolution 00:41
Demo 02:12
Additional Info 00:25
Summary 00:22

Difference between WHERE and HAVING 00:05:49
Misconception 00:28
Resolution 00:50
Demo 03:12
Additional Info 00:44
Summary 00:35

Order in WHERE clause 00:07:26
Misconception 00:31
Resolution 00:33
Demo 05:11
Additional Info 00:37
Summary 00:34

Concepts Around Temporary Tables and Table Variables 00:08:57
Misconception 00:43
Resolution 00:36
Demo: Table variables exists in Memory misconception 02:10
Demo: Temp tables exist in Physical drive myth 01:14
Demo: Shows Table variables can have Index 01:27
Demo: Scope of transaction with table and temp tables 01:48
Additional Info 00:29
Summary 00:30

Are stored procedures pre-compiled? 00:05:07
Misconception 00:27
Resolution 00:48
Demo 02:42
Additional Info 00:45
Summary 00:25

UNIQUE INDEX and NULLs problem 00:06:39
Misconception 00:46
Resolution 00:37
Demo 03:52
Additional Info 01:02
Summary 00:22

DELETE VS TRUNCATE 00:06:05
Misconception 00:22
Resolution 00:36
Demo 03:42
Additional Info 00:57
Summary 00:28

Locks and Duration of Transactions 00:15:08
Misconception 00:30
Resolution 00:40
Demo 12:38
Additional Info 01:00
Summary 00:20

Nested Transaction and Rollback 00:09:12
Misconception 00:29
Resolution 00:31
Demo: Nested Transaction - 1 02:13
Demo: Nested Transaction - 2 02:08
Demo: Nested Transaction - 3 03:16
Summary 00:35

Understanding Date/Time Datatypes 00:07:37
Misconception 00:37
Resolution 00:39
Demo 05:17
Additional Info 00:34
Summary 00:30

Differences between VARCHAR and NVARCHAR datatypes 00:06:36
Misconception 00:33
Resolution 00:27
Demo 04:38
Additional Info 00:31
Summary 00:27

Precedence of DENY and GRANT security permissions 00:05:27
Misconception 00:23
Resolution 00:27
Demo 03:39
Additional Info 00:40
Summary 00:18

Identify Blocking Process 00:06:33
Misconception 00:29
Resolution 00:47
Demo 03:35
Additional Info 01:06
Summary 00:36

NULLS usage with Dynamic SQL 00:08:02
Misconception 00:32
Resolution 00:42
Demo 05:25
Additional Info 00:52
Summary 00:31

Appendix Tips and Tricks with Tools 00:20:42
Using the ssms command-line tool 05:00
Using Activity Monitor 04:59
Using filtering in query results 04:26
Configuration options in SSMS 06:17
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: WMV
Видео: WMV3, 1024x768, 15 fps, ~115 kbps
Аудио: WMA v2, 44100Hz, 128 kb/s, Stereo
[spoiler="Скриншоты"]

[/spoiler]