中文名: SQL Server 數據庫編程教程
英文名: LYNDA.COM SQL SERVER TRIGGERS STORED PROCEDURES AND FUNCTIONS
資源格式: 光盤鏡像
主講人: Martin Guidry
發行日期: 2012年9月24日
地區: 美國
對白語言: 英語
文字語言: 英文
簡介:

語言：英語
網址：http://www.lynda.com/SQL-Server-tutorials/SQL-Server-Triggers-Stored-Procedures-Functions/104964-2.html
類別：教程
由Lynda出品的SQL Server 數據庫編程教程。
教學時長：1小時52分鐘，
主講：Martin Guidry
教程所使用的軟件：SQL Server
SQL被作為關系型數據庫管理系統的標准語言。SQL語句可以用來執行各種各樣的操作，例如更新數據庫中的數據，從數據庫中提取數據等。目前，絕大多數流行的關系型數據庫管理系統，如Oracle,Sybase,Microsoft SQL Server,Access等都采用了SQL語言標准。雖然很多數據庫都對SQL語句進行了再開發和擴展，但是包括Select,Insert,Update,Delete,Create，以及Drop在內的標准的SQL命令仍然可以被用來完成幾乎所有的數據庫操作。
Microsoft SQL Server 2012 提供更加出色的在線時間，超快的性能以及更加高級的安全特性滿足不同規模用戶對關鍵業務應用的需要; 可管理的自服務數據分析與令人驚歎的交互式數據可視化能力滿足不同用戶的各種突破性洞察數據的需要; Cloud On Your Own Terms 將解決方案從現有的環境擴展到私有雲乃至公有雲可以實現按照您的需求構建應用雲平台的需要。
本課程探討數據庫編程的幾個關鍵概念：觸發器，存儲過程，函數，和.NET通用語言運行庫（ CLR ）的程序集。作者Martin Guidry顯示了如何結合這些技術，並創建一個高品質的使用Microsoft SQL Server 2012的數據庫。課程還包括實際用途的插入、 更新和刪除的程序，以及如何構建基本 web 窗體，以及如何建立一個基本的Web表單連接到數據庫。
This course investigates several key database-programming concepts: triggers, stored procedures, functions, and .NET CLR (Common Language Runtime) assemblies. Author Martin Guidry shows how to combine these techniques and create a high-quality database using Microsoft SQL Server 2012. The course also covers real-world uses of the INSERT, UPDATE, and DELETE procedures, and how to build a basic web form to connect to your database.
Topics include:
Comparing triggers, functions, and stored procedures
Installing and configuring SQL Server
Creating a stored procedure
Returning data using data sets
Creating user-defined functions
Using "after," "instead," and nested triggers
Modifying existing stored procedures
Implementing logging on DELETE
Choosing between T-SQL and CLR
Executing a stored procedure
Passing parameters

資源更新列表
http://www.VeryCD.com/i/5190747/create/fol...postTime

目錄:
Introduction
2m 15s
Welcome
51s
What you should know
51s
Using the exercise files
33s
1. Getting Started
11m 1s
Comparing triggers, functions, and procedures
3m 25s
Why use a stored procedure?
4m 59s
Why use functions?
1m 27s
Why use triggers?
1m 10s
2. Installing SQL Server
6m 2s
Configuring your environment
4m 53s
Downloading and installing a sample database
1m 9s
3. Stored Procedures
26m 25s
Creating a stored procedure
2m 46s
Modifying a stored procedure
2m 34s
Returning data using data sets
3m 45s
Returning data using cursors
3m 45s
Using input and output parameters
5m 24s
Using security and permissions
5m 24s
Using transactions
2m 47s
4. User-Defined Functions
11m 56s
Creating a user-defined function
4m 59s
Exploring single-value functions
4m 18s
Exploring table value functions
2m 39s
5. Triggers
9m 31s
Using "after" triggers
3m 47s
Using "instead of" triggers
2m 9s
Using nested triggers
1m 38s
Using database-level triggers
1m 57s
6. Putting It All Together
12m 43s
Exploring a real-world INSERT procedure
5m 32s
Exploring a real-world UPDATE procedure
3m 13s
Implementing logging on DELETE
3m 58s
7. Using CLR Assemblies
19m 38s
Understanding the Common Language Runtime (CLR) and the .NET framework
1m 52s
Using CLR with SQL Server 2012
4m 11s
Writing stored procedures with C# .NET
5m 51s
Writing functions with .NET
5m 7s
Choosing between T-SQL vs. CLR
2m 37s
8. Exploring an ASP.NET Web Application
11m 35s
Creating a basic web form and connecting to a database
2m 57s
Executing a stored procedure
2m 4s
Passing parameters
3m 41s
Getting return values
2m 53s
Conclusion
1m 43s
Next steps
1m 43s
代碼

JWARE Proudly Presents: Lynda.com - SQL Server: Triggers, Stored Procedures, and Functions
Release Type: Bookware
Supplier: JWARE
Cracker: JWARE
Packer: JWARE
Protection: DRM
Publisher URL: http://www.lynda.com/
Publisher: Lynda.com
Publication date: 24/09/12
Release date: 28/10/12
Description:
This course investigates several key database-programming concepts: triggers, stored procedures,
functions, and .NET CLR (Common Language Runtime) assemblies. Author Martin Guidry shows how to
combine these techniques and create a high-quality database using Microsoft SQL Server 2012. The
course also covers real-world uses of the INSERT, UPDATE, and DELETE procedures, and how to build
a basic web form to connect to your database.