Learning SQL, 2nd Edition
Master SQL Fundamentals
Publisher: O'Reilly Media
Final Release Date: April 2009
Pages: 338

Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.

Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will:

  • Move quickly through SQL basics and learn several advanced features
  • Use SQL data statements to generate, manipulate, and retrieve data
  • Create database objects, such as tables, indexes, and constraints, using SQL schema statements
  • Learn how data sets interact with queries, and understand the importance of subqueries
  • Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements

Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

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

REVIEW SNAPSHOT®

by PowerReviews
O'Reilly MediaLearning SQL, 2nd Edition
 
3.4

(based on 8 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (2)

  • 3 Stars

     

    (2)

  • 2 Stars

     

    (1)

  • 1 Stars

     

    (1)

75%

of respondents would recommend this to a friend.

Pros

  • Well-written (6)
  • Accurate (4)
  • Easy to understand (4)
  • Concise (3)
  • Helpful examples (3)

Cons

No Cons

Best Uses

  • Novice (4)
  • Student (4)
    • Reviewer Profile:
    • Developer (4)

Reviewed by 8 customers

Sort by

Displaying reviews 1-8

Back to top

 
3.0

Download instruction issues

By Emonkey

from Dayton, OH

About Me Newb

Verified Buyer

Pros

  • Well-written

Cons

    Best Uses

      Comments about O'Reilly Media Learning SQL, 2nd Edition:

      It's easy to read, but following the download of MySQL wasn't possible/didn't work. I'm putting it aside while I work through another (older) text using XAMPP and then plan to go back to it.

      (0 of 1 customers found this review helpful)

       
      3.0

      Good for new SQL developers

      By kralj

      from Ohio, USA

      About Me Developer, Sys Admin

      Verified Reviewer

      Pros

      • Accurate
      • Easy to understand
      • Well-written

      Cons

      • Faulty Example Code
      • No Plsql

      Best Uses

      • Intermediate
      • Novice

      Comments about O'Reilly Media Learning SQL, 2nd Edition:

      I enjoyed reading this title.

      A lot of useful information with regards to basic select statements through to more complex subqueries and joins.

      Although I would have liked to have seen more about PL SQL. Yet this book is about base SQL. The examples are based off of MySQL. So I am not to surprised that Oracle's PL/SQL wasn't a topic of heavy discussion.

      One other note, the code did not work for me.
      I read this months ago, so I don't remember what error(s) I ran into when attempting to create the example database. I see from the other reviews found here, that others have had this same issue. I wish the author would look into and resolve this. The faulty code makes it harder for folks to read this and learn SQL hands on. *If it wasn't for this, I would have given the title a four star review.

       
      5.0

      Must have for your SQL Tool Box

      By krobinson937

      from Dayton, Ohio

      Verified Reviewer

      Pros

      • Accurate
      • Concise
      • Easy to understand
      • Good Starting Point
      • Helpful examples
      • Well-written

      Cons

      • None

      Best Uses

      • Student

      Comments about O'Reilly Media Learning SQL, 2nd Edition:

      I'm studying to become more proficient with databases and sql. I bought this book to get a start in a new career while working with Access 2010 and MySQL. So far so good. All codes work fine in my current environment which is XAMPP and Windows.

      (4 of 8 customers found this review helpful)

       
      1.0

      Not Useful-Tutorial Software Unavailable

      By Austin

      from Michigan

      About Me Designer, Developer, Educator, Sys Admin

      Pros

      • Uncertain

      Cons

      • Too many errors
      • Tutorial Software

      Best Uses

      • Intermediate

      Comments about O'Reilly Media Learning SQL, 2nd Edition:

      This book might be good but I can't tell. The book requires MySQL Server 6.0 to do the tutorials, which is not available. Subsequently, I can't do the tutorials. I checked MySQL download site and there is: MySQL Enterprise, Cluster CGE, Community Server, Cluster and so on listed on the download page. It would be helpful if the Author/Publisher listed the specific version of MySQL that can be used with the tutorials and the detailed instructions on how to load on your computer. Without this information, the book is not useful.

      (7 of 9 customers found this review helpful)

       
      2.0

      Lacks support

      By Deb

      from Tampa, FL

      Verified Reviewer

      Comments about O'Reilly Media Learning SQL, 2nd Edition:

      I think this book might be good. The book is based on Mysql 6.0 which is no longer available for download. Difficulties in figuring out what products under the MYSQL download site would be appropriate for use with this book. The Support and supposed Web Page that supports this book are non-existent. I think if I could actually get a clean supported mysql download that was compatible with the book that the book would be a good way to learn the basic of SQL. So far this has been a waste of money since I can't actually follow along with the book and examples.

      (1 of 1 customers found this review helpful)

       
      5.0

      Fantastic

      By ao

      from UK

      About Me Developer

      Verified Reviewer

      Pros

      • Concise
      • Easy to understand
      • Well-written

      Cons

        Best Uses

        • Novice
        • Student

        Comments about O'Reilly Media Learning SQL, 2nd Edition:

        I recommend this book whenever someone needs to learn the basics of SQL. There's not really a lot to say - it's clear, concise, and gets the job done.

        (5 of 6 customers found this review helpful)

         
        4.0

        Excellent Starter Book

        By Arthur

        from San Jose, CA

        About Me Business User

        Verified Reviewer

        Pros

        • Accurate
        • - Chapters are not long -
        • Concise
        • Easy to understand
        • - Exercises at the end of
        • Helpful examples
        • Well-written

        Cons

        • - Author should discuss t
        • - More diagrams would be

        Best Uses

        • Novice
        • Student

        Comments about O'Reilly Media Learning SQL, 2nd Edition:

        First of all - I am not a programmer. My background is business - and my last exposure to programming was BASIC!
        I do have a strong working knowledge of DB - 5 years as an end user. This book trained me to do my own SQL queries while doing technical support and QA.

        I highly recommend this to high school students.

        (7 of 7 customers found this review helpful)

         
        4.0

        Excellent Database Query Instructions

        By Daniel Fitzgerald

        from Elkin, North Carolina

        About Me Developer, Educator

        Verified Reviewer

        Pros

        • Accurate
        • Helpful examples
        • Well-written

        Cons

          Best Uses

          • General user
          • Novice
          • Student

          Comments about O'Reilly Media Learning SQL, 2nd Edition:

          I was looking for a book I could recommend to a business friend, whom wanted to learn Database Query Language for his small business. I bought the book and reviewed its syllabus and appropriateness to an intelligent audience, not necessarily as technical as I am with databases. I found the book to be excellently written, and in grammer, syntax, and outline as presentable a book to the 'general' audience as one could hope for. I have spent several weeks with the book. I recommend this book to be the first purchase by anyone who desires to learn to write in SQL.

          Displaying reviews 1-8

          Back to top

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

          Available in Multiple Languages