Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies (eBook)
768 Seiten
John Wiley & Sons (Verlag)
978-1-118-05194-8 (ISBN)
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!
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.
Introduction 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
| Erscheint lt. Verlag | 10.2.2011 |
|---|---|
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► SQL Server |
| Mathematik / Informatik ► Informatik ► Netzwerke | |
| Informatik ► Office Programme ► Outlook | |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| Schlagworte | Computer-Ratgeber • End-User Computing • Microsoft Other Software • Microsoft Sonstige Software • SQL Server |
| ISBN-10 | 1-118-05194-7 / 1118051947 |
| ISBN-13 | 978-1-118-05194-8 / 9781118051948 |
| Haben Sie eine Frage zum Produkt? |
EPUB (Adobe DRM)Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: EPUB (Electronic Publication)
EPUB ist ein offener Standard für eBooks und eignet sich besonders zur Darstellung von Belletristik und Sachbüchern. Der Fließtext wird dynamisch an die Display- und Schriftgröße angepasst. Auch für mobile Lesegeräte ist EPUB daher gut geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
