Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies
- Length: 768 pages
- Edition: 1
- Language: English
- Publisher: For Dummies
- Publication Date: 2008-09-29
- ISBN-10: 0470179546
- ISBN-13: 9780470179543
- Sales Rank: #1111633 (See Top 100 Books)
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
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.