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

(based on 6 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (2)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (1)

  • 1 Stars

     

    (1)

67%

of respondents would recommend this to a friend.

Pros

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

Cons

    Best Uses

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

    Reviewed by 6 customers

    Sort by

    Displaying reviews 1-6

    Back to top

     
    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.

    (2 of 5 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.

    (6 of 8 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-6

        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