eBooksBay - Download Free eBooks » Free-Book-Spot--Latest Books

In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzlesand then helps solve them with a variety of solutions and explanations. Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but help develop the mindset needed to solve the many difficult SQL puzzles you face every day. Of course, part of the fun is to see whether or not you can write better solutions than Joes. * A great collection of tricky SQL puzzles with a variety of solutions and explanations. * Uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems. * New edition features: Many new puzzles added! Dozens of new solutions to puzzles, and using features in SQL-99 Code is edited to conform to SQL STYLE rules New chapter on temporal query puzzles New chapter on common misconceptions about SQL and RDBMS that leads to problems Read more...

Over 200 games by the great Cuban champion drawn from lesser matches and exhibition events. Included are games against Corzo, which earned Capablanca the Cuban Championship at the age of 12, as well as match and exhibition games, consultation games, simultaneous games with clocks, more. Bibliography. 151 diagrams. Read more...

Covering the PIC BASIC and PIC BASIC PRO compilers, PIC Basic Projects provides an easy-to-use toolkit for developing applications with PIC BASIC. Numerous simple projects give clear and concrete examples of how PIC BASIC can be used to develop electronics applications, while larger and more advanced projects describe program operation in detail and give useful insights into developing more involved microcontroller applications. Including new and dynamic models of the PIC microcontroller, such as the PIC16F627, PIC16F628, PIC16F629 and PIC12F627, PIC Basic Projects is a thoroughly practical, hands-on introduction to PIC BASIC for the hobbyist, student and electronics design engineer. * Packed with simple and advanced projects which show how to program a variety of interesting electronic applications using PIC BASIC * Covers the new and powerful PIC16F627, 16F628, PIC16F629 and the PIC12F627 models * A CDROM includes program source files, HEX code, data sheets of devices, sensors and schematics of the circuits used in the book About the Author Dogan Ibrahim works for the Traffic Control Systems Unit in London, UK. He was formerly a lecturer at South Bank University and Head of Department at Near East University, Cyprus in the UK. Read more...

When you learn Photoreading you will experience what might sound impossible. You will PhotoRead the written page at rates exceeding a page per second, directing information into the expanded processing capabilities of your brain. There the information connects with your prior knowledge and becomes useful to accomplishing your purpose. You get your reading done in the time you have available, at a level of comprehension you need. About the Author Paul R. Scheele is a recognized authority in three leading edge technologies or human development: Accelerated Learning, Neuro-Linguistic Programming, and Preconscious Processing. His unique expertise allows him to develop the process of "mentally photographing" printed material at rates exceeding 25,000 words a minute. Read more...

Over the last ten years, the ARM architecture has become one of the most pervasive architectures in the world, with more than 2 billion ARM-based processors embedded in products ranging from cell phones to automotive braking systems. A world-wide community of ARM developers in semiconductor and product design companies includes software developers, system designers and hardware engineers. To date no book has directly addressed their need to develop the system and software for an ARM-based system. This text fills that gap. This book provides a comprehensive description of the operation of the ARM core from a developers perspective with a clear emphasis on software. It demonstrates not only how to write efficient ARM software in C and assembly but also how to optimize code. Example code throughout the book can be integrated into commercial products or used as templates to enable quick creation of productive software. The book covers both the ARM and Thumb instruction sets, covers Intel's XScale Processors, outlines distinctions among the versions of the ARM architecture, demonstrates how to implement DSP algorithms, explains exception and interrupt handling, describes the cache technologies that surround the ARM cores as well as the most efficient memory management techniques. A final chapter looks forward to the future of the ARM architecture considering ARMv6, the latest change to the instruction set, which has been designed to improve the DSP and media processing cap Read more...

Dr. Tarrasch begins with the endgame-because it's easier for a novice to deal with a few men than the entire 32. An important and extensive discussion of the middle game follows. Finally, the author deals with openings and offers enlightening comments on many historically important variations. Over 340 diagrams and 12 complete games. Read more...

Speed-reading is about reading--and being able to recall--more written information in less time. Following a unique five-step system, this practical guide teaches readers the basics of speed-reading in less than an hour. It includes tools and information on a variety of reading and memory techniques that allow readers to start using and practicing the techniques as they read--and therefore finish this book in a fraction of the time they would have taken previously. The book shows how to read effectively under pressure and concentrate in today's noisy, distracting environments. About the Author Tina Konstant is a coach, researcher and professional speaker on human potential and learning skills. Read more...

The key to mastering any Unix system, especially Linux and Mac OS X, is a thorough knowledge of shell scripting. Scripting is a way to harness and customize the power of any Unix system, and it's an essential skill for any Unix users, including system administrators and professional OS X developers. But beneath this simple promise lies a treacherous ocean of variations in Unix commands and standards. bash Cookbook teaches shell scripting the way Unix masters practice the craft. It presents a variety of recipes and tricks for all levels of shell programmers so that anyone can become a proficient user of the most common Unix shell -- the bash shell -- and cygwin or other popular Unix emulation packages. Packed full of useful scripts, along with examples that explain how to create better scripts, this new cookbook gives professionals and power users everything they need to automate routine tasks and enable them to truly manage their systems -- rather than have their systems manage them. Read more...

If you need to build Web and database applications quickly but you don't dream in computer code, take heart! Ruby on Rails was created for you, and this book will have you up and running in no time. The Ruby scripting language and the Rails framework let you create full-featured Web applications fast. It's even fun!... Discover how to * Install and run Ruby and Rails * Use the RadRails IDE * Create a blog with Ruby * Connect your Web site to a database * Build a shopping cart * Explore Ruby's syntax As a computer book author, I strive not to be full of myself. I have no illusions that you plan on reading this book from cover to cover. I read sections and chapters out of order when I buy a computer book. Why would I expect you to approach my book any differently? And even if I read something in Chapter 2, who says I remember it when I read Chapter 11? I write each section with these thoughts in mind. In the middle of Chapter 12, I might want you to remember some nugget of knowledge that I introduce in Chapter 4. If I use that nugget over and over again in Chapters 5, 7, 8, and 9, I donÃƒÂ¢Ã¢â€šÂ¬Ã¢â€žÂ¢t remind you about it in Chapter 12. But for other nuggets ÃƒÂ¢Ã¢â€šÂ¬Ã¢â‚¬? ones that you donÃƒÂ¢Ã¢â€šÂ¬Ã¢â€žÂ¢t read about repeatedly in this book ÃƒÂ¢Ã¢â€šÂ¬Ã¢â‚¬? I provide cross references. Read more...