Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch.The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You'll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well.Other recipes in the book teach you to:Access data from multiple tables at the same time Use SQL to select, sort, and summarize rows Find matches or mismatches between rows in two tables Determine intervals between dates or times, including age calculations Store images into MySQL and retrieve them for display in web pages Get LOAD DATA to read your data files properly or find which values in the file are invalid Use strict mode to prevent entry of bad data into your database Copy a table or a database to another server Generate sequence numbers to use as unique row identifiers Create database events that execute according to a schedule And a lot moreMySQL Cookbook doesn't attempt to develop full-fledged, complex applications. Instead, it's intended to assist you in developing applications yourself by helping you get past problems that have you stumped.

    If you're a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases.Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you'll also discover how to efficiently design and manage databases to meet your needs.You'll also learn how to:Explore relational databases, including lightweight and centralized modelsUse SQLite and SQLiteStudio to create lightweight databases in minutesQuery and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BYJoin tables to get a more complete view of your business dataBuild your own tables and centralized databases by using normalized design principlesManage data by learning how to INSERT, DELETE, and UPDATE records

    You'll learn the tricks for fixing common problems, retouching secrets, how to colour correct any photo, and a whole chapter is dedicated to Photoshop special effects.

    As you d expect, there s accurate, clearly written coverage of every exam objective (now including Service Pack 1): installation and configuration; user, group, and computer accounts; filesystems and backup/recovery; hardware, disk storage, and printers; Update Services and licensing; monitoring, and more. The content s been extensively revamped and more effectively focused on the exam s objectives. There s also a large Prepare for the Test section packed with questions, answers, testing skills, and suggested practices. You ll find more case studies, more troubleshooting scenarios, electronic practice testing in practically any form your heart desires, and (if you don t have Windows Server handy) a 120-day evaluation version. There s even a 15% discount coupon for your exam -- making this package an even more compelling proposition. Bill Camarda, from the June 2006 href="http://www.barnesandnoble.com/newslet... Only

    The first female CEO of one of Australia's big four banks, listed by Forbes in 2010 as the 8th most powerful woman in the world, and mother of four (including triplets), Gail is celebrated as one of our finest, most innovative thinkers on leadership and workplace culture.In these personal, practical chapters, Gail Kelly shares what she's learned over her remarkable career, drawing from her personal and professional life. As a leader, she argues passionately for the importance of putting people and customers at the heart of a business; of leading with courage and generosity of spirit; and of resilience. Some of those lessons were learnt at times of high pressure, and Gail takes us into her thinking as she led Westpac through the global financial crisis and the merger with St. George.But Gail's voice speaks to each of us, whatever our role in life. She explores the absolute importance of loving what you do; learning to learn; backing yourself; and most importantly, placing your family above all things.At the heart of Gail's refreshing, authentic, integrated approach is how both individuals and companies thrive when they openly address the meaning of what they do, and understand the need to live a whole life. Live, Lead, Learn is the inspiring story of one of the world's most prominent business people, who started as a Latin teacher and became mother of four and CEO of Westpac - and everything she has learned along the way.

    With no prior knowledge of game development or 3D required, you will learn from scratch, taking each concept at a time working up to a full 3D mini-game. You'll learn scripting with C# or JavaScript and master the Unity development environment with easy-to-follow stepwise tasks. If you're a designer or animator who wishes to take their first steps into game development or prototyping, or if you've simply spent many hours sitting in front of video games, with ideas bubbling away in the back of your mind, Unity and this book should be your starting point. No prior knowledge of game production is required, inviting you to simply bring with you a passion for making great games.

    A tall, lean striker with the world at his feet, Ferguson seemed destined to develop into one of Scotland's most successful exports, but anger, and a number of injuries, hampered his progress. Ferguson has scored the most goals of any Scot in the Premiership but also shares the record for Premiership red cards. In 1995, he became the first professional footballer to be jailed for an offence committed on the pitch. It earned him a three-month sentence in Glasgow's infamous Barlinnie Prison and a twelve-match ban from the SFA. Bruised by the experience, he walked away from the Scotland team and blanked the media from then on. Featuring contributions from numerous top players, this explosive biography uncovers the real Duncan Ferguson. The author delves into Ferguson's personal and professional life and reveals that there is more to him than the media portrayal of a Scottish hard man.

    We are in an era where entire businesses are built on Instagram; kids in their bedrooms are racking up tens of millions of YouTube views; bloggers are becoming millionaires from their kitchen tables, and businesses are getting more attention from a viral video than a Super Bowl ad. But in a space that moves so fast, how can businesses keep up - let alone compete? And how do you make sure that your activity is profitable? Whether it’s building a targeted fanbase, selling more of your products & services or serving customers, every piece of your social media marketing campaign should be making you money. Combining the ‘holy grail’ marketing principles from some of history’s most successful marketers with the very latest social media strategies gives savvy businesses of all size a chance to ‘do’ social media in an entirely new way. Gone are the days of fumbling around in the dark. The new era is about testing, measuring and profit. From the psychological triggers that make us buy; employing social proof to stand out; using (and faking) controversy to sell more or just simply demonstrating your true competitive advantage, profitable social media marketing is here. As Head Ninja at Exposure Ninja, Tim Cameron-Kitchen has personally worked with hundreds of businesses of all shapes and sizes, and seen first hand how doing the right things on social media can transform a business. Yvonne Ivanescu came to Exposure Ninja from one of the world’s highest profile marketing agencies, and brought her brand experience to help business on the front line. This book is the distillation of everything that makes a profitable campaign, laid out in step-by-step instructions for you to follow and apply to your own business - whatever your size or market. So whether you’re a local plumber looking to pick up leads from Twitter, or an independent e-commerce site wanting the attention of influential bloggers, the strategies and profitable shortcuts for entrepreneur-run businesses in this book will give you a chance to compete in competitive markets where time and budget is of the essence.

    Ankur Warikoo is an entrepreneur and content creator whose witty and brutally honest thoughts on success and failure, money and investing, self-awareness and personal relationships have made him one of India’s top personal brands.In his first book, Ankur puts together the key ideas that have fuelled his journey.This is a book to be read, and reread, a book you will give your family and friends and strangers.

    Python is a beautiful computer language. It is simple, and it is intuitive. Python is used by a sorts of people – data scientists use it for much of their number crunching and analytics; security testers use it for testing out security and IT attacks; it is used to develop high-quality web applications and many of the large applications that you use on the internet are also written in Python, including YouTube, DropBox, and Instagram. Are you interested in learning Python? Then settle in and learn the basics in just 7 days - enough for you to be comfortable in moving on to the next level without any trouble.Are you interested in learning Python? Then settle in and learn the basics in just 7 days - enough for you to be comfortable in moving on to the next level without any trouble. In this book you'll learn: Setting Up Your Environment Let’s Get Programming Variables and Programs in Files Loops, Loops and More Loops Functions Dictionaries, Lists, and Tuples The “for” Loop Classes Modules File Input/Output Error Handling and much more! Now it's time for you to start your journey into Python programming! Click on the Buy Now button above and get started today!

    THIS BOOK has been written to cover BOTH the current ("2nd generation") Kindle Fire HD, AND the earlier ("1st Generation") Kindle Fire HD.<br><br></h2><br><br><h2>"Fantastic..." "Great Help..." "Easy for a non-geek to understand." -Actual reviewer comments for Kindle Fire HD Tips, Tricks, and Traps: A How-To Tutorial for the Kindle Fire HD</h2><br><i><br>"Fantastic! I searched and searched for a source to help me better understand my new Kindle. I was about to give up and then I found this book. I have discovered so many tips and tricks! I am enjoying my Kindle so much more!"<br><br>"Easy for a non-geek to understand. Thanks for writing a book that I can understand. Very basic guide to the kindle fire that is easy to follow and makes it easy to implement any suggestions offered. The directions given matched what is actually on my kindle fire. I have read a couple of books that were supposedly updated for late 2012 or for January 2013 that gave instructions for actions on my kindle fire that didn't match what I see on my device bough in December 2012. This is hugely frustrating to a tech novice. This book told me exactly where to go and what to do."<br><br>"Great help. This was a big help with my first venture in tablet land. A lot of good ideas. A must read for any kindle user."<br></i><br><br>So, you've got a Kindle Fire as a gift, or perhaps you bit the purchase bullet on your own because you wanted this impressive tablet. Do you want to get the most out of your new Kindle Fire HD? If you are looking for a top-notch tutorial at a reasonable cost, you've come to the right place! Here is the book that will teach you 100% of what you need to know. <b>Kindle Fire HD Tips, Tricks, and Traps: A How-To Tutorial for the Kindle Fire HD</b> is your detailed guide to getting the maximum benefit from your Kindle Fire HD.<br>In this comprehensive guide, you'll learn tips (ways to effectively use your Kindle Fire), tricks (ways to improve the operation of your Kindle Fire), and traps (things to avoid to prevent problems while using your Kindle Fire). You will learn-<br><br>• How to get around within the user interface, the home screen, and the carousel more efficiently<br><br>• How to make your Kindle Fire your own, customizing its display and operation for fastest and easiest use<br><br>• How to find THOUSANDS of FREE books, as well as movies and songs, for your Kindle Fire<br><br>• How to setup the security options to protect your account information<br><br>• How you can move your iTunes or other music library to your Kindle Fire<br><br>• How you can download YouTube videos to your Kindle Fire<br><br>* How to use the built-in camera and the new camera app provided by Amazon in a late 2012 software update<br><br>• Suggested apps that no Kindle Fire owner should be without<br><br>You will learn all of the above and more, with Kindle Fire Tips, Tricks, and Traps: A How-To Tutorial for the Kindle Fire HD as a part of your library.

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

    It matters WHY you do it. “What’s good, if brief, is twice as good.” – Baltasar Gracian Don't you hate it when you've always wanted to read a book but never able to quite find the time? Or do you just want to extract the key ideas of a book without having to spend weeks and months reading through it all? Fret not! Welcome to Top Line Summaries, brought to you by BrevityBooks Publishing - encapsulating the core concepts, big ideas and best bits from all your favourite business and leadership, personal development and self-help bestselling books. In an age where personal time is more limited than ever, our core belief is that ‘being brief is best.’ Whether in business or at home, Topline Summaries will get you on the express road to success! The latest book to get the infamous 'Topline Summary Treatment' is Simon Sinek's groundbreaking book, Start with Why. “The more organizations and people who learn to start with WHY, the more people there will be who wake up being fulfilled by the work they do.” – Simon Sinek, Start with Why Have you ever wondered why some companies fail, others do average, and some - the rare few – become huge success stories? Why is it that some leaders never achieve greatness and others motivate millions? What sets apart the mundane from the masterful, the indifferent from the inspirational? Simon Sinek encapsulated the answers to all of these questions in his groundbreaking book Start with Why, following on from his hugely popular and now legendary TED talk. We have extracted the best and most pertinent parts of the book and here it now is, available just a short read away!

    Xamarin.Forms lets you write shared user-interface code in C# and XAML that maps to native controls on these three platforms.

    Learn Java Programming Fast with a unique Hands-On Project. Book 4 of the Learn Coding Fast Series. Covers Java 8. Have you always wanted to learn computer programming but are afraid it'll be too difficult for you? Or perhaps you know other programming languages but are interested in learning the Java language fast? This book is for you. You no longer have to waste your time and money trying to learn Java from boring books that are 600 pages long, expensive online courses or complicated Java tutorials that just leave you more confused and frustrated. What this book offers... Java for Beginners Complex concepts are broken down into simple steps to ensure that you can easily master the Java language even if you have never coded before. Carefully Chosen Java Examples Examples are carefully chosen to illustrate all concepts. In addition, the output for all examples are provided immediately so you do not have to wait till you have access to your computer to test the examples. Careful selection of topics Topics are carefully selected to give you a broad exposure to Java, while not overwhelming you with information overload. These topics include object-oriented programming concepts, error handling techniques, file handling techniques and more. In addition, new features in Java (such as lambda expressions and default methods etc) are also covered so that you are always up to date with the latest advancement in the Java language. Learn The Java Programming Language Fast Concepts are presented in a "to-the-point" style to cater to the busy individual. You no longer have to endure boring and lengthy Java textbooks that simply puts you to sleep. With this book, you can learn Java fast and start coding immediately. How is this book different... The best way to learn Java is by doing. This book includes a unique project at the end of the book that requires the application of all the concepts taught previously. Working through the project will not only give you an immense sense of achievement, it’ll also help you retain the knowledge and master the language. Are you ready to dip your toes into the exciting world of Java coding? This book is for you. Click the BUY button and download it now. What you'll learn: Introduction to Java - What is Java? - What software do you need to code Java programs? - How to install and run JDK and Netbeans? Data types and Operators - What are the eight primitive types in Java? - What are arrays and lists? - How to format Java strings - What is a primitive type vs reference type? - What are the common Java operators? Object Oriented Programming - What is object oriented programming? - How to write your own classes - What are fields, methods and constructors? - What is encapsulation, inheritance and polymorphism? - What is an abstract class and interface? Controlling the Flow of a Program - What are condition statements? - How to use control flow statements in Java - How to handle errors and exceptions - How to throw your own exception