Items related to Practical SQL, 2nd Edition: A Beginner's Guide...

Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data - Softcover

  • 4.26 out of 5 stars
    224 ratings by Goodreads
 
9781718501065: Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data

Synopsis

Analyze data like a pro, even if you’re a beginner.

Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your data. The examples and code use the open-source database PostgreSQL and its companion pgAdmin interface, and the concepts you learn will apply to most database management systems, including MySQL, Oracle, SQLite, and others.*

You’ll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from real-world datasets such as US Census demographics, New York City taxi rides, and earthquakes from US Geological Survey. Each chapter includes exercises and examples that teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently.

You’ll learn how to:

  • Create databases and related tables using your own data
  • Aggregate, sort, and filter data to find patterns
  • Use functions for basic math and advanced statistical operations
  • Identify errors in data and clean them up
  • Analyze spatial data with a geographic information system (PostGIS)
  • Create advanced queries and automate tasks

  • This updated second edition has been thoroughly revised to reflect the latest in SQL features, including additional advanced query techniques for wrangling data. This edition also has two new chapters: an expanded set of instructions on for setting up your system plus a chapter on using PostgreSQL with the popular JSON data interchange format. 

    Learning SQL doesn’t have to be dry and complicated. Practical SQL delivers clear examples with an easy-to-follow approach to teach you the tools you need to build and manage your own databases.

    * Microsoft SQL Server employs a variant of the language called T-SQL, which is not covered by Practical SQL.

    "synopsis" may belong to another edition of this title.

    About the Author

    Anthony DeBarros is a longtime journalist who has combined his interests in data analysis, coding, software product development, and storytelling for much of his career. He is a data news editor for The Wall Street Journal, focusing on topics such as the economy, trade, the U.S. Census, and politics. He previously held positions with USA TODAY, the Poughkeepsie Journal, and the DocumentCloud project for Investigative Reporters and Editors. His work has received multiple honors, including a prestigious Silver Baton from the Alfred I. duPont-Columbia University Awards.

    "About this title" may belong to another edition of this title.

    • PublisherNo Starch Press
    • Publication date2022
    • ISBN 10 1718501064
    • ISBN 13 9781718501065
    • BindingPaperback
    • LanguageEnglish
    • Edition number2
    • Number of pages464
    • Rating
      • 4.26 out of 5 stars
        224 ratings by Goodreads

    Buy Used

    Condition: Very Good
    View this item

    US$ 3.99 shipping within U.S.A.

    Destination, rates & speeds

    Search results for Practical SQL, 2nd Edition: A Beginner's Guide...

    Stock Image

    DeBarros, Anthony
    Published by No Starch Press, 2022
    ISBN 10: 1718501064 ISBN 13: 9781718501065
    Used Softcover

    Seller: Goodwill, Brooklyn Park, MN, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: VeryGood. Seller Inventory # 2Y6RVK004XD2_ns

    Contact seller

    Buy Used

    US$ 19.27
    Convert currency
    Shipping: US$ 3.99
    Within U.S.A.
    Destination, rates & speeds

    Quantity: 1 available

    Add to basket

    Stock Image

    DeBarros, Anthony
    Published by No Starch Press, 2022
    ISBN 10: 1718501064 ISBN 13: 9781718501065
    Used Softcover

    Seller: Goodwill, Brooklyn Park, MN, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: Good. Corners are bent. Stains on outside cover/inside the book. There are tears on paperback/pages. Seller Inventory # 2Y6JCK00BJ0W_ns

    Contact seller

    Buy Used

    US$ 19.28
    Convert currency
    Shipping: US$ 3.99
    Within U.S.A.
    Destination, rates & speeds

    Quantity: 1 available

    Add to basket

    Stock Image

    DeBarros, Anthony
    Published by No Starch Press, 2022
    ISBN 10: 1718501064 ISBN 13: 9781718501065
    Used paperback

    Seller: HPB-Emerald, Dallas, TX, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    paperback. Condition: Very Good. Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_437583541

    Contact seller

    Buy Used

    US$ 19.99
    Convert currency
    Shipping: US$ 3.75
    Within U.S.A.
    Destination, rates & speeds

    Quantity: 1 available

    Add to basket

    Seller Image

    DeBarros, Anthony
    Published by No Starch Press, 2022
    ISBN 10: 1718501064 ISBN 13: 9781718501065
    Used Softcover

    Seller: Goodwill of Greater Milwaukee and Chicago, Racine, WI, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: good. Book is considered to be in good or better condition. The actual cover image may not match the stock photo. Hard cover books may show signs of wear on the spine, cover or dust jacket. Paperback book may show signs of wear on spine or cover as well as having a slight bend, curve or creasing to it. Book should have minimal to no writing inside and no highlighting. Pages should be free of tears or creasing. Stickers should not be present on cover or elsewhere, and any CD or DVD expected with the book is included. Book is not a former library copy. Seller Inventory # SEWV.1718501064.G

    Contact seller

    Buy Used

    US$ 23.28
    Convert currency
    Shipping: US$ 3.00
    Within U.S.A.
    Destination, rates & speeds

    Quantity: 1 available

    Add to basket

    Seller Image

    Debarros, Anthony
    Published by No Starch Press, 2022
    ISBN 10: 1718501064 ISBN 13: 9781718501065
    New Softcover

    Seller: GreatBookPrices, Columbia, MD, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: New. Seller Inventory # 41943627-n

    Contact seller

    Buy New

    US$ 28.19
    Convert currency
    Shipping: US$ 2.64
    Within U.S.A.
    Destination, rates & speeds

    Quantity: Over 20 available

    Add to basket

    Stock Image

    Debarros, Anthony
    Published by Penguin Random House
    ISBN 10: 1718501064 ISBN 13: 9781718501065
    New

    Seller: INDOO, Avenel, NJ, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: New. Seller Inventory # 9781718501065

    Contact seller

    Buy New

    US$ 30.84
    Convert currency
    Shipping: FREE
    Within U.S.A.
    Destination, rates & speeds

    Quantity: Over 20 available

    Add to basket

    Seller Image

    Debarros, Anthony
    Published by No Starch Press, 2022
    ISBN 10: 1718501064 ISBN 13: 9781718501065
    Used Softcover

    Seller: GreatBookPrices, Columbia, MD, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: As New. Unread book in perfect condition. Seller Inventory # 41943627

    Contact seller

    Buy Used

    US$ 28.25
    Convert currency
    Shipping: US$ 2.64
    Within U.S.A.
    Destination, rates & speeds

    Quantity: Over 20 available

    Add to basket

    Stock Image

    DeBarros,Anthony
    Published by Penguin Random House
    ISBN 10: 1718501064 ISBN 13: 9781718501065
    Used

    Seller: INDOO, Avenel, NJ, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: As New. Unread copy in mint condition. Seller Inventory # RH9781718501065

    Contact seller

    Buy Used

    US$ 30.90
    Convert currency
    Shipping: FREE
    Within U.S.A.
    Destination, rates & speeds

    Quantity: Over 20 available

    Add to basket

    Stock Image

    DeBarros, Anthony
    Published by No Starch Press, 2022
    ISBN 10: 1718501064 ISBN 13: 9781718501065
    New Softcover

    Seller: Lakeside Books, Benton Harbor, MI, U.S.A.

    Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

    Condition: New. Brand New! Not Overstocks or Low Quality Book Club Editions! Direct From the Publisher! We're not a giant, faceless warehouse organization! We're a small town bookstore that loves books and loves it's customers! Buy from Lakeside Books! Seller Inventory # OTF-S-9781718501065

    Contact seller

    Buy New

    US$ 27.41
    Convert currency
    Shipping: US$ 3.99
    Within U.S.A.
    Destination, rates & speeds

    Quantity: Over 20 available

    Add to basket

    Stock Image

    DeBarros, Anthony
    Published by No Starch Press, 2022
    ISBN 10: 1718501064 ISBN 13: 9781718501065
    New Softcover

    Seller: Lucky's Textbooks, Dallas, TX, U.S.A.

    Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

    Condition: New. Seller Inventory # ABLIING23Mar2912160056901

    Contact seller

    Buy New

    US$ 30.98
    Convert currency
    Shipping: US$ 3.99
    Within U.S.A.
    Destination, rates & speeds

    Quantity: 12 available

    Add to basket

    There are 32 more copies of this book

    View all search results for this book