《探索SQL Server 2005》(Exploring SQL Server 2005)DVD版本[ISO]

用户共享的电驴资源列表
[探索SQL.Server.2005].AppDev.-.Exploring.SQL.Server.2005.iso	959.28 MB
全选 复制选中链接 下载	959.28 MB

中文名: 探索SQL Server 2005英文名: Exploring SQL Server 2005资源格式: 光盘镜像版本: DVD版本发行时间: 2006年地区: 美国对白语言: 英语简介:
中文名称：探索SQL Server 2005
英文名称：Exploring SQL Server 2005
资源类型：ISO
版本：DVD版本
发行时间：2006年
地区：美国
语言：英语
简介：
本教程为网上收集，如果你喜欢请购买正版程序。
全英文教程，6模块，9小时多媒体教程。适合初学者学习，不过要求英语听力能力。
原教程介绍链接
Exploring SQL Server 2005
with Don Kiely
Want to get up to speed on Microsoft s new SQL Server 2005? SQL Server 2005 is a major upgrade from its very successful predecessor, SQL Server 2000. This course introduces you to the new technological advances in SQL Server 2005 that provide businesses decreased downtime, increased scalability and performance, and set a new standard on data security. You will also learn about many new features that greatly reduce application development time allowing developers to be highly productive.
Course includes 9+ hours of total training time...
6 modules of training
Over 9 hours of media run time
Sample code
Introduction to SQL Server 2005
Database Engine
Security
Analysis Services
Integration Services
Reporting Services
Notification Services
SQL Management Tools
Management Studio
Reports
Template Explorer
SQL Server Profiler
Database Tuning Advisor
Configuration Manager
Surface Area Configuration
SQLCMD
Authorization
Strong Password Policies
Password Policies
Changing a Login
SQL 2005 Principals
Securable Objects
Metadata Visibility
Security in Practice
Execution Contexts
Ownership Chains
When to Use Each Option
Users and Schemas
Synonyms
Encryption
Algorithms
Encryption Hierarchy
Service Master Key
Database Master Key
Use a Certificate
Asymmetric Keys
Symmetric Keys
SQLCLR
Introduction to SQLCLR
Why Use SQLCLR Code?
Creating Raw SQLCLR Code
Create with Visual Studio
Deploy the UDF
Deployment Notes
Data Access in SQLCLR
User-Defined Functions
Stored Procedures
More SQLCLR
Write a SQLCLR Stored Procedure
User-Defined Aggregates
Triggers
User-Defined Types
Troubleshooting Code
Security in SQLCLR
Permission Sets
Secure Coding Practices
T-SQL vs SQLCLR
SQL Management Objects
Management Frameworks
SMO Object Model
SMO Class Types
Code Behind the SMO Demo
Code to Connect to the Server
Create a Database
Delete a Database
Create a Table
SQL Express Visual Studio Integration
Introducing SQL Express
Client and Management Tools
Design Time Features
Create a Database Application
Deploy the Database Application
Server Explorer Features
SQL Reporting Services
ADO.NET Enhancements
New Data Types
Multiple Active Result Sets
Asynchronous Queries
Asynchronous Methods
Error Handling
Query Notifications
Working with Service Broker
Setup Database for Service Broker
Client Access Enhancements
Batch Updates
Bulk Copy
Changes to the DataTable
Stream Data into DT/DS
DataTable from a DataView
New Rowstate Features
XML
XML Data Type
Typed XML Data
Indexing XML Data
Using the XML Schema
Querying XML
XML Data Type Methods
XQuery Limits in SQL Server
T-SQL XML Enhancements
Retrieving XML
Path for Returning XML Data
Include Multiple Paths
Output Column Data as a TN
Include an Inline XML Schema
Nested FOR XML Queries
OpenXML Enhancements
XML Bulk Load
Web Services
Exposing Web Services
Create a Stored Procedure
Create a Web Service
View the WSDL
T-SQL Enhancements - Part 1
New Data Types
Using TOP
Using DML Output
Pivot/Unpivot Operators
T-SQL Enhancements - Part 2
Ranking Functions
Using Other Ranking Functions
Common Table Expressions
Using DDL Triggers
[通过安全测试]
杀毒软件：卡巴斯基防病毒软件6.0
版本： 2006.12.24
服务器:DonkeyServer No.1
共享时间：8PM-7AM.
[通过安装测试]Windows 2000 Advanced Server SP4/Windows 2000 Pro SP4/Windows XP SP2 + Deamon 4.33