Pluralsight com SQL Server Transact SQL Basic Data Modification | FD8DBF590FC8490445A46FFB5AB5DA9925C099F1

Pluralsight com SQL Server Transact SQL Basic Data Modification

Name	[pluralsight.com] SQL Server - Transact-SQL Basic Data Modification	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	347.7 MB
Total Files	84
Hash	FD8DBF590FC8490445A46FFB5AB5DA9925C099F1

/1. Introduction/
1. Introduction.wmv	2.8 MB
2. Course Structure.wmv	1.9 MB
/2. Setting Up a Transact-SQL Learning Environment/
1. Module Introduction.wmv	1.4 MB
10. Demo - Installing SSDT.wmv	6.1 MB
11. AdventureWorks Sample Database.wmv	946.1 KB
12. Demo - Attaching the AdventureWorks Sample Database.wmv	10.8 MB
13. Basic Data Modification Query in SSMS and SSDT.wmv	1.2 MB
14. Demo - Execute a Data Modification Query in SSMS.wmv	8.8 MB
15. Demo - Execute a Data Modification Query in SSDT.wmv	8.5 MB
2. SQL Server 2012 Express with Tools.wmv	1.5 MB
3. SQL Server 2012 Express Abridged Requirements.wmv	2.8 MB
4. Demo - Checking Hardware and OS Specifications.wmv	4.6 MB
5. Demo - Checking .NET 3.5 SP1 Prerequisites.wmv	3.7 MB
6. Demo - Installing SQL Server 2012 Express with Tools.wmv	12.5 MB
7. SQL Server Management Studio (SSMS).wmv	1.3 MB
8. Demo - Using SSMS.wmv	6.7 MB
9. SQL Server Data Tools (SSDT).wmv	2.1 MB
/3. Exploring Table Metadata/
1. Module Introduction.wmv	1.8 MB
10. Triggers.wmv	1.1 MB
11. Demo - Trigger Catalog View.wmv	5.5 MB
12. sys.dm_sql_referencing_entities.wmv	618.5 KB
13. Demo - sys.dm_sql_referencing_entities.wmv	3.2 MB
2. Using sp_help.wmv	1.0 MB
3. Identity and RowGuidCol sp_help Information.wmv	1.2 MB
4. Constraint sp_help Information.wmv	919.0 KB
5. Demo - sp_help.wmv	5.8 MB
6. Catalog Views.wmv	1.1 MB
7. Demo - Catalog Views.wmv	11.9 MB
8. Catalog Views (2).wmv	1.3 MB
9. Demo - Catalog Views (2).wmv	13.8 MB
/4. Inserting Data/
1. Module Introduction.wmv	1.1 MB
10. Handling Defaults.wmv	940.0 KB
11. Demo - Handling Defaults.wmv	7.5 MB
12. Populating via Derived Table and EXECUTE.wmv	1.1 MB
13. Demo - Populating via Derived Table and EXECUTE.wmv	8.7 MB
2. Demo - Backing up and restoring your sample database.wmv	9.8 MB
3. Basic Row Insert.wmv	1.2 MB
4. Demo - Basic Row Insert.wmv	5.0 MB
5. Column List.wmv	1.6 MB
6. Demo - Column List Usage.wmv	10.6 MB
7. Specifying Data Values.wmv	1.5 MB
8. Transact-SQL Row Constructors.wmv	910.0 KB
9. Demo - Transact-SQL Row Constructors.wmv	9.4 MB
/5. Updating Data/
1. Module Introduction.wmv	913.0 KB
10. Updating with Sub-Query Values.wmv	378.1 KB
11. Demo - Updating with Sub-Query Values.wmv	8.5 MB
12. Updating Views.wmv	1.3 MB
13. Demo - Updating Views.wmv	8.5 MB
2. Simple Update.wmv	1.5 MB
3. Demo - Simple UPDATE.wmv	6.1 MB
4. UPDATE with FROM.wmv	813.8 KB
5. Demo - UPDATE with FROM.wmv	5.4 MB
6. Defaults.wmv	606.5 KB
7. Demo - Handling Defaults.wmv	6.2 MB
8. Compound assignment operators.wmv	699.6 KB
9. Demo - Compound assignment operators.wmv	3.7 MB
/6. Deleting Data/
1. Module Introduction.wmv	792.8 KB
2. Basic DELETE.wmv	849.9 KB
3. Demo - Basic DELETE.wmv	9.2 MB
4. WHERE and FROM clause with DELETE.wmv	663.6 KB
5. Demo - WHERE and FROM clauses with DELETE.wmv	4.2 MB
6. DELETE vs. TRUNCATE TABLE.wmv	1.3 MB
7. Demo - DELETE vs. TRUNCATE TABLE.wmv	13.2 MB
/7. Beyond the Basics/
1. Module Introduction.wmv	1.5 MB
10. Demo - Referencing Sequence Objects.wmv	10.2 MB
11. OUTPUT Clause.wmv	615.5 KB
12. Demo - OUTPUT Clause.wmv	7.7 MB
13. Consistent Data Type Usage.wmv	1.2 MB
14. Batching Modifications with TOP.wmv	1.3 MB
15. Demo - Batching Modifications with TOP.wmv	9.0 MB
16. Explicit Transactions.wmv	1.3 MB
17. Demo - Using Explicit Transactions.wmv	3.9 MB
18. @@ROWCOUNT and ROWCOUNT_BIG.wmv	756.7 KB
19. Error Handling.wmv	630.5 KB
2. MERGE.wmv	1.2 MB
20. Demo - Error Handling.wmv	6.0 MB
21. Course Summary.wmv	1.1 MB
3. Demo - MERGE.wmv	19.1 MB
4. Data Modifications with CTEs.wmv	834.8 KB
5. Demo - Data Modifications with CTES.wmv	6.7 MB
6. Updating Large-Value Data Types.wmv	1.8 MB
7. Demo - Updating Large-Value Data Types.wmv	9.2 MB
8. Minimal Logging Operations.wmv	1.7 MB
9. Referencing Sequence Objects.wmv	1.1 MB
Total files 84