Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL's roots and underlying logic. Next, it walks you through core topics such as single-table queries, joins, subqueries, table expressions, and set operators. Then the book covers more-advanced data-query topics such as window functions, pivoting, and grouping sets. The book also explains how to modify data, work with temporal tables, and handle transactions, and provides an overview of programmable objects. Microsoft Data Platform MVP Itzik Ben-Gan shows you how to: Review core SQL concepts and its mathematical roots Create tables and enforce data integrity Perform effective single-table queries by using the SELECT statement Query multiple tables by using joins, subqueries, table expressions, and set operators Use advanced query techniques such as window functions, pivoting, and grouping sets Insert, update, delete, and merge data Use transactions in a concurrent environment Get started with programmable objects-from variables and batches to user-defined functions, stored procedures, triggers, and dynamic SQL

    A must-read for anyone who wants to win at social.” - Jonah Berger (NYT Bestselling author of Contagious: Why Things Catch On) ***Discover how to get the right type of people to talk about you.*** ARE YOU SHARING GREAT WORK, but it seems nobody is listening? Does it seem like you’re at the mercy of social networks’ mysterious algorithms? Do you feel like it is an insurmountable task to understand and leverage social media? In Viralnomics: How to Get People to Want to Talk About You, Jonathan Goodman shows you how to appeal to people’s desires and get them to share your message as an extension of themselves. In this engaging, entertaining, and educational quick read you will discover: Methods to ethically persuade on social media. (pg 105) How to identify and befriend the real influencers (they aren’t who you think they are). (pg 23) A concept buried deep in psychological research that holds the secret to purposeful social sharing. (pg 53) The two keys to creating true power with Internet marketing. (pg 65) How to craft your messages and build your networks. (pg 115) If you desire to use social media marketing to get your product, service, or small business out to the right audience you don’t need to understand what buttons to push, you need to understand and appeal to the people pushing them. This book will help. Don't delay, scroll up and buy your copy today!

    By now it’s clear that whether you’re promoting a business, a product, or yourself, social media is near the top of what will determine your success or failure. And there are countless pundits, authors, and consultants eager to advise you.   But there’s no one quite like Guy Kawasaki, the legendary former chief evangelist for Apple and one of the pioneers of business blogging, tweeting, facebooking, tumbling, and much, much more. Now Guy has teamed up with his Canva colleague Peg Fitzpatrick to offer The Art of Social Media – the one essential guide you need to get the most bang for your time, effort, and money.   With more than 100 practical tips, tricks, and insights, Guy and Peg present a ground-up strategy to produce a focused, thorough, and compelling presence on the most popular social-media platforms. They guide you through the steps of building your foundation, amassing your digital assets, going to market, optimizing your profile, attracting more followers, and effectively integrating social media and blogging.   For beginners overwhelmed by too many choices, as well as seasoned professionals eager to improve their game, The Art of Social Media is full of tactics that have been proven to work in the real world. Or as Guy puts it, “Great Stuff, No Fluff.” http://artof.social/

    Aaron Goldman has written an essential book that goes beyond telling us how Google became so important to explaining why the revolution it's leading will affect everyone in media and marketing." --Brian Morrissey, Digital Editor, Adweek"An insightful tour of the elements that have made Google successful combined with a usable guide on how to apply this learning to your business." --Rishad Tobaccowala, Chief Strategy & Innovation Officer, VivakiAbout the BookYou know you've hit it big when your name becomes a verb--and no one knows that better than Google. In just over 10 years, Google has become the world's most valuable brand, consistently dominating its category and generating $6 billion in revenue per quarter.How does Google do it? In a word: marketing.You may not think Google does much marketing. Indeed, it doesn't do a lot of what has traditionally been viewed as marketing. But in today's digital world, marketing has taken new shape--and Google is at the cutting edge.In Everything I Know about Marketing I Learned from Google, digital marketing expert Aaron Goldman offers 20 powerful lessons straight from Google's playbook. Taking you deep into the inner workings of the Googleplex (which are simpler than you think), Goldman provides the knowledge and tools you need to build and grow your brand (which is also simpler than you think).Along the way, he shows how Google's tactics are being used by a wide range of successful corporations, from Apple to Zappos. Key principles include:Tap into the Wisdom of Crowds: Get the signals you need directly from your customersKeep It Simple, Stupid: Craft messages people can grasp in a nanosecond and pass alongDon't Interrupt: Join the conversation-- but avoid disrupting itAct Like Content: Provide value, not sales pitchesTest Everything: Take no detail of your program for granted; you can always improveShow Off Your Assets: Distribute your brand everywhereThe beauty of it all is that these Googley lessons can be applied to every aspect of marketing, in organizations of any size. Whether you run a PR department in a multinational corporation or serve as the sole marketer in a small business, these tactics work.In its mission to "organize the world's information," Google has rewritten the book on marketing. Use Everything I Know about Marketing I Learned from Google to remake your own organization's marketing--and engage more customers than ever.

    It takes several years for that—more than a book and a couple of days of reading can promise.  But this gives you a plan for success before you even start. Think of it as a road map for your first 90 days!Now, you can start a solid blog with the potential to make money WITHOUT a $1,000+ blogging education! Here’s a snapshot of what’s packed into this how-to guide: Popular guru promises exposed! I expose the truth about popular revenue streams and why NOT ALL monetization options are right for you despite guru promises! The 2M (+1) strategy to help you hit your first $1K blogging. How to find YOUR unique angle, so you can stand out from the pack and attract the right kind of readers. The smartest ways to make critical website pages sticky—Make these pages shout out “YES, you’re in the right place!” and understand what you need and don’t need to include. Why some bloggers make the leap and others don’t. (It has everything to do with what they don’t do!) 3 MUST-ANSWER questions that will shape your blog’s journey. How to create a strategic blog launch plan and my answer to the question “How many posts do you need before launching?” (No more confusion or stress. Just an actionable plan for results.) AND MORE! Imagine knowing exactly what you need to focus on despite all the distractions pulling you in a million directions.Imagine if in a mere year you accomplish more than you ever thought possible, feel a sense of satisfaction, and actually make progress toward this larger vision of what you want your blog and business to do for you.You don't flinch, get panicky, or try different tactics hoping one sticks. You have a plan of action and every decision you make for your blog is calculated and intentional. That’s the power of the process and the promise behind The Blog Startup!Intrigued yet? Then scroll to the top and click or tap “Buy Now.”

    HARNESS THE POWER OF HOLLYWOOD STORYTELLING MAGIC Renowned Hollywood story expert Michael Hauge’s Six Step Success Story formula gives your potential clients and buyers the emotional experience of success—and will move them to take action.

    Even though relationships are fuzzy and intangible, they can be measured and managed-with powerful results.Measure What Matters explains simple, step-by-step procedures for measuring customers, social media reputation, influence and authority, the media, and other key constituencies.Based on hundreds of case studies about how organizations have used measurement to improve their reputations, strengthen their bottom lines, and improve efficiencies all around Learn how to collect the data that will help you better understand your competition, do strategic planning, understand key strengths and weaknesses, and better respond to customer preferences Author runs a successful blog and serves as a measurement consultant to companies such as Facebook, Southwest Airlines, Raytheon, and Allstate Don't draw conclusions or make key decisions based on guesswork. Instead, Measure What Matters and the difference will show in the most important measure: your bottom line.

    Yet, it’s also a challenging time, with much work to do and an ever-changing array of platforms, features, and networks to master—all on a tighter budget than before.Don’t get discouraged, get scrappy! Shattering the myth that only big brands can do big things, Get Scrappy will help you: Demystify digital marketing in a way that makes sense for your business Do more with less Build a strong brand with something to say Find inspiration in unexpected places Create relevant and engaging content and promote it via Twitter, Facebook, and other channels Integrate strategy and message across touchpoints for a unified brand experience—both online and off Spark dialogue with your community of customers Measure what matters The result is a reliable, repeatable system for reinventing your marketing as marketing reinvents itself. Featuring frameworks, hacks, tips, idea starters, and more, Get Scrappy is the map you need to take your marketing from good to great.

    And Harry J.Friedman is very good at it. Someone once said, "Harry is the kind of guy who would sell someone a kickstand and then a $3,000 bicycle to go on top of it. "What makes him and his bookon retail selling so unique is his uncanny ability to turn shoppers into buyers, and teach others how to do the same. "No Thanks, I'm Just Looking" will give you the inside scoop on how to skyrocket your career with a system of practical money-making steps that are easy to learn and fun to use. No theoretical mumbojumbo oroutdated 1940s methodologies.Unlike most sales trainers who are obsessed with handling objections and tricky closing techniques, Harryconcentrates more on "front-end selling." He'll show you how to get past customer resistance - that "I don't like you and I don't trust you" defensive shield thatcustomers are seemingly born with. And he'll show you how to probe more effectively so you can find outexactly what your customers want so that all you have to do is deliver it. The essence of front-end selling is having your customers say "I'11 take it" before you everhave to ask "Will you buy it?"The fun really begins, however, when you learn his unique version of the trial close - how to routinely add on additional merchandise, while you're closing thesale on the main item. This will put you in control of the sale and set you up for the final step which will reduce returns, build referrals and increase your repeat business.This book will save you countless hours of trial and error experience and allow you to focus on the things that really work. It will become your retail bible as you read it over and over. And each time you do,you'll turn up another batch of gems that just keep making you money.

    Nobody gets tapped with a magic wand and suddenly has the ability to produce art, music, photos, films, or writing—they just do it. And you probably should too. Make It Till You Make It breaks down 40 myths and truths about the pursuit of creative expression, whether you want to make $0 a year doing your thing or $100,000 a year.

    People don't listen to advertisements, they listen to their peers. But why do people talk about certain products and ideas more than others? Why are some stories and rumors more infectious? And what makes online content go viral? Wharton marketing professor Jonah Berger has spent the last decade answering these questions. He's studied why New York Times articles make the paper's own Most E-mailed List, why products get word of mouth, and how social influence shapes everything from the cars we buy to the clothes we wear to the names we give our children. In this book, Berger reveals the secret science behind word-of-mouth and social transmission. Discover how six basic principles drive all sorts of things to become contagious, from consumer products and policy initiatives to workplace rumors and YouTube videos.Contagious combines groundbreaking research with powerful stories. Learn how a luxury steakhouse found popularity through the lowly cheese-steak, why anti-drug commercials might have actually increased drug use, and why more than 200 million consumers shared a video about one of the seemingly most boring products there is: a blender. If you've wondered why certain stories get shared, e-mails get forwarded, or videos go viral, Contagious explains why, and shows how to leverage these concepts to craft contagious content. This book provides a set of specific, actionable techniques for helping information spread - for designing messages, advertisements, and information that people will share. Whether you're a manager at a big company, a small business owner trying to boost awareness, a politician running for office, or a health official trying to get the word out, Contagious will show you how to make your product or idea catch on.

    As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting.

    Engaging with your followers and fans, listening to what they have to say, and producing consistently great content are the true markers of successful social media marketing today. Pinterest gives business users the opportunities to do all three in visually stunning, engaging ways. But business owners need help in knowing how to use Pinterest effectively for marketing purposes. "Pinfluence" will show business owners, entrepreneurs, online merchants and bloggers how to use Pinterest to drive traffic to their websites, connect with their potential and current clients, and convert their followers into buyers using this exciting new platform."Pinfluence" will be accessible and easy to read, with action steps that readers can implement right away. Readers will learn how to: Set up your professional Pinterest profile for maximum business exposure, so when your pins go viral, they send a flood of massive, targeted traffic to your website or blog. Develop a targeted Pinterest strategy for your business so you can increase your online exposure, bring in more income and avoid wasting time doing tasks that doesn't get you more leads or fansQuickly and easily start growing your audience, engage with your followers, and collect tons of business leadsConvert followers into buyersGet Pinterest marketing help for special types of situations, like business-to-business companies and nonprofits

    TheCult of the Luxury Brand illuminates the mysterious inner workings of Asia’s love affair with luxury for business professionals and intrigued consumers alike.

    He solidified his standing as the nation's foremost political forecaster with his near perfect prediction of the 2012 election. Silver is the founder and editor in chief of FiveThirtyEight.com. Drawing on his own groundbreaking work, Silver examines the world of prediction, investigating how we can distinguish a true signal from a universe of noisy data. Most predictions fail, often at great cost to society, because most of us have a poor understanding of probability and uncertainty. Both experts and laypeople mistake more confident predictions for more accurate ones. But overconfidence is often the reason for failure. If our appreciation of uncertainty improves, our predictions can get better too. This is the "prediction paradox": The more humility we have about our ability to make predictions, the more successful we can be in planning for the future.In keeping with his own aim to seek truth from data, Silver visits the most successful forecasters in a range of areas, from hurricanes to baseball, from the poker table to the stock market, from Capitol Hill to the NBA. He explains and evaluates how these forecasters think and what bonds they share. What lies behind their success? Are they good-or just lucky? What patterns have they unraveled? And are their forecasts really right? He explores unanticipated commonalities and exposes unexpected juxtapositions. And sometimes, it is not so much how good a prediction is in an absolute sense that matters but how good it is relative to the competition. In other cases, prediction is still a very rudimentary-and dangerous-science.Silver observes that the most accurate forecasters tend to have a superior command of probability, and they tend to be both humble and hardworking. They distinguish the predictable from the unpredictable, and they notice a thousand little details that lead them closer to the truth. Because of their appreciation of probability, they can distinguish the signal from the noise.