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.

     Plenty of experts argue that anyone who wants to develop a skill, play an instrument, or lead their field should start early, focus intensely, and rack up as many hours of deliberate practice as possible. If you dabble or delay, you'll never catch up to the people who got a head start. But a closer look at research on the world's top performers, from professional athletes to Nobel laureates, shows that early specialization is the exception, not the rule.David Epstein examined the world's most successful athletes, artists, musicians, inventors, forecasters and scientists. He discovered that in most fields--especially those that are complex and unpredictable--generalists, not specialists, are primed to excel. Generalists often find their path late, and they juggle many interests rather than focusing on one. They're also more creative, more agile, and able to make connections their more specialized peers can't see.Provocative, rigorous, and engrossing, Range makes a compelling case for actively cultivating inefficiency. Failing a test is the best way to learn. Frequent quitters end up with the most fulfilling careers. The most impactful inventors cross domains rather than deepening their knowledge in a single area. As experts silo themselves further while computers master more of the skills once reserved for highly focused humans, people who think broadly and embrace diverse experiences and perspectives will increasingly thrive.

    But a few years ago, he realized that while some of the habits he outlined in What Got You Here apply to both men and women, women face specific, and different, challenges as they seek to advance in their careers.So he partnered with his longtime colleague, women’s leadership expert Sally Helgesen, to create this invaluable handbook for women trying to take the next step in their careers. They realized that for women in particular, the very skills and habits that made them successful early in their careers could actually be holding them back as they advance to the next stage of their working lives. Women in particular struggle with habits like:1. Reluctance to Claim Your Achievements2. Expecting Others to Spontaneously Notice and Reward Your Hard Work3. Overvaluing Expertise4. Building Rather than Leveraging Relationships5. Failing to Enlist Allies from Day One6. Putting Your Job Before Your Career7. The Disease to Please8. The Perfection Trap9. Minimizing10. Too Much11. Ruminating12. Letting Your Radar Distract YouLike the original What Got You Here, this new book will help women identify specific behaviors that keep them from realizing their full potential, no matter what stage they are in their career. It will also help them identify why what worked for them in the past will not necessarily get them where they want to go in the future–and how to finally shed those behaviors so they can advance to the next level, whatever that may be.

    These are intelligent, well-meaning answers but they are also completely wrong. More valuable than money, human resources, and intellectual property, Passion Capital is what separates leaders from followers, and innovators from imitators. It is the foundation upon which all other forms of capital are built. Passion is an emotion, but Passion Capital is tangible. It is the energy, intensity, and sustainability leaders use to build lasting value and competitive advantage. Organizations that possess Passion Capital – Apple, Johnson & Johnson, Four Seasons Hotels, the Montreal Canadiens, among others – lead their sectors, while those that rely on established forms of capital may get stuck in neutral and fail to achieve their full potential.Passion Capital presents seven principles for growing and investing in this new asset class and includes over fifty insightful stories drawn from business, not-for-profit, the arts sector, and politics.  In this groundbreaking book, veteran business leader Paul Alofs ushers in a whole new way of thinking about the very definition of success and reveals how to acquire the world’s most valuable asset and apply it to your career, company, or cause.

    We need a fresh understanding of the meaning of success. What do Condoleezza Rice, Joe Torre, Bill Gates, Goldie Hawn, Mary Hart, Garry Kasparov, and Jack Welch have in common? All have talked at length with Maria Bartiromo about business, the world and their surprising, inspiring and uncommon ideas about the meaning of success. Their stories, those of an extraordinary range of other people from all walks of life, and Maria Bartiromo’s personal insights are the foundation of The 10 Laws of Enduring Success. It is the guide for the extraordinary times we are living through.  During bullish, optimistic periods, people seem to ride an upward wave with ease and confidence. The tangible evidence is right there for all to see--in their jobs, bank accounts, homes, families, and the admiration of their peers. But it is a fact of life that success, once earned, is not necessarily there to stay. If ever there was a cautionary tale about the fleeting nature of success, it is the events of recent years.     But a funny thing happened. Faced with gut-wrenching realities, many people have started to re-evaluate the meaning of success in less superficial and impermanent ways. They're asking themselves hard questions that havelong been ignored:  about what's really important to them, and where the bedrock of their personal achievement lies.     As Maria Bartiromo watched the financial drama from her front-row seat at the New York Stock Exchange, she began to re-assess the meaning of success--not just as one-off achievements, but as a durable, lifelong pursuit. Is there, she wondered, a definition of success that you can have permanently--in spite of the turmoil in your life, your job, or your bank account? This question is more important than ever, given the unpredictability of the current economy. --What are the intangibles that can't be measured or counted? --What are the qualities that aren't reflected in your title or on your business card?--And more practically, how can you remain successful even when the worst things happen to you? --Is it possible to build success from failure? It's lonely at the bottom of the heap, when your BlackBerry stops buzzing, and the world moves on without you.  Everyone wants to be close to success, and to have success. But what is success? How do you get it, and how do you keep it? As Maria interviewed some of the most successful people in the world, she felt the need to answer these questions: what makes these success stories tick? How did they achieve such leadership and power and how can one hold onto it, once you get it. What are the barriers to success and what is the bedrock to enduring success? From the Hardcover edition.

    You know there's something missing from your marriage and you have a feeling what's missing is you, but you can't bear to rock that comfortable old boat. You're stuck. And, as bestselling author Judith Sills would say, you know the horse is dead. Get off! We all have our comfort zones'your coffee bar, your preference for half hazelnut/half decaf very light no sugar, your seat on the 8:24, your same old fight over the holidays with your parents' and, indeed, they're what make life possible. But the time comes when your comfort zone isn't so comfortable anymore, when it's keeping you from having a happier, more meaningful, and fulfilling life. If the Horse Is Dead, Get Off! is for anyone whose life has temporarily run aground, whether you're stuck in a dead-end relationship, in a soul-killing job, or when your life just seems to have become one long summer rerun. The rewards for escaping your comfort zone are enormous. And Sills, who has helped thousands with her sage advice, dispensed in her signature go-get-em style has come up with a brilliant, excuse-busting seven-step plan that points a clear, inspiring way out.

    Gelb identified seven aspects of Da Vinci's genius that contemporary readers can emulate and apply in their own lives. Now, in WORK LIKE DA VINCI, Gelb adapts these principles to the specific demands of the workplace, sharing the innovative solutions to contemporary corporate and career challenges that have kept him in constant demand as a top-tier speaker and consultant to Fortune 500 clients. In Gelb's expert perspective, Da Vinci's genius can be distilled into seven principles for the business listener: Ask the right questions (Curiosit�) Put your answers to work (Dimostrazione) Develop your business senses (Sensazione) Turn uncertainty into opportunity (Sfumato) Strike a profitable balance (Arte/Scienza) Integrate for success (Corporalit�) Make the break-through connection (Connessione) These principles will help you tackle such timeless business challenges as: leadership; innovation; teamwork; strategic planning; decision-making; managing change and uncertainty; giving powerful presentations; giving and receiving feedback; and more.

    Nikki Goldstein's fresh and fun approach to dating and relationships will instill readers with a new level of confidence, positivity and excitement as they traverse the modern dating landscape.The intersection of real world and digital world situations experienced by today's dater can be confusing and overwhelming. In Single But Dating, Australia's most in-demand sexologist and relationship expert, Dr. Nikki Goldstein, dispenses invaluable advice on how to tackle a broad variety of relevant topics like how to let go of outdated beliefs around what it means to be single, how to become technosexually savvy, how to know if you are overtexting, when to enact a man-ban and how to deal with new dating phenomena like ghosting.Statistics show that women are staying single longer than ever before, prioritizing their professional and financial power over their domestic and reproductive power. That's what makes Single But Dating so timely - it is a crucial guide book for any woman navigating the (sometimes frustrating) dating world full of new rules and distractions. With a surprising mix of some time-tested oldies but goodies, thought-provoking exercises and fresh, forward-looking advice, Dr. Nikki equips single-but-dating women with the tools they need to learn to love both themselves and the wild ride of 21st century dating.

    Most leaders need reminding everyday that with their privileges comes responsibility and obligation. If any young man or woman seeking to become a leader and not a manager only reads one book on leadership, let it be this one!

    However, many people have had trouble bringing the book's message into their own career and company. Now, along with two of his colleagues, Peter Docker and David Mead, he has created a guide to the most important step any business can take: finding your why. This easy-to-follow guide starts with the search for your personal why, and then expands to helping your colleagues find your organization's why. With detailed instructions on every stage in the process, the book also answer common concerns, such as: What if my why sounds like my competitor's? Can you have more than one why? And, if my work doesn't match my why, what do I do? Whether you're entry level or a CEO, whether your team is run by the founder or a recent hire, these simple steps will lead you on a path to a more fulfilling life and longterm success for you and your colleagues.

     You're told that if you "do what you love, you'll never work a day in your life." Whether it's working for "exposure" and "experience," or enduring poor treatment in the name of "being part of the family," all employees are pushed to make sacrifices for the privilege of being able to do what we love.In Work Won't Love You Back, Sarah Jaffe, a preeminent voice on labor, inequality, and social movements, examines this "labor of love" myth -- the idea that certain work is not really work, and therefore should be done out of passion instead of pay. Told through the lives and experiences of workers in various industries -- from the unpaid intern, to the overworked nurse, to the nonprofit worker and even the professional athlete -- Jaffe reveals how all of us have been tricked into buying into a new tyranny of work. As Jaffe argues, understanding the trap of the labor of love will empower us to work less and demand what our work is worth. And once freed from those binds, we can finally figure out what actually gives us joy, pleasure, and satisfaction.

    Thomas Frank, founder of the College Info Geek blog, YouTube channel, and podcast, breaks these ways down into ten steps in this short book.You'll learn how to learn more effectively in your classes, take better notes, remember more from textbook readings, cut down on procrastination, build an optimal study environment, and more.Along the way, you'll find techniques for increasing your study and work efficiency, giving you more free time in college as well.

    Triggers shows us how to break that cycle and enact meaningful change.In Triggers, renown executive coach and psychologist Marshall Goldsmith discusses the emotional triggers that set off a reaction or a behavior in us that often works to our detriment. Do you find that at times you suddenly become defensive or enraged by an idle comment from a colleague? Or that your temper rises when another car cuts you off in traffic? Your reactions don’t occur in a vacuum. They are the result of emotional and psychological triggers that often happen only in specific settings—at meetings, or in competitive situations, or with a specific person who rubs you the wrong way, or when you feel under particular pressure. Being able to recognize those triggers and understand how the environment affects our behavior is key to controlling our responses and managing others at work and in life. Make no mistake—change is hard. And the starting point is the willingness to accept help, and the desire to change. This book will show you how.Over the course of this book, Marshall explores the power of active questions to get us to take responsibility for our actions—and our failure to act. Questions such as “Did I do my best to make progress toward my goal?” “Did I work hard at being fully engaged?” He discusses the importance of structure in effecting permanent change. Because, he points out, change is hard, and without a structure to keep us on track, we inevitably relapse and fall back.Filled with illuminating stories from Marshall’s work with some of the most accomplished executives and leaders in America, Triggers shows readers how to achieve meaningful and sustained change that will allow us to open our imaginations and escape the rigidity of binary thinking.

    Later, as you're about to get back to work, a colleague taps you on the shoulder to chat. At home, screens get in the way of quality time with your family. Another day goes by, and once again, your most important personal and professional goals are put on hold.  What would be possible if you followed through on your best intentions? What could you accomplish if you could stay focused and overcome distractions? What if you had the power to become "indistractable"?  International best-selling author, former Stanford lecturer, and behavioral design expert, Nir Eyal, wrote Silicon Valley's handbook for making technology habit-forming. Five years after publishing Hooked, Eyal reveals distraction's Achilles' heel in his groundbreaking new book.  In Indistractable, Eyal reveals the hidden psychology driving us to distraction. He describes why solving the problem is not as simple as swearing off our devices: Abstinence is impractical and often makes us want more.  Eyal lays bare the secret of finally doing what you say you will do with a four-step, research-backed model. Indistractable reveals the key to getting the best out of technology, without letting it get the best of us.  Inside, Eyal overturns conventional wisdom and reveals: Why distraction at work is a symptom of a dysfunctional company culture - and how to fix it  What really drives human behavior and why "time management is pain management"  Why your relationships (and your sex life) depend on you becoming indistractable  How to raise indistractable children in an increasingly distracting world Empowering and optimistic, Indistractable provides practical, novel techniques to control your time and attention - helping you live the life you really want.

    Great leaders don't buy it. Great leaders lead with or without the authority and learn to unleash their influence wherever they are.With practical wisdom and humor, Clay Scroggins will help you nurture your vision and cultivate influence, even when you lack authority in your organization. And he will free you to become the great leader you want to be so you can make a difference right where you are. Even when you're not in charge.