Microsoft SQL Server 2008 For DummiesISBN: 978-0-470-22465-6
Paperback
408 pages
September 2008
|
Part I: Welcome to SQL Server 2008.
Chapter 1: Introducing SQL Server 2008.
Chapter 2: Building Your SQL Server.
Chapter 3: Working with SQL Server Tools.
Part II: Building SQL Server 2008 Databases.
Chapter 4: Planning Your Database.
Chapter 5: Creating Databases and Tables.
Chapter 6: Imposing Constraints and Relationships.
Part III: Retrieving Data from Databases.
Chapter 7: Constructing Simple Database Queries.
Chapter 8: Joins and Other Advanced Queries.
Chapter 9: Turning Data into Information with SQL Server Reporting Services.
Part IV: Inserting and Manipulating Your Data.
Chapter 10: Inserting, Updating, and Deleting Data.
Chapter 11: Saving Time with Functions, Stored Procedures, and Triggers.
Part V: SQL Server Administration.
Chapter 12: Keeping Your SQL Server Running Smoothly.
Chapter 13: Automating SQL Server 2008 Administration.
Chapter 14: Troubleshooting SQL Server 2008 Problems.
Chapter 15: Replicating Data across Multiple Servers.
Part VI: Protecting Your Data.
Chapter 16: Protecting Your Data from Prying Eyes.
Chapter 17: Preserving the Integrity of Your Transactions.
Chapter 18: Preparing for Disaster.
Chapter 19: Staying Alive: High Availability in SQL Server 2008.
Chapter 20: Implementing Policy-Based Management with the Declarative Management Framework.
Part VII: The Part of Tens.
Chapter 21: Ten Ways to Keep Your SQL Server 2008 Databases Humming.
Chapter 22: Ten Database Design Tips.
Index.