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


    Q&A | July 20, 2015

    Jesse Ball: IMG Powell’s Q&A: Jesse Ball



    Describe your latest book. I woke up one day from a sort of daydream with an idea for a book's structure, and for the thread of that book, one... Continue »
    1. $16.80 Sale Hardcover add to wish list

      A Cure for Suicide

      Jesse Ball 9781101870129

    spacer

Professional SQL Server 2000 Programming (Programmer to Programmer)

Professional SQL Server 2000 Programming (Programmer to Programmer) Cover

 

Synopses & Reviews

Publisher Comments:

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.

Professional SQL Server 2000 Programming 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 want to add programming skills to your DBA knowledge, you’ll find what you need in this book to come to grips with SQL Server 2000 development.

Who is this book for:

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 insofar as it affects the SQL Server developer.

What does this book cover?

  • 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
  • Querying a SQL Server database using English Query and Full-Text Search

Book News Annotation:

Intended for experienced developers, this book introduces the Transact SQL (T-SQL) code for creating databases, tables, keys and constraints, and explains how to develop applications using SQL Server 2000. The author then discusses index structures, stored procedures, transactions, triggers, nested subqueries, linked servers, cursors, the integration of XML into SQL Server, data transformation services, replication, analysis services, English Query, and some security issues. Client- side examples are written in Visual Basic.
Annotation ©2004 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

What is this book about?

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.

What does this book cover?

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

Who is this book for?

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.

Synopsis:

This book addresses the new features of SQL Server 2000. With a general understanding of programming principles, (e.g. familiarity with VB, C++, VB Script) "Professional SQL Server 2000 Programming" provides a comprehensive overview of the new areas of SQL Server, for programmers. There is an in-depth discussion of T-SQL, the query language of Microsoft SQL Server.

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.

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.

Product Details

ISBN:
9780764543791
Publisher:
Wrox
Location:
Indianapolis, IN
Author:
Vieira, Robert
Author:
Vieria, Robert
Subject:
Programming - General
Subject:
Programming Languages - SQL
Subject:
Database management
Subject:
Client-server computing
Subject:
Database Management - SQL Server
Subject:
Sql server
Subject:
Programming - Software Development
Subject:
Database-SQL
Subject:
Database design
Copyright:
Series:
Programmer to Programmer
Series Volume:
v. 82, no. 5
Publication Date:
20040818
Binding:
Electronic book text in proprietary or open standard format
Grade Level:
General/trade
Language:
English
Illustrations:
Yes
Pages:
1440
Dimensions:
9.08x7.26x2.63 in. 3.99 lbs.

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Applications
Computers and Internet » Database » SQL

Professional SQL Server 2000 Programming (Programmer to Programmer)
0 stars - 0 reviews
$ In Stock
Product details 1440 pages Wrox Press - English 9780764543791 Reviews:
"Synopsis" by , What is this book about?

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.

What does this book cover?

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

Who is this book for?

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.

"Synopsis" by , This book addresses the new features of SQL Server 2000. With a general understanding of programming principles, (e.g. familiarity with VB, C++, VB Script) "Professional SQL Server 2000 Programming" provides a comprehensive overview of the new areas of SQL Server, for programmers. There is an in-depth discussion of T-SQL, the query language of Microsoft SQL Server.
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.