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

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