Learning SQL on SQL Server 2005
The Simplest Way to Learn to Query SQL Server
Publisher: O'Reilly Media
Final Release Date: April 2006
Pages: 352

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.

Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyLearning SQL on SQL Server 2005
 
2.6

(based on 9 reviews)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (2)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (2)

  • 1 Stars

     

    (3)

Reviewed by 9 customers

Sort by

Displaying reviews 1-9

Back to top

 
1.0

Worst O'Reilly book I ever read

By Eric R.

from Pittsburgh PA

About Me Developer, Educator, Sys Admin

Verified Reviewer

Pros

  • Better than nothing

Cons

  • Too many errors

Best Uses

  • Kindling

Comments about oreilly Learning SQL on SQL Server 2005:

So many mistakes made it hard to read and I stopped 70 pages short of finishing. Never picked it up again.

(0 of 1 customers found this review helpful)

 
1.0

How to run script? Where is the book cod

By A_Frustated_Reader

from Los Angeles

About Me Designer

Pros

    Cons

      Best Uses

        Comments about oreilly Learning SQL on SQL Server 2005:

        Well... This book is for beginners, now they gave the script for creating a database (in Appendix B) but did not explained how to run that script or how to install the practice database using that script.

         
        2.0

        Some things are missing

        By Randolf Balasus

        from Undisclosed

        Comments about oreilly Learning SQL on SQL Server 2005:

        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

        (1 of 1 customers found this review helpful)

         
        5.0

        Execellent book for beginners to the SQL language

        By Jesse Network Consultant

        from Undisclosed

        Comments about oreilly Learning SQL on SQL Server 2005:

        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.

         
        1.0

        Move on...nothing to see here...

        By Joe

        from Undisclosed

        Comments about oreilly Learning SQL on SQL Server 2005:

        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

         
        3.0

        Frustrating

        By Anonymous

        from Undisclosed

        Comments about oreilly Learning SQL on SQL Server 2005:

        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.

         
        4.0

        An OK read

        By Fred Gravel

        from Undisclosed

        Comments about oreilly Learning SQL on SQL Server 2005:

        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

         
        2.0

        Not What it Should Be

        By Ian Easton

        from Undisclosed

        Comments about oreilly Learning SQL on SQL Server 2005:

        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.

        (1 of 1 customers found this review helpful)

         
        4.0

        Good introduction to SQL text

        By David A.King

        from Undisclosed

        Comments about oreilly Learning SQL on SQL Server 2005:

        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.

        Displaying reviews 1-9

        Back to top

         
        Buy 2 Get 1 Free Free Shipping Guarantee
        Buying Options
        Immediate Access - Go Digital what's this?
        Ebook: $35.99
        Formats:  DAISY, ePub, Mobi, PDF