- Used Books
- Kobo eReading
- Staff Picks
- Gifts & Gift Cards
- Sell Books
- Stores & Events
Special Offers see all
More at Powell's
Recently Viewed clear list
New Trade Paper
Ships in 1 to 3 days
Other titles in the For Dummies series:
Microsoft SQL Server 2008 for Dummies (For Dummies)by Mike Chapple
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
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:
* 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
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: 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.
What Our Readers Are Saying
Other books you might like
Computers and Internet » Computer Languages » SQL