SKU: 47306291295

SQL Queries for Mere Mortals, 3/E (Paperback)

$478.12 $531.25
Save 10%
No.2 Bestseller on 2pierres.com >

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

Shipping Estimate
USA
  • USA
  • CAN

Ships within 48 hours · Estimated delivery Jul 27 - Aug 1

Promo Codes Available:

For Your Every Summer RSVP, with Code: SUMMER15

Description

SQL Queries for Mere Mortals, 3/E (Paperback)SQL Queries for Mere Mortals is the easiest, most practical guide to writing modern SQL queries. Now extensively updated to cover new database platforms and include more advanced techniques, it guides the reader step step through creating and modifying queries for virtually any SQL based database. Michael J. Hernandez and John L. Viescas demystify all facets of query writing with SQL Features SQL queries explained in plain English, with plenty of

SQL Queries for Mere Mortals is the easiest, most practical guide to writing modern SQL queries. Now extensively updated to cover new database platforms and include more advanced techniques, it guides the reader step--step through creating and modifying queries for virtually any SQL-based database. Michael J. Hernandez and John L. Viescas demystify all facets of query writing with SQL Features SQL queries explained in plain English, with plenty of examples using the latest database products and SQL standards Covers everything needed to create efficient queries, work with multiple tables, summarize and group data, modify datasets, and more Includes three new chapters of advanced techniques, covering complex Not/And problems, unlinked tables, and problem-solving with CASE and drivertables ContentChapter 1 What Is RelationalChapter 2 Ensuring Your Database Structure Is SoundChapter 3 A Concise History of SQLChapter 4 Creating a Simple QueryChapter 5 Getting More Than Simple ColumnsChapter 6 Filtering Your DataChapter 7 Thinking in SetsChapter 8 INNER JOINsChapter 9 OUTER JOINsChapter 10 UNIONsChapter 11 SubqueriesChapter 12 Simple TotalsChapter 13 Grouping DataChapter 14 Filtering Grouped DataChapter 15 Updating Sets of DataChapter 16 Inserting Sets of DataChapter 17 Deleting Sets of DataChapter 18 "NOT" and "AND" ProblemsChapter 19 Condition Testing

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: 47306291295

Discover Niche Categories That Outsell

Top-Converting Item to Boost Your Average Order

4.8 ★★★★★
Based on 24 reviews
Sort
Highest Rating
Newest First
Oldest First
Product Reviews
M
Verified Purchase
Miguel
Birmingham, US
★★★★★ 5
Super perfecto
Perfecto
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on April 25, 2026
B
Boer
New York, US
★★★★★ 5
Quick and easy to install
This review is for the INFISTAR AC85111 Cabin Air Filter. To be honest, when I saw this product I was a bit perplexed as to whether our car (Honda Odyssey) even had one! I have never replaced a cabin air filter on any car before. The mechanics might have done so during regular service, but I was not aware of it and had to do an internet search to find out where it would even be installed. Just because of my ignorance, I decided to get it and educate myself. My car actually DID have one and installation would have been a quick and easy job if I remembered to take all the heavy stuff (manuals, etc.) out of the glove box. Because I did not do it, it unhooked it on the right and I had quite a bit of trouble realigning it. If it hadn't been for that, installation would have only take a couple of minutes as it was a breeze. The new filter looks like a good quality product and will last a while. Jury is still out for me on the color though. The old filter was white, so it was easy to see the dirt it trapped. This new filter is almost dirt color which would make it harder to see how dirty it is. However, at such an affordable price, I can replace it as often as I want. I asked my mechanic about it and he said he only replaces cabin air filters if the customer requests it or if he notices a funny odor in the car.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on April 4, 2026
D
Deval
Lowell, US
★★★★★ 5
Effective Cabin Air Filter – Fresh and Clean Air for My Car
I recently replaced my car’s cabin air filter with the AC85111 activated carbon filter, and I’ve noticed a clear improvement in air quality inside the vehicle. It helps keep the cabin air fresh, especially during daily commutes and long drives. The activated carbon layer does a good job of reducing dust, odors, and outside pollution, making the driving experience more comfortable. I also noticed less smell from traffic fumes and general road dust entering the car. The fit was perfect for my Honda Pilot, and installation was simple without needing any special tools. It is compatible with several Honda and Acura models, which makes it a reliable replacement option. The material feels well-made and sturdy enough for regular use, ensuring consistent airflow while filtering out impurities effectively. Considering its performance and durability, it also offers good value for money. Overall, this is a practical, easy-to-install, and reliable cabin air filter that helps maintain cleaner and fresher air inside the car.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on May 8, 2026
T
TJ
New York, US
★★★★★ 5
Good fit for our Honda Accord, quality filter
This was the perfect fit for my daughter's Honda Accord. It's a solid, budget‑friendly upgrade that fits perfectly. It only took a few minutes to install. The pleated material feels sturdy, and the activated carbon layer helps cut down on odors and everyday cabin dust.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on May 30, 2026
Z
Zack
Fort Morgan, US
★★★★★ 5
No more funky smell!
Have had a funky smell for a while in my car. Air fresheners just couldn't quite cover it up. I pulled the old filter out which was reallll caked up with stuff and got the new one in. Not only is the funky smell finally gone, but the HVAC is a lot quieter when on full blast, and it blows the air harder. It fit great, installation was easy, and having the smell gone makes it worth absolutely every penny.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on April 24, 2026

recommand products

Interactive Cat Toys for Indoor Cats, Electric Cat Ball Fast Rolling in Pouch, Motion Activated Chirping Cat Toy, Hide and Seek Cat Toy with LED Light
41.99
Classic – Cat Puzzle Feeder – Interactive Enrichment Toy – Treat Puzzle Box – Food Maze for Indoor Cats
22.32
WePet Cat Litter Scoop, Aluminum Alloy Sifter, Kitty Metal Scooper, Deep Shovel, Long Handle, Poop Sifting, Kitten Pooper Lifter, Durable, Heavy Duty, for Litter box
19.59
White Rose — Edition V
14.00
Poppy Field — Edition IV
14.00