Microsoft SQL Server 2005: A Beginner

Microsoft SQL Server 2005: A Beginner"s Guide

by Dusan Petkovic
     
 

View All Available Formats & Editions

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

See more details below

Overview

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

Read More

Product Details

ISBN-13:
9780072260939
Publisher:
McGraw-Hill Professional Publishing
Publication date:
10/16/2005
Series:
Essential Skills for Database Professionals Ser.
Pages:
704
Sales rank:
1,453,792
Product dimensions:
7.40(w) x 9.20(h) x 1.35(d)

Related Subjects

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >