SKU: 33380418179

Practical Sql, 2nd Edition: A Beginner's Guide to Storytelling with Data

Sale price$35.99 Regular price$39.99
Save 10%

Pay in installments of $10.00 with ShopPay, AfterPay and Klarna

Shipping Estimate
USA
  • USA
  • CAN

Ships within 48 hours · Estimated delivery Jul 18 - Jul 23

Promo Codes Available:

For Your Every Summer RSVP, with Code: SUMMER15

Description

Practical Sql, 2nd Edition: A Beginner's Guide to Storytelling with DataAnalyze 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

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.
    Shipping Notes
    • Free Standard Shipping on $100+ Orders to the USA.
    • Except Preorder products are shipped in 48 hours.
    • Delivery to the USA:
    1. Standard Shipping : 3-10 business days
    • If time is of the essence, please consider selecting expedited delivery for faster service.
    Exchange/Return Notes
    • We offer a 30-day return/exchange service after receiving.
    • Final sale items are not eligible for returns or exchanges.
    • To process your return/exchange, please contact us at [email protected]
    • Please click here for more details>>> Return & Exchange Policy
    SKU: 33380418179

    Discover Niche Categories That Outsell

    Top-Converting Item to Boost Your Average Order

    4.5 ★★★★★
    Based on 30 reviews
    Sort
    Highest Rating
    Newest First
    Oldest First
    Product Reviews
    C
    Verified Purchase
    Carmen Alicea
    Natrona Heights, US
    ★★★★★ 5
    A Beta Worth Rooting For
    Format: Kindle
    In Spare, Violet Fox flips the omegaverse on its head, giving us a Beta heroine determined to make her mark. Joining the Beta Trials to support her sick father, she's thrown into a pack that doesn't want her, especially the possessive Alphas. But here's the twist: their sweet Omega turns out to be her scent match. Cue the angst, forbidden tension, and a slow-burn romance that will make your heart ache in the best way. Violet Fox delivers an emotional, refreshing take on the genre, proving Betas aren't "spares." They're stars.
    WAS THIS REVIEW HELPFUL?YesReportShare
    Reviewed in the United States on January 10, 2025
    C
    Verified Purchase
    C. Hunter
    New York, US
    ★★★★★ 5
    Beta, Alpha, Omega oh my!
    Format: Kindle
    Omegas are precious and given to Alphas & their packs... but the Betas want in too. To this end, the Beta government is rolling out its trial of assigning a Beta to each Alpha-Omega pack. But forcing a Beta into a pack where they are not wanted will not end well... Of course, no one expected the Omega to fall for the assigned Beta. Great read and cliffhanger
    WAS THIS REVIEW HELPFUL?YesReportShare
    Reviewed in the United States on February 15, 2025
    B
    Verified Purchase
    B. Stubby
    Alexandria, US
    ★★★★★ 3
    A familiar story, just with…..less.
    Format: Kindle
    So, as other reviewers make clear, this is very similar to Pack Darling and The Beta. It’s much closer aligned with The Beta, in plot and maybe more like Pack Darling with characters. That being said, I don’t hate this…..but it wasn’t great either. It’s both books mentioned but just….less. Less angst, less emotion, less feeling. The plot feels very half fleshed out, and the “bad guy” feels underwhelming. I didn’t really feel any real emotions from and of the male leads, except maybe Oliver. The others fell sorta flat for me. And Mika makes herself out to be this big bad ass straight outta training and then we never see it from here again with the one fitting room incident as the exception. SPOILER: The whole, “Oh, I’m actually probably an Omega, but I don’t wanna be but I do actually wanna be but no one can ever know my secret that I do nothing to hide “ thing fell so flat. She never commutes to believing she was secretly an omega, but also mentions her “secret” a lot. It just felt so manufactured. I’m intrigued enough to read part 2 and see how the author closes everything out, but this is not one I’ll recommend or ever come back to.
    WAS THIS REVIEW HELPFUL?YesReportShare
    Reviewed in the United States on February 13, 2024
    A
    Verified Purchase
    Ashley Morgan
    Lake Worth, US
    ★★★★★ 5
    ABSOLUTELY A MUST for Omegaverse Girls!!!
    I ABSOLUTELY LOVE Jillian West and her books!!! I’m so happy I already bought book two and now I have to buy the others for the Assurance Security series!! Not gonna lie Val kind of annoyed me at the beginning but she grew on me!! Her men are chef’s kisses!!! Holt annoys me some but I can let it slide. I already bought part two so I’m going to be reading that in between work phone calls!!!! DON’T TELL MY BOSS 😂😂😂😂
    WAS THIS REVIEW HELPFUL?YesReportShare
    Reviewed in the United States on September 30, 2025
    C
    Verified Purchase
    Carmen Alicea
    Waukegan, US
    ★★★★★ 4
    Baby bumps and bodyguards
    Format: Kindle
    Dark, emotional, and unexpectedly tender, Not Ready is an omegaverse romance that delivers found family feels, fierce protectiveness, and a very pregnant heroine who refuses to break. Vale’s on the run from a stalker, but lands in the arms of three private security alphas, cue the swoony tension, fake marriage twist, and slow-burn heat. It’s a little gritty, a little soft, and a whole lot addictive. If you love protective alphas, high stakes, and heroines with quiet strength, this one’s a must-read.
    WAS THIS REVIEW HELPFUL?YesReportShare
    Reviewed in the United States on December 18, 2025

    recommand products