LIBRARY AND INFORMATION CENTRE

UNIVERSITY OF AGRICULTURAL SCIENCES

Mastering SQL server 2008 [electronic resource] / Michael Lee, Gentry Bieker.

By: Lee, Michael, 1966-Contributor(s): Bieker, GentryMaterial type: TextTextSeries: Serious skills: Publisher: Indianapolis, Ind. : Wiley Pub., c2009Description: 1 online resource (xxvi, 766 p.) : illISBN: 9780470467398 (electronic bk.); 0470467398 (electronic bk.); 6612012358 (electronic bk.); 9786612012358 (electronic bk.); 9781118257388 (electronic bk.); 1118257383 (electronic bk.)Subject(s): Client/server computing | SQL server | Relational databases | COMPUTERS -- Data ProcessingGenre/Form: Electronic books.Additional physical formats: Print version:: Mastering SQL server 2008.DDC classification: 005.75/85 Online resources: UASB, GKVK
Contents:
Overview of Microsoft SQL server 2008 -- Understanding SQL server architecture -- Databases, files, and resource management -- Tables and CRUD operations -- Procedural programming -- Managing data integrity -- SQL server and XML -- Managing user security -- Data recovery -- Monitoring SQL server activity -- Using the SQL server agent service -- Data availability and distribution -- SQL server data security -- Indexing strategies for query optimization -- Transactions and locking -- Using the resource governor and policy-based management -- SQL server and the .NET client -- SQL server and the common language runtime -- Using spatial data -- Service-oriented architecture and the service broker -- Full-text search services.
Summary: Whether you're a database administrator or application developer, this in-depth guide is your key to delivering improved data collection, storage, reporting, and security with SQL Server 2008. Mastering SQL Server 2008 brings you up to speed on architecture, installation, and configuration essentials, before moving to the step-by-step instruction you need for more advanced topics such as procedural programming, query optimization, how to use spatial data, SQL Server in the .NET world, and more. You'll master the extensive toolset, explore useful third-party tools, and most importantly, find out how to choose and use the right SQL Server features for the specific tasks you have.
Tags from this library: No tags from this library for this title. Log in to add tags.
    Average rating: 0.0 (0 votes)
Item type Current location Call number Status Date due Barcode
e-Books e-Books GKVK Library
Available eB-67

Includes index.

Overview of Microsoft SQL server 2008 -- Understanding SQL server architecture -- Databases, files, and resource management -- Tables and CRUD operations -- Procedural programming -- Managing data integrity -- SQL server and XML -- Managing user security -- Data recovery -- Monitoring SQL server activity -- Using the SQL server agent service -- Data availability and distribution -- SQL server data security -- Indexing strategies for query optimization -- Transactions and locking -- Using the resource governor and policy-based management -- SQL server and the .NET client -- SQL server and the common language runtime -- Using spatial data -- Service-oriented architecture and the service broker -- Full-text search services.

Whether you're a database administrator or application developer, this in-depth guide is your key to delivering improved data collection, storage, reporting, and security with SQL Server 2008. Mastering SQL Server 2008 brings you up to speed on architecture, installation, and configuration essentials, before moving to the step-by-step instruction you need for more advanced topics such as procedural programming, query optimization, how to use spatial data, SQL Server in the .NET world, and more. You'll master the extensive toolset, explore useful third-party tools, and most importantly, find out how to choose and use the right SQL Server features for the specific tasks you have.

Description based on print version record.

There are no comments on this title.

to post a comment.

Hosted by GKVK Library | Powered by Koha