TorBT - Torrents and Magnet Links Search Engine
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions
- Date: 2022-11-24
- Size: 171 MB
- Files: 73
File Name
Size
00. Introduction/00.01. Welcome.mov
5.1 MB
00. Introduction/00.02. What you should know.mov
859 kB
00. Introduction/00.03. Using the exercise files.mov
667 kB
00. Introduction/00.02. What you should know.srt
1.2 kB
00. Introduction/00.01. Welcome.srt
1.2 kB
00. Introduction/00.03. Using the exercise files.srt
812 B
01. Getting Started/01.02. Why use a stored procedure.mov
4.6 MB
01. Getting Started/01.01. Comparing triggers, functions, and procedures.mov
4.2 MB
01. Getting Started/01.03. Why use functions.mov
1.3 MB
01. Getting Started/01.04. Why use triggers.mov
1.0 MB
01. Getting Started/01.02. Why use a stored procedure.srt
7.6 kB
01. Getting Started/01.01. Comparing triggers, functions, and procedures.srt
4.9 kB
01. Getting Started/01.03. Why use functions.srt
2.1 kB
01. Getting Started/01.04. Why use triggers.srt
1.7 kB
02. Installing SQL Server/02.01. Configuring your environment.mov
8.7 MB
02. Installing SQL Server/02.02. Downloading and installing a sample database.mov
2.6 MB
02. Installing SQL Server/02.01. Configuring your environment.srt
6.3 kB
02. Installing SQL Server/02.02. Downloading and installing a sample database.srt
1.6 kB
03. Stored Procedures/03.06. Using security and permissions.mov
9.1 MB
03. Stored Procedures/03.05. Using input and output parameters.mov
7.0 MB
03. Stored Procedures/03.03. Returning data using data sets.mov
5.1 MB
03. Stored Procedures/03.04. Returning data using cursors.mov
4.8 MB
03. Stored Procedures/03.02. Modifying a stored procedure.mov
3.7 MB
03. Stored Procedures/03.07. Using transactions.mov
3.6 MB
03. Stored Procedures/03.01. Creating a stored procedure.mov
3.2 MB
03. Stored Procedures/03.05. Using input and output parameters.srt
8.4 kB
03. Stored Procedures/03.06. Using security and permissions.srt
8.2 kB
03. Stored Procedures/03.04. Returning data using cursors.srt
5.7 kB
03. Stored Procedures/03.03. Returning data using data sets.srt
5.6 kB
03. Stored Procedures/03.01. Creating a stored procedure.srt
4.5 kB
03. Stored Procedures/03.07. Using transactions.srt
4.3 kB
03. Stored Procedures/03.02. Modifying a stored procedure.srt
3.8 kB
04. User-Defined Functions/04.02. Exploring single-value functions.mov
6.8 MB
04. User-Defined Functions/04.01. Creating a user-defined function.mov
6.4 MB
04. User-Defined Functions/04.03. Exploring table value functions.mov
4.0 MB
04. User-Defined Functions/04.01. Creating a user-defined function.srt
7.1 kB
04. User-Defined Functions/04.02. Exploring single-value functions.srt
5.7 kB
04. User-Defined Functions/04.03. Exploring table value functions.srt
3.7 kB
05. Triggers/05.01. Using after triggers.mov
5.3 MB
05. Triggers/05.02. Using instead of triggers.mov
2.7 MB
05. Triggers/05.04. Using database-level triggers.mov
2.5 MB
05. Triggers/05.03. Using nested triggers.mov
2.0 MB
05. Triggers/05.01. Using after triggers.srt
5.2 kB
05. Triggers/05.02. Using instead of triggers.srt
3.0 kB
05. Triggers/05.04. Using database-level triggers.srt
2.9 kB
05. Triggers/05.03. Using nested triggers.srt
2.4 kB
06. Putting It All Together/06.01. Exploring a real-world INSERT procedure.mov
11 MB
06. Putting It All Together/06.03. Implementing logging on DELETE.mov
6.2 MB
06. Putting It All Together/06.02. Exploring a real-world UPDATE procedure.mov
4.7 MB
06. Putting It All Together/06.01. Exploring a real-world INSERT procedure.srt
8.7 kB
06. Putting It All Together/06.03. Implementing logging on DELETE.srt
6.0 kB
06. Putting It All Together/06.02. Exploring a real-world UPDATE procedure.srt
4.9 kB
07. Using CLR Assemblies/07.03. Writing stored procedures with C# .NET.mov
9.4 MB
07. Using CLR Assemblies/07.04. Writing functions with .NET.mov
7.7 MB
07. Using CLR Assemblies/07.02. Using CLR with SQL Server 2012.mov
5.5 MB
07. Using CLR Assemblies/07.05. Choosing between T-SQL vs. CLR.mov
2.4 MB
07. Using CLR Assemblies/07.01. Understanding the Common Language Runtime (CLR) and the .NET framework.mov
2.4 MB
07. Using CLR Assemblies/07.03. Writing stored procedures with C# .NET.srt
7.2 kB
07. Using CLR Assemblies/07.04. Writing functions with .NET.srt
6.1 kB
07. Using CLR Assemblies/07.02. Using CLR with SQL Server 2012.srt
5.5 kB
07. Using CLR Assemblies/07.05. Choosing between T-SQL vs. CLR.srt
3.9 kB
07. Using CLR Assemblies/07.01. Understanding the Common Language Runtime (CLR) and the .NET framework.srt
2.4 kB
08. Exploring an ASP .NET Web Application/08.03. Passing parameters.mov
8.0 MB
08. Exploring an ASP .NET Web Application/08.01. Creating a basic web form and connecting to a database.mov
5.4 MB
08. Exploring an ASP .NET Web Application/08.02. Executing a stored procedure.mov
4.4 MB
08. Exploring an ASP .NET Web Application/08.04. Getting return values.mov
4.4 MB
08. Exploring an ASP .NET Web Application/08.03. Passing parameters.srt
5.2 kB
08. Exploring an ASP .NET Web Application/08.04. Getting return values.srt
4.3 kB
08. Exploring an ASP .NET Web Application/08.01. Creating a basic web form and connecting to a database.srt
4.3 kB
08. Exploring an ASP .NET Web Application/08.02. Executing a stored procedure.srt
3.0 kB
09. Conclusion/09.01. Next steps.mov
3.7 MB
09. Conclusion/09.01. Next steps.srt
2.7 kB
Exercise Files/Ex_Files_SQL_Server_Trig.zip
803 kB