Microsoft® SQL Server™ 2000 Programming Step by Step

Microsoft® SQL Server™ 2000 Programming Step by Step
Published:November 29, 2000Language:English
Author:Rebecca RiordanTechnology:Microsoft SQL Server 2000
Length:720 PagesISBN 13:9780735611429

List Price:

$ 49.99
About The BookLearn SQL programming the easy way with this practical, step-by-step guide!

With scalability for the most demanding applications, Microsoft® SQL Server™ 2000 can dramatically reduce the time needed to bring e-commerce, data warehousing, and line-of-business applications to market. Whether you’re new to databases or familiar with Microsoft Access, Oracle, and other relational databases, MICROSOFT SQL SERVER 2000 PROGRAMMING STEP BY STEP is the ideal way to learn how SQL Server can work for you. Written by an experienced database developer and author and replete with examples and exercises, this book will help you quickly get up to speed with creating and maintaining databases using the interactive tools provided by SQL Server 2000 Personal, Standard, and Enterprise Editions. It’s a must-have resource for anyone who wants to create and maintain databases and program with Transact-SQL. This title shows you how to:
  • Get started with SQL Server: Use the Enterprise Manager to connect to a database; start, stop, and pause SQL Server; back up and restore a database and use the Maintenance Plan Wizard to create a monthly backup plan; and manage SQL Server security functions.
  • Create a SQL database: Create and manage databases, tables, indexes, relationships, constraints, table objects, and database diagrams.
  • Retrieve data: Retrieve rows, use the SELECT statement, join tables and summarize data, and view data in a variety of ways.
  • Work with data: Add, delete, and update rows, and import and export data.
  • Use the Transact-SQL programming language: Understand operators, variables, parameters, and control of flow; use stored procedures; create and manage triggers; and learn error handling.Included on CD-ROM!
  • Sample database files
  • Sample script code in Transact-SQL
  • About Rebecca RiordanRebecca Riordan is the author of DESIGNING RELATIONAL DATABASE SYSTEMS. She has worked as a consultant, systems analyst, and senior technical support engineer for Microsoft Australia and she studied database design and analysis at the University of California, Irvine. Rebecca was also a presenter at 1994 and 1995 TechEd sessions, covering topics ranging from reusable system components to searching data stores.
    Other Books By Rebecca Riordan
    Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community. Preparing for an exam now? Find your Microsoft Certification Study Group. Talk to us on these social networks:
    What do you think of this book?Your feedback is important in helping us create books that serve your needs and meet your expectations. Please take our survey at www.microsoft.com/learning/booksurvey

    Note: You will need this book's 13-digit International Standard Book Number (ISBN) to take the survey. The ISBN 13 can be found above.
    To report or search for corrections in this book or companion content,
    please go to www.microsoft.com/learning/support/books/