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.2

(based on 9 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (2)

  • 3 Stars

     

    (2)

  • 2 Stars

     

    (2)

  • 1 Stars

     

    (1)

67%

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 (5)
  • Student (4)
    • Reviewer Profile:
    • Developer (4)

Reviewed by 9 customers

Sort by

Displaying reviews 1-9

Back to top

 
2.0

Lengthy text on basic syntax

By Tom

from Nacka, Sweden

About Me Designer

Verified Reviewer

Pros

    Cons

    • Not comprehensive enough
    • Too basic

    Best Uses

    • Novice

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

    I have to admit that this I am not the target reader of this book, and my impression is naturally biased by this fact.

    This book seems to be written for someone who has trouble understanding a casual phrase like "Let's store the data in the database". It feels to me like the author has written the book for someone who has never heard the word "data" or the word "database" before.

    Admittedly there is correct information in the book on SQL syntax. But this correct information is incredible diluted in lengthy texts describing the most basic concepts.

    As I have learnt SQL by working with it, my knowledge is about the parts of SQL that I have used. There are parts of the SQL language that I have not worked with, and that feel unfamiliar to me. I bought this book to learn the parts of the SQL syntax that I have not worked with. This was the wrong book for that purpose.

     
    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.

        (5 of 9 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-9

            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