You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in several flavors of SQL, including Oracle, DB2, SQL Server, MySQL, and PostgreSQL.

Most programming languages contain good and bad parts, but JavaScript has more than its share of the bad, having been developed and released in a hurry before it could be refined.

'One of the best books yet written on data and algorithms. . .deserves a place on the bestseller charts.' (The Times) You are accused of a crime. Who would you rather determined your fate - a human or an algorithm? An algorithm is more consistent and less prone to error of judgement.

With a setting unlike any other to explore and mysteries lying buried, Horizon Zero Dawn is a game you'll want to dig deep into. This fully updated book will provide everything you need to overcome the odds and gain a deeper understanding of the game's unique world, including the new Frozen Wilds content. +++ Get an Overview of How Things Work: Our breakdown of the game's systems is as in-depth as it gets. You'll have the benefit of countless hours' play at your fingertips, with analysis of the skills, crafting and rewards that cover both Ultra Hard and New Game+ modes. +++ Plan Your Route Through the Game: We provide everything you need to plot out your own route through the game, based on your way of playing.

Food photography is a rapidly-growing genre, and whether you're a food blogger looking to take your presentation to the next level, or a professional photographer keen to expand into this lucrative market, this book has everything you need to make it all a piece of cake.

Since its initial release in 1997, Paul Gilreath's The Guide to MIDI Orchestration has been the premiere text on creating realistic emulations of a symphony orchestra using samplers and computer recording techniques. Now in its fourth edition, The Guide to MIDI Orchestration explains how to merge this ever-expanding technology with the artistry of orchestration to produce the most lifelike recordings possible. T