v

您的位置:VeryCD教育计算机


《SQL Server 数据库编程教程》(LYNDA.COM SQL SERVER TRIGGERS STORED PROCEDURES AND FUNCTIONS)[光盘镜像]

  • 状态: 精华资源
  • 摘要:
    主讲人Martin Guidry
    发行日期2012年9月24日
    对白语言英语
    文字语言英文
  • 时间: 2012/11/08 23:27:55 发布 | 2012/11/12 09:01:43 更新
  • 分类: 教育  计算机 

MTina

精华资源: 3862

全部资源: 3863

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名SQL Server 数据库编程教程
英文名LYNDA.COM SQL SERVER TRIGGERS STORED PROCEDURES AND FUNCTIONS
资源格式光盘镜像
主讲人Martin Guidry
发行日期2012年9月24日
地区美国
对白语言英语
文字语言英文
简介

IPB Image

语言:英语
网址: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

IPB Image

资源更新列表


http://www.VeryCD.com/i/5190747/create/fol...postTime

IPB Image



目录

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.

正在读取……

这里是其它用户补充的资源(我也要补充):

暂无补充资源
正在加载,请稍等...

点击查看所有222网友评论

 

(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

    小贴士:
  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。