Product Description

It's been five years since Microsoft released a new version of SQL Server—which holds 39% of the Windows database market—and the latest edition of this bestselling beginner's guide gets users up and running on SQL Server 2005. The book covers database concepts, and discusses key topics for new users including the SQL Server Workbench,T-SQL, automated administration tasks, security, and analysis.

Product Details

• Amazon Sales Rank: #192906 in Books
• Published on: 2006-01-01
• Original language: English
• Number of items: 1
• Binding: Paperback
• 704 pages

From the Back Cover

Deploy and manage SQL Server 2005 with ease

Learn to use all the powerful features available in SQL Server 2005 from this straightforward, hands-on guide. Set up SQL Server 2005, automate system administration tasks, execute simple and complex database queries, and use the robust analysis, business intelligence, and reporting tools. Troubleshooting, data partitioning, replication, and query optimization are also covered. With SQL Server 2005: A Beginner’s Guide, you’ll be able to set up a secure, reliable, and productive data management platform in no time.

Essential Skills for Database Professionals

• Install and customize SQL Server 2005
• Create, alter, and remove database objects with Transact-SQL statements
• Use SQL Server as a native XML database system
• Tune your database system for optimal performance
• Use the new SQL Server Management Studio tool for executing and analyzing ad hoc queries
• Retrieve data from more than one source using join operations and SELECT statements
• Secure your database using two different authentication modes--Windows and mixed
• Restore databases using transaction logs and backup and recovery methods
• Streamline system administration tasks using the SQL Server Agent service tool
• Analyze and manage information stored in a data warehouse with Microsoft Analysis Services

About the Author
Dusan Petkovic is a professor in the Department of Computer Science at the Polytechnic in Rosenheim, Germany. He is the bestselling author of two editions of SQL Server: A Beginner’s Guide and is a frequent contributor to SQL Server magazine.

Customer Reviews

Previous Experience of SQL Server Required...
Had this book for about 6 months now, and it has quickly become a "Bible" on my desk. If you have experience of SQL or SQL Server and need help to get to 2005 this is probably the book for you, however for a complete beginner I wouldn't recommend this book.

Real practical steps how to make things work, from simple T-SQL scripting, right the way up through pretty advanced SQL Server 2005 administration, and everything inbetween.

Only down side to this book is the author does seem to flit between understandable concepts to very difficult ones from page to page which usually results in looking into the index and re-reading previous pages.

I'm not a database administrator by any stretch of the imagination but for my use of reporting and general occasional admin this book is great!