- Paperback: 660 pages
- Publisher: MICROSOFT PRESS; 1 edition (1 Dec 2000)
- Language English
- ISBN-10: 0735611424
- ISBN-13: 978-0735611429
- Product Dimensions: 23.4 x 18.8 x 4.3 cm
- Average Customer Review: 4.5 out of 5 stars See all reviews (2 customer reviews)
-
Amazon Bestsellers Rank:
620,724 in Books (See Top 100 in Books)
- #37 in Books > Computers & Internet > Computer Science > Databases > Applications > Microsoft SQL Server > Introduction
- #42 in Books > Computers & Internet > Computer Science > Databases > Applications > Microsoft SQL Server > Programming SQL Server
- See Complete Table of Contents
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Product 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 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
- Learn error handling
Included on CD-ROM!
Sample database files
Sample script code in Transact-SQL
About the Author
With twenty years experience in the field, Rebecca M. Riordan has earned an international reputation for designing and implementing computer systems that are technically sound, reliable, and effectively meet her clients' needs. Her particular area of expertise is database design and she is a five year Access MVP. Rebecca has also authored several database books and served as a senior technical support engineer for Microsoft's database products. As a Microsoft employee in Australia, Rebecca was the Senior technical support engineer for Microsoft's database products.
Inside This Book
(Learn More)
First Sentence
Microsoft SQL Server 2000 has been designed to support high-volume, mission-critical databases in a number of different application areas, including online transaction processing (OLTP), data warehousing, and e-commerce. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Microsoft SQL Server 2000 has been designed to support high-volume, mission-critical databases in a number of different application areas, including online transaction processing (OLTP), data warehousing, and e-commerce. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
Most Helpful Customer Reviews
3 of 4 people found the following review helpful
Format:Paperback
My organisation decided to change from its current database to SQL Server 2000, with no in house experience and I got the job of DBA. My previous experience was on Oracle DBA, but not that in debth.
This book was of great help to me as it shows exactly what you need to do to get your SQL Server Database started.
If you want a good techie book I would advise you to look elsewhere, if you are after a learning book, then you will not go far wrong in getting this one.
3 of 6 people found the following review helpful
Format:Paperback
I'm a web developer. I spent a time looking for a good book to starting SQL SERVER 2000. This book helped me to learn SQL SERVER 2000 and understood Transact-SQL as well. I recommend this book to SQL server beginners and SQL server 7 users. By the way, I like to work Step by Step.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
17 reviews
8 of 8 people found the following review helpful
Excellent SQL Starter Guide!
5 Jan 2001
Format:Paperback
Once again Rebecca has taken a difficult topic - SQL Server 2000 - and turned the complexitities of the topic around. I have found this book to be an excellent guide to using Microsoft SQL Server 2000, and a good reference to fall back on.
I would recommend this to anyone who is either planning or currently doing work with SQL Server 2000, you will find this to be an invaluable additional to the reference material included with SQL Server.
Buy it today, you will not regret it!
4 of 4 people found the following review helpful
'Step by Step Microsoft SQL Server 2000 Programming'
14 Mar 2001
Format:Paperback
This is a well written book suitable for beginners like myself with limited exposure on database etc. The examples are clear and free of errors. I completed the first 21 chapters in two days. I would recommend this book to anyone new to the subject of SQL servers.
3 of 3 people found the following review helpful
Rebecca's first book was not a fluke!
13 Dec 2000
Format:Paperback
Any time someone writes a great book, you're always tempted to wonder if it was just dumb luck. But Rebecca has once again proven that she can not only use an effective writing style to get a message across. She can also leverage her vast knowledge of databases and the SQL Server product to produce a compelling way to get people into the product.
I usually do not get excited about "step by step" books, but I made a promise to myself that I would look at this one. In the end I could not put it down until I had gone all the way through it. Her command of not just the subject matter but of the book's target audience and how to keep them interested and entertained while they are learning truly stunning.
By the end of the book, you will know more than most of the people who claim to be SQL Server experts, but you will have learned most of under anesthesia since the pace of the book is not too daunting at all.
Kudos to Rebecca! Her first book gave people the knowledge of how to design databases properly, and now her second book will take you through the important information about the world's most compelling database product!
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Introduction
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Data Warehousing
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Databases > Database Theory
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Microsoft Windows > SQL Server
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
