Professional SQL Server 2000 Programming (June 2003 reprint) View Larger Image | Robert Vieira
Wrox Press, Paperback, Published November 2000, 1440 pages, ISBN 0764543792 | List Price: $59.99
Our Price: $37.50
You Save: $22.49 (37% Off)
| | | Availability: Out-Of-Stock |
Customer Reviews: 2 Average Customer Rating:    Write a Review and tell the world about this title! People who purchase this book frequently purchase: - Professional SQL Server 2000 DTS (June 2003 reprint); Mark Chaffin, et al, $30.95, 38% Off!
- The Guru's Guide to Transact-SQL; Ken Henderson, $40.95, 37% Off!
- Inside Microsoft SQL Server 2000; Kalen Delaney, $35.95, 40% Off!
- Professional C#, 3rd Edition; Simon Robinson, et al, $31.50, 37% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
SQL Server 2000 is the latest and most powerful version of Microsoft's data
warehousing and relational database management system. This new release is tightly
integrated with Windows 2000 and offers more support for XML, as well as improved
Analysis Services for OLAP and data mining.
Professional SQL Server 2000 provides a comprehensive guide to programming
with SQL Server 2000, from a complete tutorial on Transact-SQL to an in-depth
discussion of new features, such as indexed views, user-defined functions, and
the wealth of new SQL Server features to support XML. Whether you're coming
to SQL Server 2000 from another relational database management system, upgrading
your existing system, or perhaps wanting to add programming skills to your DBA
knowledge, you'll find what you need in this book to get to grips with SQL Server
2000 development.
Here are just a few of the things covered in this book:
- A complete introduction to Transact-SQL
- Database design issues
- Creating and using views, stored procedures, and user- defined functions
- Responding to events with triggers
- Making your SQL Server secure
- Retrieving your data as XML
- An introduction to Analysis Services
- Moving data using Data Transformation Services and the bulk copy program
- Maintaining the integrity of distributed data with replication
This book is aimed at the SQL Server developer who wants to make the most out
of the new features of SQL Server 2000. No knowledge of SQL Server is assumed,
although in order to follow this book, you do need to have an understanding
of programming basics such as variables, data types, and procedural programming.
Database administration is also covered but only as it affects the SQL Server
developer.
Table of Contents
Introduction.
Chapter 1: SQL Server 2000 – Particulars and History.
Chapter 2: RDBMS Basics: What Makes Up a SQL Server Database?
Chapter 3: Tools of the Trade.
Chapter 4: The Foundation Statements of T-SQL.
Chapter 5: Joining Tables.
Chapter 6: Creating and Altering Tables.
Chapter 7: Constraints.
Chapter 8: Normalization and Other Basic Design Issues.
Chapter 9: SQL Server Storage and Index Structures.
Chapter 10: Views.
Chapter 11: Writing Scripts and Batches.
Chapter 12: Stored Procedures.
Chapter 13: User Defined Functions.
Chapter 14: Transactions and Locks.
Chapter 15: Triggers.
Chapter 16: Advanced Queries.
Chapter 17: Distributed Queries and Transactions.
Chapter 18: SQL Cursors.
Chapter 19: A Brief XML Primer.
Chapter 20: Integration of XML into SQL Server.
Chapter 21: The Bulk Copy Program (bcp).
Chapter 22: Introduction to Data Transformation Services.
Chapter 23: Replication.
Chapter 24: Advanced Design.
Chapter 25: Analysis Services.
Chapter 26: Full-Text Search.
Chapter 27: English Query.
Chapter 28: Security.
Chapter 29: Performance Tuning.
Chapter 30: Administration Overview.
Chapter 31: Advanced DTS.
Chapter 32: Scripting Administrative Functions with WMI.
Appendix A: System Functions.
Appendix B: Function Listing.
Appendix C: Tools for Our Time.
Appendix D: Access Upsizing.
Appendix E: Microsoft Data Transformation Services Package Object Library Reference.
Index.
About the Author
Robert Vieira Experiencing his first bout with computing in 1978,
Robert Vieira knew right away that this was something "really cool".
In 1980 he began immersing himself into the computing world more fully –
splitting time between building and repairing computer kits, and programming
in BASIC as well as Z80 and 6502 assembly languages. In 1983, he began studies
for a degree in Computer Information Systems, but found the professional mainframe
environment too rigid for his tastes, dropping out in 1985 to pursue other interests.
Later that year, he caught the "PC bug" and began the long road of
programming in database languages from dBase to SQL Server. Rob completed a
degree in Business Administration in 1990, and has since typically worked in
roles that allow him to combine his knowledge of business and computing. Beyond
his Bachelor's degree, he has been certified as a Certified Management Accountant
as well as Microsoft Certified as a Solutions Developer (MCSD), Trainer (MCT),
and Database Administrator (MCDBA).
Rob is currently the Principal Consultant for Database and Storage Technologies
with the Technology and Innovation Group at STEP Technology in Portland, Oregon
– a position that offers the high-end consulting and team support he craves.
He resides with his wife Nancy, elder daughter Ashley, and new addition Adrianna,
in Vancouver, WA.
Customer Reviews
Customer Reviews: 2 Average Customer Rating: Apr 7, 2005
The only book you need for SQL Server 2000
This is simply the best technical book i have ever used. Relevavent and detailed examples. Along with the online help built into SQL Server this is the first and only book you need for SQL Server.
Dec 9, 2003 giacomo from Siena, Italy
very great book
The more deep and exaustive book I've read about T-SQL Programming. Very usefull even for SQL Server DBA.
|
