Synopses & Reviews
SQL Server 2008 books are going to fly off the shelves. This product, currently code-named Katmai, promises significant advances in data warehousing , online transaction processing and other important areas. Microsoft's next release also benefits from great timing. Gartner estimates that the relational database market grew 8 0.000000rom 2004-2005 and Microsoft provided the driving force, growing at more than double the rate of its nearest competitor . Government labor experts forecast that the database administration career field will "grow much faster than the average ." These statistics all add up to an exciting market potential for SQL Server 2008 for Dummies.
SQL Server 2008 for Dummies will provide users with an approachable, friendly reference to Microsoft's next generation relational database. It offers coverage designed for the new SQL Server administrator interested in building and maintaining a SQL Server system, designing databases, and performing data manipulation. The book also provides an introduction to SQL Server's business intelligence, security, and disaster recovery capabilities.
Book Contents in Brief:
Part I: Welcome to SQL Server 2008
Chapter 1: Introducing SQL Server 2008
Chapter 2: The Wacky World of Databases
Chapter 3: Building Your SQL Server
Chapter 4: Working with Management Studio
Part II: Building Databases
Chapter 5: Planning Your Database
Chapter 6: Creating Databases and Tables
Chapter 7: The Keys to Relationship Management
Part III: Retrieving Data from Databases
Chapter 8: Simple Database Queries
Chapter 9: The Power of Marriage: Joining Tables Together
Chapter 10: Working With Database Views
Chapter 11: SQL Server Analysis Services
Part IV: Working With Your Data
Chapter 12: Inserting Data into Your Database
Chapter 13: Stored Procedures and User Functions
Chapter 14: Triggers
Chapter 15: Migrating from Access
Part V: SQL Server Administration
Chapter 16: Keeping Your Server Running Smoothly
Chapter 17: Automating Administration
Chapter 18: Replication
If you’re a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company’s data management — read Microsoft SQL Server 2008 For Dummies!
SQL Server 2008 lets you build powerful databases and create database queries that give your organization the information it needs to excel. Microsoft SQL Server 2008 For Dummies helps you build the skills you need to set up, administer, and troubleshoot SQL Server 2008. You’ll be able to:
- Develop and maintain a SQL Server system
- Design databases with integrity and efficiency
- Turn data into information with SQL Server Reporting Services
- Organize query results, summarizing data with aggregate functions and formatting output
- Import large quantities of data with SSIS
- Keep your server running smoothly
- Protect data from prying eyes
- Develop and implement a disaster recovery plan
- Improve performance with database snapshots
- Automate SQL Server 2008 administration
Microsoft SQL Server 2008 For Dummies is a great first step toward becoming a SQL Server 2008 pro!
* Rewritten from scratch by a new author, this accessible guide has been refocused to give novice database administrators (DBAs) the skills and knowledge they need to hit the ground running with SQL Server 2008
* Zeroes in on the essential know-how SQL Server DBAs need to succeed-installation, maintenance, administration, troubleshooting, and reporting
* Provides SQL Server veterans with a succinct overview of new 2008 features and functions, such as self-tuning and self-maintaining capabilities and the capacity to store multimedia data
* The valuable companion CD-ROM features a 180-day trial version of SQL Server 2008
* The job market for database administrators is projected to grow by 44 percent over the next decade, with Oracle and SQL Server DBAs leading the way
The fun and easy way® to build powerful databases
See how to administer, troubleshoot, and report like a pro in SQL Server
Are you ready to unleash the power hidden within your organization's data to meet business objectives? This book will help you build the skills that SQL Server database administrators must have to succeed. You'll find out how to develop and maintain a SQL Server system, design databases, manipulate data, and much more.
Discover how to:
Build your first SQL Server databases
Insert, manipulate, and retrieve data
Keep your database server running smoothly
Protect data from prying eyes
Improve performance with database snapshots
About the Author
Mike Chapple, MCDBA, CISA, CISSP, is an IT professional at the University of Notre Dame, where he teaches a computer applications course. He is a coauthor of the CISSP Study Guide.
Table of Contents
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.