Ben Forta

Light Paperback (1 lb or less)

Arizona

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

New full-color code examples help you see how SQL statements are structured





Whether you''re an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job.





Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know-starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints.





You''ll learn methodically, systematically, and simply-in 22 short, quick lessons that will each take only 10 minutes or less to complete.





With the Fourth Edition of this worldwide bestseller, the book has been thoroughly updated, expanded, and improved. Lessons now cover the latest versions of IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base. And new full-color SQL code listings help the beginner clearly see the elements and structure of the language.

10 minutes is all you need to learn how to...








 * Use the major SQL statements
 * Construct complex SQL statements using multiple clauses and operators
 * Retrieve, sort, and format database contents
 * Pinpoint the data you need using a variety of filtering techniques
 * Use aggregate functions to summarize data
 * Join two or more related tables
 * Insert, update, and delete data
 * Create and alter database tables
 * Work with views, stored procedures, and more

Table of Contents

1 Understanding SQL


2 Retrieving Data


3 Sorting Retrieved Data


4 Filtering Data


5 Advanced Data Filtering


6 Using Wildcard Filtering


7 Creating Calculated Fields


8 Using Data Manipulation Functions


9 Summarizing Data


10 Grouping Data


11 Working with Subqueries


12 Joining Tables


13 Creating Advanced Joins


14 Combining Queries


15 Inserting Data


16 Updating and Deleting Data


17 Creating and Manipulating Tables


18 Using Views


19 Working with Stored Procedures


20 Managing Transaction Processing


21 Using Cursors


22 Understanding Advanced SQL Features


Appendix A: Sample Table Scripts


Appendix B: Working in Popular Applications


Appendix C : SQL Statement Syntax


App

Sams Teach Yourself SQL in 10 Minutes

b4ddbd34-c213-4079-9330-a296a8623a7d-1

Susan Scott

Heavy Paperback (2 to 4 lbs)

Susan Scott maintains an international consulting practice through her firm, Fierce Conversations Inc., which provides Fierce Conversations, Fierce Leadership, and Fierce Coaching programs to CEOs and company leaders. For fourteen years, she ran think tanks and seminars for business leaders through TEC International, an organization dedicated to increasing the effectiveness and enhancing the lives of CEOS around the world. Scott has extensive experience assisting companies with mission, vision, values, leadership development, cultural transformation, strategic planning, and executive coaching.

SM Fierce Conversations

29d9f073-513d-4de1-b318-42d297ed0821-1

Chris Kyle

Scott McEwen

Jim DeFelice

The Autobiography of the Most Lethal Sniper in U. S. History

NOW A BLOCKBUSTER MOTION PICTURE DIRECTED BY CLINT EASTWOOD—NOMINATED FOR SIX ACADEMY AWARDS, INCLUDING BEST PICTURE From 1999 to 2009, U.S. Navy SEAL Chris Kyle recorded the most career sniper kills in United States military history. His fellow American warriors, whom he protected with deadly precision from rooftops and stealth positions during the Iraq War, called him "The Legend"; meanwhile, the enemy feared him so much they named him al-Shaitan ("the devil") and placed a bounty on his head. Kyle, who was tragically killed in 2013, writes honestly about the pain of war—including the deaths of two close SEAL teammates—and in moving first-person passages throughout, his wife, Taya, speaks openly about the strains of war on their family, as well as on Chris. Gripping and unforgettable, Kyle's masterful account of his extraordinary battlefield experiences ranks as one of the great war memoirs of all time. Includes new material by Taya Kyle about the making of the American Sniper film

American Sniper

4e7a9dc6-1980-497d-b4fc-b6f1e32f8adc-1

Ambrosia Hawthorn

Essential Spells to Change Your Life

Change your life with this enchantingly easy spell book Magic is present within us all--when accessed, it allows us to connect to the natural world, invite in opportunities, and create the change we need in our lives. The Spell Book for New Witches shows you how to tap into your inner power and make spellcasting practical for your day-to-day. This spell book starts with an introduction to spell work, including performing spells, prepping your space, and channeling energy to access your power. Easy-to-follow spells will help you find lasting love, protect your family and friends, advance your career, and live the life you deserve. The Spell Book for New Witches includes: Practical magic--An overview to spellcasting covers terminology, best practices, misconceptions, and more. Sage advice--Learn to create an altar, access your power, and connect with the magic using calendars, seasons, and cycles. Spellbound--This spell book covers seven categories, such as Romantic Love, Family and Friends, Money Matters and Prosperity, and Health and Healing. Transform your life with The Spell Book for New Witches--made for the everyday witch.

The Spell Book for New Witches

384c2404-8504-4ffd-9037-f1990cc4635e-1

Monica Sweeney

A Journal for Leaving Your Bullsh*t Behind and Creating a Happy Life

A sweary guided journal for people who want to cut through the bullsh*t to unf*ck their lives without all the touchy-feely self-help crap, This book shows people how to stop dwelling on past hurts and move on toward the bright future ahead.

Let That Sh*t Go

2894a63d-6b97-4a5b-98f5-e98b813acc73-1

Lee Crutchley

Oliver Burkeman

A Creative Workbook

Author and illustrator Lee Crutchley brings his lively interactive approach to a little-discussed but very common issue: the struggle with depression and anxiety. Through a series of supportive, surprising, and engaging prompts, HOW TO BE HAPPY (OR AT LEAST LESS SAD) helps readers see things in a new light, and rediscover simple pleasures and everyday joy…or at least feel a little less sad. By turns a workbook, trusted friend, creative outlet, security blanket, and secret diary, the pages of this book will offer solace, distraction, engagement, a fresh perspective, and hopeful new beginnings—for readers of all ages and walks of life.

How to Be Happy (or at Least Less Sad)

ea48ee73-d91d-450b-99c7-f9d0934f9b86-1

Mike Duke

The Yuletide Butcher

5f8d2e32-a45b-4317-b03e-98de9a95a6a7-0

T. J. Klune

Paperback (1 to 2 lbs)

Lambda Literary Award-winning author TJ Klune’s bestselling, breakout contemporary fantasy that's "1984 meets The Umbrella Academy with a pinch of Douglas Adams thrown in." (Gail Carriger) A USA Today Bestseller! An Indie Next Pick! One of Publishers Weekly's "Most Anticipated Books of Spring 2020" One of Book Riot’s “20 Must-Read Feel-Good Fantasies” A magical island. A dangerous task. A burning secret. Linus Baker leads a quiet, solitary life. At forty, he lives in a tiny house with a devious cat and his old records. As a Case Worker at the Department in Charge Of Magical Youth, he spends his days overseeing the well-being of children in government-sanctioned orphanages. When Linus is unexpectedly summoned by Extremely Upper Management he's given a curious and highly classified assignment: travel to Marsyas Island Orphanage, where six dangerous children reside: a gnome, a sprite, a wyvern, an unidentifiable green blob, a were-Pomeranian, and the Antichrist. Linus must set aside his fears and determine whether or not they’re likely to bring about the end of days. But the children aren’t the only secret the island keeps. Their caretaker is the charming and enigmatic Arthur Parnassus, who will do anything to keep his wards safe. As Arthur and Linus grow closer, long-held secrets are exposed, and Linus must make a choice: destroy a home or watch the world burn. An enchanting story, masterfully told, The House in the Cerulean Sea is about the profound experience of discovering an unlikely family in an unexpected place—and realizing that family is yours.

The House in the Cerulean Sea

a079b311-0a84-4153-8352-509f83d34482-1

Brian Kirk

"Kirk's suspenseful and terror-driven novel employs supernatural elements to capitalize on the dread and horror of reality... [his] handling of visceral horror and human drama make for an immersive tale." - Publisher's Weekly


You don't read the book. It reads you.


Rumors of a deadly book have been floating around the dark corners of the deep web. A disturbing tale about a mysterious figure who preys on those who read the book and subjects them to a world of personalized terror.


Jesse Wheeler--former guitarist of the heavy metal group The Rising Dead--was quick to discount the ominous folklore associated with the book. It takes more than some urban legend to frighten him. Hell, reality is scary enough. Seven years ago his greatest responsibility was the nightly guitar solo. Then one night when Jesse was blackout drunk, he accidentally injured his son, leaving him permanently disabled. Dreams of being a rock star died when he destroyed his son's future. Now he cuts radio jingles and fights to stay clean.


But Jesse is wrong. The legend is real--and tonight he will become the protagonist in an elaborate scheme specifically tailored to prey on his fears and resurrect the ghosts from his past.


Jesse is not the only one in danger, however. By reading the book, you have volunteered to participate in the author's deadly game, with every page drawing you closer to your own personalized nightmare. The real horror doesn't begin until you reach the end.


That's when the evil comes for you.


FLAME TREE PRESSis the new fiction imprint of Flame Tree Publishing. Launching in 2018 the list brings together brilliant new authors and the more established; the award winners, and exciting, original voices.

Will Haunt You

e614a0b1-7b8a-4ad0-ba73-7e01812d844a-1

Kate Atkinson

A Novel

"One of the best novels I've read this century. Kate Atkinson is a marvel. There aren't enough breathless adjectives to describe LIFE AFTER LIFE: Dazzling, witty, moving, joyful, mournful, profound."--Gillian Flynn, author of Gone Girl What if you could live again and again, until you got it right? On a cold and snowy night in 1910, Ursula Todd is born, the third child of a wealthy English banker and his wife. She dies before she can draw her first breath. On that same cold and snowy night, Ursula Todd is born, lets out a lusty wail, and embarks upon a life that will be, to say the least, unusual. For as she grows, she also dies, repeatedly, in any number of ways. Ursula's world is in turmoil, facing the unspeakable evil of the two greatest wars in history. What power and force can one woman exert over the fate of civilization -- if only she has the chance? Wildly inventive, darkly comic, startlingly poignant -- this is Kate Atkinson at her absolute best.

Life after Life

5c8703b7-5bcf-4165-a7f2-35e8cc5432ac-1

Santa Muerte Claus

Carlton Mellick Iii

"Tick and Polly have never met their parents before. They live in the same house with them, they dream about them every night, they share the same flesh and blood, yet for some reason their parents have never found the time to visit them even once since they were born. Living in a dark corner of their parents' vast crumbling mansion, the children long for the day when they will finally be held in their mother's loving arms for the first time... But that day seems to never come. They worry their parents have long since forgotten about them. When the machines that provide them with food and water stop functioning, the children are forced to venture out of the nursery to find their parents on their own. But the rest of the house is much larger and stranger than they ever could have imagined. The maze-like hallways are dark and seem to go on forever, deranged creatures lurk in every shadow, and the bodies of long-dead children litter the abandoned storerooms. Every minute out of the nursery is a constant battle for survival. And the deeper into the house they go, the more they must unravel the mysteries surrounding their past and the world they've grown up in, if they ever hope to meet the parents they've always longed to see."--Page 4 of cover.

Quicksand House

fe12e70f-37cf-4777-9389-2d78c56f3a07-1

Jock

Scott Snyder

Everything you thought you knew about witches is wrong. They are much darker, and they are much more horrifying. Wytches takes the mythology of witches to a far creepier, bone-chilling place than readers have dared venture before. When the Rooks family moves to the remote town of Litchfield, NH to escape a haunting trauma, they're hopeful about starting over. But something evil is waiting for them in the woods just beyond town. Watching from the trees. Ancient...and hungry. Collects Wytches #1-6. SPECIAL LOW INTRODUCTORY PRICE OF $9.99!

Wytches Volume 1

badec6d2-8c0b-4b0c-9c26-83e368edda48-1

Dan Watters

Caspar Wijngaard

In the summer of 1994, a haunted house walks across California. Inside is Ami, lead-singer of a high school punk band- who's been missing for weeks. How did she get there? What do these ghosts want? And does this mean the band have to break up? Expect three chord songs and big bloody action as Power Rangers meets The Shining (yes really), and as writer DAN WATTERS (Lucifer/COFFIN BOUND) and artist CASPAR WIJNGAARD (Star Wars/Peter Cannon: Thunderbolt) delve into the horrors of misspent youth.

Home Sick Pilots, Volume 1

488da035-34cb-47bb-94bf-78376c594bce-1

Kieron Gillen

Jamie McKelvie

Every ninety years, twelve gods are incarnated into humans to enjoy a limited two-year lifespan, this time appearing as pop stars, and college student Laura finds herself in her midst as one of the gods is set up for murder.

Faust Act

f6acb6fe-9051-44c6-8678-c290d7d56d05-1

Mikaela Bee

Jillian loves being a stay at home mom. But when her son starts kindergarten, she realizes quickly how lonely she is. Things start to look up when she befriends the mysterious Madison, who seems to conveniently enter her life at just the right time. The two women immediately bond, and Madison invites Jillian and her husband for a peaceful, adults-only weekend away at her boyfriend's lake house. They find a sitter for their son, pack their bags, and head to the Adirondacks. The lake house is on a private, secluded island. It all seems perfect until someone ends up dead. And if someone screams in the middle of a lake, with no one else around, do they even make a sound?

The Lake House

e865e9c0-e193-4819-abab-359d20d29949-1

Fredrik Backman

Taken hostage by a failed bank robber while attending an open house, eight anxiety-prone strangers--including a redemption-seeking bank director, two couples who would fix their marriages, and a plucky octogenarian--discover their unexpected common traits.

Anxious People

c47822a6-42e9-4a60-93ce-ac3d6c26ead5-1

Carrie Ryan

Through twists and turns of fate, orphaned Mary seeks knowledge of life, love, and what lies beyond her walled village and the surrounding forest, where dwell the Unconsecrated, aggressive flesh-eating people who were once dead.

The Forest of Hands and Teeth

30e6f488-ef27-47a4-9075-8659aabc1755-1

Joyce Carol Oates

"A collection of psychologically daring, suspenseful stories"--

The Doll-Master and Other Tales of Terror

a0fffc22-8be3-45e2-b37a-3ea4e9f88cfa-1

Chuck Palahniuk

Assigned to a story on Sudden Infant Death Syndrome, fortyish journalist Carl Streator finds a poetry anthology that contains an African chant that becomes lethal when spoken or thought in someone's direction, is transformed into an involuntary serial killer, and embarks on a cross-country odyssey to destroy all copies of the book before humankind itself is destroyed. Reprint. 175,000 first printing.

Lullaby

d97898df-034a-4148-9a9c-a32a36e7322f-1

When a freeway "accident" leaves a beautiful fashion model disfigured and incapable of speech, she seeks to reinvent herself and her world, along with her new friend, Brandy Alexander, a transvestite who is one operation away from becoming a real woman

Invisible Monsters

a7244939-da55-4cfe-9b76-45fa463d3189-1

Laurell K. Hamilton

An Anita Blake, Vampire Hunter Novel

In her tenth adventure, nothing can save vampire hunter Anita Blake from a twist of fate that draws her ever closer to the brink of humanity.

Narcissus in Chains

ca8769cc-923f-4876-b780-c4e364bb4ab7-1

Craig DiLouie

From the macabre mind of a Bram Stoker Award-nominated author, this heart-pounding novel of horror and psychological suspense takes a ghost hunting reality TV crew into a world they could never have imagined.



Fade to Black is the newest hit ghost hunting reality TV show. Led by husband and wife team Matt and Claire Kirklin, it delivers weekly hauntings investigated by a dedicated team of ghost hunting experts.



Episode Thirteen takes them to every ghost hunter's holy grail: the Paranormal Research Foundation. This brooding, derelict mansion holds secrets and clues about bizarre experiments that took place there in the 1970s. It's also famously haunted, and the team hopes their scientific techniques and high tech gear will prove it. But as the house begins to reveal itself to them, proof of an afterlife might not be everything Matt dreamed of. A story told in broken pieces, in tapes, journals, and correspondence, this is the story of Episode Thirteen--and how everything went terribly, horribly wrong.



"An epistolary descent into a living nightmare . . . well-written and genuinely unsettling. Fans of paranormal documentaries, ghost-hunting shows, and found-footage horror will lose their minds over this one." --Kealan Patrick Burke, Bram Stoker Award winning author of Kin



"A beautiful Russian doll of a story... Episode Thirteen hooks you, creeps you out, and then it overwhelms you. It's House of Leaves meets Haunting of Hill House, in all the best possible ways."--Peter Clines, NYT bestselling author of The Broken Room



For more from Craig DiLouie, check out:

The Children of Red Peak

Our War

One of Us

Episode Thirteen

eff87eb8-123d-42b4-b0c8-c29d8d48b549-1

Juliet Rose

Nothing happens in a small town. At least, that's what Wes and his friends think when a building erected and is just a boring sew shop. A place for old ladies to make quilts and complain about the youth of the town like always. That's until Wes and his friend Clare discover a strange symbol on the floor or the shop and later the four friends see the old people holding a strange ceremony conjuring up entities. They quickly discover the sew shop isn't what it seems and they must decide if it is up to them to stop the destructive happenings which could affect them all.

Browse by categories

Ben Forta

Sams Teach Yourself SQL in 10 Minutes

Susan Scott

SM Fierce Conversations

Chris Kyle; Scott McEwen; Jim DeFelice

American Sniper

Ambrosia Hawthorn

The Spell Book for New Witches

Monica Sweeney

Let That Sh*t Go

Lee Crutchley; Oliver Burkeman

How to Be Happy (or at Least Less Sad)

Mike Duke

The Yuletide Butcher

T. J. Klune

The House in the Cerulean Sea

Brian Kirk

Will Haunt You

Kate Atkinson

Life after Life

R.J. Benetti

Santa Muerte Claus

Carlton Mellick Iii

Quicksand House

Jock; Scott Snyder

Wytches Volume 1

Dan Watters; Caspar Wijngaard

Home Sick Pilots, Volume 1

Kieron Gillen; Jamie McKelvie

Faust Act

Mikaela Bee

The Lake House

Fredrik Backman

Anxious People

Carrie Ryan

The Forest of Hands and Teeth

Joyce Carol Oates

The Doll-Master and Other Tales of Terror

Chuck Palahniuk

Lullaby

Chuck Palahniuk

Invisible Monsters

Laurell K. Hamilton

Narcissus in Chains

Craig DiLouie

Episode Thirteen

Juliet Rose

Stitched Together

Get The App