Microsoft SQL Server 2005: A Beginner''s Guide

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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 ProfessionalsInstall and customize SQL Server 2005Create, alter, and remove database objects with Transact-SQL statementsUse SQL Server as a native XML database systemTune your database system for optimal performanceUse the new SQL Server Management Studio tool for executing and analyzing ad hoc queriesRetrieve data from more than one source using join operations and SELECT statementsSecure your database using two different authentication modes--Windows and mixedRestore databases using transaction logs and backup and recovery methodsStreamline system administration tasks using the SQL Server Agent service toolAnalyze and manage information stored in a data warehouse with Microsoft Analysis Services