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

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

  • Length: 768 pages
  • Edition: 1
  • Publisher:
  • Publication Date: 2008-09-29
  • ISBN-10: 0470179546
  • ISBN-13: 9780470179543
  • Sales Rank: #1111633 (See Top 100 Books)
Description

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 Dummiescan 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. You’ll discover how to:

  • Build and maintain tables
  • Design a database and communicate with it
  • Retrieve, analyze, and report data
  • Build solid, robust database applications
  • Use the SQL Server Optimizer and Query Designer
  • Navigate SQL Server with Visual Studio
  • Develop useful reports with the Report Builder and Report Designer
  • Create Business Intelligence solutions with Business Intelligence Development Studio
  • Configure your server and perform major administrative tasks

To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummiesis divided into nine minibooks:

  • Essential Concepts
  • Designing and Using Databases
  • Interacting With Your Data
  • Database Programming
  • Reporting Services
  • Analysis Services
  • Performance Tips and Tricks
  • Database Administration
  • Appendixes

Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!

Table of Contents

Book I Essential Concepts
Chapter 1: Introducing SQL Server 2008
Chapter 2: SQL Server Architecture and Key Concepts
Chapter 3: Getting Started, Getting Around
Chapter 4: Setting Up SQL Server 2008
Chapter 5: Using SQL Server Management Studio

Book II Designing and Using Databases
Chapter 1: Setting Up a Database
Chapter 2: Care and Feeding of Your Database
Chapter 3: Data Types and How to Use Them
Chapter 4: Constructing New Tables
Chapter 5: Looking After Your Tables
Chapter 6: Understanding Relationships

Book III Interacting with Your Data
Chapter 1: Using Proper Normalization Techniques
Chapter 2: The SQL Server Optimizer
Chapter 3: Using the Query Designer
Chapter 4: Setting Query Options
Chapter 5: Searching for Information
Chapter 6: Organizing Query Results
Chapter 7: Modifying Your Data
Chapter 8: Taking Advantage of Views
Chapter 9: Advanced Query Topics

Book IV Database Programming
Chapter 1: Understanding Transact-SQL
Chapter 2: Stored Procedures and Functions
Chapter 3: Triggers
Chapter 4: Working with Visual Studio
Chapter 5: Web Services
Chapter 6: Developing Remote Applications
Chapter 7: Advanced Development Topics

Book V Reporting Services
Chapter 1: Introduction to SQL Server Reporting Services
Chapter 2: Creating Reports with Report Builder
Chapter 3: Creating Reports with Report Designer
Chapter 4: Integrating Reports

Book VI Analysis Services
Chapter 1: Introduction to SQL Server Analysis Services
Chapter 2: Creating Business Intelligence Solutions with BIDS
Chapter 3: Data Mining and Maintaining Analysis Services Objects

Book VII Performance Tips and Tricks
Chapter 1: Working with the SQL Server Optimizer
Chapter 2: Using Performance Monitoring Tools
Chapter 3: Data Access Strategies
Chapter 4: Tuning SQL Server

Book VIII Database Administration
Chapter 1: Configuring SQL Server
Chapter 2: Performing Major Administrative Tasks
Chapter 3: Security: Keeping SQL Server Safe
Chapter 4: Integration and Your Database
Chapter 5: Replication
Chapter 6: Spreading the Load with Partitioning

Book IX Appendixes
Appendix A: Ten Sources of Information on SQL Server 2008
Appendix B: Troubleshooting SQL Server 2008
Appendix C: Glossary

To access the link, solve the captcha.