Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies

Name: Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies
Author: Robert Schneider

Paperback Engels 2008 9780470179543

Verwachte levertijd ongeveer 8 werkdagen

43,43

In winkelwagen

Samenvatting

Your one-stop guide to the SQL Server 2008 database management system

If you're in charge of database administration, developing database software, or looking for database solutions for your company, 'Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies' can help you get a handle on this extremely popular relational database management system. Here you'll find what's new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy.

Youll discover how to:
- Choose the right version of SQL Server
- Install SQL Server quickly
- Design a database and communicate with it
- Monitor, maintain, and protect your data
- Build solid, robust database applications

Specificaties

ISBN13:9780470179543

Taal:Engels

Bindwijze:paperback

Aantal pagina's:747

Uitgever:Wiley Computing

Druk:1

Hoofdrubriek:IT-management / ICT

Serie:Dummies (Engelstalig)

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Schrijf een recensie

Geef uw waardering

Zeer goed Goed Voldoende Matig Slecht

Over Darril Gibson

Darril Gibson, CISSP, Security+, CASP, is the CEO of YCDA (short for You Can Do Anything), and he has authored or coauthored more than 40 books. Darril regularly writes, consults, and teaches on a wide variety of technical and security topics and holds several certifications.

Andere boeken door Darril Gibson

Bekijk alle boeken

Inhoudsopgave

Introduction

Book 1: Essential concepts
1. Introducing SQL Server 2008
2. SQL Server architecture and key concepts
3. Getting started, getting around
4. Setting up SQL Server 2008
5. Using SQL Server Management Studio

Book 2: Designing and using databases
1. Setting up a database
2. Care and feeding of your database
3. Data types and how to use them
4. Constructing new tables
5. Looking after your tables
6. Understanding relationships

Book 3: Interacting with your data
1. Using proper normalization techniques
2. The SQL Server optimiser
3. Using the query designer
4. Setting Query designer
5. Searching for information
6. Organizing query results
7. Modifying tour data
8. Taking advantage of views
9. Advanced query topics

Book 4: Database programming
1. Understanding Transact-SQL
2. Stored procedures and functions
3. Triggers
4. Working with Visual Studio
5. Web Services
6. Developing Remote Applications
7. Advanced Development Topics

Book 5: Reporting Services
1. Introduction to SQL Server Reporting Services
2. Creating Reports with Reporter Builder
3. Creating Reports with Report Designer
4. Integrating Reports

Book 6: Analysis Services
1. Introduction to SQL Server Analysis Services
2. Creating Business Intelligence Solution with BIDS
3. Data Mining and Maintaining Analysis Services Objects

Book 7: Performance Tips and Tricks
1. Working with the SQL Server Optimizer
2. Using Performance monitoring Tools
3. Data Access Strategies
4. Tuning SQL Server

Book 8: Database Administration
1. Configuring SQL Server
2. Performing Major Administering Tasks
3. Security: keeping SQL Server Safe
4. Integration and your Database
5. Replication
6. spreading the load with partitioning

Book 9: Appendixes
A: Ten sources of information on SQL Server 2008
B: Troubleshooting SQL Server 2008
C: Glossary

Index