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.

    However, it is an extremely powerful and versatile programming language in its own right. It focuses on simplicity and offers a fully object-oriented environment."Beginning Ruby" is a thoroughly contemporary guide for every type of reader who wants to learn Ruby, from novice programmers to web developers to Ruby newcomers. It starts by explaining the principles behind object-oriented programming and within a few chapters builds toward creating a genuine Ruby application.The book then explains key Ruby principles, such as classes and objects, projects, modules, and libraries, and other aspects of Ruby such as database access. In addition, Ruby on Rails is covered in depth, and the books appendixes provide essential reference information as well as a primer for experienced programmers. What you'll learn Understand the basics of Ruby and object-oriented building blocks. Work with Ruby libraries, gems, and documentation. Work with files and databases. Write and deploy Ruby applications. Explore Ruby web frameworks and aspects of network programming with Ruby. Develop desktop and GUI applications with Ruby. Who this book is forBeginning programmers, programmers new to Ruby, and web developers interested in knowing the foundations of the language. "

    It is also about Python. However, there is much more. The study of algorithms and data structures is central to understanding what computer science is all about. Learning computer science is not unlike learning any other type of difficult subject matter. The only way to be successful is through deliberate and incremental exposure to the fundamental ideas. A beginning computer scientist needs practice so that there is a thorough understanding before continuing on to the more complex parts of the curriculum. In addition, a beginner needs to be given the opportunity to be successful and gain confidence. This textbook is designed to serve as a text for a first course on data structures and algorithms, typically taught as the second course in the computer science curriculum. Even though the second course is considered more advanced than the first course, this book assumes you are beginners at this level. You may still be struggling with some of the basic ideas and skills from a first computer science course and yet be ready to further explore the discipline and continue to practice problem solving. We cover abstract data types and data structures, writing algorithms, and solving problems. We look at a number of data structures and solve classic problems that arise. The tools and techniques that you learn here will be applied over and over as you continue your study of computer science.

    With the help of kid-friendly examples, author Nick Morgan teaches the essentials of JavaScript. Morgan starts with the basics of strings, arrays, and loops, then moves on to show readers how to modify elements with jQuery and draw graphics with canvas. By the end of the book, you'll be ready to create your own fun animations and games and you'll have a solid understanding of the fundamentals of JavaScript.

     Here's A Preview Of What Machiavelli Mindset Contains... An Introduction to Machiavelli Seeing the World through Machiavelli’s Eyes Getting Over The Guilt Moving Above And Beyond Conventional Thinking Machiavelli's Thoughts On Generosity Compassion Vs. Cruelty (Is It Better To Be Loved Or Feared?) What Machiavelli Says About Honesty How To Achieve Success The Machiavellian Way The Qualities Of A Great Leader How to Avoid Attracting Hatred and Other Lessons from the Prince And Much, Much More! Download Your Copy Now And Get Ahead Today!

    An ordinary girl. An extraordinary royal wedding.Princess Ever AfterRegina Beswick was born to be a princess. But she’s content to be a small-town girl, running a classic auto restoration shop, unaware a secret destiny awaits her.How to Catch a PrinceAn American heiress and a crown prince seem destined to be together. Will the devastation of war keep them apart forever?

    If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements.To help you attain this fundamental SQL knowledge, look to "Learning SQL," an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language."Learning SQL" moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed: The history of the computerized databaseSQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and deleteSQL Schema Statements--those used to create database objects, such as tables, indexes, and constraintsHow data sets can interact with queriesThe importance of subqueriesData conversion and manipulation via SQL's built-in functionsHow conditional logic can be used in Data StatementsBest of all, "Learning SQL" talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. Whenever possible, the book sticks to the features included in the ANSI SQL standards. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL.Put the power and flexibility of SQL to work. With "Learning SQL" you can master this important skill and know that the SQL statements you write are indeed correct.

    This book is both an example-driven programmer's guide and a keep-on-your-desk reference, with new chapters that explain everything you need to know to get the most out of JavaScript, including:Scripted HTTP and Ajax XML processing Client-side graphics using the canvas tag Namespaces in JavaScript--essential when writing complex programs Classes, closures, persistence, Flash, and JavaScript embedded in Java applicationsPart I explains the core JavaScript language in detail. If you are new to JavaScript, it will teach you the language. If you are already a JavaScript programmer, Part I will sharpen your skills and deepen your understanding of the language.Part II explains the scripting environment provided by web browsers, with a focus on DOM scripting with unobtrusive JavaScript. The broad and deep coverage of client-side JavaScript is illustrated with many sophisticated examples that demonstrate how to:Generate a table of contents for an HTML document Display DHTML animations Automate form validation Draw dynamic pie charts Make HTML elements draggable Define keyboard shortcuts for web applications Create Ajax-enabled tool tips Use XPath and XSLT on XML documents loaded with Ajax And much morePart III is a complete reference for core JavaScript. It documents every class, object, constructor, method, function, property, and constant defined by JavaScript 1.5 and ECMAScript Version 3.Part IV is a reference for client-side JavaScript, covering legacy web browser APIs, the standard Level 2 DOM API, and emerging standards such as the XMLHttpRequest object and the canvas tag.More than 300,000 JavaScript programmers around the world have made this their indispensable reference book for building JavaScript applications."A must-have reference for expert JavaScript programmers...well-organized and detailed."-- Brendan Eich, creator of JavaScript

    It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two.Now available in an updated second edition, our very popular "SQL Pocket Guide" is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The "SQL Pocket Guide" is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including: Oracle Database 10g, Release 2 (includingthe free Oracle Database 10g Express Edition (XE))Microsoft SQL Server 2005MySQL 5IBM DB2 8.2PostreSQL 8.1 database

    He had learnt from early on that trust and unconditional love end badly. Both his mother’s failed relationship with his rich and absent father and his mentor’s marriage to a scrupulous and selfish woman taught him the lesson not to carry his heart on his sleeve. The man who had turned James’ life around in the darkest of his teenage years, died alone and rejected. Ridiculous accusations that prompted such ending left James incredulous and furious, the heat of his anger never completely leaving him in the years that followed.It is impossible to escape the past, his mentor’s suicide and the events that lead to it still very much on his mind. The fate has given him the rare opportunity to finally settle the scores. Avenging Steve Masden’s death is simply too tempting to be ignored. Emily Beggins knows right away that something isn’t right about her stepsister’s mysterious fiancé. He might well be the most handsome and charming man she has ever met, but there is a certain icy resolve in his eyes that frightens her witless. Behind the impeccable façade and lethal smile, she senses something dark and dangerous. Something that shouldn’t really be there…Loyalty has always been a big part of her character, even though her life with her stepmother and stepsister had proven far more challenging and difficult than she had ever anticipated. They share enough memories and dirty secrets to bind them together with the invisible thread of guilt and obligations. Saving Sophie from the unknown disaster leaves Emily no choice but to confront the man who had managed to capture her stepsister’s heart in a span of mere days.Only James isn’t ready to play fair, one sweep of his hand pushing aside any hopes she might have for a happy ending. He knows too much and cares too little to have any sympathy for her or her family.She has to play by his rules, each step taking her deeper and deeper into his world. Soon it becomes her world too and the lines between black and white blur, nothing certain any longer.As time goes by the question of how to survive being around James becomes replaced by another, more urgent one.How will she ever live without him?

    But how do you defeat them? Based on Authentic firsthand case studies Rasmus Ankersen answers some of the toughest management questions of today.

    

    Python is easy to learn, and it's perfect for exploring topics like statistics, geometry, probability, and calculus. You’ll learn to write programs to find derivatives, solve equations graphically, manipulate algebraic expressions, even examine projectile motion.Rather than crank through tedious calculations by hand, you'll learn how to use Python functions and modules to handle the number crunching while you focus on the principles behind the math. Exercises throughout teach fundamental programming concepts, like using functions, handling user input, and reading and manipulating data. As you learn to think computationally, you'll discover new ways to explore and think about math, and gain valuable programming skills that you can use to continue your study of math and computer science.If you’re interested in math but have yet to dip into programming, you’ll find that Python makes it easy to go deeper into the subject—let Python handle the tedious work while you spend more time on the math.

    Learn responsive design using HTML5 and CSS3 to adapt websites to any browser or screen size.

    Renowned poker professional and author Jonathan Little brings together 17 of the greatest no-limit experts in the world to discuss all aspects of the game. These experts include superstars such as Phil Hellmuth, Chris Moneymaker, Mike Sexton and Jared Tendler. In Part 1 strategies are analysed for topics such as understanding the fundamentals, satellite play, lower-buy in events, analysing tells and moving up in stakes Part 2 sees a thorough technical breakdown of the game including sections on range analysis, game theory optimal play, short stack strategies, value betting and final table play. As any serious poker will confirm, the technical side is only half the battle and so Part 3 deals with mental toughness, psychology and understanding tilt. Excelling at No-Limit Hold‘em provides all the tools that an aspiring player needs to understand no-limit hold‘em. It is a must buy for anyone who is serious about wanting to improve their poker.