MySQL 8 Cookbook. Over 150 recipes for high-performance database querying and administration

Karthik Appigatla

MySQL is one of the most popular and widely used relational databases in the World today. The recently released MySQL 8 version promises to be better and more efficient than ever before.This book contains everything you need to know to be the go-to person in your organization when it comes to MySQL. Starting with a quick installation and configuration of your MySQL instance, the book quickly jumps into the querying aspects of MySQL. It shows you the newest improvements in MySQL 8 and gives you hands-on experience in managing high-transaction and real-time datasets. If you've already worked with MySQL before and are looking to migrate your application to MySQL 8, this book will also show you how to do that. The book also contains recipes on efficient MySQL administration, with tips on effective user management, data recovery, security, database monitoring, performance tuning, troubleshooting, and more.With quick solutions to common and not-so-common problems you might encounter while working with MySQL 8, the book contains practical tips and tricks to give you the edge over others in designing, developing, and administering your database effectively.

Microsoft Dynamics NAV 2016 Financial Management. Click here to enter text. - Second Edition

Anju Bala, Cristina Nicolas Lorente, Laura Nicolas Lorente

Microsoft Dynamics NAV is a global Enterprise Resource Planning (ERP) solution that provides small and mid-size businesses with greater control over their finances and a way to simplify their supply chain, manufacturing, and operations.Microsoft Dynamics NAV Financial Management explains all you need to know in order to successfully handle your daily financial management tasks. This book walks you through all the improvements in the latest release and shows you how to apply them in your workplace. You will learn about functionalities including sales and purchase processes, payments, bank account management, reporting taxes, budgets, cash flow, fixed assets, cost accounting, inventory valuation, workflows, sending and receiving electronic documents, and business intelligence. This book comprehensively covers all the financial management features inside the latest version of Dynamics NAV and follows a logical schema. By the time you’re finished this book you will have learned about budgets, cash flow management, currencies, intercompany postings, and accounting implications in areas such as jobs, services, warehousing, and manufacturing.

Windows Server 2016 Administration Fundamentals. Deploy, set up, and deliver network services with Windows Server while preparing for the MTA 98-365 exam and pass it with ease

Bekim Dauti

Windows Server 2016 is the server operating system developed by Microsoft as part of the Windows NT family of operating systems, developed concurrently with Windows 10. This book is designed to get you started with Windows Server 2016. It will prepare you for your MTA 98-365 exam. With step-by-step instructions driven by targeted, easy-to-understand graphics, you will be able to understand the roles, features, functions, and quirks of Windows Server 2016.The book begins with the basics of Windows Server 2016, which includes the installation process and basic configuration. You will then move on to roles and features such as Active Directory, Hyper-V, Remote Access, Storage, and Printer. With the help of real-world examples, you will get to grips with the fundamentals of Windows Server 2016, which will help you solve difficult tasks the easy way. Later, the book also shows you maintenance and troubleshooting tasks, where with the help of best practices you will be able to manage Windows Server 2016 with ease. Each chapter ends with a questionnaire to ensure you make the best use of the content provided. By the end of this book, you will have the knowledge required to administer and manage Windows Server environments.

Mapping with ArcGIS Pro. Design accurate and user-friendly maps to share the story of your data

Amy Rock, Ryan Malhoski

ArcGIS Pro is a geographic information system for working with maps and geographic information. This book will help you create visually stunning maps that increase thelegibility of the stories being mapped and introduce visual and design concepts intoa traditionally scientific, data-driven process. The book begins by outlining the stepsof gathering data from authoritative sources and lays out the workflow of creating a great map. Once the plan is in place you will learn how to organize the Contents Pane in ArcGIS Pro and identify the steps involved in streamlining the production process. Then you will learn Cartographic Design techniques using ArcGIS Pro's feature set to organize thepage structure and create a custom set of color swatches. You will be then exposedto the techniques required to ensure your data is clear and legible no matter the sizeor scale of your map. The later chapters will help you understand the various projectionsystems, trade-offs between them, and the proper applications of them to make sureyour maps are accurate and visually appealing. Finally, you will be introducedto the ArcGIS Online ecosystem and how ArcGIS Pro can utilize it within theapplication. You will learn Smart Mapping, a new feature of ArcGIS Online that willhelp you to make maps that are visually stunning and useful.By the end of this book, you will feel more confident in making appropriate cartographic decisions.

Learning C# 7 By Developing Games with Unity 2017. Learn C# Programming by building fun and interactive games with Unity - Third Edition

Micael DaGraça

Do you want to learn C# programming by creating fun and interactive games using the latest Unity 2017 platform? If so, look no further; this is the right book for you. Get started with programming C# so you can create 2D and 3D games in Unity. We will walk you through the basics to get you started with C# 7 and its latest features. Then, explore the use of C# 7 and its latest functional programming capabilities to create amazing games with Unity 2017.You will create your first C# script for Unity, add objects into it, and learn how to create game elements with it. Work with the latest functional programming features of C# and leverage them for great game scripting.Throughout the book, you will learn to use the new Unity 2017 2D tool set and create an interactive 2D game with it. You will make enemies appear to challenge your player, and discover some optimization techniques for great game performance. At the end, you will learn how to transform a 2D game into 3D, and you will be able to skill up to become a pro C# programmer with Unity 2017!

Modern Big Data Processing with Hadoop. Expert techniques for architecting end-to-end big data solutions to get valuable insights

V Naresh Kumar, Prashant Shindgikar

The complex structure of data these days requires sophisticated solutions for data transformation, to make the information more accessible to the users.This book empowers you to build such solutions with relative ease with the help of Apache Hadoop, along with a host of other Big Data tools.This book will give you a complete understanding of the data lifecycle management with Hadoop, followed by modeling of structured and unstructured data in Hadoop. It will also show you how to design real-time streaming pipelines by leveraging tools such as Apache Spark, and build efficient enterprise search solutions using Elasticsearch. You will learn to build enterprise-grade analytics solutions on Hadoop, and how to visualize your data using tools such as Apache Superset. This book also covers techniques for deploying your Big Data solutions on the cloud Apache Ambari, as well as expert techniques for managing and administering your Hadoop cluster. By the end of this book, you will have all the knowledge you need to build expert Big Data systems.

Learning Docker. Build, ship, and scale faster - Second Edition

Vinod Singh, Pethuru Raj, Jeeva S. Chelladhurai

Docker is an open source containerization engine that offers a simple and faster way for developing and running software. Docker containers wrap software in a complete filesystem that contains everything it needs to run, enabling any application to be run anywhere – this flexibily and portabily means that you can run apps in the cloud, on virtual machines, or on dedicated servers.This book will give you a tour of the new features of Docker and help you get started with Docker by building and deploying a simple application. It will walk you through the commands required to manage Docker images and containers. You’ll be shown how to download new images, run containers, list the containers running on the Docker host, and kill them. You’ll learn how to leverage Docker’s volumes feature to share data between the Docker host and its containers – this data management feature is also useful for persistent data. This book also covers how to orchestrate containers using Docker compose, debug containers, and secure containers using the AppArmor and SELinux security modules.

ArcPy and ArcGIS. Automating ArcGIS for Desktop and ArcGIS Online with Python - Second Edition

Silas Toms, Dara OBeirne

ArcGIS allows for complex analyses of geographic information. The ArcPy module is used to script these ArcGIS analyses, providing a productive way to perform geo-analyses and automate map production.The second edition of the book focuses on new Python tools, such as the ArcGIS API for Python. Using Python, this book will guide you from basic Python scripting to advanced ArcPy script tools.This book starts off with setting up your Python environment for ArcGIS automation. Then you will learn how to output maps using ArcPy in MXD and update feature class in a geodatabase using arcpy and ArcGIS Online. Next, you will be introduced to ArcREST library followed by examples on querying, updating and manipulating ArcGIS Online feature services. Further, you will be enabling your scripts in the browser and directly interacting with ArcGIS Online using Jupyter notebook. Finally, you can learn ways to use of ArcPy to control ArcGIS Enterprise and explore topics on deployments, data quality assurances, data updates, version control, and editing safeguards.By the end of the book, you will be equipped with the knowledge required to create automated analysis with administration reducing the time-consuming nature of GIS.