Lynda - SQL Server Triggers, Stored Procedures, and Functions

seeders: 1
leechers: 0
Added on December 13, 2014 by ytclm0392in Other > Tutorials
Torrent verified.



Lynda - SQL Server Triggers, Stored Procedures, and Functions (Size: 171.19 MB)
 01. Welcome.mov5.07 MB
 02. What you should know.mov859.24 KB
 03. Using the exercise files.mov666.76 KB
 02. What you should know.srt1.25 KB
 01. Welcome.srt1.21 KB
 03. Using the exercise files.srt812 bytes
 02. Why use a stored procedure.mov4.59 MB
 01. Comparing triggers, functions, and procedures.mov4.24 MB
 03. Why use functions.mov1.3 MB
 04. Why use triggers.mov1.04 MB
 02. Why use a stored procedure.srt7.59 KB
 01. Comparing triggers, functions, and procedures.srt4.92 KB
 03. Why use functions.srt2.11 KB
 04. Why use triggers.srt1.74 KB
 01. Configuring your environment.mov8.7 MB
 02. Downloading and installing a sample database.mov2.61 MB
 01. Configuring your environment.srt6.31 KB
 02. Downloading and installing a sample database.srt1.62 KB
 06. Using security and permissions.mov9.1 MB
 05. Using input and output parameters.mov6.96 MB
 03. Returning data using data sets.mov5.09 MB
 04. Returning data using cursors.mov4.8 MB
 02. Modifying a stored procedure.mov3.7 MB
 07. Using transactions.mov3.58 MB
 01. Creating a stored procedure.mov3.19 MB
 05. Using input and output parameters.srt8.43 KB
 06. Using security and permissions.srt8.17 KB
 04. Returning data using cursors.srt5.67 KB
 02. Exploring single-value functions.mov6.83 MB
 01. Creating a user-defined function.mov6.4 MB
 03. Exploring table value functions.mov3.97 MB
 01. Creating a user-defined function.srt7.09 KB
 02. Exploring single-value functions.srt5.71 KB
 03. Exploring table value functions.srt3.71 KB
 01. Using after triggers.mov5.34 MB
 02. Using instead of triggers.mov2.74 MB
 04. Using database-level triggers.mov2.54 MB
 03. Using nested triggers.mov2.02 MB
 01. Using after triggers.srt5.21 KB
 02. Using instead of triggers.srt2.98 KB
 04. Using database-level triggers.srt2.89 KB
 03. Using nested triggers.srt2.36 KB
 01. Exploring a real-world INSERT procedure.mov10.73 MB
 03. Implementing logging on DELETE.mov6.21 MB
 02. Exploring a real-world UPDATE procedure.mov4.72 MB
 01. Exploring a real-world INSERT procedure.srt8.68 KB
 03. Implementing logging on DELETE.srt6.05 KB
 02. Exploring a real-world UPDATE procedure.srt4.91 KB
 03. Writing stored procedures with C# .NET.mov9.4 MB
 04. Writing functions with .NET.mov7.75 MB
 02. Using CLR with SQL Server 2012.mov5.46 MB
 05. Choosing between T-SQL vs. CLR.mov2.4 MB
 01. Understanding the Common Language Runtime (CLR) and the .NET framework.mov2.4 MB
 03. Writing stored procedures with C# .NET.srt7.23 KB
 04. Writing functions with .NET.srt6.06 KB
 02. Using CLR with SQL Server 2012.srt5.5 KB
 05. Choosing between T-SQL vs. CLR.srt3.89 KB
 01. Understanding the Common Language Runtime (CLR) and the .NET framework.srt2.41 KB
 03. Passing parameters.mov7.99 MB
 01. Creating a basic web form and connecting to a database.mov5.39 MB
 02. Executing a stored procedure.mov4.42 MB
 04. Getting return values.mov4.36 MB
 03. Passing parameters.srt5.17 KB
 04. Getting return values.srt4.3 KB
 01. Creating a basic web form and connecting to a database.srt4.27 KB
 02. Executing a stored procedure.srt2.99 KB
 01. Next Steps.mov3.73 MB
 01. Next Steps.srt2.74 KB
 Ex_Files_SQL_Server_Trig.zip803.07 KB

Description

Cover:
image

Lynda - SQL Server Triggers, Stored Procedures, and Functions | 179 MB
Duration: 1h 52m | Video: AVC (.mov) 960x540 15fps | Audio: AAC 44.1KHz 1ch (English Subtitle included)
Genre: Business, Developer, Databases | Level: Advanced | Language: English | year: Sep 24, 2012

This course investigates several key database-programming concepts: triggers, stored procedures, functions, and .NET CLR (Common Language Runtime) assemblies. Author Martin Guidry shows how to combine these techniques and create a high-quality database using Microsoft SQL Server 2012. The course also covers real-world uses of the INSERT, UPDATE, and DELETE procedures, and how to build a basic web form to connect to your database.

Topics include:
* Comparing triggers, functions, and stored procedures
* Installing and configuring SQL Server
* Creating a stored procedure
* Returning data using data sets
* Creating user-defined functions
* Using "after," "instead," and nested triggers
* Modifying existing stored procedures
* Implementing logging on DELETE
* Choosing between T-SQL and CLR
* Executing a stored procedure
* Passing parameters


Enjoy Learning !!!


Sharing Widget


Download torrent
171.19 MB
seeders:1
leechers:0
Lynda - SQL Server Triggers, Stored Procedures, and Functions