• Contact

  • Newsletter

  • About us

  • Delivery options

  • Prospero Book Market Podcast

  • Microsoft SQL Server 2005: A Beginner''s Guide: A Beginner's Guide. Essential Skills for Database Professionals

    Microsoft SQL Server 2005: A Beginner''s Guide by Petkovic, Dusan;

    A Beginner's Guide. Essential Skills for Database Professionals

    Series: DATABASE & ERP - OMG;

      • GET 10% OFF

      • The discount is only available for 'Alert of Favourite Topics' newsletter recipients.
      • Publisher's listprice GBP 44.99
      • The price is estimated because at the time of ordering we do not know what conversion rates will apply to HUF / product currency when the book arrives. In case HUF is weaker, the price increases slightly, in case HUF is stronger, the price goes lower slightly.

        20 312 Ft (19 345 Ft + 5% VAT)
      • Discount 10% (cc. 2 031 Ft off)
      • Discounted price 18 281 Ft (17 411 Ft + 5% VAT)

    20 312 Ft

    db

    Availability

    Estimated delivery time: In stock at the publisher, but not at Prospero's office. Delivery time approx. 3-5 weeks.
    Not in stock at Prospero.

    Why don't you give exact delivery time?

    Delivery time is estimated on our previous experiences. We give estimations only, because we order from outside Hungary, and the delivery time mainly depends on how quickly the publisher supplies the book. Faster or slower deliveries both happen, but we do our best to supply as quickly as possible.

    Product details:

    • Publisher McGraw Hill
    • Date of Publication 16 January 2006

    • ISBN 9780072260939
    • Binding Paperback
    • No. of pages704 pages
    • Size 231x182x36 mm
    • Weight 1211 g
    • Language English
    • 0

    Categories

    Long description:

    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


    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

    More

    Table of Contents:

    Part I: SQL Server: Basic Concepts

    Chapter 1: Database Systems and SQL Server

    Chapter 2: SQL Server Management Studio

    Part II: Transact-SQL Language

    Chapter 3: SQL Components

    Chapter 4: Data Definition Language

    Chapter 5: Simple Queries

    Chapter 6: Complex Queries

    Chapter 7: Modification of a Table's Contents

    Chapter 8: Stored Procedures and User-Defined Functions

    Chapter 9: Indices and Query Optimization

    Chapter 10: Views

    Chapter 11: Systems Catalog

    Chapter 12: SQL Server Security

    Chapter 13: Triggers

    Chapter 14: Transactions

    Chapter 15: SQL Server System Environment

    Part III: SQL Server: System Administration

    Chapter 16: Overview of System Administration

    Chapter 17: Planning the Installation and Installing SQL Server

    Chapter 18: Managing Database and Database Files

    Chapter 19: Managing Security

    Chapter 20: Backup and Recovery

    Chapter 21: Automating Systems Administration Tasks

    Chapter 22: Performance and Tuning

    Chapter 23: Data Partitioning

    Chapter 24: Data Replication

    Part IV: Microsoft Analysis Services

    Chapter 25: Data Warehousing: An Introduction

    Chapter 26: Microsoft Analysis Services

    Chapter 27: Business Intelligence and SQL

    Chapter 28: Microsoft Reporting Services

    Part V: XML Support

    Chapter 29: Overview of XML

    Chapter 30: SQL Server 2005 and XML

    INDEX

    More

    0