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
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
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
|
0121 702 2828 
Published by: MICROSOFT PRESS