With SQL and this task-based guide to it, you can do it too—no programming experience required!After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily launches into the tasks that will get you comfortable with SQL fast. In addition to explaining SQL basics, this updated reference covers the ANSI SQL:2003 standard and contains a wealth of brand-new information, including a new chapter on set operations and common tasks, well-placed optimization tips to make your queries run fast, sidebars on advanced topics, and added IBM DB2 coverage.Best of all, the book's examples were tested on the latest versions of Microsoft Access, Microsoft SQL Server, Oracle, IBM DB2, MySQL, and PostgreSQL. On the companion Web site, you can download the SQL scripts and sample database for all these systems and put your knowledge to work immediately on a real database..

     Once one of Silicon Valley’s greatest success stories, Facebook has been under constant fire for the past five years, roiled by controversies and crises. It turns out that while the tech giant was connecting the world, they were also mishandling users’ data, spreading fake news, and amplifying dangerous, polarizing hate speech. The company, many said, had simply lost its way. But the truth is far more complex. Leadership decisions enabled, and then attempted to deflect attention from, the crises. Time after time, Facebook’s engineers were instructed to create tools that encouraged people to spend as much time on the platform as possible, even as those same tools boosted inflammatory rhetoric, conspiracy theories, and partisan filter bubbles. And while consumers and lawmakers focused their outrage on privacy breaches and misinformation, Facebook solidified its role as the world’s most voracious data-mining machine, posting record profits, and shoring up its dominance via aggressive lobbying efforts. Drawing on their unrivaled sources, Sheera Frenkel and Cecilia Kang take readers inside the complex court politics, alliances and rivalries within the company to shine a light on the fatal cracks in the architecture of the tech behemoth. Their explosive, exclusive reporting led them to a shocking conclusion: The missteps of the last five years were not an anomaly but an inevitability—this is how Facebook was built to perform. In a period of great upheaval, growth has remained the one constant under the leadership of Mark Zuckerberg and Sheryl Sandberg. Both have been held up as archetypes of uniquely 21st century executives—he the tech “boy genius” turned billionaire, she the ultimate woman in business, an inspiration to millions through her books and speeches. But sealed off in tight circles of advisers and hobbled by their own ambition and hubris, each has stood by as their technology is coopted by hate-mongers, criminals and corrupt political regimes across the globe, with devastating consequences. In An Ugly Truth, they are at last held accountable.

    Not wanting to face a court martial for being gay, he had to live in a world where he had to watch everything he did and said for fear of being outed; and in another world where he was free to be himself. "One of the hardest things for me to reconcile was the fact that I was completely open with my family and friends but faced the very real possibility of being court martialed and going to jail if I was open with my 'work' colleagues." As Reichen explains, "The don't ask don't tell policy is so contradictory to what the Air Force and all the armed forces stand for ... but they force you to lie in order to serve your country." It was the contradictions which led Reichen to leave the Air Force once he completed his commitment. Happenstance brought Reichen to meet a friend at a Los Angeles restaurant where he was approached by the casting director for "The Amazing Race." Reichen believes his military training was extremely helpful in his winning the show's million dollar prize.

    A shot rang out, and the Redcoats replied with a devastating volley.But the day that started so well for the king's troops would end in catastrophe: seventy-three British soldiers dead, two hundred wounded, and the survivors chased back into Boston by the angry colonists. Drawing on diaries, letters, official documents, and memoirs, William H. Hallahan vividly captures the drama of those tense twenty-four hours and shows how they decided the fate of two nations.

    Fifteen years later, his Minnesota company had created over 500 American jobs and developed more than 50 new medical devices that saved and improved lives. But in 2011, the federal government threatened to destroy his company and put Howard behind bars for years. Why? Federal prosecutors had been sold a bill of goods – a tall tale peddled by a money-hungry ex-employee out for revenge. All over one device. A device that never harmed a single patient and made up less than 1% of the company s sales. The investigation revealed the charges to be baseless, but the scalp-hunting prosecutors didn't back off. Instead they dug in – threatening witnesses, misleading grand juries, and strategically leaking secret documents. Whatever it took to pressure a headline-grabbing settlement. Howard Root stood up to the shakedown. Five years, 121 attorneys and $25 million in legal fees later, his life's work and freedom rested in the hands of 12 strangers in a San Antonio jury room. Would Howard and his company be vindicated by the verdict, or had he made the biggest mistake of his life by challenging the federal government? Cardiac Arrest is the eye-opening true story of life on the Feds' hit-list, told from the desk of a CEO who decided to fight back. Follow Howard from the boardroom to the courtroom, as he tells the inside story of the case that sparked outrage in the pages of The Wall Street Journal and triggered a congressional investigation.

    Carter's unpopularity helped Republicans win seats in the House and gain control over the Senate for the first time in over 20 years. The Reagan Era had begun, ushering in a generation of conservative power. Democrats blamed Carter for this catastrophe and spent the next decade pretending he had never existed. Republicans cheered his demise and trotted out his name to scare voters for years to come. Carter and his wife Rosalynn returned to their farm in the small town of Plains, Georgia. They were humiliated, widely unpopular, and even in financial debt. 35 years later, Carter has become the most celebrated post-president in American history. He has won the Nobel Peace Prize, written bestselling books, and become lauded across the world for his efforts on behalf of peace and social justice. Ex-presidents now adopt the Carter model of leveraging their eminent status to benefit humanity. By pursuing diplomatic missions, leading missions to end poverty and working to eradicate disease around the world, Carter has transformed the idea of what a president can accomplish after leaving the White House.This is the story of how Jimmy Carter lost the biggest political prize on earth--but managed to win back something much greater. Jordan Michael Smith is a contributing writer at Salon and the Christian Science Monitor. His writing has appeared in print or online for the New York Times Magazine, Washington Post, The Atlantic, Slate, BBC, and many other publications. Born in Toronto, he holds a Master's of Arts in Political Science from Carleton University. He lives in New York City. www.jordanmichaelsmith.typepad.com.Cover design by Adil Dara.

    Robert J. Darling organizes President Bush's trip to Florida on Sept. 10, 2001, he believes the next couple of days will be quiet. He has no idea that a war is about to begin. The next day, after terrorists crash airliners into the World Trade Center towers and the Pentagon, Maj. Darling rushes to the president's underground chamber at the White House. There, he takes on the task of liaison between the vice president, national security advisor and the Pentagon. He works directly with the National Command Authority, and he's in the room when Vice President Cheney orders two fighter jets to get airborne in order to shoot down United Flight 93. Throughout the attacks, Maj. Darling witnesses the unprecedented actions that leaders are taking to defend America. As Vice President Cheney, Secretary of State Condoleezza Rice, and others make decisions at a lightning pace with little or no deliberation, he's there to lend his support. Follow Darling's story as he becomes a Marine Corps aviator and rises through the ranks to play an incredible role in responding to a crisis that changed the world in 9-11-01: The White House: Twenty-Four Hours inside the President's Bunker.