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

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

SQL Server: Transact-SQL Basic Data Modification

Год выпуска: 2012
Производитель: pluralsight.com
Автор: Joe Sack
Продолжительность: 02:32:58
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: If you need to modify data in a SQL Server database, then you need to know how to use the INSERT, UPDATE and DELETE statements. This course starts by explaining how to find information about the tables and columns you want to modify. It then explains the INSERT, UPDATE, and DELETE statements in detail along with various methods for limiting the data being modified. Finally it moves beyond the basic modification statements to more advanced topics like the MERGE statement, error handling and more. More then thirty five 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 modify data in SQL Server databases, 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:09
Introduction 01:51
Course Structure 01:18

Setting Up a Transact-SQL Learning Environment 00:38:03
Module Introduction 00:58
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 Modification Query in SSMS and SSDT 00:46
Demo: Execute a Data Modification Query in SSMS 04:11
Demo: Execute a Data Modification Query in SSDT 04:39

Exploring Table Metadata 00:19:14
Module Introduction 01:12
Using sp_help 00:40
Identity and RowGuidCol sp_help Information 00:49
Constraint sp_help Information 00:36
Demo: sp_help 02:43
Catalog Views 00:44
Demo: Catalog Views 02:12
Catalog Views (2) 00:53
Demo: Catalog Views (2) 04:28
Triggers 00:45
Demo: Trigger Catalog View 02:05
sys.dm_sql_referencing_entities 00:24
Demo: sys.dm_sql_referencing_entities 01:43

Inserting Data 00:28:46
Module Introduction 00:44
Demo: Backing up and restoring your sample database 05:15
Basic Row Insert 00:56
Demo: Basic Row Insert 02:20
Column List 01:06
Demo: Column List Usage 04:22
Specifying Data Values 01:02
Transact-SQL Row Constructors 00:38
Demo: Transact-SQL Row Constructors 04:27
Handling Defaults 00:39
Demo: Handling Defaults 03:33
Populating via Derived Table and EXECUTE 00:45
Demo: Populating via Derived Table and EXECUTE 02:59

Updating Data 00:17:52
Module Introduction 00:39
Simple Update 01:02
Demo: Simple UPDATE 02:27
UPDATE with FROM 00:35
Demo: UPDATE with FROM 02:01
Defaults 00:25
Demo: Handling Defaults 01:57
Compound assignment operators 00:27
Demo: Compound assignment operators 01:44
Updating with Sub-Query Values 00:17
Demo: Updating with Sub-Query Values 02:32
Updating Views 00:52
Demo: Updating Views 02:54

Deleting Data 00:10:36
Module Introduction 00:34
Basic DELETE 00:38
Demo: Basic DELETE 02:50
WHERE and FROM clause with DELETE 00:26
Demo: WHERE and FROM clauses with DELETE 01:31
DELETE vs. TRUNCATE TABLE 00:52
Demo: DELETE vs. TRUNCATE TABLE 03:45

Beyond the Basics 00:35:18
Module Introduction 01:05
MERGE 00:52
Demo: MERGE 06:21
Data Modifications with CTEs 00:34
Demo: Data Modifications with CTES 02:21
Updating Large-Value Data Types 01:10
Demo: Updating Large-Value Data Types 03:01
Minimal Logging Operations 01:06
Referencing Sequence Objects 00:41
Demo: Referencing Sequence Objects 03:02
OUTPUT Clause 00:26
Demo: OUTPUT Clause 03:06
Consistent Data Type Usage 00:51
Batching Modifications with TOP 00:53
Demo: Batching Modifications with TOP 02:59
Explicit Transactions 00:55
Demo: Using Explicit Transactions 01:53
@@ROWCOUNT and ROWCOUNT_BIG 00:30
Error Handling 00:26
Demo: Error Handling 02:24
Course Summary 00:42
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: WMV
Видео: WMV3, 1024x768, 15 fps, ~170 kbps
Аудио: WMA v2, 44100Hz, 128 kb/s, Stereo
[spoiler="Скриншоты"]

[/spoiler]