Download Lynda com - SQL Server Triggers, Stored Procedures, and Function Torrent

Torrent Contents Size: 683.47 MB

Lynda com - SQL Server Triggers, Stored Procedures, and Function

00. Introduction

1. Welcome.mp4	MP4	9.52 MB
2. What You Should Know.mp4	MP4	2.19 MB
3. Using The Exercise Files.mp4	MP4	2.03 MB

01. Getting Started

1. Comparing Triggers, Functions, and Procedures.mp4	MP4	15.61 MB
2. Why Use A Stored Procedure.mp4	MP4	12.72 MB
3. Why Use Functions.mp4	MP4	3.27 MB
4. Why Use Triggers.mp4	MP4	2.41 MB

02. Installing SQL Server

	1. Configuring Your Environment.mp4	MP4	27.68 MB
	2. Downloading and Installing A Sample Database.mp4	MP4	9.25 MB

03. Stored Procedures

1. Creating A Stored Procedure.mp4	MP4	13.8 MB
2. Modifying A Stored Procedure.mp4	MP4	16.63 MB
3. Returning Data Using Data Sets.mp4	MP4	26.39 MB
4. Returning Data Using Cursors.mp4	MP4	25.31 MB
5. Using Input and Output Parameters.mp4	MP4	33.85 MB
6. Using Security and Permissions.mp4	MP4	33.51 MB
7. Using Transactions.mp4	MP4	19.09 MB

04. User-Defined Functions

1. Creating A User-Defined Function.mp4	MP4	28.83 MB
2. Exploring Single-Value Functions.mp4	MP4	30.65 MB
3. Exploring Table Value Functions.mp4	MP4	18.05 MB

05. Triggers

1. Using _After_ Triggers.mp4	MP4	23.62 MB
2. Using _Instead Of_ Triggers.mp4	MP4	13.03 MB
3. Using Nested Triggers.mp4	MP4	9.28 MB
4. Using Database-Level Triggers.mp4	MP4	11.92 MB

06. Putting It All Together

1. Exploring a Real-World INSERT Procedure.mp4	MP4	37.61 MB
2. Exploring a Real-World UPDATE Procedure.mp4	MP4	19.41 MB
3. Implementing Logging On Delete.mp4	MP4	28.96 MB

07. Using CLR Assemblies

1. Understanding the Common Language Runtime (CLR) and the .NET Framework.mp4	MP4	6.57 MB
2. Using CLR with SQL Server 2012.mp4	MP4	23.94 MB
3. Writing Stored Procedures with C# .NET.mp4	MP4	36.89 MB
4. Writing Functions with .NET.mp4	MP4	5.34 MB
5. Choosing Between T-SQL vs. CLR.mp4	MP4	30.53 MB

08. Exploring an ASP .NET Web Application

1. Creating a Basic Web Form and Connecting to a Database.mp4	MP4	17.97 MB
2. Executing a Stored Procedure.mp4	MP4	16.43 MB
3. Passing Parameters.mp4	MP4	29.13 MB
4. Getting Return Values.mp4	MP4	19.72 MB

09. Conclusion

1. Next Steps.mp4

MP4

19.29 MB

Exercise Files

Ex_Files_SQL_Server_Trig

Exercise Files

Ch02

	02_create_database.txt	TXT	2.5 KB
	02_create_table.txt	TXT	683 B

Ch03

03_03.txt	TXT	101 B
03_04.txt	TXT	407 B
03_05.txt	TXT	109 B
03_06a.txt	TXT	237 B
03_06b.txt	TXT	129 B
03_07.txt	TXT	416 B

Ch04

	04_02.txt	TXT	1.22 KB
	04_03.txt	TXT	463 B

Ch05

05_01.txt	TXT	291 B
05_02.txt	TXT	191 B
05_03.txt	TXT	51 B
05_04.txt	TXT	150 B
05_setup.txt	TXT	1.44 KB

Ch06

06_01_query.txt	TXT	160 B
06_01_setup.txt	TXT	1.48 KB
06_02_query.txt	TXT	126 B
06_02_setup.txt	TXT	1.1 KB
06_03_function.txt	TXT	185 B
06_03_query.txt	TXT	32 B
06_03_setup.txt	TXT	659 B
06_03_table.txt	TXT	156 B
Students.csv	CSV	2.76 MB

Ch07

07_02

helloworld

HelloWorldProc.cs

299 B

Properties

AssemblyInfo.cs

1.42 KB

bin

Debug

	helloworld.dll	DLL	5 KB
	helloworld.pdb	PDB	11.5 KB

Release

	helloworld.dll	DLL	4.5 KB
	helloworld.pdb	PDB	13.5 KB

helloworld.csproj

CSPROJ

2.32 KB

helloworld.csproj.user

USER

143 B

obj

Debug

DesignTimeResolveAssemblyReferencesInput.cache	CACHE	5.52 KB
helloworld.csproj.FileListAbsolute.txt	TXT	291 B
helloworld.dll	DLL	5 KB
helloworld.pdb	PDB	11.5 KB

Release

DesignTimeResolveAssemblyReferencesInput.cache	CACHE	5.63 KB
helloworld.csproj.FileListAbsolute.txt	TXT	792 B
helloworld.dll	DLL	4.5 KB
helloworld.pdb	PDB	13.5 KB

q.cs

707 B

helloworld.sln

SLN

924 B

helloworld.suo

SUO

13 KB

07_03

CLRtest

CLRtest.csproj

CSPROJ

2.29 KB

CLRtest.csproj.user

USER

143 B

Class1.cs

159 B

Properties

AssemblyInfo.cs

1.41 KB

bin

Debug

	CLRtest.dll	DLL	5 KB
	CLRtest.pdb	PDB	11.5 KB

Release

	CLRtest.dll	DLL	4.5 KB
	CLRtest.pdb	PDB	11.5 KB

mySprocs.cs

958 B

obj

Debug

CLRtest.csproj.FileListAbsolute.txt	TXT	499 B
CLRtest.dll	DLL	5 KB
CLRtest.pdb	PDB	11.5 KB
DesignTimeResolveAssemblyReferencesInput.cache	CACHE	5.6 KB

Release

CLRtest.csproj.FileListAbsolute.txt	TXT	464 B
CLRtest.dll	DLL	4.5 KB
CLRtest.pdb	PDB	11.5 KB
DesignTimeResolveAssemblyReferencesInput.cache	CACHE	5.61 KB

CLRtest.sln

SLN

915 B

CLRtest.suo

SUO

15.5 KB

snippet.txt

TXT

396 B

07_04

CLRFunctions

CLRfunctions

CLRfunctions.csproj

CSPROJ

2.26 KB

CLRfunctions.csproj.user

USER

143 B

Class1.cs

468 B

Properties

AssemblyInfo.cs

1.42 KB

bin

Release

	CLRfunctions.dll	DLL	4.5 KB
	CLRfunctions.pdb	PDB	11.5 KB

obj

Debug

DesignTimeResolveAssemblyReferencesInput.cache

CACHE

5.59 KB

Release

CLRfunctions.csproj.FileListAbsolute.txt	TXT	509 B
CLRfunctions.dll	DLL	4.5 KB
CLRfunctions.pdb	PDB	11.5 KB
DesignTimeResolveAssemblyReferencesInput.cache	CACHE	5.65 KB

CLRfunctions.sln

SLN

930 B

CLRfunctions.suo

SUO

9 KB

class.txt

TXT

465 B

function.txt

TXT

118 B

Ch08

08_01.txt	TXT	1.05 KB
08_02.txt	TXT	99 B
08_03.txt	TXT	1.37 KB
08_04.txt	TXT	368 B

README.nfo

NFO

1.27 KB

Description

									Show full description
								

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Lynda com - Java Essential Training 2016 Posted by dry_cactus in Movies - Other Movies Posted in Movies - Other Movies 1 965.56 MB 9 years ago dry_cactus	Size 965.56 MB	Files 76	Age 9 years ago	Seeds 1	Leechs 0	Source
WordPress Essential Training - Lynda com - [GameSlim] Posted by GameSlim in Movies - Other Movies Posted in Movies - Other Movies 0 899.56 MB 10 years ago GameSlim	Size 899.56 MB	Files 57	Age 10 years ago	Seeds 0	Leechs 0	Source
Lynda com Tutorial - Accounting Fundamentals - GameSlim Posted by GameSlim in Movies - Other Movies Posted in Movies - Other Movies 1 341.49 MB 10 years ago GameSlim	Size 341.49 MB	Files 30	Age 10 years ago	Seeds 1	Leechs 0	Source
Lynda com - AutoCAD 2016 Essential Training Posted by junoliv69 in Movies - Other Movies Posted in Movies - Other Movies 1 819.83 MB 10 years ago junoliv69	Size 819.83 MB	Files 116	Age 10 years ago	Seeds 1	Leechs 0	Source
Lynda com Planning and Staging an Exhibition-QUASAR Posted by SFIAC in Movies - Other Movies Posted in Movies - Other Movies 0 409 MB 10 years ago SFIAC	Size 409 MB	Files 31	Age 10 years ago	Seeds 0	Leechs 0	Source

Lynda com - SQL Server Triggers, Stored Procedures, and Function

Torrent Contents Size: 683.47 MB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags