SQL Server 7 Developer's Guide

3 avg rating
( 4 ratings by Goodreads )
 
9780078825484: SQL Server 7 Developer's Guide

Master SQL Server 7 database administration and application development, and learn ways to reduce Total Cost of Ownership within your organization, using this complete guide for power programmers. Written by two SQL Server experts, SQL Server 7 Developer's Guide combines start-to-finish coverage of core SQL Server 7 concepts with step-by-step programming examples in text and on CD-ROM. It also provides special tutorials on relational database concepts and building SQL statements - PLUS a complete guide to using Visual Basic for SQL Server application development.

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

Review:

SQL Server 7 Developer's Guide is equally divided into a database administrator's manual and a developer's primer, providing useful content for readers who are interested in both angles.

The book opens with overviews of the SQL Server database architecture and the new features of version 7. The management and security aspects of the all-important Enterprise Manager are covered in depth. The authors make very liberal use of screen shots and information tables, lending a visual look to this introduction. The first part continues with sections on replication, data warehousing, performance optimization, and SQL-DMO--the object-oriented framework that lets you write your own management applications.

Part 2 opens with a traditional look at databases and a focus on the relational model. After introducing you to entity-relationship diagrams and a rather detailed tutorial of the SQL language, the authors present each of the various ways to access SQL Server from client applications: Microsoft Access front ends, data access objects (DAO), Open DataBase Connectivity (ODBC)Direct, the ODBC API, Remote Data Objects, object linking and embedding database (OLE DB), ActiveX Data Objects, and DB-Library. The last chapter discusses Active Server Pages (ASP) development and how to integrate SQL Server databases with Web sites.

A companion CD-ROM contains all of the example code in the book and offers a centralized interface for running it. --Stephen W. Plain

From the Back Cover:

SQL Server 7 database development from start to finish!

Master SQL Server 7 database administration and application development, and learn ways to reduce Total Cost of Ownership within your organization, using this complete guide for power programmers. Written by two SQL Server experts, SQL Server 7 Developer's Guide combines start-to-finish coverage of core SQL Server 7 concepts with step-by-step programming examples in text and on CD-ROM. It also provides special tutorials on relational database concepts and building SQL statements - PLUS a complete guide to using Visual Basic for SQL Server application development.

Inside, learn about:
*Administration techniques using MMC and the Enterprise Manager
*Data access using Transact-SQL, SQL-DMO, ODBC, DB-Library, DAO, ODBCDirect, RDO, OLE DB, and ADO
*Breaking the speed limit on response times
*Performance tuning using SQL Profiler
*Rapid development using Access
*Web integration using ASP
*Integrated security and roles.

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

Top Search Results from the AbeBooks Marketplace

1.

Michael Otey; Michael Ctey; Paul Conte
Published by Osborne Publishing (1998)
ISBN 10: 0078825482 ISBN 13: 9780078825484
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description Osborne Publishing, 1998. Paperback. Book Condition: New. book. Bookseller Inventory # 0078825482

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 26.09
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Michael Otey, Michael Ctey, Paul Conte
Published by Osborne Publishing (1998)
ISBN 10: 0078825482 ISBN 13: 9780078825484
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Osborne Publishing, 1998. Paperback. Book Condition: New. Bookseller Inventory # DADAX0078825482

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 28.99
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds