Microsoft SQL Server 2008 Step by Step - Brossura

Hotek, Mike

Brossura

ISBN 10: 0735626049 ISBN 13: 9780735626041

Casa editrice: Microsoft Pr, 2008

Riassunto

Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems.

Discover how to:

• Install and work with core components and tools
• Create tables and index structures
• Manipulate and retrieve data
• Secure, manage, back up, and recover databases
• Apply tuning plus optimization techniques to generate high-performing database applications
• Optimize availability through clustering, database mirroring, and log shipping
• Tap business intelligence tools—Reporting, Analysis, and Integration Services

CD features:

• Practice exercises and code samples
• Fully searchable eBook

Su questo libro

L'autore:

Mike Hotek is a SQL Server expert with three decades' experience as a consultant and solution developer. He has written several books, including Microsoft SQL Server 2008 Step by Step.

Contenuti:

AcknowledgmentsIntroductionPart I: Getting Started with Microsoft SQL Server 2008

• Chapter 1: Overview of Microsoft SQL Server
• Chapter 2: Installing and Configuring SQL Server 2008
• Chapter 3: Using the Tools in SQL Server 2008

Part II: Designing Databases

• Chapter 4: Creating Databases
• Chapter 5: Designing Tables
• Chapter 6: Indexes
• Chapter 7: Partitioning

Part III: Retrieving and Manipulating Data

• Chapter 8: Data Retrieval
• Chapter 9: Advanced Data Retrieval
• Chapter 10: Data Manipulation

Part IV: Designing Advanced Database Objects

• Chapter 11: Views
• Chapter 12: Stored Procedures
• Chapter 13: Functions
• Chapter 14: Triggers
• Chapter 15: Database Snapshots
• Chapter 16: Service Broker
• Chapter 17: Full-Text Indexing

Part V: Database Management

• Chapter 18: Security
• Chapter 19: Policy-Based Management
• Chapter 20: Data Recovery
• Chapter 21: SQL Server Agent
• Chapter 22: Dynamic Management Views

Part VI: High Availability Overview

• Chapter 23: High Availability

Part VII: Business Intelligence

• Chapter 24: SQL Server Integration Services
• Chapter 25: SQL Server Reporting Services
• Chapter 26: SQL Server Analysis Services

About the AuthorAdditional Resources for Developers from Microsoft PressMore Great Developer Resources

Su questa edizione

• Editore: Microsoft Pr
• Data di pubblicazione: 2008
• ISBN 10: 0735626049
• ISBN 13: 9780735626041
• Rilegatura: Copertina flessibile
• Numero edizione: 1
• Numero di pagine: 505