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

    When users can browse the Web on a three-inch phone screen as easily as on a fifty-inch HDTV, what's a developer to do?Peter Gasston's The Modern Web will guide you through the latest and most important tools of device-agnostic web development, including HTML5, CSS3, and JavaScript. His plain-English explanations and practical examples emphasize the techniques, principles, and practices that you'll need to easily transcend individual browser quirks and stay relevant as these technologies are updated.Learn how to:Plan your content so that it displays fluidly across multiple devices Design websites to interact with devices using the most up-to-date APIs, including Geolocation, Orientation, and Web Storage Incorporate cross-platform audio and video without using troublesome plug-ins Make images and graphics scalable on high-resolution devices with SVG Use powerful HTML5 elements to design better formsTurn outdated websites into flexible, user-friendly ones that take full advantage of the unique capabilities of any device or browser. With the help of The Modern Web, you'll be ready to navigate the front lines of device-independent development.

    Peter Flach's clear, example-based approach begins by discussing how a spam filter works, which gives an immediate introduction to machine learning in action, with a minimum of technical fuss. Flach provides case studies of increasing complexity and variety with well-chosen examples and illustrations throughout. He covers a wide range of logical, geometric and statistical models and state-of-the-art topics such as matrix factorisation and ROC analysis. Particular attention is paid to the central role played by features. The use of established terminology is balanced with the introduction of new and useful concepts, and summaries of relevant background material are provided with pointers for revision if necessary. These features ensure Machine Learning will set a new standard as an introductory textbook.

    

    His books have been read by over 1,000,000 people and are #1 best-sellers. His book Beginning Ubuntu Linux recently entered its sixth edition, and picked-up a Linux Journal award along the way. Thomas is also the author of Ubuntu Kung Fu. * * * * * * * * * * * * * * * * * Get to grips with the Ubuntu command-line with this #1 best-selling and concise guide. "Best buck I've spent yet" — Amazon review.* Readable, accessible and easy to understand;* Learn essential Ubuntu vocational skills, or read just for fun;* Covers Ubuntu commands, syntax, the filesystem, plus advanced techniques;* For ANY version of Linux based on Debian, such as Linux Mint--not just Ubuntu!;* Includes BONUS introduction to Ubuntu chapter, plus a glossary appendix and a guide to reading Linux/Unix documentation.

    In this acclaimed reference work, Martin covers everything from the core aspects of working in Photoshop to advanced techniques for professional results. Subjects covered include organizing a digital workflow, improving creativity, output, automating Photoshop, and using Camera RAW. The style of the book is extremely clear, with real examples, diagrams, illustrations, and step-by-step explanations supporting the text throughout. This is, quite simply, the essential reference for photographers of all levels using Photoshop. All DVD content is now available online at http://booksite.focalpress.com/compan... for kindle and eBook readers. * Learn Photoshop the Martin Evening way! Everything you need to know for superb photographic results using Photoshop CS5 * Accompanying DVD includes the images used in the book, as well as QuickTime movie tutorials that show you how to get results fast * Packed with diagrams, step-by-steps, and over 750 color images

    Master the multitouch interface, send text messages, enjoy rich-HTML e-mail, use GPS maps, and more, with this full-color guide to show you how! Edward C. Baig and "Dr. Mac" Bob LeVitus, two giants of Mac-dom, have packed this colorful little book with tips on every cool feature of the iPhone 3G. They'll show you how to find and download hundreds of cool apps from the new Apps Store, sync up your contact lists with MobileMe, browse the Internet, take photos, download music, and much more. For example:Use 3G wireless technology to surf the Web faster, send and receive e-mail, and talk on the phone, all at once Play music, watch videos on the widescreen display, or download a game from the App Store Navigate Web sites or photos using tap, flick, and pinch Get turn-by-turn directions, view a map, get live traffic information, or find services near your location with the GPS feature Synchronize data, calendar entries, and address books between your desktop and your iPhone Snap, share, sync, and save photos See how the touch screen lets you type, surf, dial, download, play music, and more, all with a simple tap Use the new scientific calculator Find out what Microsoft Exchange has to offer You already love your iPhone. With iPhone For Dummies, 2nd Edition, you'll find more to love!

    Once you have thoroughly covered the basics, the book returns to each concept to cover more advanced examples and techniques. This book is for web designers who want to create interactive elements for their designs, and for developers who want to create the best user interface for their web applications. Basic JavaScript programming and knowledge of HTML and CSS is required. No knowledge of jQuery is assumed, nor is experience with any other JavaScript libraries.

    Despite it's name, unit testing is really a coding technique, not a testing technique. Unit testing is done by programmers, for programmers. It's primarily for our benefit: we get improved confidence in our code, better ability to make deadlines, less time spent in the debugger, and less time beating on the code to make it work correctly.This book shows how to write tests, but more importantly, it goes where other books fear to tread and gives you concrete advice and examples of what to test--the common things that go wrong in all of our programs. Discover the tricky hiding places where bugs breed, and how to catch them using the freely available JUnit framework. It's easy to learn how to think of all the things in your code that are likely to break. We'll show you how with helpful mnemonics, summarized in a handy tip sheet (also available from our pragmaticprogrammer.com website) to help you remember all this stuff.With this book you will:Write better code, and take less time to write it Discover the tricky places where bugs breed Learn how to think of all the things that could go wrong Test individual pieces of code without having to include the whole project Test effectively with the whole teamWe'll also cover how to use Mock Objects for testing, how to write high quality test code, and how to use unit testing to improve your design skills. We'll show you frequent "gotchas"--along with the fixes--to save you time when problems come up. We'll show you how with helpful mnemonics, summarized in a handy tip sheet (also available from our pragmaticprogrammer.com website).But the best part is that you don't need a sweeping mandate to change your whole team or your whole company. You don't need to adopt Extreme Programming or Test-Driven Development, or change your development process in order to reap the proven benefits of unit testing. You can start unit testing, the pragmatic way, right away.

    This book is indispensable for anyone who is serious about using jQuery for non-trivial applications." -- Raffaele Cecco, longtime developer of video games, including Cybernoid, Exolon, and StormlordjQuery is the "write less, do more" JavaScript library. Its powerful features and ease of use have made it the most popular client-side JavaScript framework for the Web. This book is jQuery's trusty companion: the definitive "read less, learn more" guide to the library.jQuery Pocket Reference explains everything you need to know about jQuery, completely and comprehensively. You'll learn how to:Select and manipulate document elementsAlter document structureHandle and trigger eventsCreate visual effects and animationsScript HTTP with Ajax utilitiesUse jQuery's selectors and selection methods, utilities, plugins and moreThe 25-page quick reference summarizes the library, listing all jQuery methods and functions, with signatures and descriptions.

    If you have read the Swift Programming Guide, and want to explore more, this book is for you.Swift is a great language for systems programming, but also lends itself for very high-level programming. We'll explore both high-level topics (for example, programming with generics and protocols), as well as low-level topics (for example, wrapping a C library and string internals).

    Written by the developer of the Ruby project Prawn, this concise book explains how to design beautiful APIs and domain-specific languages with Ruby, as well as how to work with functional programming ideas and techniques that can simplify your code and make you more productive. You'll learn how to write code that's readable, expressive, and much more.Ruby Best Practices will help you:Understand the secret powers unlocked by Ruby's code blocks Learn how to bend Ruby code without breaking it, such as mixing in modules on the fly Discover the ins and outs of testing and debugging, and how to design for testability Learn to write faster code by keeping things simple Develop strategies for text processing and file management, including regular expressions Understand how and why things can go wrong Reduce cultural barriers by leveraging Ruby's multilingual capabilities This book also offers you comprehensive chapters on driving code through tests, designing APIs, and project maintenance. Learn how to make the most of this rich, beautiful language with Ruby Best Practices.

    It is one of egos and money, where millions of dollars are won and lost every day and phones are routinely thrown across hectic trading desks. This palpable excitement has led to the explosion of the retail FX market, which has unfortunately spawned a new breed of authors and gurus more than happy to provide misleading and often downright fraudulent information by promising traders riches while making forex trading 'easy'. Well I'll let you in on a little secret: there is nothing easy about trading currencies. If you don't believe me then stop by Warren Buffet's office and ask him how he could lose $850m betting on the dollar or ask George Soros why his short yen bets cost him $600m not once but twice in 1994. What's wrong with these guys, don't they read FX books? In reality, the average client's trading approach combined with the unscrupulous practices of some brokers make spot FX trading more akin to the games found on the Vegas strip than to anything seen on Wall St. The FX market is littered with the remains of day traders and genius 'systems, ' and to survive in the long-run traders have to realize that they are playing a game where the cards are clearly stacked against them. Have you ever had your stop hit at a price that turned out to be the low/high for the day? Bad luck perhaps? Maybe. What if it happens more than once? Do you ever feel like the market is out to get you? Well guess what, in this Zero Sum game it absolutely is. Covering the day-to-day mechanics of the FX market and the unsavoury dealings going on, Beat the Forex Dealer offers traders the market-proven trading techniques needed to side-step dealer traps and develop winning trading methods. Learn from an industry insider the truth behind dirty dealer practices including: stop-hunting, price shading, trading against clients and 'no dealing desk' realities. Detailing the dealer-inspired trading techniques developed by MIGFX Inc, consistently ranked among the world's leading currency trading firms, the book helps turn average traders into winning traders; and in a market with a 90% loss rate winning traders are in fact quite rare! More than just a simple manual, Beat the Forex Dealer brings to life the excitement of the FX market by delivering insights into some of the greatest trading triumphs and highlighting legendary disasters; all written in an easy to read style. Make no mistake about it there is a lot of money to be made in currency trading, you just have to know where to look. Sidestepping simple dealer traps is one way of improving your daily p&l, but it is surely not the only one. Successful trading comes down to taking care of the details, which means skipping the theoretical stuff and providing only up-to-date, real-life examples while sharing the FX trading tips that have proved so profitable over the years. By stripping away the theory and getting down to the core of trading, you too will find yourself on the way to beating the forex dealer!

    Computer scientists have identified many techniques that a wide range of programs need, such as: Fuzzy pattern matching for text (identify misspellings!) Finding correlations in data Game-playing algorithms Predicting phenomena such as Web traffic Polynomial and spline fitting Using algorithms explained in this book, you too can carry out traditional programming tasks in a high-powered, efficient, easy-to-maintain manner with Perl.This book assumes a basic understanding of Perl syntax and functions, but not necessarily any background in computer science. The authors explain in a readable fashion the reasons for using various classic programming techniques, the kind of applications that use them, and -- most important -- how to code these algorithms in Perl.If you are an amateur programmer, this book will fill you in on the essential algorithms you need to solve problems like an expert. If you have already learned algorithms in other languages, you will be surprised at how much different (and often easier) it is to implement them in Perl. And yes, the book even has the obligatory fractal display program.There have been dozens of books on programming algorithms, some of them excellent, but never before has there been one that uses Perl.The authors include the editor of The Perl Journal and master librarian of CPAN; all are contributors to CPAN and have archived much of the code in this book there."This book was so exciting I lost sleep reading it." Tom Christiansen

    This book is neither a step-by-step tutorial nor a reference book. Instead, our goal is to bring a diverse set of software engineering topics together into a single narrative, help readers understand the most important ideas through concrete examples and a learn-by-doing approach, and teach readers enough about each topic to get them started in the field. Courseware for doing the work in the book is available as a virtual machine image that can be downloaded or deployed in the cloud. A free MOOC (massively open online course) at saas-class.org follows the book's content and adds programming assignments and quizzes. See http://saasbook.info for details.