The focus is on SQL-it covers all major SQL databases without getting lost in the details of any one specific product. Starting with the basics of indexing and the WHERE clause, SQL Performance Explained guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate. Topics covered include: Using multi-column indexes; Correctly applying SQL functions; Efficient use of LIKE queries; Optimizing join operations; Clustering data to improve performance; Pipelined execution of ORDER BY and GROUP BY; Getting the best performance for pagination queries; Understanding the scalability of databases. Its systematic structure makes SQL Performance Explained both a textbook and a reference manual that should be on every developer's bookshelf.

    Git tasks displayed on two-page spreads provide all the context you need, without the extra fluff. Get up to speed on Git right now with Pragmatic Guide to Git. Task-oriented two-page spreads get you up and running with minimal fuss. Each left-hand page dives into the underlying implementation for each task. The right-hand page contains commands that focus on the task at hand, and cross references to other tasks that are related. You'll find what you need fast. Git is rapidly becoming the de-facto standard for the open source community. Its excellent merging capabilities, coupled with its speed and relative ease of use, make it an indispensable tool for any developer. New Git users will learn the basic tasks needed to work with Git every day, including working with remote repositories, dealing with branches and tags, exploring the history, and fixing problems when things go wrong. If you're already familiar with Git, this book will be your go-to reference for Git commands and best practices. You won't find a more practical approach to learning Git than Pragmatic Guide to Git.

    The Hacker Playbook provides them their own game plans. Written by a longtime security professional and CEO of Secure Planet, LLC, this step-by-step guide to the “game” of penetration hacking features hands-on examples and helpful advice from the top of the field. Through a series of football-style “plays,” this straightforward guide gets to the root of many of the roadblocks people may face while penetration testing—including attacking different types of networks, pivoting through security controls, and evading antivirus software. From “Pregame” research to “The Drive” and “The Lateral Pass,” the practical plays listed can be read in order or referenced as needed. Either way, the valuable advice within will put you in the mindset of a penetration tester of a Fortune 500 company, regardless of your career or level of experience. Whether you’re downing energy drinks while desperately looking for an exploit, or preparing for an exciting new job in IT security, this guide is an essential part of any ethical hacker’s library—so there’s no reason not to get in the game.

    Get an insider's tour of databases and client-server systems so you can understand the local customs. Then work your way up to sophisticated commands and statements, and check out the coverage of SQL-related products, such as Microsoft SQL server. You'll be able to communicate with your database like a native speaker in no time! Inside, find helpful advice on how to Get a complete overview of SQL components, such as Data Definition Language, Data Manipulation Language, and Data Control Language Use SQL to transfer and retrieve information on the Internet and intranets Uncover fundamental SQL commands and data types Extract data from many different data sources by using ODBC Master the basics of creating tables, views, schemas, and indexes for easy data access Manage databases by using SQL server Access a database over the Internet Get tips for making advanced queries

    Step-by-step illustrations, helpful diagrams, and exceptional photography make this book an easy-to-follow and easy-on-the-eyes guide to getting your project done.With an emphasis on making DIY projects that can change the world, The Big Book of Maker Skills includes sections and tutorials on:Setting Up a HackerspacePicking the Right ToolsWelding SmartsCircuitry BasicsProgramming & ArduinosWorking with Wood3-D PrintingLaser-cuttingCNC RoutingTesting & PrototypingDrones and Space Exploration ToolsRoboticsBiotechnologySourcing and Crowdsourcing

     FreeMind is a premier mind mapping software written in Java. It is a high-productivity tool that can make all your online mind mapping simple. Organize, prioritize, know where you are, where you've been and where you're heading with FreeMind. Mind mapping can be used for brainstorming, goal planning, product design, event planning, and so much more - the only limit is your own creativity. Use this guide's step-by-step instructions and screenshots to learn how to create your own digital mind maps. THIS BOOK DOES NOT TEACH YOU MIND MAPPING CONCEPTS OR BASICS. It ONLY shows you how to use the FreeMind software that creates digital mind maps. If you are new to mind maps, you may want to pick up Mind Mapping Secrets - Achieving Your Goals for a quick primer on how to create mind maps using pen and paper. Then take your maps to a new level with this easy to master How To guide today.