For SQL beginners, it's more important for a book to focus on general concepts and offer clear explanations and examples of what the various statements can accomplish. This is that beginner book. A number of features make The LANGUAGE OF SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading them. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to build on your prior understanding as you encounter new words and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, MySQL, and Oracle, with special "Database Differences" boxes that will show you any differences in the syntax among those three databases, as well as instructions on how to obtain and install free versions of the databases. This is the only book you'll need to gain a working knowledge of SQL and relational databases.

    In barely six years, a small group of young, ambitious programmers in Silicon Valley built an $11.5 billion business out of the ashes of a failed podcasting company. Today Twitter boasts more than 200 million active users and has affected business, politics, media, and other fields in innumerable ways. Now Nick Bilton of the New York Times takes readers behind the scenes with a narrative that shows what happened inside Twitter as it grew at exponential speeds. This is a tale of betrayed friendships and high-stakes power struggles as the four founders—Biz Stone, Evan Williams, Jack Dorsey, and Noah Glass—went from everyday engineers to wealthy celebrities, featured on magazine covers, Oprah, The Daily Show, and Time’s list of the world’s most influential people. Bilton’s exclusive access and exhaustive investigative reporting—drawing on hundreds of sources, documents, and internal e-mails—have enabled him to write an intimate portrait of fame, influence, and power. He also captures the zeitgeist and global influence of Twitter, which has been used to help overthrow governments in the Middle East and disrupt the very fabric of the way people communicate.

     If you're serious about starting a YouTube business and want to make money on YouTube, I can show you the way. I've doubled my monthly income by creating a YouTube channel. Thousands of people watch each video and I've built a community that supports and motivates me every day...and that's all in less than two years! Is it Too Late to Start a YouTube Business? I"ve been developing online businesses since 2012 but was late to the game on YouTube. By the time I started my YouTube channel, people were already saying, "YouTube is dead!"; People were saying you couldn"t grow on YouTube anymore and that small channels couldn't win in the YouTube algorithm. I'm living proof you CAN start a YouTube business and be successful. I average $3,500 a month on ads alone (June 2019) and another three- to four-thousand on sponsorships, affiliates and my own products. In fact, I believe we’re just coming into the Age of YouTube with the rollout of 5G and every business owner needs a video presence. A YouTube How-To from Someone that's Been There I've seen the frustration for small YouTubers, trying to compete and get views against the million-subscriber monsters. I know what it’s like to start a channel from nothing. I’ll not only show you how to set up your channel to look professional, I’ll reveal the secrets even some of the biggest YouTube creators don’t know. In this book, you'll learn: How to get YouTube video ideas and hack the most popular videos for viral success (Pg 49) Five steps to building a YouTube channel brand that creates an army of supporters (Pg 69) The easy way to record videos, even if you don't like to be on camera (Pg 85) Five income streams that guarantee you WILL make money on YouTube (Pg 135) Since starting my YouTube channel, I've consulted and helped other video influencers grow their channels for millions of views. I’ve helped them find sponsorships and make enough money to quit their day job to make YouTube a full-time business. I can do the same for you with this book. I can show you the way but YOU have to get started. Scroll back up and click Buy Now to create your YouTube business and start making money on YouTube.

    But what if you could have your computer do them for you?In "Automate the Boring Stuff with Python," you'll learn how to use Python to write programs that do in minutes what would take you hours to do by hand no prior programming experience required. Once you've mastered the basics of programming, you'll create Python programs that effortlessly perform useful and impressive feats of automation to: Search for text in a file or across multiple filesCreate, update, move, and rename files and foldersSearch the Web and download online contentUpdate and format data in Excel spreadsheets of any sizeSplit, merge, watermark, and encrypt PDFsSend reminder emails and text notificationsFill out online formsStep-by-step instructions walk you through each program, and practice projects at the end of each chapter challenge you to improve those programs and use your newfound skills to automate similar tasks.Don't spend your time doing work a well-trained monkey could do. Even if you've never written a line of code, you can make your computer do the grunt work. Learn how in "Automate the Boring Stuff with Python.""

    In the past decade, inexpensive but sophisticated navigation devices and mobile phones have led to alarming levels of overconfidence on the trail. Adding to this worrisome trend, the increasing popularity of ventures into mountainous terrain has led hikers seeking solitude--or an adrenaline rush--into increasingly remote or risky forays. Sandy Stott, the "Accidents" editor at the journal of the Appalachian Mountain Club, delivers both a history and a celebration of the search and rescue workers who save countless lives in the White Mountains--along with a plea for us not to take their steadfastness and bravery for granted. Filled with tales of astonishing courage and sobering tragedy, Critical Hours will appeal to outdoor enthusiasts and armchair adventurers alike.

    These visionary stories explore prediction science, quantum computing, real-time translation, machine learning, and much more. The authors used inside access to leading-edge work from Microsoft Research as inspiration, crafting pieces that predict the near-future of technology%mdash;and examine its complex relationship to our core humanity.Future Visions features contributions from: Elizabeth BearGreg BearDavid BrinNancy KressAnn LeckieJack McDevittSeanan McGuireRobert J. Sawyer…along with a short graphic novel by Blue Delliquanti and Michele Rosenthal, plus original illustrations by Joey Camacho.These are some of today’s most visionary creators—and they’ve joined together to give us a preview of tomorrow.

    Written by Peter Morville, author of the groundbreaking Information Architecture for the World Wide Web, the book defines our current age as a state of unlimited findability. In other words, anyone can find anything at any time. Complete navigability.Morville discusses the Internet, GIS, and other network technologies that are coming together to make unlimited findability possible. He explores how the melding of these innovations impacts society, since Web access is now a standard requirement for successful people and businesses. But before he does that, Morville looks back at the history of wayfinding and human evolution, suggesting that our fear of being lost has driven us to create maps, charts, and now, the mobile Internet.The book's central thesis is that information literacy, information architecture, and usability are all critical components of this new world order. Hand in hand with that is the contention that only by planning and designing the best possible software, devices, and Internet, will we be able to maintain this connectivity in the future. Morville's book is highlighted with full color illustrations and rich examples that bring his prose to life.Ambient Findability doesn't preach or pretend to know all the answers. Instead, it presents research, stories, and examples in support of its novel ideas. Are we truly at a critical point in our evolution where the quality of our digital networks will dictate how we behave as a species? Is findability indeed the primary key to a successful global marketplace in the 21st century and beyond. Peter Morville takes you on a thought-provoking tour of these memes and more -- ideas that will not only fascinate but will stir your creativity in practical ways that you can apply to your work immediately.

    An approachable guide to programming in SQL (Structured Query Language) that will teach even beginning programmers how to build powerful databases and analyze data to find meaningful information.Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language) written by longtime professional journalist Anthony DeBarros. SQL is the primary tool that programmers, web developers, researchers, journalists, and others use to explore data in a database. DeBarros focuses on using SQL to find the story in data, with the aid of the popular open-source database PostgreSQL and the pgAdmin interface.This thoroughly revised second edition includes a new chapter describing how to set up PostgreSQL and more extensive discussion of pgAdmin's best features. The author has also added a chapter on the JSON data format that shows readers how to store and query JSON data. DeBarros has also updated the data in the book throughout, added coverage of additional topics, and perfected the book's examples.Readers love DeBarros's use of exercises and real-world examples that demonstrate how to:- Create databases and related tables using your own data - Correctly define data typesAggregate, sort, and filter data to find patterns - Clean their data and transfer data as text files - Create advanced queries and automate tasksThis book uses PostgreSQL, but the SQL syntax is applicable to many database applications, including Microsoft SQL Server and MySQL.

    This may seem hard to accept, but, as Harari explains in his trademark style—thorough, yet riveting—famine, plague and war have been transformed from incomprehensible and uncontrollable forces of nature into manageable challenges. For the first time ever, more people die from eating too much than from eating too little; more people die from old age than from infectious diseases; and more people commit suicide than are killed by soldiers, terrorists and criminals put together. The average American is a thousand times more likely to die from binging at McDonalds than from being blown up by Al Qaeda.What then will replace famine, plague, and war at the top of the human agenda? As the self-made gods of planet earth, what destinies will we set ourselves, and which quests will we undertake? Homo Deus explores the projects, dreams and nightmares that will shape the twenty-first century—from overcoming death to creating artificial life. It asks the fundamental questions: Where do we go from here? And how will we protect this fragile world from our own destructive powers? This is the next stage of evolution. This is Homo Deus.With the same insight and clarity that made Sapiens an international hit and a New York Times bestseller, Harari maps out our future.

    Targets beginning to intermediate Excel users seeking real-world examples of how they can use Excel's powerful built-in functions Shows readers how to use Excel functions in formulas to help them decide between buying and leasing a car, calculate mortgage costs, compute grades, evaluate investment performance, figure college expenses, and more Gives explanations and examples of real-world situations Provides an abbreviated discussion of an additional 200 functions Excel commands nearly 90 percent of the market for spreadsheet applications; although this book is written for Excel 2003, the functions described are in earlier versions as well

    In the coming years, we will make decisions regarding our human spaceflight program that will lead to one of two familiar futures: the open universe of "Star Trek, "where we allow ourselves the opportunity to spread our wings and attempt to flourish as an interplanetary species--or the closed, dystopian, and ultimately self-destructive world of "Soylent Green." If we ever hope to live in the future that is the former scenario, our first stepping stone must be a manned mission to Mars. In this four-part e-special, Dr. Robert Zubrin details the challenges of a manned Earth-to-Mars mission. Challenges which, according to Zubrin, we are technologically more prepared to overcome than the obstacles of the missions to the moon of the sixties and seventies. Dr. Zubrin's relatively simple plan, called Mars Direct, could feasibly have humans on the surface of Mars within a decade. Zubrin also discusses the current predicament of NASA, the promise of privatized space flight from companies like SpaceX, and the larger implication behind the absolute necessity to open the final frontier to humanity--the human race's future as a species that takes the necessary baby steps away from the cradle that is planet Earth or, ultimately, perishes here.

    

    Along the way Stephen Baxter looks at our place in the universe, considers the possibility that we are in fact alone, and wonders whether that fact gives us the right to inherit everything. He also looks at how we might strive to overcome the limitations of the physical universe and win the deepest future. Stephen Baxter has brought his trademark narrative flair and imaginative brilliance to the latest ideas in physics and cosmology and produced a breathtaking guide to our possible futures.

    Even as they bring ease to our lives, these programs are stealing something essential from us.Drawing on psychological and neurological studies that underscore how tightly people’s happiness and satisfaction are tied to performing hard work in the real world, Carr reveals something we already suspect: shifting our attention to computer screens can leave us disengaged and discontented.From nineteenth-century textile mills to the cockpits of modern jets, from the frozen hunting grounds of Inuit tribes to the sterile landscapes of GPS maps, The Glass Cage explores the impact of automation from a deeply human perspective, examining the personal as well as the economic consequences of our growing dependence on computers.With a characteristic blend of history and philosophy, poetry and science, Carr takes us on a journey from the work and early theory of Adam Smith and Alfred North Whitehead to the latest research into human attention, memory, and happiness, culminating in a moving meditation on how we can use technology to expand the human experience.

    He was a celebrity during the height of America’s Gilded Age. In this book, you will read about his friendship with Mark Twain, his furious competition with his former employer Thomas Edison, his uneasy relationship with billionaire J.P. Morgan, and his rivalry with Albert Einstein. During his lifetime, Tesla revolutionized the field of electrical engineering with his most famous invention: the induction motor. But that wasn’t all he contributed to the world of technology. His coils, turbines, robotic boats, and mysterious “death ray” continue to beguile the imagination and inspire the inventors of the 21st century. But who was Tesla really? This book will take you from his early childhood in Croatia, where he experienced strange optical visions and “luminous phenomenon” that gave him near super-human powers of memory and visualization, to the “War of the Currents”, Thomas Edison’s bizarre campaign to ruin Tesla’s reputation. From trying to fight the Spanish American War with robots, to electrifying the skies of the Colorado desert, and to starting an earthquake in the middle of New York city, learn how Nikola Tesla shaped the world we live in today.