Microsoft SQL Server 2005 for Dummies

430 pages, parution le 21/02/2006

Ajouter à une liste

Indisponible

Résumé

Now updated to reflect the much-anticipated "Yukon" release of SQL Server, this friendly guide shows database developers and administrators as well as those who use database application how to get up to speed fast
Offers a gentle introduction to relational database design and shows how to build databases, create database applications, and maintain and optimize database performance
Covers the major new features of the "Yukon" release-including analysis services, reporting services, and notification services
The CD-ROM contains an evaluation copy of Microsoft SQL Server

Andrew Watt est chercheur senior au sein de la Confédération européenne des syndicats.

SQL Server 2005: An Overview
- Introducing SQL Server 2005
- New Features in SQL Server 2005
- Introducing and Configuring Management Studio
Basic Operations
- Creating Databases, Tables, and Relationships with T-SQL
- Asking Questions and Getting Answers
- Building a Simple Application
Working with SQL Server
- Working with XML
- Using the Common Language Runtime
- Using Stored Procedures
- Error Handling in T-SQL
Protecting Your Data
- Securing Your Data
- Availability and Preventing Data Loss
- Maintaining Integrity with Transactions
- Maintaining Data Integrity with Constraints and Triggers
Administering a SQL Server System
- Configuring a SQL Server System
- Scheduling SQL Server Agent Jobs
- Sending Information Using Notification Services
- Maintaining a SQL Server System
- Working with Multiple Servers
Using SQL Server Business Intelligence (BI) Services
- SQL Server Integration Services
- Analysis Services
- Building Business Reports with Reporting Services
The Part of Tens
- Ten Sources of Information on SQL Server 2005
- Products that Work with SQLServer 2005

Voir tout

Replier