Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Supporting your high street Find out how »
Microsoft SQL Server 2000 Programming Step by Step, Mixed media product Book

Microsoft SQL Server 2000 Programming Step by Step Mixed media product

Mixed media product

Item not Available

Description

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 ServerBack 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 flowUse stored procedures; create and manage triggersLearn error handlingIncluded on CD-ROM!Sample database filesSample script code in Transact-SQLFor customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Information

Save 26%

£39.49

£29.15

Item not Available
Item not Available
Sign in to add to wishlist
 
Free Home Delivery

on all orders

 
Pick up orders

from local bookshops

Information