SQL for Data Analytics. Harness the power of SQL to extract insights from data - Third Edition

Jun Shan, Matt Goldwasser, Upom Malik, Benjamin Johnston

Every day, businesses operate around the clock, and a huge amount of data is generated at a rapid pace. This book helps you analyze this data and identify key patterns and behaviors that can help you and your business understand your customers at a deep, fundamental level.SQL for Data Analytics, Third Edition is a great way to get started with data analysis, showing how to effectively sort and process information from raw data, even without any prior experience.You will begin by learning how to form hypotheses and generate descriptive statistics that can provide key insights into your existing data. As you progress, you will learn how to write SQL queries to aggregate, calculate, and combine SQL data from sources outside of your current dataset. You will also discover how to work with advanced data types, like JSON. By exploring advanced techniques, such as geospatial analysis and text analysis, you will be able to understand your business at a deeper level. Finally, the book lets you in on the secret to getting information faster and more effectively by using advanced techniques like profiling and automation. By the end of this book, you will be proficient in the efficient application of SQL techniques in everyday business scenarios and looking at data with the critical eye of analytics professional. 

Building Android Games with Cocos2d-x. Learn to create engaging and spectacular games for Android using Cocos2d-x

Raydelto Hernadez, Raydelto Hernandez

The Pro Tools 2023 Post-Audio Cookbook. A holistic approach to post audio workflows like music production, motion picture, and spoken word

Emiliano Paternostro

Pro Tools has long been an industry-standard Digital Audio Workstation (DAW) for audio professionals, but it can often be overwhelming for new and experienced users alike. The Pro Tools 2023 Post-Audio Cookbook acts as a reference guide to the software and breaks down each stage of a project into manageable phases. From planning a session, editing a sequence, performing a mix to printing the final masters, you can approach this book either sequentially or peruse the self-contained recipes.You’ll come to grips with workflows for music production, motion picture, and spoken word production, helping you gain expertise in the area of your choice. You'll learn aspects of music mixing like side chain processing to keep instruments from overshadowing each other and conforming for motion picture. The author’s expertise with Pro Tools will help you discover and incorporate different techniques into your workflows. You’ll also learn to build consistent and replicable workflows and templates by understanding what happens behind the scenes in Pro Tools. With this cookbook, you’ll be able to focus on the creative aspects of your audio production and not get mired by the technical hurdles.By the end of this book, you’ll be well-equipped to handle even the most complex features of Pro Tools to deliver immaculate results for your clients.

Mastering VMware Horizon 7. Virtualization that can transform your organization - Second Edition

Peter von Oven, Barry Coombs

Desktop virtualization can be a bit of a headache. But VMware Horizon 7 changes all that. With a rich and adaptive UX, improved security and a range of useful features for storage and networking optimization, there’s plenty to love.But to properly fall in love with it, you need to know how to use it. And that means venturing deeper into the software, taking advantage of its extensive range of features, many of which are underused and underpromoted. This guide will take you through everything you need to know to not only successfully virtualize your desktop infrastructure but also to maintain and optimize the infrastructure to keep all your users happy.We’ll show you how to assess and analyze your infrastructure, and how to use that analysis to design a solution that meets your organizational and user needs. Once you’ve done that, you’ll find out how to build your virtualized environment, before deploying your virtualized solution. But more than that, we’ll also make sure you know everything you need to know about the full range of features on offer, including mobile cloud, so you can use them to take full control of your virtualized infrastructure.

Adversarial Tradecraft in Cybersecurity. Offense versus defense in real-time computer conflict

Dan Borges

Little has been written about what to do when live hackers are on your system and running amok. Even experienced hackers tend to choke up when they realize the network defender has caught them and is zoning in on their implants in real time. This book will provide tips and tricks all along the kill chain of an attack, showing where hackers can have the upper hand in a live conflict and how defenders can outsmart them in this adversarial game of computer cat and mouse.This audiobook contains two subsections in each chapter, specifically focusing on the offensive and defensive teams. It begins by introducing you to adversarial operations and principles of computer conflict where you will explore the core principles of deception, humanity, economy, and more about human-on-human conflicts. Additionally, you will understand everything from planning to setting up infrastructure and tooling that both sides should have in place.Throughout this audiobook, you will learn how to gain an advantage over opponents by disappearing from what they can detect. You will further understand how to blend in, uncover other actors’ motivations and means, and learn to tamper with them to hinder their ability to detect your presence. Finally, you will learn how to gain an advantage through advanced research and thoughtfully concluding an operation.By the end of this audiobook, you will have achieved a solid understanding of cyberattacks from both an attacker’s and a defender’s perspective.

Learning NGUI for Unity. Leverage the power of NGUI for Unity to create stunning mobile and PC games and user interfaces

Charles Bernardoff, Charles Bernardoff (EURO)

Learning C# by Developing Games with Unity 3D Beginner's Guide. The beauty of this book is that it assumes absolutely no knowledge of coding at all. Starting from very first principles it will end up giving you an excellent grounding in the writing of C# code and scripts

Terry Norton

For the absolute beginner to any concept of programming, writing a script can appear to be an impossible hurdle to overcome. The truth is, there are only three simple concepts to understand: 1) having some type of information; 2) using the information; and 3) communicating the information. Each of these concepts is very simple and extremely important. These three concepts are combined to access the feature set provided by Unity.Learning C# by Developing Games with Unity 3D Beginner's Guide assumes that you know nothing about programming concepts. First you will learn the absolute basics of programming using everyday examples that you already know. As you progress through the book, you will find that C# is not a foreign language after all, because you already know the words. With a few keywords and using substitution, before you know it, you'll be thinking in code.The book starts by explaining in simple terms the three concepts you need for writing C# code and scripts: 1) variables to hold information; 2) methods (functions) to use the information; and 3) Dot Syntax to communicate the information where it's needed. The book builds on these concepts to open up the world of C# coding and Unity scripting. You will use this new power to access the features provided in Unity's Scripting Reference.The first half of this book is devoted to the code writing beginner. The concepts of variables, methods, Dot Syntax, and decision processing are fully explained. Since C# is an actual programming language, we take advantage of this to develop a State Machine to help control and organize each phase of a Unity project. Once the basic programming concepts are established and we have some State Machine organization, the features and power of Unity are accessed using the Scripting Reference.If you're looking to learn C# for Unity then this is the book that offers everything you need and more - so discover what C# offers today and see your work come to life as complete games!

Mobile Game Design Essentials. Immerse yourself in the fundamentals of mobile game design. This book is written by two highly experienced industry professionals to give real insights and valuable advice on creating games for this lucrative market

Claudio Scolastici, David M Nolte

The videogame industry is not affected by the economic crisis as the market expands each year. In addition to that, the mobile market offers the opportunity to small teams with limited budgets to create successful games that can compete with the big companies. This is a guide to help you take a share of this huge market.Mobile Game Design Essentials will teach you how to develop professional quality games for mobile platforms. You will learn how to take advantage of devices and their built-in technologies. Get to know the best software and programming languages to create videogames from scratch and detailed tutorials to get your hands dirty with the common practices of game development.Mobile Game Design Essentials introduces you to smartphones, their operating systems, and development environments. It describes in detail the roles required by an indie team of mobile developers, the most popular software to create graphics and audio for games, the most used programming languages, and the best game engines. It also provides several tutorials detailing efficient game development and prototyping.Starting with a description of the mobile platforms and the roles to cover when building up your own indie team, Mobile Game Design Essentials then provides a description of the techniques and software used to create graphics and audio for games and the coding languages and development environments used by programmers. It also aims to acquaint you with the best practices of mobile game design and development, by addressing the importance of the prototype-test-polish cycle and the analysis of the distinctive aspects of mobile game design. Finally, it concludes with a step-by-step guide to create the presentation document for your next mobile game.Mobile Game Design Essentials covers everything you need to know to get started in the mobile game industry; from collecting your team, recommendations on development software, to marketing and publication.