- Paperback: 816 pages
- Publisher: Prentice Hall; 1 edition (10 Nov 2003)
- Language English
- ISBN-10: 0130293393
- ISBN-13: 978-0130293398
- Product Dimensions: 23.6 x 17.6 x 4.5 cm
- Average Customer Review: 5.0 out of 5 stars See all reviews (1 customer review)
- Amazon Bestsellers Rank: 1,617,526 in Books (See Top 100 in Books)
- 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
This command reference, designed for users of all levels, provides a user-friendly guide to the SQL database programming language. All commands will be listed alphabetically by functional area -- ideal for beginners who can locate commands based on the tasks they are trying to accomplish. In addition, the author has included a "roadmap" listing commands in alphabetical order at the front of the book that is ideal for more advanced users who know the command name and simply need to know a page number. Each command will include a hands-on example. The book reflects the new SQL standard, and should be one of the very first books on the market. Author includes extensive examples for Oracle and Microsoft SQL Server implementations. This 6x9 reference is the perfect companion to Bowman's Practical SQL Handbook and is design to fit on the busy Database Developer's desk.
From the Back Cover
This is the SQL reference you'll reach for first, every time!
If you're an SQL programmer, you can easily picture how useful a comprehensive, single-volume Transact-SQL command reference manual would be in streamlining your work. And if that book was rich in examples, was written with users of all levels of expertise in mind, and was even designed to fit comfortably on your desktop, you'd probably buy it right away, wouldn't you? Well, look no further—Transact-SQL Desk Reference, by noted programming instructor Deac Lancaster, is exactly the book you need.
As it turns out, Transact-SQL Desk Reference is just the book Deac himself was looking for. The problem was, no such book existed, so he saved programmers everywhere a lot of trouble and he wrote it himself! The book answers the question, "How exactly do I write a statement to do a particular job?" by providing the full syntax of each command along with examples showing each command in action. Then, to assist you in making your code more portable, Transact-SQL Desk Reference shows where Transact-SQL diverges from the ANSI SQL standard. The commands are arranged by functional area and are well indexed and cross-referenced, making it as easy as possible to find what you're looking for-even if you don't know the command's name. Inside, you'll find:
- SQL commands grouped logically by purpose and function, plus an index so you can jump right to the command
- Definitions that give the full syntax of each command, along with examples of each command in use plus tips on maximizing portability
- Additional chapters covering RDBMS concepts, details of Transact-SQL, and advanced SELECT queries!
This book is intended for programmers of all levels working with Microsoft SQL Server.
Inside This Book
(Learn More)
First Sentence
This chapter is introductory and tutorial in nature and should be bypassed if you are interested only in the reference material contained in the chapters that follow. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
This chapter is introductory and tutorial in nature and should be bypassed if you are interested only in the reference material contained in the chapters that follow. 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
Format:Paperback
excellent book. used by several analysts. highly recommended for those unknown syntax that you never knew existed
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
5 reviews
12 of 13 people found the following review helpful
Scott Hill
22 Dec 2003
Format:Paperback
Excellent examples and clear explanations. 12/22/2003
This book is exactly what I was looking for, an extension of Books Online with extra clear examples and explanations. Books Online is often still my first reference because it is convenient and does an excellent job. But when I need a second source for more information I now turn to Transact-SQL Desk Reference. If I still don't find what I need then I have to go to user groups or other external sources, but so far that has only happened once.
The tutorial in the first chapter is a nice overview for those who need it, but an advanced user can skip past it and go straight to the reference material starting in Chapter 2. The index is excellent and so far has never failed to put me in the right place to find what I want. I particularly like the extra examples of how to use different features. And the explanation of how to do disk layout to help restorability and performance is well beyond what I expected in a reference book. I plan to use the layout presented as a starting point for configuring my production database.
It could be argued that the syntax definitions taken from Books Online could be omitted, though in some cases the book has a better explanation of some of the items. All in all, it is definitely worth the price.
6 of 6 people found the following review helpful
Very Good Content - Not So Good Index
7 Jan 2005
Format:Paperback
This book is exactly what it's title says, it's a reference book. If you need brief descriptions and syntax for T-SQL statements and functions, this is a great book to have on your book shelf. However, the index is very weak. It is essentially an alphabetical listing of functions, so you need to know the name of a function to find it. For example, if you wanted to add an INDEX to a table, you would probably look under "I" for "INDEX.". But, you wouldn't find what you were looking for. You would need to look under "C" because the function is "CREATE INDEX." But, if you know what you are looking for, you'll find it in this book.
2 of 2 people found the following review helpful
Great reference
2 April 2005
Format:Paperback
The back of this book claims that "This is the SQL reference you'll reach for first!" and I can personally support their claim. It is easily the best organized SQL reference that I have encountered. It contains alphabetical listings of all SQL data types and their related functions, in-depth instruction on data definition (create, alter, drop, etc.) and comprehensive descriptions and examples of all data manipulation methods (insert, update, delete, etc.).
The only possible drawback of this book is that it is not, nor is it intended to be, an instruction manual for SQL. The book cuts right to the point, and only tells you exactly what you need to know. For beginners, this book would not be a good starting point, but for people with at least some exposure to SQL, this book will probably never leave your desk.
The only possible drawback of this book is that it is not, nor is it intended to be, an instruction manual for SQL. The book cuts right to the point, and only tells you exactly what you need to know. For beginners, this book would not be a good starting point, but for people with at least some exposure to SQL, this book will probably never leave your desk.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- 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.
|
