Microsoft SQL Server 2005: A Beginner's Guide - Softcover

Du an Petković

  • 3.75 out of 5 stars
    16 ratings by Goodreads
 
9780072260939: Microsoft SQL Server 2005: A Beginner's Guide
Softcover
ISBN 10: 0072260939 ISBN 13: 9780072260939
Publisher: McGraw Hill, 2005

Synopsis

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 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

"synopsis" may belong to another edition of this title.

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.

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 this title" may belong to another edition of this title.

Publisher
McGraw Hill
Publication date
2005
Language
English
ISBN 10 
0072260939
ISBN 13 
9780072260939
Binding
Paperback
Edition number
1
Number of pages
704
Rating
  • 3.75 out of 5 stars
    16 ratings by Goodreads