If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite. The updated edition describes how these database management systems implement SQL syntax for both querying and making changes to a database. You'll find details on data types and conversions, regular expression syntax, window functions, pivoting and unpivoting, and more. Quickly look up how to perform specific tasks using SQL Apply the book's syntax examples to your own queries Update SQL queries to work in five different database management systems NEW: Connect Python and R to a relational database NEW: Look up frequently asked SQL questions in the "How Do I?" chapter The book's example SQL statements execute against a set of tables, with data that you can quickly download.

SQL Pocket Guide, 4th Edition

Data is at the center of many challenges in system design today. Difficult issues need to be figured out, such as scalability, consistency, reliability, efficiency, and maintainability. In addition, we have an overwhelming variety of tools, including relational databases, NoSQL datastores, stream or batch processors, and message brokers. What are the right choices for your application? How do you make sense of all these buzzwords? In this practical and comprehensive guide, author Martin Kleppmann helps you navigate this diverse landscape by examining the pros and cons of various technologies for processing and storing data. Software keeps changing, but the fundamental principles remain the same. With this book, software engineers and architects will learn how to apply those ideas in practice, and how to make full use of data in modern applications. Peer under the hood of the systems you already use, and learn how to use and operate them more effectively Make informed decisions by identifying the strengths and weaknesses of different tools Navigate the trade-offs around consistency, scalability, fault tolerance, and complexity Understand the distributed systems research upon which modern databases are built Peek behind the scenes of major online services, and learn from their architectures

Designing Data-Intensive Applications

AN INSTANT NEW YORK TIMES BESTSELLER The founder and CEO of AppSumo.com, Noah Kagan, knows how to launch a seven-figure business in a single weekend—and he’s done it seven times. Million Dollar Weekend will show you how. Now is the best time in history for entrepreneurship. More than ever, the world needs new businesses and it’s cheaper than ever to create them. And, let’s be frank: most day jobs suck. People spend too much time doing too much work for too little money—and they know it. They want out. But, if the barriers to starting a business are getting lower and lower, why is it SO HARD TO DO for SO MANY PEOPLE? Why are there so many wantrepreneurs playing at business on social media and so few entrepreneurs actually running them? Ask yourself: Do you want to work for yourself, or start a side-hustle, but it all feels too risky and unpredictable? Have you spent time or money on things like websites and logos, but still have no customers? Are you brainstorming endlessly and waiting for the perfect idea to strike? All those Frequent Excuses are solvable. The plan is simple—so simple it can be completed in a single weekend, but so powerful that Kagan has used it to build seven businesses now worth more than $1 million: Find your Creator’s Courage to overcome your fear and have fun! Use the "Million Dollar Weekend" Process to get customers EXCITED to give you money. Automate your business so it can grow while you sleep. By Monday, you’ll have a market-tested, scalable business idea and you’ll be a entrepreneur on the path to seven figures. Million Dollar Weekend is the path to creating your dream life and attaining financial freedom. LFG.

Million Dollar Weekend

USA Today Bestseller National Bestseller "Like going to business school and therapy all in one book." —James Clear, New York Times Bestselling Author, Atomic Habits Once a barista in a small cafe making $6.50 an hour, Andrew Wilkinson built a business valued at over a billion dollars by the time he was 36—and yet, his path to success was anything but a straight line. In Never Enough, Wilkinson pulls back the curtain on the lives of the ultra-rich, sharing insights into building a successful business that has been called a “Berkshire Hathaway, but for internetcompanies,” and a surprising first-person account of what it’s actually like to become a billionaire. Never Enough features both the lessons Wilkinson has learned as well as the many mistakes made on the road to wealth—some of which cost him money, happiness, and important relationships. Taking a “no secrets” approach to stories the wealthy rarely reveal, Wilkinson is unwaveringly honest about some of the unexpected downsides of money: its toxic effect on personal relationships, how the lifestyles of the rich and famous aren’t all they’re cracked up to be, and how competition with peers leaves everyone—even billionaires—feeling like they never have enough. In this book, you’ll discover: A candid glimpse into the lives of the super-rich and what truly matters beyond money Insights on building a successful business from the ground up Lessons learned from the mistakes made on the journey to his fortune The surprising realities of life as a billionaire and the challenges that come with extreme wealth In this rare and deeply honest account, Wilkinson examines his journey to nine zeros, what came after that pinnacled number, and the essential things money can’t buy.

Never Enough

Revised and Updated, Featuring a New Case Study How do successful companies create products people can’t put down? Why do some products capture widespread attention while others flop? What makes us engage with certain products out of sheer habit? Is there a pattern underlying how technologies hook us? Nir Eyal answers these questions (and many more) by explaining the Hook Model—a four-step process embedded into the products of many successful companies to subtly encourage customer behavior. Through consecutive “hook cycles,” these products reach their ultimate goal of bringing users back again and again without depending on costly advertising or aggressive messaging. Hooked is based on Eyal’s years of research, consulting, and practical experience. He wrote the book he wished had been available to him as a start-up founder—not abstract theory, but a how-to guide for building better products. Hooked is written for product managers, designers, marketers, start-up founders, and anyone who seeks to understand how products influence our behavior. Eyal provides readers with: • Practical insights to create user habits that stick. • Actionable steps for building products people love. • Fascinating examples from the iPhone to Twitter, Pinterest to the Bible App, and many other habit-forming products.

Raul Cano

Full Stack Developer ✦ Indiehacker ✦ Runner ✦