SQL Server 数据库编程教程(LYNDA.COM SQL SERVER TRIGGERS STORED PROCEDURES AND FUNCTIONS

游客，本帖隐藏的内容需要积分高于 1 才可浏览，您当前积分为 0

资源信息： 中文名: 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.