Getting Started with SQL
A Hands-On Approach for Beginners
Publisher: O'Reilly Media
Final Release Date: February 2016
Pages: 134

Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you’re a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases.

Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you’ll also discover how to efficiently design and manage databases to meet your needs.

You’ll also learn how to:

  • Explore relational databases, including lightweight and centralized models
  • Use SQLite and SQLiteStudio to create lightweight databases in minutes
  • Query and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BY
  • Join tables to get a more complete view of your business data
  • Build your own tables and centralized databases by using normalized design principles
  • Manage data by learning how to INSERT, DELETE, and UPDATE records
Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyGetting Started with SQL
 
3.6

(based on 13 reviews)

Ratings Distribution

  • 5 Stars

     

    (7)

  • 4 Stars

     

    (2)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (4)

69%

of respondents would recommend this to a friend.

Pros

  • Easy to understand (7)
  • Concise (5)
  • Helpful examples (4)
  • Well-written (4)

Cons

No Cons

Best Uses

  • Novice (7)
  • Student (7)
  • Intermediate (3)
    • Reviewer Profile:
    • Developer (4), Educator (3)

Reviewed by 13 customers

Displaying reviews 1-10

Back to top

Previous | Next »

(1 of 1 customers found this review helpful)

 
4.0

Some small errors.

By Little Mountain

from HCMC, Vietnam

Pros

  • Helpful examples

Cons

  • Not comprehensive enough

Best Uses

  • Novice

Comments about oreilly Getting Started with SQL:

Page 34. The code should be:

SELECT * FROM station_data
WHERE (not tornado) AND (not hail);

 
5.0

very intuitive, excellent in practical evironment

By Sandy

from NJ

About Me Developer

Verified Buyer

Pros

  • Accurate
  • Concise
  • Easy to understand
  • Helpful examples
  • Well-written

Cons

    Best Uses

    • Expert
    • Intermediate
    • Novice
    • Student

    Comments about oreilly Getting Started with SQL:

    uptodate query results

     
    5.0

    A very nice book

    By geng

    from Beijing

    Verified Reviewer

    Pros

    • Easy to understand

    Cons

      Best Uses

      • Student

      Comments about oreilly Getting Started with SQL:

      This is a very nice book, very easy to follow. I think that the current star is too low and I want to make it higher :)

      (1 of 3 customers found this review helpful)

       
      1.0

      Seems to skip some details and download files link bad

      By bnave

      from Los Angeles,ca

      Verified Reviewer

      Pros

        Cons

        • Not comprehensive enough
        • Too many errors

        Best Uses

          Comments about oreilly Getting Started with SQL:

          I need to the programs and data files to use the book. Seems to skip how to download and install the SQLite program. Do we need it? Doesn't say. Skips to SQLite Studio (page 9). Do I need both programs? This for beginners nice if you provided more detail about his basic step. I can't figure out how to install SQLite.

          The path to download the SQL files does not work. So how I can a reader use the files mentioned in the book?

          Without the program and data file the book is useless.

           
          5.0

          Great Book (From a Former Teacher)

          By Erin

          from Indianapolis, IN

          Verified Reviewer

          Comments about oreilly Getting Started with SQL:

          The author broke everything down into easy steps and provided lots of information. I was a math teacher for six years and recently started a new career in data analytics, so I really appreciate people who are able to teach effectively (especially through a book - that's so hard!). This book is perfect if you have some programming experience but you're looking to add SQL to your resume!

          (2 of 3 customers found this review helpful)

           
          1.0

          Getting Started with the book....

          By Marten

          from Germany

          Comments about oreilly Getting Started with SQL:

          Sorry, I never had such a poor installation of the examples database and its Editor. To put it straight:
          1) The example db download link via GitHub doesnt work
          2) The SQLLiteStudio Editor dosnt open the other examples found on GitHub
          3) Dont buy the book unless you want to work without the SQL-Editor and db examples.
          For me, wasted money and time

          (1 of 2 customers found this review helpful)

           
          5.0

          Perfect for Getting Started

          By gm

          from az

          About Me Developer

          Verified Reviewer

          Pros

          • Concise
          • Easy to understand

          Cons

            Best Uses

            • Novice
            • Student

            Comments about oreilly Getting Started with SQL:

            I would recommend this to anyone who doesn't know where to begin with SQL which can be overwhelming with all of the offerings.

            However it will only get you started and you could read the book and learn the skills in about a week and be left wanting more. But it can't be beat for it's intended audience.

            (0 of 7 customers found this review helpful)

             
            1.0

            Fundamental problems from page 11

            By Paul

            from London

            About Me Developer, Educator

            Verified Reviewer

            Pros

              Cons

              • Difficult to understand
              • Too many errors

              Best Uses

                Comments about oreilly Getting Started with SQL:

                Installed SQLStudio but impossible to connect to example databases so the rest of the book is redundant. Total waste of money. Do not buy!!!!!

                (3 of 3 customers found this review helpful)

                 
                5.0

                Like in the Matrix... "I know SQL"

                By Marco

                from Los Angeles, CA

                About Me Future Data Scientist

                Verified Reviewer

                Pros

                • Concise
                • Easy to understand
                • Well-written

                Cons

                  Best Uses

                  • Novice
                  • Student

                  Comments about oreilly Getting Started with SQL:

                  Ok... that's an exaggeration. But really, if you don't know SQL and have some programming experience this book will give you a basic knowledge of SQL quickly and painlessly.

                  (3 of 3 customers found this review helpful)

                   
                  5.0

                  Great book!

                  By Rex

                  from Dallas, TX

                  Verified Reviewer

                  Pros

                  • Easy to understand
                  • Helpful examples
                  • Well-written

                  Cons

                    Best Uses

                    • Intermediate
                    • Novice
                    • Student

                    Comments about oreilly Getting Started with SQL:

                    I read this book after receiving a 2 hr 101 training on SQL. I felt this book did a great job in helping me understand the basic fundamentals of using SQL.

                    Since reading the book, I've helped coworkers with SQL and have created a few queries of my own.

                    The author's word choice, explanations, and examples helped me understand each topic.

                    I have already recommended this book to my coworkers who are wanting to learn the basic fundamentals of SQL.

                    Displaying reviews 1-10

                    Back to top

                    Previous | Next »

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