Lynda.com - SQL Server Triggers, Stored Procedures, and Functions

Creation Time	Oct. 3, 2023, 5:09 p.m.
Last Access Time	Aug. 23, 2024, 8:07 p.m.
File Size	683.5 MB
Keywords	and Functions Triggers Lynda Procedures - Server Stored SQL com
Total Requests	33
Total Files	119
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

06. Putting It All Together/1. Exploring a Real-World INSERT Procedure.mp4 37.6 MB
07. Using CLR Assemblies/3. Writing Stored Procedures with C# .NET.mp4 36.9 MB
03. Stored Procedures/5. Using Input and Output Parameters.mp4 33.8 MB
03. Stored Procedures/6. Using Security and Permissions.mp4 33.5 MB
04. User-Defined Functions/2. Exploring Single-Value Functions.mp4 30.6 MB
07. Using CLR Assemblies/5. Choosing Between T-SQL vs. CLR.mp4 30.5 MB
08. Exploring an ASP .NET Web Application/3. Passing Parameters.mp4 29.1 MB
06. Putting It All Together/3. Implementing Logging On Delete.mp4 29.0 MB
04. User-Defined Functions/1. Creating A User-Defined Function.mp4 28.8 MB
02. Installing SQL Server/1. Configuring Your Environment.mp4 27.7 MB
03. Stored Procedures/3. Returning Data Using Data Sets.mp4 26.4 MB
03. Stored Procedures/4. Returning Data Using Cursors.mp4 25.3 MB
07. Using CLR Assemblies/2. Using CLR with SQL Server 2012.mp4 23.9 MB
05. Triggers/1. Using _After_ Triggers.mp4 23.6 MB
08. Exploring an ASP .NET Web Application/4. Getting Return Values.mp4 19.7 MB
06. Putting It All Together/2. Exploring a Real-World UPDATE Procedure.mp4 19.4 MB
09. Conclusion/1. Next Steps.mp4 19.3 MB
03. Stored Procedures/7. Using Transactions.mp4 19.1 MB
04. User-Defined Functions/3. Exploring Table Value Functions.mp4 18.0 MB
08. Exploring an ASP .NET Web Application/1. Creating a Basic Web Form and Connecting to a Database.mp4 18.0 MB
03. Stored Procedures/2. Modifying A Stored Procedure.mp4 16.6 MB
08. Exploring an ASP .NET Web Application/2. Executing a Stored Procedure.mp4 16.4 MB
01. Getting Started/1. Comparing Triggers, Functions, and Procedures.mp4 15.6 MB
03. Stored Procedures/1. Creating A Stored Procedure.mp4 13.8 MB
05. Triggers/2. Using _Instead Of_ Triggers.mp4 13.0 MB
01. Getting Started/2. Why Use A Stored Procedure.mp4 12.7 MB
05. Triggers/4. Using Database-Level Triggers.mp4 11.9 MB
00. Introduction/1. Welcome.mp4 9.5 MB
05. Triggers/3. Using Nested Triggers.mp4 9.3 MB
02. Installing SQL Server/2. Downloading and Installing A Sample Database.mp4 9.3 MB
07. Using CLR Assemblies/1. Understanding the Common Language Runtime (CLR) and the .NET Framework.mp4 6.6 MB
07. Using CLR Assemblies/4. Writing Functions with .NET.mp4 5.3 MB
01. Getting Started/3. Why Use Functions.mp4 3.3 MB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch06/Students.csv 2.8 MB
01. Getting Started/4. Why Use Triggers.mp4 2.4 MB
00. Introduction/2. What You Should Know.mp4 2.2 MB
00. Introduction/3. Using The Exercise Files.mp4 2.0 MB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest.suo 15.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/bin/Release/helloworld.pdb 13.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/obj/Release/helloworld.pdb 13.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld.suo 13.0 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/bin/Release/CLRtest.pdb 11.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/bin/Debug/CLRtest.pdb 11.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/obj/Debug/helloworld.pdb 11.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/bin/Release/CLRfunctions.pdb 11.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/obj/Release/CLRfunctions.pdb 11.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/bin/Debug/helloworld.pdb 11.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/obj/Debug/CLRtest.pdb 11.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/obj/Release/CLRtest.pdb 11.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions.suo 9.0 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/obj/Release/DesignTimeResolveAssemblyReferencesInput.cache 5.7 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/obj/Release/DesignTimeResolveAssemblyReferencesInput.cache 5.6 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/obj/Release/DesignTimeResolveAssemblyReferencesInput.cache 5.6 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache 5.6 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache 5.6 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache 5.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/bin/Debug/helloworld.dll 5.0 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/obj/Debug/helloworld.dll 5.0 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/obj/Debug/CLRtest.dll 5.0 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/bin/Debug/CLRtest.dll 5.0 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/obj/Release/helloworld.dll 4.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/obj/Release/CLRfunctions.dll 4.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/bin/Release/helloworld.dll 4.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/bin/Release/CLRtest.dll 4.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/obj/Release/CLRtest.dll 4.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/bin/Release/CLRfunctions.dll 4.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch02/02_create_database.txt 2.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/helloworld.csproj 2.3 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/CLRtest.csproj 2.3 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/CLRfunctions.csproj 2.3 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch06/06_01_setup.txt 1.5 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch05/05_setup.txt 1.4 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/Properties/AssemblyInfo.cs 1.4 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/Properties/AssemblyInfo.cs 1.4 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/Properties/AssemblyInfo.cs 1.4 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch08/08_03.txt 1.4 KB
README.nfo 1.3 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch04/04_02.txt 1.2 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch06/06_02_setup.txt 1.1 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch08/08_01.txt 1.1 KB
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/mySprocs.cs 958 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions.sln 930 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld.sln 924 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest.sln 915 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/obj/Release/helloworld.csproj.FileListAbsolute.txt 792 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/q.cs 707 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch02/02_create_table.txt 683 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch06/06_03_setup.txt 659 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/obj/Release/CLRfunctions.csproj.FileListAbsolute.txt 509 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/obj/Debug/CLRtest.csproj.FileListAbsolute.txt 499 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/Class1.cs 468 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/class.txt 465 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/obj/Release/CLRtest.csproj.FileListAbsolute.txt 464 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch04/04_03.txt 463 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch03/03_07.txt 416 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch03/03_04.txt 407 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/snippet.txt 396 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch08/08_04.txt 368 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/HelloWorldProc.cs 299 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch05/05_01.txt 291 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/obj/Debug/helloworld.csproj.FileListAbsolute.txt 291 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch03/03_06a.txt 237 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch05/05_02.txt 191 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch06/06_03_function.txt 185 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch06/06_01_query.txt 160 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/Class1.cs 159 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch06/06_03_table.txt 156 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch05/05_04.txt 150 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/CLRFunctions/CLRfunctions/CLRfunctions/CLRfunctions.csproj.user 143 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_02/helloworld/helloworld/helloworld.csproj.user 143 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_03/CLRtest/CLRtest/CLRtest.csproj.user 143 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch03/03_06b.txt 129 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch06/06_02_query.txt 126 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch07/07_04/function.txt 118 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch03/03_05.txt 109 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch03/03_03.txt 101 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch08/08_02.txt 99 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch05/05_03.txt 51 bytes
Exercise Files/Ex_Files_SQL_Server_Trig/Exercise Files/Ch06/06_03_query.txt 32 bytes

Lynda.com - SQL Server Triggers, Stored Procedures, and Functions

File List

Download Torrent

Related Resources

Copyright Infringement