| CARVIEW |
Select Language
HTTP/2 302
server: nginx
date: Fri, 01 Aug 2025 09:11:50 GMT
content-type: text/plain; charset=utf-8
content-length: 0
x-archive-redirect-reason: found capture at 20090504193617
location: https://web.archive.org/web/20090504193617/https://oreilly.com/catalog/9780596102159
server-timing: captures_list;dur=0.472780, exclusion.robots;dur=0.015739, exclusion.robots.policy;dur=0.007484, esindex;dur=0.010254, cdx.remote;dur=75.707328, LoadShardBlock;dur=101.776512, PetaboxLoader3.datanode;dur=83.395574
x-app-server: wwwb-app215
x-ts: 302
x-tr: 200
server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0
set-cookie: SERVER=wwwb-app215; path=/
x-location: All
x-rl: 0
x-na: 0
x-page-cache: MISS
server-timing: MISS
x-nid: DigitalOcean
referrer-policy: no-referrer-when-downgrade
permissions-policy: interest-cohort=()
HTTP/2 200
server: nginx
date: Fri, 01 Aug 2025 09:11:51 GMT
content-type: text/html
x-archive-orig-date: Mon, 04 May 2009 19:35:54 GMT
x-archive-orig-server: Apache
x-archive-orig-p3p: policyref="https://www.oreillynet.com/w3c/p3p.xml",CP="CAO DSP COR CURa ADMa DEVa TAIa PSAa PSDa IVAa IVDa CONo OUR DELa PUBi OTRa IND PHY ONL UNI PUR COM NAV INT DEM CNT STA PRE"
x-archive-orig-last-modified: Thu, 30 Apr 2009 23:03:33 GMT
x-archive-orig-accept-ranges: bytes
x-archive-orig-content-length: 44031
x-archive-orig-connection: close
x-archive-guessed-content-type: text/html
x-archive-guessed-charset: windows-1250
memento-datetime: Mon, 04 May 2009 19:36:17 GMT
link: ; rel="last memento"; datetime="Mon, 14 Aug 2023 08:47:55 GMT"
content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org
x-archive-src: 51_9_20090504185655_crawl101-c/51_9_20090504193350_crawl100.arc.gz
server-timing: captures_list;dur=0.497611, exclusion.robots;dur=0.018986, exclusion.robots.policy;dur=0.008598, esindex;dur=0.009185, cdx.remote;dur=27.407259, LoadShardBlock;dur=96.956816, PetaboxLoader3.datanode;dur=153.158791, load_resource;dur=358.255468, PetaboxLoader3.resolve;dur=249.254892
x-app-server: wwwb-app215
x-ts: 200
x-tr: 574
server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0
x-location: All
x-rl: 0
x-na: 0
x-page-cache: MISS
server-timing: MISS
x-nid: DigitalOcean
referrer-policy: no-referrer-when-downgrade
permissions-policy: interest-cohort=()
content-encoding: gzip
Learning SQL on SQL Server 2005 | O'Reilly Media
Featured customer reviews
Some things are missing, December 02 2008
The fist impression of the book was luke warm, and after reading some of the opening chapters, I realized that some of the most interesting details were missing. In my opinion, there is no description of the "CURSOR" and no information about loops "WHILE". Therefore, in my opinion, I would say that book remains incomplete.
Randolf Balasus
Execellent book for beginners to the SQL language, June 19 2008
A customer approached me looking for a book to teach the SQL language, after querying my fellow trainers the book that was suggested was Learning SQL on SQL Server 2005.
I ordered a copy of this book and was pleased with it.
For the intended audience, this is the best O'Reilly book I have read. It clearly describes the SQL language so that new comers to databases can quickly learn the language. As with almost all technical computer books it is a little dry in reading, but compared with other books covering the same material this book is much more readable.
The example database is available online (through a script) so readers can practice with the book?s examples and even experiment on their own. It is complete enough to allow complex queries without adding layers of complexity that would confuse. Students can download from Microsoft a trial version of the SQL Server database and play to their hearts content. I would have added an appendix that explains the database layout and the design decisions for the layout, this would help with the transition from using a database to the next level of designing a database.
Each chapter ends with review questions and exercises, so the student can gauge their progress and understanding. The questions represent a reasonable level of expected learning for the student to achieve. I would like to see answers to the questions in the book or available on the Internet.
In summary, this is an excellent book for students wanting to learn the SQL language. I presented the book to the customer and they plan on adopting it for their course.
Move on...nothing to see here..., May 29 2008
one of the spottiest coverage of the subject I have read to date. For this price, OReilly should be ashamed of themselves. Have they actually read this book? Sorry, guys...I am gonna have to pass.
BTW - Yes I did read the entire book and entered most of the examples. Not bad SQL - but NOTHING here that you can't get free on any intro to SQL website.
Joe
Frustrating, May 19 2008
Not having answers to review exercises is very frustrating, especially when there isn't a matching example in the chapter.
Overall, this book was better than slogging through an exhaustive 600 page 'Bible' but I still felt like I'll need something else for reference.
An OK read, February 28 2008
I found this book to be a relatively dry technical manual.
Don't get me wrong, I would definitely recommend this book to newbies and even those that have been in the business for somewhat longer.
The topics, while somewhat un-inspired, are covered very well. One topic flows to the next, leading the reader through the development of a database project. The exercises and review questions are are an excellent test to the reader, but with no answers provided, the reader is left not really knowing whether they answered correctly or not.
All in all - if I had a limited budget - as a seasoned professional this wouldn't be the book I would purchase - there are lots better out there for us long-timers, but I would recommend this one to an entry level database designer
Not What it Should Be, April 23 2007
This book does a very good job of covering the basics, but it's not what it should be. Other O'Reilly books I've used(most notably Learning Perl) have been a joy to read, and are written by people who clearly love their subject matter. This book is, by comparison, very flat and bland, and doesn't do anything to inject any life into itself. Additionally, there are numerous typos throughout the book, including at least one serious one (sample syntax that isn't correct). Finally, while there are plenty of review questions and exercises at the end of each chapter, there's no answer key to be found. It seems rather pointless when you've got no way to check yourself except go back over the chapter.
Good introduction to SQL text, February 09 2007
Overall a good introduction to Microsoft SQL 2005 book. It does suffer from some minor typos and the fact that at the time of my reading it no errata existed made it a little tedious to get through. But no show stoppers. I enjoyed the flow of material and the usefulness of it as well. I would recommend this book for beginner SQL students or for a refresher for older techies.
Media reviews
"For the serious and ambitious SQL beginner this book offers plenty of useful information, presented in a compact, precise, and competent way."
-- Frank Kalis, SQL-Server-Performance.com
"...provides an excellent introduction to the SQL language and applications."
-- Diane Donovan, California Bookwatch
"This is an excellent introduction to the SQL language and database concepts. Using sample tables and data provided, the reader is able to do all of the examples to experience hands-on SQL programming. "
-- Deac Lancaster, author of Transact-SQL Desk Reference
Read all reviews
Learning SQL on SQL Server 2005
The Simplest Way to Learn to Query SQL Server
By Sikha Saha Bagui, Richard Walsh Earp
April 2006
Pages: 342
ISBN 10: 0-596-10215-1 |
ISBN 13: 9780596102159
(Average of 7 Customer Reviews)
This book is OUT OF PRINT, but is available on Safari Books Online.
DescriptionIf 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.
Full 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.
Featured customer reviews
Some things are missing, December 02 2008
Rating:
Submitted by
Randolf Balasus
[Respond | View]
The fist impression of the book was luke warm, and after reading some of the opening chapters, I realized that some of the most interesting details were missing. In my opinion, there is no description of the "CURSOR" and no information about loops "WHILE". Therefore, in my opinion, I would say that book remains incomplete.
Randolf Balasus
Execellent book for beginners to the SQL language, June 19 2008
Rating:
Submitted by
Jesse Network Consultant
[Respond | View]
A customer approached me looking for a book to teach the SQL language, after querying my fellow trainers the book that was suggested was Learning SQL on SQL Server 2005.
I ordered a copy of this book and was pleased with it.
For the intended audience, this is the best O'Reilly book I have read. It clearly describes the SQL language so that new comers to databases can quickly learn the language. As with almost all technical computer books it is a little dry in reading, but compared with other books covering the same material this book is much more readable.
The example database is available online (through a script) so readers can practice with the book?s examples and even experiment on their own. It is complete enough to allow complex queries without adding layers of complexity that would confuse. Students can download from Microsoft a trial version of the SQL Server database and play to their hearts content. I would have added an appendix that explains the database layout and the design decisions for the layout, this would help with the transition from using a database to the next level of designing a database.
Each chapter ends with review questions and exercises, so the student can gauge their progress and understanding. The questions represent a reasonable level of expected learning for the student to achieve. I would like to see answers to the questions in the book or available on the Internet.
In summary, this is an excellent book for students wanting to learn the SQL language. I presented the book to the customer and they plan on adopting it for their course.
Move on...nothing to see here..., May 29 2008
Rating:
Submitted by
Joe
[Respond | View]
one of the spottiest coverage of the subject I have read to date. For this price, OReilly should be ashamed of themselves. Have they actually read this book? Sorry, guys...I am gonna have to pass.
BTW - Yes I did read the entire book and entered most of the examples. Not bad SQL - but NOTHING here that you can't get free on any intro to SQL website.
Joe
Frustrating, May 19 2008
Rating:
Submitted by Anonymous Reader [Respond | View]
Not having answers to review exercises is very frustrating, especially when there isn't a matching example in the chapter.
Overall, this book was better than slogging through an exhaustive 600 page 'Bible' but I still felt like I'll need something else for reference.
An OK read, February 28 2008
Rating:
Submitted by
Fred Gravel
[Respond | View]
I found this book to be a relatively dry technical manual.
Don't get me wrong, I would definitely recommend this book to newbies and even those that have been in the business for somewhat longer.
The topics, while somewhat un-inspired, are covered very well. One topic flows to the next, leading the reader through the development of a database project. The exercises and review questions are are an excellent test to the reader, but with no answers provided, the reader is left not really knowing whether they answered correctly or not.
All in all - if I had a limited budget - as a seasoned professional this wouldn't be the book I would purchase - there are lots better out there for us long-timers, but I would recommend this one to an entry level database designer
Not What it Should Be, April 23 2007
Rating:
Submitted by
Ian Easton
[Respond | View]
This book does a very good job of covering the basics, but it's not what it should be. Other O'Reilly books I've used(most notably Learning Perl) have been a joy to read, and are written by people who clearly love their subject matter. This book is, by comparison, very flat and bland, and doesn't do anything to inject any life into itself. Additionally, there are numerous typos throughout the book, including at least one serious one (sample syntax that isn't correct). Finally, while there are plenty of review questions and exercises at the end of each chapter, there's no answer key to be found. It seems rather pointless when you've got no way to check yourself except go back over the chapter.
Good introduction to SQL text, February 09 2007
Rating:
Submitted by
David A.King
[Respond | View]
Overall a good introduction to Microsoft SQL 2005 book. It does suffer from some minor typos and the fact that at the time of my reading it no errata existed made it a little tedious to get through. But no show stoppers. I enjoyed the flow of material and the usefulness of it as well. I would recommend this book for beginner SQL students or for a refresher for older techies.
Media reviews
"For the serious and ambitious SQL beginner this book offers plenty of useful information, presented in a compact, precise, and competent way."
-- Frank Kalis, SQL-Server-Performance.com
"...provides an excellent introduction to the SQL language and applications."
-- Diane Donovan, California Bookwatch
"This is an excellent introduction to the SQL language and database concepts. Using sample tables and data provided, the reader is able to do all of the examples to experience hands-on SQL programming. "
-- Deac Lancaster, author of Transact-SQL Desk Reference
Read all reviews
"...provides an excellent introduction to the SQL language and applications."
--Diane Donovan, California Bookwatch
©2009, O'Reilly Media, Inc. (707) 827-7000 / (800) 998-9938 All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. |
About O'Reilly
Academic Solutions Authors Contacts Customer Service Jobs Newsletters O'Reilly Labs Press Room Privacy Policy RSS Feeds Terms of Service User Groups Writing for O'Reilly |
More O'Reilly Sites
O'Reilly Radar Ignite Tools of Change for Publishing Digital Media Inside iPhone O'Reilly FYI makezine.com craftzine.com hackszine.com perl.com xml.com Partner Sites InsideRIA java.net |
Content Archive Business Technology Computer Technology Microsoft Mobile Network Operating System Digital Photography Programming Software Web Web Design |