» » Microsoft SQL Server 2000 Programming Step by Step (Step by Step Developer)

Download Microsoft SQL Server 2000 Programming Step by Step (Step by Step Developer) fb2

by Microsoft Corporation
Download Microsoft SQL Server 2000 Programming Step by Step (Step by Step Developer) fb2
Programming
  • Author:
    Microsoft Corporation
  • ISBN:
    0735611424
  • ISBN13:
    978-0735611429
  • Genre:
  • Publisher:
    Microsoft Press (December 9, 2000)
  • Pages:
    720 pages
  • Subcategory:
    Programming
  • Language:
  • FB2 format
    1851 kb
  • ePUB format
    1359 kb
  • DJVU format
    1658 kb
  • Rating:
    4.6
  • Votes:
    258
  • Formats:
    doc mbr lit azw


Each lesson of this book walks you through step by step performing basic SQL programming techniques. Filled with screen shots to go with just about every step it is a great way to find out something about Microsoft SQL 2000

Each lesson of this book walks you through step by step performing basic SQL programming techniques. Filled with screen shots to go with just about every step it is a great way to find out something about Microsoft SQL 2000. Once you have finished with the lessons then you will have a better feel for if you want to go further into SQL Programming (It took me a weekend to finish!). If/When you are ready to learn the programming aspect pick up a copy of the book recomended above, you will not be disapointed.

Each lesson of this book walks you through step by step performing basic SQL programming techniques.

This Step by Step guide serves as a great starting point for getting familiar with . How to do some basic MDX programming. How to make custom incremental cube processing.

This Step by Step guide serves as a great starting point for getting familiar with Microsoft's Analysis services. It starts with a quick introduction to data warehousing (without resorting to giving an entire history of the subject, as seems so common today) and how it relates to OLAP and then moves right into the Analysis Servies tools. All of Microsoft's literature talks about how SQL Server 2000's great support for the web/XML. Strangely, it is very hard to find this information for Analysis Services, and this book doesn't provide any guidance.

With scalability for the most demanding applications, Microsoft® SQL Server™ 2000 can dramatically reduce .

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.

Straight from the Microsoft® SQL Server™ 2000 product team and Microsoft Consulting Services, the new SQL . Founded in 1975, Microsoft Corp. Nasdaq MSFT ) is the worldwide leader in software, services and Internet technologies for personal and business computing.

Straight from the Microsoft® SQL Server™ 2000 product team and Microsoft Consulting Services, the new SQL Server 2000 Resource Kit delivers this advantage.

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.

Start by marking Microsoft® SQL Server� 2000 Programming Step by. .

Start by marking Microsoft® SQL Server� 2000 Programming Step by Step as Want to Read: Want to Read savin. ant to Read. 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.

From the Publisher: Microsoft SQL Server 2000 can dramatically reduce the time required to bring e-commerce, data warehousing, and line-of-business applications to market

From the Publisher: Microsoft SQL Server 2000 can dramatically reduce the time required to bring e-commerce, data warehousing, and line-of-business applications to market. MICROSOFT SQL SERVER 2000 PROGRAMMING STEP BY STEP, written by an experienced databas. ONTINUE READING.

Using the DTSRun command prompt utility, either directly or through a batch file. aspx?scid kb;%5bLN%5d;269074. Developers commonly run into issues when executing through scheduled jobs packages that they created and tested interactively on their workstations using DTS Designer.

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 dаta: Retrieve rows, use the SELECT statement, join tables and summarize data, and view data in a variety of ways. Work with dаta: 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

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.


Fawrindhga
This book has the wrong title, it should be called "SQL Server 2000 Basics". The word 'programming' should definitely be taken away from the title as only about 1/3 of the book deals with programming, in just the most basic way. This book is just an intro to SQL Server, nothing too detailed. For someone that knows nothing about SQL Server, you will learn the basics here, but you will need to buy other books to get the details.
Hallolan
Great book to have as a learning tool and a resource for future reference. Thanks for getting it to me quickly.
Ytli
SQL Server, this is the topic that I think it is very hard for me to learn. But after I have try this book, it is really make really funny to learn SQL server. I learn a lot of basic things such as table, query, rule, user define function... from this book and now I could SQL Server to manage my own database. There are two advantage that I found in this book:

1. Each chapter is guide you from the basic and have many screen shoot for you to learn. You do not need to have any previous knowledge about SQL server. What you need is the basic task with windows operating system, such as shut down, restart, moving windows dialog box, resize windows dialog box, copy/cut or paste file...

2. The author use a very simple word to explain to the reader and very easy to follow each step.

Whether this book is design for the beginner, you will need to read additional book after you read this book. This book just give you a starting point only, if you want to master sql server 2000 you should try to find another resource which guide you deeply in this technology.
Cordalas
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!
Dagdarad
I am very new to SQL Server 2000 (or any SQL Server for that matter), so I wanted a book that was robust, but was easy to follow. "Step by Step" seemed to be the way to go, but this book leaves MUCH to be desired.
It is WAY too basic. I mean, the language SQL Server uses is called TRANSACT-SQL, but not ONCE in the book does she go over TRANSACTIONS!! She reiterated the same points over and over, and used WAY too many screen shots. I would say at least 70% of the book is comprised of useless screen shots. You get hardly any actual content at all... and best of all, the examples are VERY weak.
I am a big fan of WROX books, since WROX books are very complete and can be used as a desk reference. This book, however, is usless the second you finish it. I recommend it ONLY to people who have never programmed ANYTHING before, and to those who don't care about learning fundementals like transactions.
The entire contents of this book can be learned from a 30 minute reading of some of the MSDN documentation.
Jeyn
If you have never used Microsoft SQL 2000 and would like an introduction to see if you want to get into MS-SQL Programming then this is the book for you.
On the other hand if you already know that you want to learn MS-SQL Programming or have done some SQL programming don't waste your money, get Beginning SQL Server 2000 Programming by Robin Dewson ISBN: 1861005237 !
Each lesson of this book walks you through step by step performing basic SQL programming techniques. Filled with screen shots to go with just about every step it is a great way to find out something about Microsoft SQL 2000. Once you have finished with the lessons then you will have a better feel for if you want to go further into SQL Programming (It took me a weekend to finish!). If/When you are ready to learn the programming aspect pick up a copy of the book recomended above, you will not be disapointed.
Having some experience already with SQL 7.0 from a pure admin support stance I found very little in this book useful for my skill level (I knew what most of the GUI interfaces looked like already). The repetition got old when the writer told you everytime how to go into Design Table View 1 to 5 times for 12+ Chapters strait!
Arlelond
When I first started to read this book, I wanted to learn more about SQL, but this book failed. As the title says, it's pretty much just a bunch of step-by-step exercises and screen shots, but doesn't really get into too much detail, or give any reasons or explanation.

The only reason why I am writing a review now is that I now have something to compare this book against.

If you want a great book on SQL programming, I suggest you pick up "Profession SQL Server 2000 Programming" by Robert Vieira (Wrox Press), which is a great book even for novices.

IF you really want to buy this book, I have a copy that I'd be willing to let go for dirt cheap.