|
Learning SQL on SQL Server 2005 |  | Authors: Sikha Saha Bagui, Richard Walsh Earp
Publisher: O'Reilly Media
Category: Book
List Price: $44.99
Buy Used: $14.99
as of 9/10/2010 19:59 CDT details
You Save: $30.00 (67%)
New (6) Used (18) from $14.99
Seller: BananaRoad Posters
Rating:  12 reviews
Sales Rank: 295491
Media: Paperback
Edition: 1
Pages: 352
Number Of Items: 1
Shipping Weight (lbs): 1.3
Dimensions (in): 9 x 7 x 0.8
ISBN: 0596102151
Dewey Decimal Number: 005.133
EAN: 9780596102159
ASIN: 0596102151
Publication Date: April 26, 2006
Availability: Usually ships in 1-2 business days
| |
| Similar Items:
| |
| Editorial Reviews:
Product Description
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.
|
| Customer Reviews:
Showing reviews 1-5 of 12
 Excellent Way To Learn SQL & SQL Server 2005 July 18, 2006
Daniel McKinnon (Tewksbury, MA USA)
11 out of 15 found this review helpful
Learning SQL on SQL Server 2005 by Richard Earp is an outstanding book for those that are new to SQL and want to learn how to use it on the SQL Server 2005 platform. Excellent writing, a compact size that isn't too big or too small (300+ pages), and solid content make this a book for those that want to pick up and excel at using SQL in no time at all.
11 Chapters cover all this needed to get started with the following topics covered:
01. Basics of setting up SQL Server 2005
02. Basic SQL commands
03. Creating, altering, populating tables
04. Joins
05. Functions
06. Developing queries
07. Set Operations
08. Joins versus Subqueries
09. Aggregation
10. Correlated Subqueries
11. Indexes and Constraints
All in all this is an EXCEPTIONAL piece of work that is well worth the price. I absolutely LOVE the 'Learning' line of books that O'Reilly puts out --- no doubt the easiest way for any person to just pick up a text and start getting to work as opposed to reading an 800 page encyclopedia that feels more like a filibustering politican rather than a teaching tool.
***** HIGHLY RECOMMENDED
A Perfect book for beginners and Excellent read for others - Review of Database Administrator SQLAuthority.com August 13, 2007
Pinalkumar Dave (SQLAuthority)
1 out of 1 found this review helpful
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 (www.sqlauthority.com) 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
(http://www.SQLAuthority.com)
Great introduction to SQL (The title says it all) October 23, 2007
Douglas Sparling
This is a nice, succinct book on learning SQL using SQL Server 2005. Most of the book is dedicated to teaching SQL basics, not on using or administering SQL Server itself (exactly as the title suggests). However, the first chapter will give you everything you need to know to get SQL Server up and running.
I'm a big fan of the O'Reilly "Learning" books, and like many other books in that series, "Learning SQL on SQL Server 2005" is a great introductory book on its subject. Highly recommended for those who'd like to learn or review the fundamentals of SQL and SQL Server.
tells most of what you want to know about sql in a easy way October 24, 2007
Bill (Missouri)
I am a beginner of database, and the book make the SQL simple to learn.
The title says it all! January 19, 2008
Lawrence D. Erickson (San Diego, CA USA)
This is an excellent book. It's well written and provides good code examples for every concept. It is written for users who which to learn SQL on SQL Server 2005; the title of the book says it all!
After reading the book, it felt as if I had completed a university course with lectures, lab work, and homework assignments. So, I estimate I saved $500 and all the time I would have spent in an evening class.
I highly recommend this book. It's one of the best computer books I have read in the last two years.
Showing reviews 1-5 of 12
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2008, SQL Server 2005 Books. All Rights Reserved. In association with Amazon.com | |
