Mastering PostgreSQL 13. Build, administer, and maintain database applications efficiently with PostgreSQL 13 - Fourth Edition

Hans-Jürgen Schönig

Thanks to its reliability, robustness, and high performance, PostgreSQL has become one of the most advanced open source databases on the market. This updated fourth edition will help you understand PostgreSQL administration and how to build dynamic database solutions for enterprise apps with the latest release of PostgreSQL, including designing both physical and technical aspects of the system architecture with ease.Starting with an introduction to the new features in PostgreSQL 13, this book will guide you in building efficient and fault-tolerant PostgreSQL apps. You’ll explore advanced PostgreSQL features, such as logical replication, database clusters, performance tuning, advanced indexing, monitoring, and user management, to manage and maintain your database. You’ll then work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and move from Oracle to PostgreSQL. The book also covers transactions, locking, and indexes, and shows you how to improve performance with query optimization. You’ll also focus on how to manage network security and work with backups and replication while exploring useful PostgreSQL extensions that optimize the performance of large databases.By the end of this PostgreSQL book, you’ll be able to get the most out of your database by executing advanced administrative tasks.

Practical Threat Detection Engineering. A hands-on guide to planning, developing, and validating detection capabilities

Megan Roddie, Jason Deyalsingh, Gary J. Katz

Threat validation is the backbone of every strong security detection strategy—it ensures your detection pipeline is effective, reliable, and resilient against real-world threats.This comprehensive guide is designed for those new to detection validation, offering clear, actionable frameworks to help you assess, test, and refine your security detections with confidence. Covering the entire detection lifecycle, from development to validation, this book provides real-world examples, hands-on tutorials, and practical projects to solidify your skills.Beyond just technical know-how, this book empowers you to build a career in detection engineering, equipping you with the essential expertise to thrive in today’s cybersecurity landscape.By the end of this book, you'll have the tools and knowledge to fortify your organization’s defenses, enhance detection accuracy, and stay ahead of cyber threats.

Microsoft 365 Certified Fundamentals MS-900 Exam Guide. Gain the knowledge and problem-solving skills needed to pass the MS-900 exam on your first attempt - Third Edition

Aaron Guilmette, Yura Lee, Marcos Zanre

The MS-900 exam tests your understanding of Microsoft 365 services and components, along with their implementation, security, licensing, and general cloud concepts. This revised third edition helps you gain detailed actionable insights into the topics included in the latest syllabus, covering each topic according to its weight in the exam.You’ll begin by reviewing key cloud concepts, including cloud computing, services, and development models, and then explore different cloud architectures and learn what Microsoft offers as a service in the form of SaaS, IaaS, and PaaS. As you advance, you’ll get to grips with core Microsoft 365 components as well as the processes and tools used for managing Windows 10, Windows 11, and Microsoft 365 apps. This edition also includes expanded information on the Microsoft Viva Suite, formerly Workplace Analytics. The chapters shed light on security, compliance, privacy, and trust in Microsoft 365, and provide additional guidance regarding the pricing and support offered by Microsoft for different services and apps.By the end of this MS-900 book, you’ll have gained all the knowledge and skills needed to confidently appear for the exam.

Game Development Patterns with Godot 4. Create resilient game systems using industry-standard solutions in Godot

Henrique Campos

Game development demands more than just creativity; it requires code that’s as dynamic and adaptable as the games you dream of creating. Seasoned Godot developer, educator and creator of popular resources like The Essential Guide to Creating Multiplayer Games with Godot 4.0, Henrique Campos introduces you to object-oriented programming design patterns, offering time-tested, reliable solutions to common coding issues. With these patterns, you’ll not only build scalable, maintainable architectures for your games but also gain the confidence to tackle real-world development challenges head-on with Godot's built-in features.In this hands-on guide, you’ll step into the role of a game mechanics engineer tasked with implementing requests from a fictional game designer, simulating the collaborative nature of real-world game development. Using Godot 4.3, you’ll develop a complete platformer game featuring a playable character, enemies with advanced AI, interactive objects, multiple levels, music, and more. Along the way, you’ll master core programming concepts such as SOLID principles, favor composition over inheritance, and have a solid understanding of object-oriented programming along with the principles behind the design patterns.By the end of the book, you’ll be able to diagnose and fix pathologies in your code with ease.

Learning ArcGIS for Desktop. Create, analyze, and map your spatial data with ArcGIS for Desktop

Daniela C Docan

ArcGIS for Desktop is one of the main components of the ESRI ArcGIS platform used to support decision making and solve real-world mapping problems. Learning ArcGIS for Desktop is a tutorial-based guide that provides a practical experience for those who are interested in start working with ArcGIS. The first five chapters cover the basic concepts of working with the File Geodatabase, as well as editing and symbolizing geospatial data. Then, the book focuses on planning and performing spatial analysis on vector and raster data using the geoprocessing and modeling tools. Finally, the basic principles of cartography design will be used to create a quality map that presents the information that resulted from the spatial analysis previously performed. To keep you learning throughout the chapters, all exercises have partial and final results stored in the dataset that accompanies the book. Finally, the book offers more than it promises by using the ArcGIS Online component in the tutorials as source of background data and for results sharing

Jira Quick Start Guide. Manage your projects efficiently using the all-new Jira

Ravi Sagar

Jira is an issue tracker and project management system. With their latest release, the Jira team has now expanded their user base to agile teams as well as business teams. This book provides a comprehensive explanation covering all major components of Jira, including Jira Software, Jira Core, and Jira Service Desk.This book starts with an introduction to Jira's unique features and how it can be used as an issue-tracking tool. It will then teach you about how a new project is created by a Jira administrator, what responsibilities there are, and using correct and relevant schemes in your project. You will then learn how to configure project workflows and fields for project screens.You will understand the various permissions used in projects and the importance of project roles in Jira. Then, the book talks about the concepts of versions acting as milestones and using components when handling issues in your projects. It will then focus on analysing data using built-in reports and creating dashboards in Jira. At the end, it will discuss various best practices for users as well as project managers or project administrators.

Automate Testing for Power Apps. A practical guide to applying low-code automation testing tools and techniques

César Calvo, Carlos de Huerta

Low-code testing helps build better applications, freeing developers from frustrating problems faced while enhancing app features. Automate Testing for Power Apps will help you use automation testing to build better Canvas apps. You’ll start by understanding the fundamentals of automation testing, different approaches for low-code testing, and its application to Power Apps. Next, you’ll learn how to use Test Studio, Power Automate Desktop, and other tools to automate testing for your Canvas apps. You'll find out how to incorporate testing into your deployment processes for faster and more reliable releases. Additionally, this book covers advanced topics such as PCF components testing and model-driven apps. You’ll discover the new open-source project, Power Apps Test Engine, that’ll provide you with a single automated testing platform for all Power Apps. You'll learn how to test these more complex components to ensure the highest quality and business value for your Power Apps. By the end of this book, you'll have become a pro at using automation testing to build better Power Apps, reduce app release times, and increase the quality of your applications.

CoffeeScript Application Development. What JavaScript user wouldn't want to be able to dramatically reduce application development time? This book will teach you the clean, elegant CoffeeScript language and show you how to build stunning applications

Ian Young, Ian Greenleaf Young

JavaScript is becoming one of the key languages in web development. It is now more important than ever across a growing list of platforms. CoffeeScript puts the fun back into JavaScript programming with elegant syntax and powerful features.CoffeeScript Application Development will give you an in-depth look at the CoffeeScript language, all while building a working web application. Along the way, you'll see all the great features CoffeeScript has to offer, and learn how to use them to deal with real problems like sprawling codebases, incomplete data, and asynchronous web requests.Through the course of this book you will learn the CoffeeScript syntax and see it demonstrated with simple examples. As you go, you'll put your new skills into practice by building a web application, piece by piece. You'll start with standard language features such as loops, functions, and string manipulation. Then, we'll delve into advanced features like classes and inheritance. Learn advanced idioms to deal with common occurrences like external web requests, and hone your technique for development tasks like debugging and refactoring.CoffeeScript Application Development will teach you not only how to write CoffeeScript, but also how to build solid applications that run smoothly and are a pleasure to maintain.

C++ Fundamentals. Hit the ground running with C++, the language that supports tech giants globally

Antonio Mallia, Francesco Zoffoli

C++ Fundamentals begins by introducing you to the C++ compilation model and syntax. You will then study data types, variable declaration, scope, and control flow statements. With the help of this book, you'll be able to compile fully working C++ code and understand how variables, references, and pointers can be used to manipulate the state of the program. Next, you will explore functions and classes — the features that C++ offers to organize a program — and use them to solve more complex problems. You will also understand common pitfalls and modern best practices, especially the ones that diverge from the C++98 guidelines.As you advance through the chapters, you'll study the advantages of generic programming and write your own templates to make generic algorithms that work with any type. This C++ book will guide you in fully exploiting standard containers and algorithms, understanding how to pick the appropriate one for each problem. By the end of this book, you will not only be able to write efficient code but also be equipped to improve the readability, performance, and maintainability of your programs.

Swift 3 Game Development. Build iOS 10 Games with Swift 3.0 - Second Edition

Stephen Haney

Swift is the perfect choice for game development. Developers are intrigued by Swift 3.0 and want to make use of new features to develop their best games yet. Packed with best practices and easy-to-use examples, this book leads you step by step through the development of your first Swift game.This book starts by introducing SpriteKit and Swift's new features that can be used for game development. After setting up your first Swift project, you will build your first custom class, learn how to draw and animate your game, and add physics simulations.Then, you will add the player character, NPCs, and powerups. To make your game more fun and engaging, you will learn how to set up scenes and backgrounds, build fun menus, and integrate with Apple Game Center to add leaderboards and achievements. You will then make your game stand out by adding animations when game objects collide, and incorporate proven techniques such as the advanced particle system and graphics. Finally, you will explore the various options available to start down the path towards monetization and publish your finished games to the App Store.By the end of this book, you will be able to create your own iOS games using Swift and SpriteKit.

IoT Projects with Bluetooth Low Energy. Harness the power of connected things

Madhur Bhargava

Bluetooth Low Energy, or Bluetooth Smart, is Wireless Personal Area networking aimed at smart devices and IoT applications. BLE has been increasingly adopted by application developers and IoT enthusiasts to establish connections between smart devices.This book initially covers all the required aspects of BLE, before you start working on IoT projects. In the initial stages of the book, you will learn about the basic aspects of Bluetooth Low Energy—such as discovering devices, services, and characteristics—that will be helpful for advanced-level projects. This book will guide you through building hands-on projects using BLE and IoT. These projects include tracking health data, using a mobile App, and making this data available for health practitioners; Indoor navigation; creating beacons using the Raspberry Pi; and warehouse weather Monitoring. This book also covers aspects of Bluetooth 5 (the latest release) and its effect on each of these projects.By the end of this book, you will have hands-on experience of using Bluetooth Low Energy to integrate with smart devices and IoT projects.

LiveCode Mobile Development Beginner's Guide. With this book and your basic programming knowledge, you’ll find it easy to use LiveCode to create mobile apps for Android and iOS. A great starting point for taking the app store by storm

Colin Holgate

LiveCode is a tool for developing mobile apps designed for those who don't want to use Objective-C, C++ or Java. Although it is a tool full of rich features to create apps it can be challenging to get beyond the basics and build interactive and fun apps. Using this book, you can develop various apps and this book guides you through till you upload the apps in the appstore.LiveCode Mobile Development Beginner's Guide will explain how to create applications with the easiest, most practical cross platform framework available, Livecode Mobile and upload the apps to the appstore with minimal effort.Throughout the book, you'll learn details that will help you become a pro at mobile app development using LiveCode. You begin with simple calculator application and quickly enhance it using LiveCode Mobile. Start by learning the interface controls for videos and images of LiveCode's environment. Dig into configuring devices, building user interfaces, and making rich media applications, then finish by uploading the mobile applications to App Stores. You will learn how to build apps for devices such as iPhone, Android with the recently developed LiveCode Mobile through sample applications of increasing complexity.

Learning Python Application Development. Click here to enter text

Ninad Sathaye

Python is one of the most widely used dynamic programming languages, supported by a rich set of libraries and frameworks that enable rapid development. But fast paced development often comes with its own baggage that could bring down the quality, performance, and extensibility of an application. This book will show you ways to handle such problems and write better Python applications.From the basics of simple command-line applications, develop your skills all the way to designing efficient and advanced Python apps. Guided by a light-hearted fantasy learning theme, overcome the real-world problems of complex Python development with practical solutions. Beginning with a focus on robustness, packaging, and releasing application code, you’ll move on to focus on improving application lifetime by making code extensible, reusable, and readable. Get to grips with Python refactoring, design patterns and best practices. Techniques to identify the bottlenecks and improve performance are covered in a series of chapters devoted to performance, before closing with a look at developing Python GUIs.

Oracle Warehouse Builder 11g: Getting Started. Extract, Transform, and Load data to build a dynamic, operational data warehouse

Bob Griesemer, Robert E Griesemer

In today's economy, businesses and IT professionals cannot afford to lag behind the latest technologies. Data warehousing is a critical area to the success of many enterprises, and Oracle Warehouse Builder is a powerful tool for building data warehouses. It comes free with the latest version of the Oracle database.Written in an accessible, informative, and focused manner, this book will teach you to use Oracle Warehouse Builder to build your data warehouse. Covering warehouse design, the import of source data, the ETL cycle and more, this book will have you up and running in next to no time.This book will walk you through the complete process of planning, building, and deploying a data warehouse using Oracle Warehouse Builder. By the book's end, you will have built your own data warehouse from scratch.Starting with the installation of the Oracle Database and Warehouse Builder software, this book then covers the analysis of source data, designing a data warehouse, and extracting, transforming, and loading data from the source system into the data warehouse. You'll follow the whole process with detailed screenshots of key steps along the way, alongside numerous tips and hints not covered by the official documentation.

Kivy - Interactive Applications and Games in Python. Create responsive cross-platform UI/UX applications and games in Python using the open source Kivy library

Roberto Ulloa

Burp Suite Cookbook. Practical recipes to help you master web penetration testing with Burp Suite

Sunny Wear

Burp Suite is a Java-based platform for testing the security of your web applications, and has been adopted widely by professional enterprise testers.The Burp Suite Cookbook contains recipes to tackle challenges in determining and exploring vulnerabilities in web applications. You will learn how to uncover security flaws with various test cases for complex environments. After you have configured Burp for your environment, you will use Burp tools such as Spider, Scanner, Intruder, Repeater, and Decoder, among others, to resolve specific problems faced by pentesters. You will also explore working with various modes of Burp and then perform operations on the web. Toward the end, you will cover recipes that target specific test scenarios and resolve them using best practices.By the end of the book, you will be up and running with deploying Burp for securing web applications.