Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/00. Introduction/00.01. Welcome.mov |
5.1 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/00. Introduction/00.02. What you should know.mov |
859 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/00. Introduction/00.03. Using the exercise files.mov |
667 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/00. Introduction/00.02. What you should know.srt |
1 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/00. Introduction/00.01. Welcome.srt |
1 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/00. Introduction/00.03. Using the exercise files.srt |
812 B |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/01. Getting Started/01.02. Why use a stored procedure.mov |
4.6 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/01. Getting Started/01.01. Comparing triggers, functions, and procedures.mov |
4.2 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/01. Getting Started/01.03. Why use functions.mov |
1.3 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/01. Getting Started/01.04. Why use triggers.mov |
1 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/01. Getting Started/01.02. Why use a stored procedure.srt |
8 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/01. Getting Started/01.01. Comparing triggers, functions, and procedures.srt |
5 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/01. Getting Started/01.03. Why use functions.srt |
2 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/01. Getting Started/01.04. Why use triggers.srt |
2 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/02. Installing SQL Server/02.01. Configuring your environment.mov |
8.7 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/02. Installing SQL Server/02.02. Downloading and installing a sample database.mov |
2.6 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/02. Installing SQL Server/02.01. Configuring your environment.srt |
6 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/02. Installing SQL Server/02.02. Downloading and installing a sample database.srt |
2 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.06. Using security and permissions.mov |
9.1 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.05. Using input and output parameters.mov |
7 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.03. Returning data using data sets.mov |
5.1 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.04. Returning data using cursors.mov |
4.8 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.02. Modifying a stored procedure.mov |
3.7 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.07. Using transactions.mov |
3.6 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.01. Creating a stored procedure.mov |
3.2 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.05. Using input and output parameters.srt |
8 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.06. Using security and permissions.srt |
8 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.04. Returning data using cursors.srt |
6 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.03. Returning data using data sets.srt |
6 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.01. Creating a stored procedure.srt |
4 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.07. Using transactions.srt |
4 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/03. Stored Procedures/03.02. Modifying a stored procedure.srt |
4 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/04. User-Defined Functions/04.02. Exploring single-value functions.mov |
6.8 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/04. User-Defined Functions/04.01. Creating a user-defined function.mov |
6.4 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/04. User-Defined Functions/04.03. Exploring table value functions.mov |
4 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/04. User-Defined Functions/04.01. Creating a user-defined function.srt |
7 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/04. User-Defined Functions/04.02. Exploring single-value functions.srt |
6 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/04. User-Defined Functions/04.03. Exploring table value functions.srt |
4 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/05. Triggers/05.01. Using after triggers.mov |
5.3 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/05. Triggers/05.02. Using instead of triggers.mov |
2.7 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/05. Triggers/05.04. Using database-level triggers.mov |
2.5 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/05. Triggers/05.03. Using nested triggers.mov |
2 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/05. Triggers/05.01. Using after triggers.srt |
5 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/05. Triggers/05.02. Using instead of triggers.srt |
3 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/05. Triggers/05.04. Using database-level triggers.srt |
3 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/05. Triggers/05.03. Using nested triggers.srt |
2 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/06. Putting It All Together/06.01. Exploring a real-world INSERT procedure.mov |
10.7 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/06. Putting It All Together/06.03. Implementing logging on DELETE.mov |
6.2 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/06. Putting It All Together/06.02. Exploring a real-world UPDATE procedure.mov |
4.7 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/06. Putting It All Together/06.01. Exploring a real-world INSERT procedure.srt |
9 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/06. Putting It All Together/06.03. Implementing logging on DELETE.srt |
6 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/06. Putting It All Together/06.02. Exploring a real-world UPDATE procedure.srt |
5 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/07. Using CLR Assemblies/07.03. Writing stored procedures with C# .NET.mov |
9.4 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/07. Using CLR Assemblies/07.04. Writing functions with .NET.mov |
7.7 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/07. Using CLR Assemblies/07.02. Using CLR with SQL Server 2012.mov |
5.5 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/07. Using CLR Assemblies/07.05. Choosing between T-SQL vs. CLR.mov |
2.4 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/07. Using CLR Assemblies/07.01. Understanding the Common Language Runtime (CLR) and the .NET framework.mov |
2.4 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/07. Using CLR Assemblies/07.03. Writing stored procedures with C# .NET.srt |
7 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/07. Using CLR Assemblies/07.04. Writing functions with .NET.srt |
6 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/07. Using CLR Assemblies/07.02. Using CLR with SQL Server 2012.srt |
5 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/07. Using CLR Assemblies/07.05. Choosing between T-SQL vs. CLR.srt |
4 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/07. Using CLR Assemblies/07.01. Understanding the Common Language Runtime (CLR) and the .NET framework.srt |
2 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/08. Exploring an ASP .NET Web Application/08.03. Passing parameters.mov |
8 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/08. Exploring an ASP .NET Web Application/08.01. Creating a basic web form and connecting to a database.mov |
5.4 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/08. Exploring an ASP .NET Web Application/08.02. Executing a stored procedure.mov |
4.4 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/08. Exploring an ASP .NET Web Application/08.04. Getting return values.mov |
4.4 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/08. Exploring an ASP .NET Web Application/08.03. Passing parameters.srt |
5 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/08. Exploring an ASP .NET Web Application/08.04. Getting return values.srt |
4 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/08. Exploring an ASP .NET Web Application/08.01. Creating a basic web form and connecting to a database.srt |
4 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/08. Exploring an ASP .NET Web Application/08.02. Executing a stored procedure.srt |
3 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/09. Conclusion/09.01. Next steps.mov |
3.7 MB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/09. Conclusion/09.01. Next steps.srt |
3 KB |
Lynda.com - SQL Server. Triggers, Stored Procedures, and Functions/Exercise Files/Ex_Files_SQL_Server_Trig.zip |
803 KB |