Cart
Free Shipping in Australia
Proud to be B-Corp

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

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

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


$37.99
Condition - Very Good
Only 2 left

Summary

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.

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

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

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. 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 Dummies is 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!

About RD Schneider

Robert D. Schneider is a database optimization consultant who has been delivering software solutions for 15 years. Darril Gibson is a professional trainer specializing in certification and Microsoft technologies.

Table of Contents

I ntroduction 1 Book I: Essential Concepts 7 Chapter 1: Introducing SQL Server 2008 9 Chapter 2: SQL Server Architecture and Key Concepts 15 Chapter 3: Getting Started, Getting Around 23 Chapter 4: Setting Up SQL Server 2008 35 Chapter 5: Using SQL Server Management Studio 59 Book II: Designing and Using Databases 73 Chapter 1: Setting Up a Database 75 Chapter 2: Care and Feeding of Your Database 89 Chapter 3: Data Types and How to Use Them 99 Chapter 4: Constructing New Tables 121 Chapter 5: Looking After Your Tables 141 Chapter 6: Understanding Relationships 155 Book III: Interacting with Your Data 175 Chapter 1: Using Proper Normalization Techniques 177 Chapter 2: The SQL Server Optimizer 187 Chapter 3: Using the Query Designer 201 Chapter 4: Setting Query Options 213 Chapter 5: Searching for Information 231 Chapter 6: Organizing Query Results 257 Chapter 7: Modifying Your Data 265 Chapter 8: Taking Advantage of Views 273 Chapter 9: Advanced Query Topics 291 Book IV: Database Programming 313 Chapter 1: Understanding Transact-SQL 315 Chapter 2: Stored Procedures and Functions 331 Chapter 3: Triggers 349 Chapter 4: Working with Visual Studio 361 Chapter 5: Web Services 375 Chapter 6: Developing Remote Applications 385 Chapter 7: Advanced Development Topics 401 Book V: Reporting Services 419 Chapter 1: Introduction to SQL Server Reporting Services 421 Chapter 2: Creating Reports with Report Builder 435 Chapter 3: Creating Reports with Report Designer 449 Chapter 4: Integrating Reports 469 Book VI: Analysis Services 477 Chapter 1: Introduction to SQL Server Analysis Services 479 Chapter 2: Creating Business Intelligence Solutions with BIDS 493 Chapter 3: Data Mining and Maintaining Analysis Services Objects 517 Book VII: Performance Tips and Tricks 529 Chapter 1: Working with the SQL Server Optimizer 531 Chapter 2: Using Performance Monitoring Tools 541 Chapter 3: Data Access Strategies 569 Chapter 4: Tuning SQL Server 587 Book VIII: Database Administration 601 Chapter 1: Configuring SQL Server 603 Chapter 2: Performing Major Administrative Tasks 619 Chapter 3: Security: Keeping SQL Server Safe 647 Chapter 4: Integration and Your Database 661 Chapter 5: Replication 677 Chapter 6: Spreading the Load with Partitioning 693 Book IX: Appendixes 701 Appendix A: Ten Sources of Information on SQL Server 2008 703 Appendix B: Troubleshooting SQL Server 2008 707 Appendix C: Glossary 715 Index 725

Additional information

GOR003418106
9780470179543
0470179546
Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies by RD Schneider
Used - Very Good
Paperback
John Wiley & Sons Inc
20080926
768
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

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