《SQL Server 数据库编程教程》[光盘镜像]
收藏本资料
本资料所属分类:
电脑
数据库
SQL Server
更新时间:2012年11月12日
如不能下载,请查看怎样下载
中文名: SQL Server 数据库编程教程
英文名: LYNDA.COM SQL SERVER TRIGGERS STORED PROCEDURES AND FUNCTIONS
资源格式: 光盘镜像
主讲人: Martin Guidry
发行日期: 2012年9月24日
地区: 美国
对白语言: 英语
文字语言: 英文
简介:
语言:英语
类别:教程
由Lynda出品的SQL Server 数据库编程教程。
教学时长:1小时52分钟,
主讲:Martin Guidry
教程所使用的软件:SQL Server
目录:
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
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.
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