SQL Server 2000 Programming by Example
| |||||||||||||||||||||||||||||
|
| |||||||||||||||||||||||||||||
| Sort customer reviews by: | |||||||||||||||||||||||||||||
|
Show All Reviews on Page
Hide All Reviews on Page
| |||||||||||||||||||||||||||||
| SQL Server 2000 Programming by Example | |||||||||||||||||||||||||||||
|
SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples.
|
|||||||||||||||||||||||||||||
|
Ideal for the database programmer or system DBA, Microsoft SQL Server 2000 Programming by Example is an excellent example-based tutorial on mastering today's SQL features. Packed with plenty of tips and tricks, this title will let most anyone do more with SQL Server.
While there are plenty of screen shots showing graphical SQL Server tools, the focus of this book is clearly on learning real command-line Transact-SQL (T-SQL). The authors provide a patient and very thorough tour of T-SQL with full coverage of both basic and advanced features. You'll learn how to define new tables, manage users in groups, and perform all kinds of queries. Standout material includes an excellent guide to SQL data types and how to choose the right one for your needs. When it comes to queries, the book does a great job of exploring all your options for joining relational data, as well as grouping data for more advanced reporting. True to its title, Microsoft SQL Server 2000 Programming by Example is filled with dozens of examples of SQL commands (and the results returned) so that you can try out this material for yourself and really learn the language thoroughly. Later on, the authors turn toward server-side programming with a digestible guide to creating stored procedures and triggers. The book closes with an in-depth guide to the issues regarding cursors (for working with table data), transactions, and locking. Sections on bulk copy tools and the Microsoft Data Transformation Services (DTS) show how to move data around the enterprise. A final section of distributed queries and linked servers will help you work with different sources of data wherever it resides in your organization. Despite some stilted writing, the comprehensive examples in this book make it a success. It will let anyone start using basic T-SQL for the first time, as well as teach more advanced readers to master the finer points of Microsoft databases. --Richard Dragan Topics covered:
|
|||||||||||||||||||||||||||||
| Reader Reviews 1 - 13 of 13 | |||||||||||||||||||||||||||||
| Review Date |
Review Rating(5 High) |
Review Helpful to: |
Customer Review | Reviewer Info |
Permanent Link |
||||||||||||||||||||||||
| Reader Reviews Below Sorted by Newest First | |||||||||||||||||||||||||||||
| 04-19-07 | 5 | (NA) |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
Excellent book for anyone, from developer to DBA to learn SQL Server basics. Also an excellent tool for passing Microsoft exam 70-229. It goes over all the topics that are covered by the Microsoft exam:
Developing Logical Data Model Implementing a physical database Creating and altering database objects Review of constraints Indexing Database replication and partitioning Retrieving and modifying data Programming business logic Tuning and optimizing data acess Database security The book includes very good explanations as well as examples. I looked at several books that would help me to pass microsoft exam but could not find any book that would cover all the topics I needed until I came across this book. Combined with a sample test from [...] it's all you need to pass the test (Review Data Last Updated: 2007-09-07 23:46:15 EST)
|
|||||||||||||||||||||||||||||
| 04-19-07 | 5 | (NA) |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
Excellent book for anyone, from developer to DBA to learn SQL Server basics. Also an excellent tool for passing Microsoft exam 70-229. It goes over all the topics that are covered by the Microsoft exam:
Developing Logical Data Model Implementing a physical database Creating and altering database objects Review of constraints Indexing Database replication and partitioning Retrieving and modifying data Programming business logic Tuning and optimizing data acess Database security The book includes very good explanations as well as examples. I looked at several books that would help me to pass microsoft exam but could not find any book that would cover all the topics I needed until I came across this book. Combined with a sample test from [...] it's all you need to pass the test (Review Data Last Updated: 2008-09-05 06:45:45 EST)
|
|||||||||||||||||||||||||||||
| 03-08-06 | 1 | 2\2 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
This book reads more like an online help book. There are no explanations of the logic of using the syntax. This book will put you to sleep. I don't recommend getting this book at all.
(Review Data Last Updated: 2007-04-12 20:56:51 EST)
|
|||||||||||||||||||||||||||||
| 03-07-06 | 1 | 2\2 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
This book reads more like an online help book. There are no explanations of the logic of using the syntax. This book will put you to sleep. I don't recommend getting this book at all.
(Review Data Last Updated: 2007-04-10 06:02:24 EST)
|
|||||||||||||||||||||||||||||
| 05-25-05 | 2 | 3\9 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
It should noted that you won't be able to print any of the pages of this book. Also, that unless you register with Adobe and give them you name and email address you won't be able to backup the pdf file or use it on another computer inadditon getting it registered took over 1/2 hour. Finally I had to let them download files to my computer that I know nothing about. So stay away from the PDF version !
(Review Data Last Updated: 2007-06-27 21:27:34 EST)
|
|||||||||||||||||||||||||||||
| 01-15-05 | 3 | 1\4 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
I have been using and reading this book for my database course for a year, I have no choice, however, I am not quite satisfied with this book as the layout is plain and difficult to understand the codes.
It has all the statements in one go, and then it print out the results after the codes with few explanations of the codes. The codes section may extend up to 3 pages and followed by the results, it is hard to read and understand, you need to flip over and over again. I just give up after reading half of the book at about page 367, that is the triggers chapter. (Review Data Last Updated: 2007-06-27 21:27:34 EST)
|
|||||||||||||||||||||||||||||
| 09-09-04 | 5 | 21\21 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
I've been teaching college database classes for years, and although I prefer to teach MySQL, it's important for serious IT students to get some experience on a full-blown enterprise database server, and for that I use MS SQL Server.
This is the only usable text I've found for developers who need to learn the fundamentals for constraints, triggers, stored procedures, etc. Most SQL Server books are about administration, and barely touch upon programming topics. Many of those targeting developers rely upon some custom database dreamed up by the author that pales beside the standard samples of pubs and Northwind included with the SQL Server product. The worst books trot out database basics that might be best learned using MS Access. The authors walk through every operation with standalone examples using either pubs or Northwind, with dozens of code listings for each chapter. You might need to complete a few consecutive listings, but there are no long-running dependencies where the authors want you to follow their development project from start to finish. You can dive in and out of this book at any point with no set up required. The tone is straighforward with clear explanations, definitions, and tips. No chitchat or bull gets in the way. There are some illustrative figures, but no page after page of useless screenshots. Like the Que series claims, you learn By Example--cranking out the listings yourself to see things work. A relly nice book for students or professionals from beginning to intermediate levels. Oh yeah...the price is right. (Review Data Last Updated: 2007-06-27 21:27:34 EST)
|
|||||||||||||||||||||||||||||
| 09-08-04 | 5 | 19\19 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
I've been teaching college database classes for years, and although I prefer to teach MySQL, it's important for serious IT students to get some experience on a full-blown enterprise database server, and for that I use MS SQL Server.
This is the only usable text I've found for developers who need to learn the fundamentals for constraints, triggers, stored procedures, etc. Most SQL Server books are about administration, and barely touch upon programming topics. Many of those targeting developers rely upon some custom database dreamed up by the author that pales beside the standard samples of pubs and Northwind included with the SQL Server product. The worst books trot out database basics that might be best learned using MS Access. The authors walk through every operation with standalone examples using either pubs or Northwind, with dozens of code listings for each chapter. You might need to complete a few consecutive listings, but there are no long-running dependencies where the authors want you to follow their development project from start to finish. You can dive in and out of this book at any point with no set up required. The tone is straighforward with clear explanations, definitions, and tips. No chitchat or bull gets in the way. There are some illustrative figures, but no page after page of useless screenshots. Like the Que series claims, you learn By Example--cranking out the listings yourself to see things work. A relly nice book for students or professionals from beginning to intermediate levels. Oh yeah...the price is right. (Review Data Last Updated: 2006-07-07 12:56:39 EST)
|
|||||||||||||||||||||||||||||
| 07-09-04 | 5 | 7\8 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
Who said you can find all the contents from Book On line? Does Book On Line has the same easy to follow structure plus the good examples that really help to learn and pratice? My confidence on SQL trippled after finishing only half of the book.
(Review Data Last Updated: 2006-07-07 12:56:39 EST)
|
|||||||||||||||||||||||||||||
| 04-22-04 | 1 | 5\18 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
There is nothing in this book that you cannot find in many readily available sources mostly the Books Online. I learned nothing from this book and neither would most people. After reading this book one thing is certain: These authors have never built truly complex Sql applications. If you are a beginner get this book. If not keep looking.
(Review Data Last Updated: 2006-07-07 12:56:39 EST)
|
|||||||||||||||||||||||||||||
| 08-16-03 | 5 | 10\11 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
This is an excellent book for average/advanced programmers who
want to review and learn all about SQL Server 2000 basics with very good and very concise,very clear examples.I recommend this book for people preparing for the Microsoft 70-229 database design and implementation.A must READ. I thank the authors. (Review Data Last Updated: 2006-07-07 12:56:39 EST)
|
|||||||||||||||||||||||||||||
| 08-06-03 | 5 | 2\16 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
The book is super new and the delivery was too fast
(Review Data Last Updated: 2006-07-07 12:56:39 EST)
|
|||||||||||||||||||||||||||||
| 10-30-02 | 5 | 10\10 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
I have been working more than four years with SQL Server, since version 6.5. In my work I have to cover all the funcionality in SQL Server as I am developer, administrator and so on. I have few SQL books as I find is quite simple to find almost anything in the BOLs.
But this book is the best I have ever seen to get into SQL Server and improve your skills, from the point of view of a developer there is not better book. It is also a incredible source of information for experts, it really explores all the new features you can find in SQL Server 2000. I also know the two authors's work as they help many people in the SQL forums and I can say they are really good. Enjoy it!!! (Review Data Last Updated: 2006-07-07 12:56:39 EST)
|
|||||||||||||||||||||||||||||
| Reader Reviews 1 - 13 of 13 | |||||||||||||||||||||||||||||
| All Books | Arts | Biography | Click Here For An A-Z Index Of All 213 Best-Seller Subjects | Business | Children's | Comics | ||||||
| Computers | Cooking | Engineering | Entertainment | Health | History | Home | Horror | Humor | Law | Fiction | Medicine | Mystery |
| Nonfiction | Outdoors | Parenting | Professional | Reference | Religion | Romance | Science | Sci-Fi | Sports | Teens | Travel | |
