Learning SQL on SQL Server 2005 and over 2 million other books are available for Amazon Kindle . Learn more

Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Start reading Learning SQL on SQL Server 2005 on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Learning SQL on SQL Server 2005 [Paperback]

Sikha Saha Bagui , Richard Walsh Earp
1.0 out of 5 stars  See all reviews (1 customer review)

Available from these sellers.


Formats

Amazon Price New from Used from
Kindle Edition 18.12  
Paperback --  
Amazon.co.uk Trade-In Store
Did you know you can use your mobile to trade in your unwanted books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details or check out the Trade-In Amazon Mobile App Guidelines on how to trade in using a smartphone. Learn more.

Book Description

6 May 2006 0596102151 978-0596102159 1

Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly.

If you're new to databases, or need a SQL refresher, Learning SQL on SQL Server 2005 is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge.

Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, Learning SQL on SQL Server 2005 starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn:

  • Beginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tables
  • How to customize SQL Server 2005's settings and about SQL Server 2005's functions
  • About joins, a common database mechanism for combining tables
  • Query development, the use of views and other derived structures, and simple set operations
  • Subqueries, aggregate functions and correlated subqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005

Whether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company's IT department, Learning SQL on SQL Server 2005 will get you up to speed on SQL in no time.


Product details

  • Paperback: 352 pages
  • Publisher: O'Reilly Media; 1 edition (6 May 2006)
  • Language: English
  • ISBN-10: 0596102151
  • ISBN-13: 978-0596102159
  • Product Dimensions: 23.3 x 17.9 x 2 cm
  • Average Customer Review: 1.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 1,370,399 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

Book Description

The Simplest Way to Learn to Query SQL Server

From the Publisher

If you're new to databases, or need a SQL refresher, this step-by-step introduction has everything you need to generate, manipulate, and retrieve data using Microsoft's SQL Server 2005. Every topic, concept, and idea in the book comes with examples of code and output, along with exercises to help you gain proficiency. Plenty of texts explain database theory. This book lets you apply the theory as you learn SQL.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

5 star
0
4 star
0
3 star
0
2 star
0
1.0 out of 5 stars
1.0 out of 5 stars
Most Helpful Customer Reviews
0 of 1 people found the following review helpful
Format:Paperback|Verified Purchase
I have been using SQL Server for some years now. I wanted a reference book and bought the book for that reason, so I can't say if the book is any good if read cover to cover. The book has an appendix called 'Important SQL commands' that lists all the important SQL commands. So far every time I have gone to the book's index to lookup an SQL command, its pointed me to the a page in the appendix of important commands. And that's it - a dead end. Nor I nor my colleges could believe this omission. All I can say is that with regards to SQL commands/syntax, neither the book's table of contents nor it's index has proven to be any good whatsoever.
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.8 out of 5 stars  12 reviews
14 of 15 people found the following review helpful
1.0 out of 5 stars Where the beef?? 29 May 2008
By Joseph Ruder - Published on Amazon.com
Format:Paperback|Verified Purchase
Wow...it is amazing the difference between 2 sites reviews - if you go to O'Reilly's site (yes the publisher) scroed it much lower - you would think you were reading reviews of a different book. This was one of the poorest books I have read in several years - and I really hate saying that as I was *highly* looking forward to this book.

My complaints are:

1. Review questions at the end of each chapter but no answers to the reviews or questions at the end of each chapter - not even online. How do we know if we got them right or not?
2. Huge missing holes of important stuff -- some obvious holes include:
a. Triggers - pretty nice things to know about
b. Procedures
c. Functions (this is about Transact-SQL)
d. Security (at least touch on pre-packaged permission roles)
e. Data locks or anything related to maintaining data integrity
d. error handling

3. Obscure examples that left me scratching my head going "OK, I can see HOW you do this but why would you WANT to?"
4. The phrase "this is beyond the scope of this book" was repeated WAY too many times -- what IS in the scope of the book if not stored procedures and functions, triggers, setting permissions, and other very basic SQL 2005 topics.

There is some good intro to SLQ stuff here well paced and well written -- but it is in NO way money well spent if you are wanting to learn the in's and out's of SQL server 2005.

The back of the book states that it is an "excellent introduction to the SQL language and database concepts" -- but yet the book does not even touch on the subject of database normalization - the very definition of "basic database concept" when talking about RDBS.

I had just finished a "dummies" book that was much more complete and cost half as much.

Just so you know, I don't make a habit of down playing many books -- I love and collect tech books -

I have an extensive library of books (many O'Reilly)
I DID read the entire book cover to cover, while working through the examples in front of my computer

I feel I gave this book a very fair chance and was let down.

Please feel free to correct or address any of my above points if you feel they are in error and I will reconsider this review.

Sorry...but I suggest moving on.

Joe

I only rated it on 1 star instead of two because of the fairly high price. If you can get it cheaper used - go for it...
3 of 3 people found the following review helpful
1.0 out of 5 stars Not a good book for learning SQL server (or SQL) 12 Nov 2008
By Robert Peters - Published on Amazon.com
Format:Paperback
The only reason I bought this book was because it was being used in a class in 2007, the only positive thing I can say is that it was cheap for a textbook.
I saw the absurdly glowing reviews and felt the need to stop anyone else before purchasing the book.

In summary, this book is a complete rehash of one of the authors earlier books covering Oracle. Some of the Questions even mention Oracle instead of SQL server.
There are numerous other better books out there for learning SQL server, that actually
cover the things you need to learn.
2 of 2 people found the following review helpful
3.0 out of 5 stars Workman-like Overview of SQL 14 July 2008
By Eric Ness - Published on Amazon.com
Format:Paperback
I was looking for a book to refresh my SQL skills and settled on Learning SQL on SQL Server after reading the many positive reviews. It sounded like just what I was looking for. My expectations took a downward turn after working through the first few chapters of the book. While the book is technically competent, the way that SQL is presented is lifeless. Working through the book is a trudge with few pleasant stops on the journey. You will learn SQL if you read through the text and work the exercises, but don't expect to have much fun on the way.
1 of 1 people found the following review helpful
4.0 out of 5 stars Good Intro to Microsofts SQL Server 4 Aug 2008
By V. Mehta - Published on Amazon.com
Format:Paperback
I gave this book 4 stars as it's not intended for a complete novice to Relational Databases, but it still can you get you up and running. Also the book is laid out in a textbook or coursebook type manner so it can be applicable to a teaching setting and not a bulky bible like many SQL references that are out there.
1 of 1 people found the following review helpful
5.0 out of 5 stars A Perfect book for beginners and Excellent read for others - Review of Database Administrator SQLAuthority.com 13 Aug 2007
By Pinalkumar Dave - Published on Amazon.com
Format:Paperback
SQLAuthority.com Book Review :
Learning SQL on SQL Server 2005 (Learning) [ILLUSTRATED] (Paperback)
by Sikha Bagui, Richard Earp

Short Review:
This books covers simple and complex concept in very easy language with lots of examples. Every beginner can learn a great amount of tips from experienced authors. Whether you are a self-learner, new to databases or in need of SQL refresher, this is good read.

Detail Review:
This book is written by two conceptual strong SQL Server Gurus. SQL Server is growing extremely popular in the area of high-performance data applications. It is very important to learn about new features of SQL Server.

This book truly represents the concept and the motive authors holds while writing the book. The book is written as systematic guide to learning SQL using SQL Server 2005 - a relational and multi-user database.

This book starts with simple SQL concepts of management studio, simple select clauses, creating database and tables from scratch. It starts getting more involving and building difficult concepts on previously addressed easy concepts. Chapters about joins, sub queries, constraints are written with conceptual depth as well as lucid and simple language.

Authors suggest that this book is expected to be used by schools and SQL training organizations. I will add to that this book is for everyone who just wants to enjoy reading about SQL. This book should be read with hands on SQL Server practice. Reader will get most out of this book while doing exercise at the end of the book.

Review questions and exercise at the end of each chapter kept me occupied for long time. Few of them are very simple and few of them I have learned from this book. If you are experienced SQL programmer, I still suggest that you will enjoy reading the review questions. I will list few of those questions here.

When would you use the ROWCOUNT function versus using the WHERE clause?
If you are going to have too many nulls in a column, what would be data type to use?
What is the maximum number of the rows that a self join can produce?
Which function can the WITH TIES option be used with?
Is SELECT INTO allowed in a view? Why or why not?

Not always all the time, everybody wants to learn about difficult subject and in depth analysis. There are few times, when even experienced DBA and developers want to read back to basic concepts. I enjoy reading this book, if you are reader of my blog ([...]) you will enjoy this book as this book is in agreement of my views of looking at SQL with simple logic but strong concepts.

There are few errors in the book but they are very minor and I was able to catch them easily. Authors seem to have good understanding about ORACLE in addition to SQL Server. That introduced some errors but on good side they are able to unleash few ideas which are not easy for SQL Server DBA to think of.

The chapter I enjoyed most is Joins Versus Subquery. Authors very easily explained their needs and differences. This statement shows the strength of chapter; If information from a table is needed in a result set, then that table can not be buried in a subquery- it must be in the outer query; simple but effective.

I highly recommend this book, if you are interested in learning about SQL in easy way. This book is PERFECT book for beginners and great reference for experience developers.

Rating : 4 and 1/2 stars

In Summary, This is must have book for every SQL student.

Pinal Dave
Principal Database Administrator
([...]
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews
ARRAY(0xa69b7060)

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback