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..

    In the tradition of Manning's ground breaking "In Action" series, this book comes from right from the source. Written by Bruce Payette, one of principal creators of PowerShell, Windows PowerShell in Action shows you how to build scripts and utilities to automate system tasks or create powerful system management tools to handle the day-to-day tasks that drive a Windows administrator's life. Because it's based on the .NET platform, PowerShell is also a powerful tool for developers and power users.Windows PowerShell in Action was written by Bruce Payette, one of the founding members of the Windows PowerShell team, co-designer of the PowerShell language and the principal author of the PowerShell language implementation. The book enables you to get the most out of the PowerShell environment. Using many examples, both small and large, this book illustrates the features of the language and environment and shows how to compose those features into solutions, quickly and effectively.This book is designed for anyone who wants to learn PowerShell and use it well. Rather than simply being a book of recipes to read and apply, this book gives you the deep knowledge about how PowerShell works and how to apply it.

    But what was once fantasy is now reality. With a growing glut of good used boats on the market, its possible to sail around the world in a boat that costs less than a car. In this fascinating book, well-known boating author John Vigor turns the spotlight on 20 seaworthy sailboats that are at home on the ocean. These are old fiberglass boats, mostly of traditional design and strong construction. All are small their sizes range from 20 feet to 32 feet overall but all have crossed oceans. Many have circumnavigated the world. And all are inexpensive. There are many hundreds of small cruising boats sailing the seven seas at this moment. They explore everywhere, from the ice-bound shores of Antarctica to the high latitudes of the Northern Hemisphere. Most, however, ply the tradewind routes where flying fish play. The water is warm, and coconut trees line calm lagoons bounded by beaches of pure white sand. But choosing the right boat to cross an ocean or go around the world can be a confusing and exasperating experience, particularly if your budget is tight. Its well-nigh impossible to find objective comparisons. Vigor sets out to remedy that in this book. He compares the designs and handling characteristics of 20 different boats whose prices on the secondhand market start at about $3,000. Interviews with experienced owners (featuring valuable tips about handling each boat in heavy weather) are interspersed with line drawings of hulls, sailplans, and accommodations. Vigor has unearthed the known weaknesses of each boat and explains how to deal with them. He rates their comparative seaworthiness, their speed, and the number of people they can carry in comfort. If you have ever dreamed the dream, this is the book that will turn it into reality.

    

    As they helped grow Google from a young start-up to a global icon, they relearned everything they knew about management. How Google Works is the sum of those experiences distilled into a fun, easy-to-read primer on corporate culture, strategy, talent, decision-making, communication, innovation, and dealing with disruption.The authors explain how the confluence of three seismic changes - the internet, mobile, and cloud computing - has shifted the balance of power from companies to consumers. The companies that will thrive in this ever-changing landscape will be the ones that create superior products and attract a new breed of multifaceted employees whom the authors dub 'smart creatives'. The management maxims ('Consensus requires dissension', 'Exile knaves but fight for divas', 'Think 10X, not 10%') are illustrated with previously unreported anecdotes from Google's corporate history.'Back in 2010, Eric and I created an internal class for Google managers,' says Rosenberg. 'The class slides all read 'Google confidential' until an employee suggested we uphold the spirit of openness and share them with the world. This book codifies the recipe for our secret sauce: how Google innovates and how it empowers employees to succeed.'

    A collector of op-art ceramics, she was inspired to translate graphic optical illusions into knitted patterns for socks, replicating their eye-popping effects.Op-Art Socks contains 19 projects. Explore graphic colorwork, textured knitting (knit and purl), shadow knitting, and shifting ribbing to create optical illusions. The book includes black and white swatches of all patterns so that you can readily perceive the op-art illusions in each piece.Op-Art Socks is truly unique in theme and designs. Go beyond ordinary sock knitting into new territory!

    Includes expert coverage of new topics: Turbocodes, Turboequalization, Antenna Arrays, Digital Cellular Systems, and Iterative Detection. Convenient, sequential organization begins with a look at the historyo and classification of channel models and builds from there.

    In Stratosphere, Michael Fullan takes a close look at the fast-paced world of emerging technologies and argues that the inevitable influence of technology on teaching and learning must not be resisted, but rather embraced and applied in meaningful ways to positively impact school classrooms.

    Each

    You’ll cover all the basics, including precut options, standard quilt sizes and needle types. Plus, finish your quilt like a pro with yardage and cutting info for borders, backings, and bindings! Easy-to-use charts, tables, and illustrations are at your fingertips in this handy, spiral-bound guide that’s easy to take with you.

     Christopher McKinlay has been featured in Wired Magazine for his groundbreaking analysis of OkCupid. For the first time he’s showing non-experts how to turn Internet dating on its head. This concise guide will show anyone (straight, gay, male or female) the procedure McKinlay used to meet his fiancee and how the same ideas can transform their lives and bring them from browsing to contact. One summer evening while logged into a supercomputer in Colorado waiting for a large computation, McKinlay was killing time on OkC when he was troubled by a problem: what if large groups of people responded to OkCupid’s personality questionnaire in statistically similar ways? He created custom software to scrape data from the site, collecting over 6,000,000 answers to OkC’s “match questions” from more than 20,000 real users. This data made clear he’d been using the site the wrong way. Based on his findings, McKinlay (a mathematics PhD), optimized his own profile. The transformation was profound. He went from showing a “match percentage” of 90% with a few hundred women in the L.A. area to showing 90% or higher with over 30,000 local women. Unsolicited messages from attractive strangers began flooding his inbox. With a foreword by Jon Finkel, McKinlay’s insightful how-to will teach you how to benefit from the buried statistical patterns of online romance.

    Whenyou upgrade to Extra Class, you gain access to the entire Amateur Radio frequency spectrum. Ues this book to ace the top-level ham radio licensing exam. Our expert instruction will lead you through all of the knowledge you need to pass the exam: rules, specific operating skills and more advanced electronics theory.

    You can become a wildly successful coach on your own terms. It’s time to transcend the inner voice that screams, “Who the f*ck am I to do this work?!” It's time to stop hiding and step fully into the successful coach you are called to be. I’ve shown hundreds of warrior coaches how to serve clients, make a difference, and make a great living – all while staying true to themselves. I learned how to build an impactful and profitable coaching business without torturing myself or following someone else’s blueprint, and so can you. Your future clients are counting on you! In this book, you’ll learn: Why many new coaches fail to create a sustainable and profitable business. The inside-out approach to finding and enrolling clients who are dying to work with you. How to price your coaching in a way that is abundant, sustainable, and honorable. Why joy, inspiration, and grace are critical to your business strategy. How to step courageously into the coach you were born to be… right now!

      Photographed over the course of a year in her life in New York, Tennessee, India, and Sweden and organized by season, Jansdotter shares her sources of inspiration and how she and her friends mix and match her key pieces while working, play- ing, resting, and traveling. Lotta Jansdotter Everyday Style brings Jansdotter’s infectious and sought-after sense of style to new followers and longtime devotees alike.

    With Step By Step, you set the pace-building and practicing the skills you need, just when you need them! Topics include building a project plan and fine-tuning the details; scheduling tasks, assigning resources, and managing dependencies; monitoring progress and costs; keeping projects on track; communicating project data through Gantt charts and other views.