Summer Reading B2G1 Free
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | July 15, 2015

    Frank Wilczek: IMG You Are... Who?



    Writing a book is an unnatural act of communication. Speaking to a person, or even to an audience, is an interaction. Very different styles are... Continue »
    1. $20.97 Sale Hardcover add to wish list

    spacer

This item may be
out of stock.

Click on the button below to search for this title in other formats.


Check for Availability
Add to Wishlist

This title in other editions

Mastering Microsoft SQL Server 2005 (Mastering)

Mastering Microsoft SQL Server 2005 (Mastering) Cover

ISBN13: 9780782143805
ISBN10: 0782143806
All Product Details

 

Synopses & Reviews

Publisher Comments:

The Comprehensive Resource for SQL Server 2005 Administrators, Consultants, and Developers

Whether you're a systems administrator, database application developer, or IT consultant, you'll quickly ratchet up your knowledge of Microsoft SQL Server 2005 with this thorough and comprehensive guide. Light on theory and heavy on practicality, it cuts to the chase with real-world examples of large-scale business applications, an entire chapter on troubleshooting, and crucial information on SQL Server 2005's enhanced connectivity. For new users of Microsoft SQL Server, this book takes you quickly, but systematically, through the introductory topics.

Coverage Includes

  • Integrating SQL Server with .NET Framework
  • Understanding Service Broker, a distributed application framework
  • Programming with ADO.NET, the data-access component of .NET
  • Setting up Notification Services, which delivers personalized information to mobile devices
  • Using SQL Server Management Studio instead of Enterprise Manager
  • Designing made easier with new Business Intelligence Development Studio (BIDS)
  • Printing multi-page reports
  • Mastering Transact-SQL programming language

Leverage the Experience of Large-Scale Enterprises through Real-World Examples

Increase Your Own Productivity with an Entire Chapter on Troubleshooting

Discover What SQL Server 2005's Increased Emphasis on Connectivity Means to Your Installation

Start Developing Apps—All the Information You Need!

www.sybex.com

Synopsis:

SQL Server is Microsoft's best-selling database because it is highly flexible, customizable, and has excellent support. The new version places heavy emphasis on connectivity. Among the enhancements are integration of SQL Server with the .NET Framework; programming with ADO.NET, the data-access component of the .NET framework; Notification Services, which delivers personalized information to mobile devices; and Service Broker, a distributed application framework for large-scale business applications. SQL Server 2005 is a full-feature database designed to handle the needs of the largest enterprises.

About the Author

Mike Gunderloy is one of the world's foremost database developers. He has written Mastering SQL Server 2000, Visual Basic Developer's Guide to ADO, and SQL Server In Record Time and contributed to Access Developer's Handbook (in several versions), all from Sybex.

Joseph L. Jorden is the co-author of Mastering SQL Server 2000 and has served as the technical editor for several Sybex books.

David W. Tschanz has worked on a variety of pro-jects related to Web-accessible information and also serves as a computer security liaison.

Table of Contents

Introduction.

Part 1: Introducing SQL Server.

Chapter 1: Introduction to SQL Server 2005.

Chapter 2: Overview of Database Concepts.

Chapter 3: Overview of SQL Server.

Chapter 4: Database Design and Normalization.

Part 2: Transact-SQL.

Chapter 5: Transact-SQL Overview and Basics.

Chapter 6: SELECT Queries.

Chapter 7: Action Queries.

Chapter 8: Topics in Advanced Transact-SQL.

Part 3: Digging into SQL Server.

Chapter 9: Using SQL Server Management Studio.

Chapter 10: Databases.

Chapter 11: Tables.

Chapter 12: Indexing.

Chapter 13: Views.

Chapter 14: Stored Procedures.

Chapter 15: Using Triggers.

.Part 4: Administering SQL Server.

Chapter 16: Basic Administrative Tasks.

Chapter 17: Automating Administration.

Chapter 18: Security and SQL Server 2005.

Part 5: Development with SQL Server.

Chapter 19: Integrating SQL Server with Microsoft .NET.

Chapter 20: ADO.NET and SQL Server.

Chapter 21: SMO and RMO Programming.

Chapter 22: Integration Services.

Part 6: Advanced Topics.

Chapter 23: Locking.

Chapter 24: Monitoring and Optimizing SQL Server 2005.

Chapter 25: Replication.

Chapter 26: Analysis Services.

Chapter 27: Notification Services.

Chapter 28: Reporting Services.

Chapter 29: Service Broker.

Chapter 30: Troubleshooting.

Appendix A: Transact-SQL Reference.

Index.

What Our Readers Are Saying

Add a comment for a chance to win!
Average customer rating based on 1 comment:

iamabc, December 17, 2007 (view all comments by iamabc)
I borrowed this book from a friend and read it.From basic topics to totally advanced topics in SQL,this book covers everything.I decided to buy this book.A must-buy for anyone who wants to learn SQL.
Was this comment helpful? | Yes | No
(3 of 3 readers found this comment helpful)

Product Details

ISBN:
9780782143805
Publisher:
Sybex
Subject:
Database management
Author:
Jorden, Joseph L.
Author:
Dav
Author:
Tschanz, David W.
Author:
id W. Tschanz
Author:
Gunderloy, Mike
Subject:
Client-server computing
Subject:
Database Management - SQL Server
Subject:
Database Management - General
Subject:
Programming - Software Development
Copyright:
Edition Description:
WebSite Associated w/Book
Series:
Mastering
Publication Date:
20060306
Binding:
Electronic book text in proprietary or open standard format
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
1108
Dimensions:
9.18x7.40x2.28 in. 3.29 lbs.

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management

Mastering Microsoft SQL Server 2005 (Mastering)
0 stars - 0 reviews
$ In Stock
Product details 1108 pages Sybex Inc - English 9780782143805 Reviews:
"Synopsis" by , SQL Server is Microsoft's best-selling database because it is highly flexible, customizable, and has excellent support. The new version places heavy emphasis on connectivity. Among the enhancements are integration of SQL Server with the .NET Framework; programming with ADO.NET, the data-access component of the .NET framework; Notification Services, which delivers personalized information to mobile devices; and Service Broker, a distributed application framework for large-scale business applications. SQL Server 2005 is a full-feature database designed to handle the needs of the largest enterprises.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.