Move into iOS development by getting a firm grasp of its fundamentals, including the Xcode 9 IDE, Cocoa Touch, and the latest version of Apple's acclaimed programming language, Swift 4. With this thoroughly updated guide, you'll learn the Swift language, understand Apple's Xcode development tools, and discover the Cocoa framework. Explore Swift's object-oriented concepts Become familiar with built-in Swift types Dive deep into Swift objects, protocols, and generics Tour the lifecycle of an Xcode project Learn how nibs are loaded Understand Cocoa's event-driven design Communicate with C and Objective-C In this edition, catch up on the latest iOS programming features. Multiline strings and improved dictionaries Object serialization Key paths and key-value observing Expanded git integration Code refactoring And more! Once you master the fundamentals, you'll be ready to tackle the details of iOS app development with author Matt Neuburg's companion guide, Programming iOS 11

Game Anim teaches the technical and artistic fundamentals of video game animation and goes further to provide practical advice and industry insights to help you become a rounded and successful game animator. Covering every stage of game production from the animator's perspective, it is packed with the lessons learned from working on a variety of game types in both in-game and cinematic roles in animator, lead, and director positions. These have been successful across multiple studios regardless of team, size and culture. The 2nd edition includes a new chapter on 2D and Pixel Art Animation, an enhanced mocap chapter covering the latest developments in Motion Matching, and even more interviews with top professionals in the field. Game Anim provides essential guidance to those looking to break into the industry and successful animators wishing to take the next step in their career. Key Features * 20 Years of Insight: Accumulated knowledge from 2 decades of experience in all areas of game animation. * The 5 Fundamentals: Reinterprets the classic 12 animation principles and sets out 5 new fundamentals for great game animation. * Animator Interviews: Notable game animators offer behind-the-scenes stories, tips, and advice. * Free Animation Rig: Free "AZRI" maya rig, tutorials and other resources on the accompanying website: www.gameanim.com/book

This book teaches anyone with a basic understanding of Java how to develop Android apps at a professional level. To start, it shows how to use the Eclipse IDE to code, test, and debug a Tip Calculator app for a smartphone or tablet. Then, it expands upon this app to show must-have Android skills such as working with layouts, widgets, events, themes, styles, menus, preferences, and fragments. Next, this book presents two more apps that illustrate Android skills you'll use every day, such as working with threads, files, adapters, intents, services, notifications, broadcast receivers, SQLite databases, content providers, and app widgets. Finally, this book presents an app that uses the Google Maps API and shows you how to submit your finished apps to the Google Play store. The real-world apps let you see how the skills you're learning work together, and they illustrate how and when you'd use each skill. And all the content is presented in Murach distinctive "paired-pages" style that developers find so clear and time-saving for both training and reference.

OpenGL ES is the standard graphics API used for mobile and embedded systems. Despite its widespread use, there is a lack of material that addresses the balance of both theory and practice in OpenGL ES. JungHyun Han's Introduction to Computer Graphics with OpenGL ES achieves this perfect balance. Han's depiction of theory and practice illustrates how 3D graphics fundamentals are implemented. Theoretical or mathematical details around real-time graphics are also presented in a way that allows readers to quickly move on to practical programming. Additionally, this book presents OpenGL ES and shader code on many topics. Industry professionals, as well as, students in Computer Graphics and Game Programming courses will find this book of importance. Key Features: Presents key graphics algorithms that are commonly employed by state-of-the-art game engines and 3D user interfaces Provides a hands-on look at real-time graphics by illustrating OpenGL ES and shader code on various topics Depicts troublesome concepts using elaborate 3D illustrations so that they can be easily absorbed Includes problem sets, solutions manual, and lecture notes for those wishing to use this book as a course text.

Every major enterprise has a significant installed base of existing software systems that reflect the tangled IT architectures that result from decades of patches and failed replacements. Most of these systems were designed to support business architectures that have changed dramatically. At best, these systems hinder agility and competitiveness and, at worst, can bring critical business functions to a halt.

Architecture-Driven Modernization (ADM) restores the value of entrenched systems by capturing and retooling various aspects of existing application environments, allowing old infrastructures to deliver renewed value and align effectively with enterprise strategies and business architectures.

This book provides a practical guide to organizations seeking ways to understand and leverage existing systems as part of their information management strategies. It includes an introduction to ADM disciplines, tools, and standards as well as a series of scenarios outlining how ADM is applied to various initiatives. Drawing upon lessons learned from real modernization projects, it distills the theory and explains principles, processes, and best practices for every industry.
* Acts as a one-stop shopping reference and complete guide for implementing various modernization models in myriad industries and departments.
* Every concept is illustrated with real-life examples from various modernization projects, allowing you to immediately apply tested solutions and see results.
* Authored by the Co-chair of the Object Management Group (OMG) Architecture-Driven Modernization (ADM) Task Force, which sets definitive systems modernization standards for the entire IT industry.
* A web site supports the book with up to date coverage of evolving ADM Specifications, Tutorials, and Whitepapers, allowing you to remain up to date on modernization topics as they develop.

Nowadays, Web applications are almost omnipresent. The Web has become a platform not only for information delivery, but also for eCommerce systems, social networks, mobile services, and distributed learning environments. Engineering Web applications involves many intrinsic challenges due to their distributed nature, content orientation, and the requirement to make them available to a wide spectrum of users who are unknown in advance. The authors discuss these challenges in the context of well-established engineering processes, covering the whole product lifecycle from requirements engineering through design and implementation to deployment and maintenance. They stress the importance of models in Web application development, and they compare well-known Web-specific development processes like WebML, WSDM and OOHDM to traditional software development approaches like the waterfall model and the spiral model. .

On March 15, 2002 we held a workshop on network interdiction and the more general problem of stochastic mixed integer programming at the University of California, Davis. Jesus De Loera and I co-chaired the event, which included presentations of on-going research and discussion. At the workshop, we decided to produce a volume of timely work on the topics. This volume is the result. Each chapter represents state-of-the-art research and all of them were refereed by leading investigators in the respective fields. Problems - sociated with protecting and attacking computer, transportation, and social networks gain importance as the world becomes more dep- dent on interconnected systems. Optimization models that address the stochastic nature of these problems are an important part of the research agenda. This work relies on recent efforts to provide methods for - dressing stochastic mixed integer programs. The book is organized with interdiction papers first and the stochastic programming papers in the second part. A nice overview of the papers is provided in the Foreward written by Roger Wets."

Authoring, its tools, processes, and design challenges are key issues for the Interactive Digital Narrative (IDN) research community. The complexity of IDN authoring, often involving stories co-created by procedures and user interaction, creates confusion for tool developers and raises barriers for new authors. This book examines these issues from both the tool designer and the author's perspective, discusses the poetics of IDN and how that can be used to design authoring tools, explores diverse forms of IDN and their demands, and investigates the challenges around conducting research on IDN authoring. To address these challenges, the chapter authors incorporate a range of interdisciplinary perspectives on 'The Authoring Problem' in IDN. While existing texts provide 'how-to' guidance for authors, this book is a primer for research and practice-based investigations into the authoring problem, collecting the latest thoughts about this area from key researchers and practitioners.

Maintaining SQL Server 2005 high availability in a global information environment is the database administrators greatest practical challenge. Availability is as much about people and processes as it is about technology. Microsoft SQL Server 2005 High Availability covers the technology, people, processes, and real-world best practices for planning, deploying, administering, and maintaining highly available SQL Server 2005 instances. With years of experience as a database consultant and production DBA, Allan Hirt provides in-depth, detailed advice on what it takes to ensure SQL Server high availability for businesses of any size. This is not an academic text; its not based on lab experiments, but on real-world experience. This book is a dramatic update and revision of the authors previous best-seller on SQL Server 2000. It gives sound guidance to DBAs and system administrators on how to really get the job done.

Most innovations in the car industry are based on software and electronics, and IT will soon constitute the major production cost factor. It seems almost certain that embedded IT security will be crucial for the next generation of applications. Yet whereas software safety has become a relatively well-established field, the protection of automotive IT systems against manipulation or intrusion has only recently started to emerge.

Lemke, Paar, and Wolf collect in this volume a state-of-the-art overview on all aspects relevant for IT security in automotive applications. After an introductory chapter written by the editors themselves, the contributions from experienced experts of different disciplines are structured into three parts. "Security in the Automotive Domain" describes applications for which IT security is crucial, like immobilizers, tachographs, and software updates. "Embedded Security Technologies" details security technologies relevant for automotive applications, e.g., symmetric and asymmetric cryptography, and wireless security. "Business Aspects of IT Systems in Cars" shows the need for embedded security in novel applications like location-based navigation systems and personalization.

The first book in this area of fast-growing economic and scientific importance, it is indispensable for both researchers in software or embedded security and professionals in the automotive industry.

Become a JavaScript programmer and have fun doing it! Start writing software that solves real problems, even if you have absolutely no programming experience! This friendly, easy, full-color book puts you in total control of your own learning, empowering you to build unique and useful programs. Microsoft has completely reinvented the beginning programmer's tutorial, reflecting deep research into how today's beginners learn, and why other books fall short. Begin to Code with JavaScript is packed with innovations, from its JavaScript code samples you can interact with straight from your browser to its "Make Something Happen" projects. Whether you're a total beginner or you've tried before, this guide will put the power, excitement, and fun of programming where it belongs: in your hands! Easy, friendly, and you're in control! Learn how to... Get and use the powerful free Visual Studio Code tool for JavaScript programming Explore the JavaScript environment and see what happens when programs run Learn key concepts from example programs, and use them to jumpstart your own Create web pages containing JavaScript programs using HTML and CSS Write complete JavaScript programs that run inside browsers Master JavaScript features for storing and processing data Break large programs into small, flexible components Use software objects to create custom data types to solve specific problems Design more attractive and usable applications Make your programs more secure and reliable Use libraries and frameworks to create powerful software more quickly Get started with the essentials of interactive game development About This Book For absolute beginners who've never written a line of code For anyone who's been frustrated with other beginning programming books or courses For people who've started out with other languages and now want to learn JavaScript

This tutorial-based book allows readers to create a first-person game from start to finish using industry-standard (and free to student) tools of Unity, Substance Painter, and Maya. The first half of the book lays out the basics of using Maya and Substance Painter to create game-ready assets. This includes polygonal modeling, UV layout, and custom texture painting. The book then covers rigging and animation solutions to create assets to be placed in the game, including animated first-person assets and motion-captured NPC animations. Finally, readers can put it all together and build interactivity that allows the player to create a finished game using the assets built and animated earlier in the book. * Written by industry professionals with real-world experience in building assets and games * Build a complete game from start to finish * Learn what the pros use: construct all assets using the tools used at game studios across the world * All software used are free to students * When complete, students will have a playable version of an FPS game Jingtian Li is a graduate of China's Central Academy of Fine Arts and New York's School of Visual Arts, where he earned an MFA in Computer Art. He currently is an Assistant Professor of 3D Animation & Game Design at the University of the Incarnate Word in San Antonio, Texas. Adam Watkins is a 20-year veteran of 3D education. He holds an MFA in 3D Animation and a BFA in Theatre Arts from Utah State University. He currently is the Coordinator and Professor of the 3D Animation & Game Department at the University of the Incarnate Word in San Antonio, Texas. Kassandra Arevalo is an instructor of 3D Animation & Game Design at the University of the Incarnate Word in San Antonio, Texas. She previously worked as an animator at Immersed Games. Matt Tovar is an industry veteran animator. He has worked at Naughty Dog, Infinity Ward, and Sony Interactive on such games as The Last of Us, Call of Duty: Modern Warfare, and most recently Marvel's Avengers with Crystal Dynamics. He is an Assistant Professor of 3D Animation at the University of the Incarnate Word in San Antonio, Texas.

This book is an introduction to the mathematical theory of optimal control of processes governed by ordinary differential eq- tions. It is intended for students and professionals in mathematics and in areas of application who want a broad, yet relatively deep, concise and coherent introduction to the subject and to its relati- ship with applications. In order to accommodate a range of mathema- cal interests and backgrounds among readers, the material is arranged so that the more advanced mathematical sections can be omitted wi- out loss of continuity. For readers primarily interested in appli- tions a recommended minimum course consists of Chapter I, the sections of Chapters II, III, and IV so recommended in the introductory sec tions of those chapters, and all of Chapter V. The introductory sec tion of each chapter should further guide the individual reader toward material that is of interest to him. A reader who has had a good course in advanced calculus should be able to understand the defini tions and statements of the theorems and should be able to follow a substantial portion of the mathematical development. The entire book can be read by someone familiar with the basic aspects of Lebesque integration and functional analysis. For the reader who wishes to find out more about applications we recommend references [2], [13], [33], [35], and [50], of the Bibliography at the end of the book.

This tutorial-based book allows readers to create a first-person game from start to finish using industry-standard (and free to student) tools of Unity, Substance Painter, and Maya. The first half of the book lays out the basics of using Maya and Substance Painter to create game-ready assets. This includes polygonal modeling, UV layout, and custom texture painting. The book then covers rigging and animation solutions to create assets to be placed in the game, including animated first-person assets and motion-captured NPC animations. Finally, readers can put it all together and build interactivity that allows the player to create a finished game using the assets built and animated earlier in the book. * Written by industry professionals with real-world experience in building assets and games * Build a complete game from start to finish * Learn what the pros use: construct all assets using the tools used at game studios across the world * All software used are free to students * When complete, students will have a playable version of an FPS game Jingtian Li is a graduate of China's Central Academy of Fine Arts and New York's School of Visual Arts, where he earned an MFA in Computer Art. He currently is an Assistant Professor of 3D Animation & Game Design at the University of the Incarnate Word in San Antonio, Texas. Adam Watkins is a 20-year veteran of 3D education. He holds an MFA in 3D Animation and a BFA in Theatre Arts from Utah State University. He currently is the Coordinator and Professor of the 3D Animation & Game Department at the University of the Incarnate Word in San Antonio, Texas. Kassandra Arevalo is an instructor of 3D Animation & Game Design at the University of the Incarnate Word in San Antonio, Texas. She previously worked as an animator at Immersed Games. Matt Tovar is an industry veteran animator. He has worked at Naughty Dog, Infinity Ward, and Sony Interactive on such games as The Last of Us, Call of Duty: Modern Warfare, and most recently Marvel's Avengers with Crystal Dynamics. He is an Assistant Professor of 3D Animation at the University of the Incarnate Word in San Antonio, Texas.

YOUR PRACTICAL, HANDS-ON GUIDE TO WRITING APPLICATIONS USING GO Google announced the Go programming language to the public in 2009, with the version 1.0 release announced in 2012. Since its announcement to the community, and the compatibility promise of the 1.0 release, the Go language has been used to write scalable and high-impact software programs ranging from command-line applications and critical infrastructure tools to large-scale distributed systems. It's speed, simplicity, and reliability make it a perfect choice for developers working in various domains. In Practical Go - Building Scalable Network + Non-Network Applications, you will learn to use the Go programming language to build robust, production-ready software applications. You will learn just enough to building command line tools and applications communicating over HTTP and gRPC. This practical guide will cover: Writing command line applications Writing a HTTP services and clients Writing RPC services and clients using gRPC Writing middleware for network clients and servers Storing data in cloud object stores and SQL databases Testing your applications using idiomatic techniques Adding observability to your applications Managing configuration data from your applications You will learn to implement best practices using hands-on examples written with modern practices in mind. With its focus on using the standard library packages as far as possible, Practical Go will give you a solid foundation for developing large applications using Go leveraging the best of the language's ecosystem.

Artificial Intelligence Techniques in IoT Sensor Networks is a technical book which can be read by researchers, academicians, students and professionals interested in artificial intelligence (AI), sensor networks and Internet of Things (IoT). This book is intended to develop a shared understanding of applications of AI techniques in the present and near term. The book maps the technical impacts of AI technologies, applications and their implications on the design of solutions for sensor networks. This text introduces researchers and aspiring academicians to the latest developments and trends in AI applications for sensor networks in a clear and well-organized manner. It is mainly useful for research scholars in sensor networks and AI techniques. In addition, professionals and practitioners working on the design of real-time applications for sensor networks may benefit directly from this book. Moreover, graduate and master's students of any departments related to AI, IoT and sensor networks can find this book fascinating for developing expert systems or real-time applications. This book is written in a simple and easy language, discussing the fundamentals, which relieves the requirement of having early backgrounds in the field. From this expectation and experience, many libraries will be interested in owning copies of this work.

Computing systems are becoming highly complex, harder to understand, and therefore more prone to failure. Where such systems control aircraft for example, system failure could have disastrous consequences. It is important therefore that we are able to employ mathematical techniques to specify the behavior of critical systems. This thesis uses the theory of Communicating Sequential Processes to show how a real-time system (a system that maintains a continuous interaction with its environment) may be specified. Included is a case study in which a local area network protocol is described at two levels of abstraction, and a general method for structuring CSP descriptions of layered protocols is given. The research contained here represents the very latest work on the specification and verification of real-time systems.

This book serves three basic purposes: (1) a tutorial-type reference for complex systems engineering (CSE) concepts and associated terminology, (2) a recommendation of a proposed methodology showing how the evolving practice of CSE can lead to a more unified theory, and (3) a complex systems (CSs) initiative for organizations to invest some of their resources toward helping to make the world a better place. A wide variety of technical practitioners-e.g., developers of new or improved systems (particularly systems engineers), program and project managers, associated staff/workers, funders and overseers, government executives, military officers, systems acquisition personnel, contract specialists, owners of large and small businesses, professional society members, and CS researchers-may be interested in further exploring these topics. Readers will learn more about CS characteristics and behaviors and CSE principles and will therefore be able to focus on techniques that will better serve them in their everyday work environments in dealing with complexity. The fundamental observation is that many systems inherently involve a deeper complexity because stakeholders are engaged in the enterprise. This means that such CSs are more difficult to invent, create, or improve upon because no one can be in total control since people cannot be completely controlled. Therefore, one needs to concentrate on trying to influence progress, then wait a suitable amount of time to see what happens, iterating as necessary. With just three chapters in this book, it seems to make sense to provide a tutorial introduction that readers can peruse only as necessary, considering their background and understanding, then a chapter laying out the suggested artifacts and methodology, followed by a chapter emphasizing worthwhile areas of application.

Description AWS gives users the networking, compute, and security services they need without making them pay for anything they're not actually using. With almost a hundred individual AWS services, putting all the pieces together is not a simple thing. That's where this book can help. Learn Amazon Web Services in a Month of Lunches guides readers through the process of building a robust and secure web application using the core AWS services they really need to know. When they're done, readers will be comfortable with the basics, and know exactly where to look when they're ready for more. Key features * Bite-sized lessons * Step-by-step guide * Thorough introduction * Hands-on examples Audience This book is for developers, system administrators, or anyone looking for an introduction to using AWS cloud. A basic understanding of TCP/IP networking is helpful, but not required. About the Technology Amazon Web Services is, by all metrics, the giant of the cloud computing world. Not only does it dominate in terms of user adoption and market share, but its innovative and highly integrated services have defined the way networked digital services are delivered.

Longitudinal studies have traditionally been seen as too cumbersome and labor-intensive to be of much use in research on Human-Computer Interaction (HCI). However, recent trends in market, legislation, and the research questions we address, have highlighted the importance of studying prolonged use, while technology itself has made longitudinal research more accessible to researchers across different application domains. Aimed as an educational resource for graduate students and researchers in HCI, this book brings together a collection of chapters, addressing theoretical and methodological considerations, and presenting case studies of longitudinal HCI research. Among others, the authors: discuss the theoretical underpinnings of longitudinal HCI research, such as when a longitudinal study is appropriate, what research questions can be addressed and what challenges are entailed in different longitudinal research designs reflect on methodological challenges in longitudinal data collection and analysis, such as how to maintain participant adherence and data reliability when employing the Experience Sampling Method in longitudinal settings, or how to cope with data collection fatigue and data safety in applications of autoethnography and autobiographical design, which may span from months to several years present a number of case studies covering different topics of longitudinal HCI research, from "slow technology", to self-tracking, to mid-air haptic feedback, and crowdsourcing.

The competitiveness of organizations facing globalization, information and communication technologies relies on strategic issues such as reuse of knowledge from past experiences to make higher quality decisions, deployment of innovative, fast methodological approaches for solving problems and building systems. Real-life systems are often multidisciplinary; their development commands a uniform way of object modeling in order to close the loop of various interactions crossing multiple domains. An innovative methodology, built on UML version 2 and MDA (Model Driven Architecture), is proposed to explain how to design large-scale systems and make software reuse a reality, how logical models can be built progressively and transformed into business assets, how real time and database systems can be integrated smoothly along a single development stream. First, the metalanguage of UML is introduced as a lesson of rigorous and meta system development. That helps developers to acquire a deep understanding of meta elements of UML, rules that govern connections. Second, thirteen UML diagrams are studied in details with short examples. Third, fundamental modeling concepts are mapped into UML objects and represented with diagrams that are the visual parts of any CASE tool. Two advanced research topics beyond UML are exposed to complement the arsenal of development tools. A state-event network (SEN), a new diagram based on Petri net, supports dynamical studies and refines UML behavioral diagrams before implementation. The image attribute method is a combinatorial technique deployed to study dynamic behavior of safety-critical systems; it takes internal state variables of an object, makes images of surrounding objects interacting with this central object to explain its complex behavior and thus, automate the design of algorithms. One part of Real-Time Object Uniform Design Methodology with UML is targeted to be used as a basic textbook in Computer Science for teaching object modeling, fundamental concepts learning and system designing with thirteen UML diagrams. Another part is devoted to advanced research topics, samples and case studies. They are must readings for any system developer or any graduate student in any discipline that needs materials and thoughts for future developments, the power of object modeling packed along a serious development methodology.

Ruby is the fastest growing and most exciting dynamic language out there. If you need to get working programs delivered fast, you should add Ruby to your toolbox. This book is the only complete reference for both Ruby 1.9 and Ruby 2.0, the very latest version of Ruby. 2013 marks the 20th anniversary of the Ruby language. We're proud that throughout its history, we've continued to cover the latest version of Ruby. Would you like to go from first idea to working code much, much faster? Do you currently spend more time satisfying the compiler instead of your clients or end users? Are you frustrated with demanding languages that seem to get in your way, instead of getting the work done? Are you using Rails, and want to dig deeper into the underlying Ruby language? If so, then we've got a language and book for you! Ruby is a fully object-oriented language, much like the classic object-oriented language, Smalltalk. Like Smalltalk, it is dynamically typed (as opposed to Java or C++), but unlike Smalltalk, Ruby features the same conveniences found in modern scripting languages such as Perl and Python. The combination of the power of a pure object-oriented language with the convenience of a scripting language makes Ruby a favorite tool of intelligent, forward-thinking programmers. The Pickaxe contains four major sections: * An acclaimed tutorial on using Ruby. * The definitive reference to the language. * Complete documentation of all built-in classes, modules, and methods. * Complete descriptions of all 97 standard libraries. This is the reference manual for Ruby, including a description of all the standard library modules, a complete reference to all built-in classes and modules (including all the new and changed methods introduced by Ruby 1.9, 1.9.2, 1.9.3, and 2.0). It also includes all the new and changed syntax and semantics introduced since Ruby 1.8. Learn about the new parameter passing rules, local variable scoping in blocks, fibers, and the new block declaration syntax, among other exciting new features. About Ruby 2.0 Ruby 2.0 is a minor update to Ruby 1.9, unlike the more major updates from Ruby 1.8 to Ruby 1.9. The major language changes in Ruby 2.0 are the addition of keyword arguments and the change to use UTF-8 as the default source file encoding. There are a number of additions to the standard library, including: * @Enumerator::Lazy@, which adds support for lazy access to potentially infinite lists. * Refinements allow you to encapsulate changes to third-party classes, and scope their application to individual source files, preventing your changes from polluting the global application. You'll also find that Ruby 2 is faster, and has memory management improvements that make it more server-friendly. All told, there are over 110 sections of the book that have been flagged and cross-linked to indicate 2.0 content. What You Need * This book assumes you have a basic understanding of object-oriented programming. * In general, Ruby programmers tend to favor the the command line for running their code, and they tend to use text editors rather than IDEs.

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. SQL programmers, analysts, data scientists, database administrators, and even relatively casual SQL users will find SQL Cookbook to be a valuable problem-solving guide for everyday issues. No other resource offers recipes in this unique format to help you tackle nagging day-to-day conundrums with SQL. The second edition includes: Fully revised recipes that recognize the greater adoption of window functions in SQL implementations Additional recipes that reflect the widespread adoption of common table expressions (CTEs) for more readable, easier-to-implement solutions New recipes to make SQL more useful for people who aren't database experts, including data scientists Expanded solutions for working with numbers and strings Up-to-date SQL recipes throughout the book to guide you through the basics

This student-friendly book provides an accessible overview of the primary debates about the effects of video games. It expands on the original The Video Game Debate to address the new technologies that have emerged within the field of game studies over the last few years. Debates about the negative effects of video game play have been evident since their introduction in the 1970s, but the advent of online and mobile gaming has revived these concerns, reinvigorating old debates and generating brand new ones. The Video Game Debate 2 draws from the latest research findings from the top scholars of digital games research to address these concerns. The book explores key developments such as virtual and augmented reality, the use of micro-transactions, the integration of loot boxes, and the growth of mobile gaming and games for change (serious games). Furthermore, several new chapters explore contemporary debates around e-sports, gamification, sex and gender discrimination in games, and the use of games in therapy. This book offers students and scholars of games studies and digital media, as well as policymakers, the essential information they need to participate in the debate.