Programming Microsoft SQL Server

Andrew J. Brust, Stephen Forte

900 pages, parution le 30/06/2006

Ajouter à une liste

Indisponible

Résumé

Essential reference guide to understanding fundamentals of programming SQL Server 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

Sommaire

Design Fundamentals and Core Technologies
- Overview
- Exploring the T-SQL enhancements in SQL Server 2005
- An overview of SQL CLR
- XML and the relational database
- Introducing SQL Server management studio
- Using SQL Server management objects (SMO)
- SQL Server 2005 security
Applications Development and Reach Technologies
- ADO.NET 2.0, typed dataset objects, and .NET data binding
- Debugging
- SQL Server 2005 native XML Web services
- Transactions
- SQL Server service broker : the new middleware
- Using SQL Server 2005 notification services
- Developing desktop applications with SQL Server Express edition
- Developing applications with SQL Server 2005 Everywhere edition and SQL Server merge replication
Reporting and Business Intelligence
- Using SQL Server 2005 integration services
- Basic OLAP
- Advanced OLAP
- OLAP application development
- Extending your database system with data mining
- Reporting services

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Microsoft Press
Auteur(s)	Andrew J. Brust, Stephen Forte
Parution	30/06/2006
Nb. de pages	900
Format	19 x 23
Couverture	Broché
Poids	1355g
Intérieur	Noir et Blanc
EAN13	9780735619234
ISBN13	978-0-7356-1923-4