|
Programming Microsoft SQL Server 2005
Get the straightforward information you need to learn the core programmability features in SQL Server 2005. This guide offers hands-on programming instruction, practical examples, and code samples to help you design and develop robust database applications and business intelligence solutions. Discover how to: *Program views, stored procedures, triggers,
and functions using T-SQL *Work with the new XML data type and XQuery method *Automate common administration and maintenance tasks *Debug databases, reports, and objects using Microsoft Visual Studio 2005 * Write transactional code and implement local and distributed transactions *Develop mobile data applications using SQL Server 2005 Everywhere Edition *Use SQL Server Notification Services to develop applications that deliver event-driven notifications to users *Use business intelligence tools, such as SQL Server Reporting Services and OLAP and data mining components PLUS - Get C# code samples on the Web
FEATURES:
Discover how to:
*Program views, stored procedures, triggers, and functions using T-SQL
*Work with the new XML data type and XQuery method
*Automate common administration and maintenance tasks
*Debug databases, reports, and objects using Microsoft Visual Studio 2005
*Write transactional code and implement local and distributed transactions
*Develop mobile data applications using SQL Server 2005 Everywhere Edition
*Use SQL Server Notification Services to develop applications that deliver event-driven notifications to users
*Use business intelligence tools, such as SQL Server Reporting Services and OLAP and data mining components
PLUS - Get C# code samples on the Web
CONTENTS:
Part 1 - Design Fundamentals and Core Technologies
1 - Overview
2 - Exploring the T-SQL Enhancements in SQL Server 2005
3 - An Overview of SQL CLR
4 - XML and the Relational Database
5 - Introducing SQL Server Management Studio
6 - Using SQL Server Management Objects (SMO)
7 - SQL Server 2005 Security
Part 2 - Applications Development and Reach Technologies
8 - ADO.NET 2.0, Typed DataSet Objects and .NET Data Binding
9 - Debugging
10 - SQL Server 2005 Native XML Web Services
11 - Transactions
12 - SQL Server Service Broker: The New Middleware
13 - Using SQL Server 2005 Notification Services
14 - Developing Desktop Applications with SQL Server Express Edition
15 - Developing Applications with SQL Server 2005 Everywhere Edition and SQL Server Merge Replication
Part 3 - Reporting and Business Intelligence
16 - Using SQL Server 2005 Integration Services
17 - Basic OLAP
18 - Advanced OLAP
19 - OLAP Application Development
20 - Extending your Database System with Data Mining
21 - Reporting Services
Index
|
