Items related to Professional SQL Server 2000 Programming

Professional SQL Server 2000 Programming - Softcover

  • 4.07 out of 5 stars
    29 ratings by Goodreads
 
9780764543791: Professional SQL Server 2000 Programming

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" may belong to another edition of this title.

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.

From the Back Cover

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

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

Buy Used

Condition: Very Good
Dispatched, from the UK, within...
View this item

US$ 7.55 shipping from United Kingdom to U.S.A.

Destination, rates & speeds

Other Popular Editions of the Same Title

9781861004482: Professional SQL Server 2000 Programming

Featured Edition

ISBN 10:  1861004486 ISBN 13:  9781861004482
Publisher: Peer Information, 2000
Softcover

Search results for Professional SQL Server 2000 Programming

Stock Image

Vieira, Robert
Published by Wrox, 2000
ISBN 10: 0764543792 ISBN 13: 9780764543791
Used Paperback

Seller: Reuseabook, Gloucester, GLOS, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Used; Very Good. Dispatched, from the UK, within 48 hours of ordering. Though second-hand, the book is still in very good shape. Minimal signs of usage may include very minor creasing on the cover or on the spine. Seller Inventory # CHL10387297

Contact seller

Buy Used

US$ 4.64
Convert currency
Shipping: US$ 7.55
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Robert Vieira
Published by Wrox 15/11/2000, 2000
ISBN 10: 0764543792 ISBN 13: 9780764543791
Used Softcover

Seller: AwesomeBooks, Wallingford, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. . Seller Inventory # 7719-9780764543791

Contact seller

Buy Used

US$ 6.05
Convert currency
Shipping: US$ 6.85
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: 2 available

Add to basket

Stock Image

Robert Vieira
Published by Wrox 15/11/2000, 2000
ISBN 10: 0764543792 ISBN 13: 9780764543791
Used Softcover

Seller: Bahamut Media, Reading, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: Very Good. Shipped within 24 hours from our UK warehouse. Clean, undamaged book with no damage to pages and minimal wear to the cover. Spine still tight, in very good condition. Remember if you are not happy, you are covered by our 100% money back guarantee. Seller Inventory # 6545-9780764543791

Contact seller

Buy Used

US$ 6.05
Convert currency
Shipping: US$ 9.58
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: 2 available

Add to basket

Stock Image

Vieira, Robert
ISBN 10: 0764543792 ISBN 13: 9780764543791
Used Softcover

Seller: Better World Books, Mishawaka, IN, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: Good. Used book that is in clean, average condition without any missing pages. Seller Inventory # 2467463-6

Contact seller

Buy Used

US$ 15.88
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Vieira, Robert
Published by Wrox, 2000
ISBN 10: 0764543792 ISBN 13: 9780764543791
Used paperback

Seller: HPB-Diamond, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

paperback. Condition: Very Good. Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_430201600

Contact seller

Buy Used

US$ 14.50
Convert currency
Shipping: US$ 3.75
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Robert Vieira
Published by Wrox, 2000
ISBN 10: 0764543792 ISBN 13: 9780764543791
Used Paperback

Seller: UBUCUU S.R.L., Bucharest, Romania

Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

Paperback. Condition: Good. 1. Seller Inventory # G-9780764543791-3

Contact seller

Buy Used

US$ 18.56
Convert currency
Shipping: US$ 18.01
From Romania to U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Vieira, Robert
Published by Wrox, 2000
ISBN 10: 0764543792 ISBN 13: 9780764543791
Used paperback

Seller: dsmbooks, Liverpool, United Kingdom

Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

paperback. Condition: Very Good. Very Good. book. Seller Inventory # D7S9-1-M-0764543792-3

Contact seller

Buy Used

US$ 128.32
Convert currency
Shipping: US$ 34.30
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Vieira
Published by John Wiley and Sons Ltd, 2000
ISBN 10: 0764543792 ISBN 13: 9780764543791
Used Softcover

Seller: OM Books, Sevilla, SE, Spain

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: Usado - bueno. Seller Inventory # 9780764543791

Contact seller

Buy Used

US$ 252.44
Convert currency
Shipping: US$ 68.59
From Spain to U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket