Learn T-SQL Querying. A guide to developing efficient and elegant T-SQL code - Second Edition

Pedro Lopes, Pam Lahoud

Data professionals seeking to excel in Transact-SQL for Microsoft SQL Server and Azure SQL Database often lack comprehensive resources. Learn T-SQL Querying second edition focuses on indexing queries and crafting elegant T-SQL code enabling data professionals gain mastery in modern SQL Server versions (2022) and Azure SQL Database. The book covers new topics like logical statement processing flow, data access using indexes, and best practices for tuning T-SQL queries.Starting with query processing fundamentals, the book lays a foundation for writing performant T-SQL queries. You’ll explore the mechanics of the Query Optimizer and Query Execution Plans, learning to analyze execution plans for insights into current performance and scalability. Using dynamic management views (DMVs) and dynamic management functions (DMFs), you’ll build diagnostic queries. The book covers indexing and delves into SQL Server’s built-in tools to expedite resolution of T-SQL query performance and scalability issues. Hands-on examples will guide you to avoid UDF pitfalls and understand features like predicate SARGability, Query Store, and Query Tuning Assistant. By the end of this book, you‘ll have developed the ability to identify query performance bottlenecks, recognize anti-patterns, and avoid pitfalls

The Ultimate iOS Interview Playbook. Conquer Swift, frameworks, design patterns, and app architecture for your dream job

Avi Tsadok

As an iOS developer, you must possess a diverse skill set encompassing Swift coding, design knowledge, and mastery of development tools. And while the demand for iOS developers remains high, the competition for landing your dream job has intensified in recent years. Being a skilled iOS developer is no longer enough — acing interviews is now just as essential as having technical expertise.In The Ultimate iOS Interview Playbook, you'll discover innovative ways to stand out as an iOS developer and pass every job interview. It will guide you to build your developer brand and present your skills to potential employers. This comprehensive guide covers over 100 interview questions, from Swift fundamentals and frameworks to complex design patterns and app architecture. You'll learn how to approach coding assessments like a pro and avoid red flags that could hinder your chances of success.Drawing from the author’s experience of interviewing hundreds of iOS developers and having been a candidate themself, this book addresses the challenges of showcasing your skills and knowledge within a limited timeframe.By the end of this book, you'll be ready to excel in any iOS interview, demonstrating your strengths and confidently tackling even the most challenging questions, ultimately paving the way to secure the job you've always wanted.

SAP NetWeaver MDM 7.1 Administrator's Guide

Uday Rao

Instant Apache Camel Messaging System. Tackle integration problems and learn practical ways to make data flow between your application and other systems using Apache Camel

Evgeniy Sharapov

There are many ways to handle data exchange between applications and systems. Apache Camel is a lightweight integration framework that trades in complexity to focus on simplicity, elegance, and flexibility instead. This book teaches you to handle data exchange using the messaging functions of the Apache Camel framework.Instant Apache Camel Messaging System is a practical, hands-on guide that provides you with step-by-step instructions which will help you to take advantage of the Apache Camel integration framework using Maven, the Spring Framework, and the TDD approach.Instant Apache Camel Messaging System introduces you to Apache Camel and provides easy-to-follow instructions on how to set up a Maven-based project and how to use unit tests and mocks to develop your application in a “test first, code later” manner. This book will help you take advantage of modern Java development infrastructures including the Spring Framework, Java DSL, Spring DSL, and Apache Camel to enhance your application.If you are looking at ways to connect various systems and applications and wondering how to configure data flow in a simple and elegant manner, then Apache Camel is for you, and this book will show you where to begin.

Getting Started with Tableau 2019.2. Effective data visualization and business intelligence with the new features of Tableau 2019.2 - Second Edition

Tristan Guillevin

Tableau is one of the leading data visualization tools and is regularly updated with new functionalities and features. The latest release, Tableau 2019.2, promises new and advanced features related to visual analytics, reporting, dashboarding, and a host of other data visualization aspects. Getting Started with Tableau 2019.2 will get you up to speed with these additional functionalities.The book starts by highlighting the new functionalities of Tableau 2019.2, providing concrete examples of how to use them. However, if you're new to Tableau, you won't have to worry as the book also covers the major aspects of Tableau with relevant examples. You'll learn how to connect to data, build a data source, visualize your data, build a dashboard, and even share data online. In the concluding chapters, you'll delve into advanced techniques such as creating a cross-database join and data blending.By the end of this book, you will be able to use Tableau effectively to create quick, cost-effective, and business-efficient Business Intelligence (BI) solutions.

Kubernetes Secrets Handbook. Design, implement, and maintain production-grade Kubernetes Secrets management solutions

Emmanouil Gkatziouras, Rom Adams, Chen Xi, Chris Jenkins

Securing Secrets in containerized apps poses a significant challenge for Kubernetes IT professionals. This book tackles the critical task of safeguarding sensitive data, addressing the limitations of Kubernetes encryption, and establishing a robust Secrets management system for heightened security for Kubernetes.Starting with the fundamental Kubernetes architecture principles and how they apply to the design of Secrets management, this book delves into advanced Kubernetes concepts such as hands-on security, compliance, risk mitigation, disaster recovery, and backup strategies. With the help of practical, real-world guidance, you’ll learn how to mitigate risks and establish robust Secrets management as you explore different types of external secret stores, configure them in Kubernetes, and integrate them with existing Secrets management solutions.Further, you'll design, implement, and operate a secure method of managing sensitive payload by leveraging real use cases in an iterative process to enhance skills, practices, and analytical thinking, progressively strengthening the security posture with each solution.By the end of this book, you'll have a rock-solid Secrets management solution to run your business-critical applications in a hybrid multi-cloud scenario, addressing operational risks, compliance, and controls.

Internet of Things Programming Projects. Build exciting IoT projects using Raspberry Pi 5, Raspberry Pi Pico, and Python - Second Edition

Colin Dow

Renowned for its versatility, affordability, and active community support, Raspberry Pi is at the forefront of IoT development. Unlock the vast potential of Raspberry Pi and Raspberry Pi Pico by learning how to develop practical projects with this updated edition of Internet of Things Programming Projects.Written by an expert programmer who’s worked for some of Canada’s largest companies, this book starts with foundational concepts and practical exercises such as building a basic weather indicator, and gradually progressed toward more complex projects. You’ll get to grips with coding nuances and web service integrations that will help you create a sophisticated IoT robot car equipped with motor control, wireless communication, and sensor amalgamation. The book also explores LoRa technology, a game-changer for long-range, low-power communication in your projects, and delves into robot car development by implementing the Robot Operating System (ROS) for advanced control and coordination.Through clear, step-by-step instructions and insightful explanations, you’ll gain the skills and confidence to develop innovative IoT solutions for real-world applications. By the end of the book, you’ll have mastered the intricacies of IoT programming, from harnessing Raspberry Pi's capabilities to seamlessly integrating external components.

Quantum Machine Learning and Optimisation in Finance. On the Road to Quantum Advantage

Antoine Jacquier, Oleksiy Kondratyev, Alexander Lipton, Marcos López de Prado

With recent advances in quantum computing technology, we finally reached the era of Noisy Intermediate-Scale Quantum (NISQ) computing. NISQ-era quantum computers are powerful enough to test quantum computing algorithms and solve hard real-world problems faster than classical hardware.Speedup is so important in financial applications, ranging from analysing huge amounts of customer data to high frequency trading. This is where quantum computing can give you the edge. Quantum Machine Learning and Optimisation in Finance shows you how to create hybrid quantum-classical machine learning and optimisation models that can harness the power of NISQ hardware.This book will take you through the real-world productive applications of quantum computing. The book explores the main quantum computing algorithms implementable on existing NISQ devices and highlights a range of financial applications that can benefit from this new quantum computing paradigm.This book will help you be one of the first in the finance industry to use quantum machine learning models to solve classically hard real-world problems. We may have moved past the point of quantum computing supremacy, but our quest for establishing quantum computing advantage has just begun!

Blueprints Visual Scripting for Unreal Engine. The faster way to build games using UE4 Blueprints - Second Edition

Marcos Romero, Brenden Sewell

Blueprints is the visual scripting system in Unreal Engine that enables programmers to create baseline systems and can be extended by designers.This book helps you explore all the features of the Blueprint Editor and guides you through using Variables, Macros, and Functions. You’ll also learn about object-oriented programming (OOP) and discover the Gameplay Framework. In addition to this, you’ll learn how Blueprint Communication allows one Blueprint to access information from another Blueprint. Later chapters will focus on building a fully functional game using a step-by-step approach. You’ll start with a basic first-person shooter (FPS) template, and each chapter will build on the prototype to create an increasingly complex and robust game experience. You’ll then progress from creating basic shooting mechanics to more complex systems, such as user interface elements and intelligent enemy behavior. The skills you will develop using Blueprints can also be employed in other gaming genres. In the concluding chapters, the book demonstrates how to use arrays, maps, enums, and vector operations. Finally, you’ll learn how to build a basic VR game.By the end of this book, you’ll have learned how to build a fully functional game and will have the skills required to develop an entertaining experience for your audience.

Instant Java Password and Authentication Security. A practical, hands-on guide to securing Java application passwords with hashing techniques

Fernando Mayoral

Password security is a critical matter when it comes to protecting the interests of application users and their data for a satisfactory user experience. With the advancement in technology, now more than ever, application developers need to be able to implement reliable mechanisms to prevent passwords from being stolen. Java Password and Authentication Security provides a practical approach to implement these reliable mechanisms with the possibility to make password authentication stronger as technology makes it easier to break them.Java Password and Authentication Security is a practical, hands-on guide covering a number of clear, step-by-step exercises and code examples that will help you to implement strong password authentication solutions for your project in no time.This book starts off with the most basic and well known hashing technique to quickly get an application developer started with implementing a standard password protection mechanism. Furthermore, it covers the stronger SHA (standard hashing algorithm) family in detail and brings up a technique to improve the hash security with a technique called “salting”.You will also learn how to use these hashes, and more importantly, when to use each technique. You will learn that not every hash algorithm is good in every situation, and how to deal with password recovery, password authentication, and timing attacks.

Mastering PHP Design Patterns. Click here to enter text

Junade Ali

Design patterns are a clever way to solve common architectural issues that arise during software development. With an increase in demand for enhanced programming techniques and the versatile nature of PHP, a deep understanding of PHP design patterns is critical to achieve efficiency while coding. This comprehensive guide will show you how to achieve better organization structure over your code through learning common methodologies to solve architectural problems. You’ll also learn about the new functionalities that PHP 7 has to offer. Starting with a brief introduction to design patterns, you quickly dive deep into the three main architectural patterns: Creational, Behavioral, and Structural popularly known as the Gang of Four patterns. Over the course of the book, you will get a deep understanding of object creation mechanisms, advanced techniques that address issues concerned with linking objects together, and improved methods to access your code. You will also learn about Anti-Patterns and the best methodologies to adopt when building a PHP 7 application. With a concluding chapter on best practices, this book is a complete guide that will equip you to utilize design patterns in PHP 7 to achieve maximum productivity, ensuring an enhanced software development experience.

Django 4 By Example. Build powerful and reliable Python web applications from scratch - Fourth Edition

Antonio Melé, Bob Belderbos

Django 4 By Example is the 4th edition of the best-selling franchise that helps you build web apps. This book will walk you through the creation of real-world applications, solving common problems, and implementing best practices using a step-by-step approach.You'll cover a wide range of web app development topics as you build four different apps:A blog application: Create data models, views, and URLs and implement an admin site for your blog. Create sitemaps and RSS feeds and implement a full-text search engine with PostgreSQL.A social website: Implement authentication with Facebook, Twitter, and Google. Create user profiles, image thumbnails, a bookmarklet, and an activity stream. Implement a user follower system and add infinite scroll pagination to your website.An e-commerce application: Build a product catalog, a shopping cart, and asynchronous tasks with Celery and RabbitMQ. Process payments with Stripe and manage payment notifications via webhooks. Build a product recommendation engine with Redis. Create PDF invoices and export orders to CSV.An e-learning platform: Create a content management system to manage polymorphic content. Cache content with Memcached and Redis. Build and consume a RESTful API. Implement a real-time chat using WebSockets with ASGI. Create a production environment using NGINX, uWSGI and Daphne with Docker Compose.This is a practical book that will have you creating web apps quickly.

Transformers for Natural Language Processing. Build innovative deep neural network architectures for NLP with Python, PyTorch, TensorFlow, BERT, RoBERTa, and more

Denis Rothman

The transformer architecture has proved to be revolutionary in outperforming the classical RNN and CNN models in use today. With an apply-as-you-learn approach, Transformers for Natural Language Processing investigates in vast detail the deep learning for machine translations, speech-to-text, text-to-speech, language modeling, question answering, and many more NLP domains with transformers.The book takes you through NLP with Python and examines various eminent models and datasets within the transformer architecture created by pioneers such as Google, Facebook, Microsoft, OpenAI, and Hugging Face.The book trains you in three stages. The first stage introduces you to transformer architectures, starting with the original transformer, before moving on to RoBERTa, BERT, and DistilBERT models. You will discover training methods for smaller transformers that can outperform GPT-3 in some cases. In the second stage, you will apply transformers for Natural Language Understanding (NLU) and Natural Language Generation (NLG). Finally, the third stage will help you grasp advanced language understanding techniques such as optimizing social network datasets and fake news identification.By the end of this NLP book, you will understand transformers from a cognitive science perspective and be proficient in applying pretrained transformer models by tech giants to various datasets.

Learning Linux Shell Scripting. Leverage the power of shell scripts to solve real-world problems - Second Edition

Ganesh Sanjiv Naik

Linux is the most powerful and universally adopted OS. Shell is a program that gives the user direct interaction with the operating system. Scripts are collections of commands that are stored in a file. The shell reads this file and acts on commands as if they were typed on the keyboard.Learning Linux Shell Scripting covers Bash, GNU Bourne Again Shell, preparing you to work in the exciting world of Linux shell scripting. CentOS is a popular rpm-based stable and secured Linux distribution. Therefore, we have used CentOS distribution instead of Ubuntu distribution. Linux Shell Scripting is independent of Linux distributions, but we have covered both types of distros. We start with an introduction to the Shell environment and basic commands used. Next, we explore process management in Linux OS, real-world essentials such as debugging and perform Shell arithmetic fluently. You'll then take a step ahead and learn new and advanced topics in Shell scripting, such as decision making, starting up a system, and customizing a Linux environment. You will also learn about grep, stream editor, and AWK, which are very powerful text filters and editors. Finally, you'll get to grips with taking backup, using other language scripts in Shell Scripts as well as automating database administration tasks for MySQL and Oracle.By the end of this book, you will be able to confidently use your own shell scripts in the real world.

Babylon.js Essentials. Understand, train, and be ready to develop 3D Web applications/video games using the Babylon.js framework, even for beginners

Julien Moreau-Mathis

Are you familiar with HTML5? Do you want to build exciting games and Web applications? Then explore the exciting world of game and Web development with one of the best frameworks out there: Babylon.JS.Starting from the beginning, the book introduces the required basics for 3D development and the knowledge you need to use the Babylon.js framework. It focuses on the simplicity provided by Babylon.js and uses a combination of theory and practice. All the chapters are provided with example files ready to run; each example file provides the previously learned features of the framework. Finally, developers will be ready to easily understand new features added to the framework in the future.

Learning C# by Developing Games with Unity 2021. Kickstart your C# programming and Unity journey by building 3D games from scratch - Sixth Edition

Harrison Ferrone

The Learning C# by Developing Games with Unity series has established itself as a popular choice for getting up to speed with C#, a powerful and versatile programming language with a wide array of applications in various domains. This bestselling franchise presents a clear path for learning C# programming from the ground up through the world of Unity game development.This sixth edition has been updated to introduce modern C# features with Unity 2021. A new chapter has also been added that covers reading and writing binary data from files, which will help you become proficient in handling errors and asynchronous operations.The book acquaints you with the core concepts of programming in C#, including variables, classes, and object-oriented programming. You will explore the fundamentals of Unity game development, including game design, lighting basics, player movement, camera controls, and collisions. You will write C# scripts for simple game mechanics, perform procedural programming, and add complexity to your games by introducing smart enemies and damage-causing projectiles.By the end of the book, you will have developed the skills to become proficient in C# programming and built a playable game prototype with the Unity game engine.

Unreal Engine 4 Shaders and Effects Cookbook. Over 70 recipes for mastering post-processing effects and advanced shading techniques

Brais Brenlla Ramos, John P. Doran

Unreal Engine 4 is a powerful game engine, one which has seen a recent boost in widespread adoption thanks to its ease of use and the powerful rendering pipeline that it packs. Seeing as how it's relatively easy to create stunning presentations and visuals, Unreal has quickly become a strong contender in industries where this kind of software had been previously denied entry.With that in mind, this book aims to help you get the most out of Unreal Engine 4 - from creating awe-inspiring graphics to delivering optimized experiences to your users. This is possible thanks to a mixture of hands-on experience with real materials and the theory behind them. You will immediately know how to create that material that you want to display, and you'll also end up with the knowledge that will let you know how to control it.All of this will be done without losing sight of two key components of any real-time application - optimization, and efficiency. The materials that you create will be light and efficient, and they will vary depending on your target platform. You'll know which techniques can be used in any kind of device and which ones should be kept to high-end machines, giving you the confidence to tackle any material-related task that you can imagine. Hop onboard and discover how!

Intel Galileo Networking Cookbook. Over 50 recipes that will help you use the Intel Galileo board to build exciting network-connected projects

Marco Schwartz

Autodesk AutoCAD 2013 Practical 3D Drafting and Design. Take your AuotoCAD design skills to the next dimension by creating powerful 3D models

JOAO ANTONIO C DOS SANTOS

AutoCAD is a computer-aided design (CAD) and drafting software application. AutoCAD supports both 2D and 3D formats. AutoCAD is used in a range of industries and is utilized by architects, project managers, and engineers, among others.Autodesk AutoCAD 2013 Practical 3D Drafting and Design will take you beyond the 2D frontier and help you create accurate 3D models that simulate reality. This book is crammed full of creative and practical tutorials which will help you master the third dimension. From exercises on coordinate systems to creating solids and surfaces from 2D, you will wonder how you ever designed without this resource by your side.Autodesk AutoCAD 2013 Practical 3D Drafting and Design is full of hands-on studies and projects that will help develop your 3D skills. Starting from the assumption of only a very basic knowledge of AutoCAD, this book will help you master 3D visualization and coordinate systems, create 3D models from 2D drawings, and from basic shapes, measure volumes, and other information, obtain 2D construction drawings from 3D models as well as how to apply lights and materials to get photorealistic images.

FL Studio Cookbook. The lofi, retrowave, and horror music chef's guide to FL Studio music production

Chris Rena

Whether it's overcoming creative blocks, troubleshooting technical issues, or refining your workflow, every budding producer faces challenges. The FL Studio Cookbook is here to provide practical solutions to common problems, empowering you to navigate any obstacle with ease by exploring one of the most renowned, industry-standard DAWs.The recipe-based approach of this book means that you’ll unlock the secrets of crafting captivating melodies and learn the art of composition with practical, step-by-step instructions, discovering how to construct melodies that evoke emotion and leave a lasting impression. From chord progressions to counterpoint, you’ll get actionable insights to help you compose music that resonates with your audience. You’ll also master the intricacies of mixing and mastering, by familiarizing yourself with the entire process from balancing levels and sculpting sounds to applying effects. You’ll also explore the endless possibilities of sculpting sound from scratch, whether you're crafting custom synths, designing unique textures, or layering effects to create otherworldly sounds.By the end of this book, you'll have acquired the skills to confidently craft professional-quality lofi, retrowave, and horror music tracks, gaining the expertise to express your musical vision and take your music production to new heights.

Instant OpenCV for iOS. Learn how to build real-time computer vision applications for the iOS platform using the OpenCV library

Kirill Kornyakov, Aleksander Shishkov

Computer vision on mobile devices is becoming more and more popular. Personal gadgets are now powerful enough to process high-resolution images, stitch panoramas, and detect and track objects. OpenCV, with its decent performance and wide range of functionality, can be an extremely useful tool in the hands of iOS developers.Instant OpenCV for iOS is a practical guide that walks you through every important step for building a computer vision application for the iOS platform. It will help you to port your OpenCV code, profile and optimize it, and wrap it into a GUI application. Each recipe is accompanied by a sample project or an example that helps you focus on a particular aspect of the technology.Instant OpenCV for iOS starts by creating a simple iOS application and linking OpenCV before moving on to processing images and videos in real-time. It covers the major ways to retrieve images, process them, and view or export results. Special attention is also given to performance issues, as they greatly affect the user experience.Several computer vision projects will be considered throughout the book. These include a couple of photo filters that help you to print a postcard or add a retro effect to your images. Another one is a demonstration of the facial feature detection algorithm. In several time-critical cases, the processing speed is measured and optimized using ARM NEON and the Accelerate framework.OpenCV for iOS gives you all the information you need to build a high-performance computer vision application for iOS devices.

Taking SketchUp Pro to the Next Level. Go beyond the basics and develop custom 3D modeling workflows to become a SketchUp ninja

Aaron Dietzen aka 'The SketchUp Guy'

Anyone who’s worked with it will know that SketchUp is the quickest and easiest way to create 3D models. While its approachable interface makes it super easy to learn, this book will show you how the extremely capable SketchUp software can take you far beyond what you may have initially thought possible. Get ready to level up from a basic user to becoming a SketchUp ninja!Each chapter will take you through the capabilities of SketchUp, challenging you to use tools in innovative ways. This includes organizing your model, modifying native commands, customizing your interface, utilizing inferencing, and much more. Additionally, you’ll learn about the extensions that can be added to SketchUp to supplement the tools you have been using, allowing you to make your 3D modeling process quicker, easier, and more powerful.By the end of this SketchUp book, you’ll have an enhanced understanding of how to use the impressive range of tools and be on your way to customizing SketchUp for your one-of-a-kind workflow.

Apache Flume: Distributed Log Collection for Hadoop. If your role includes moving datasets into Hadoop, this book will help you do it more efficiently using Apache Flume. From installation to customization, it's a complete step-by-step guide on making the service work for you

Steve Hoffman, Steven Hoffman, Kevin A. McGrail

Apache Flume is a distributed, reliable, and available service for efficiently collecting, aggregating, and moving large amounts of log data. Its main goal is to deliver data from applications to Apache Hadoop's HDFS. It has a simple and flexible architecture based on streaming data flows. It is robust and fault tolerant with many failover and recovery mechanisms.Apache Flume: Distributed Log Collection for Hadoop covers problems with HDFS and streaming data/logs, and how Flume can resolve these problems. This book explains the generalized architecture of Flume, which includes moving data to/from databases, NO-SQL-ish data stores, as well as optimizing performance. This book includes real-world scenarios on Flume implementation.Apache Flume: Distributed Log Collection for Hadoop starts with an architectural overview of Flume and then discusses each component in detail. It guides you through the complete installation process and compilation of Flume.It will give you a heads-up on how to use channels and channel selectors. For each architectural component (Sources, Channels, Sinks, Channel Processors, Sink Groups, and so on) the various implementations will be covered in detail along with configuration options. You can use it to customize Flume to your specific needs. There are pointers given on writing custom implementations as well that would help you learn and implement them.By the end, you should be able to construct a series of Flume agents to transport your streaming data and logs from your systems into Hadoop in near real time.

Extending Jenkins. Get a complete walkthrough of the many interfaces available in Jenkins with the help of real-world examples to take you to the next level with Jenkins

Donald Simpson

Jenkins CI is the leading open source continuous integration server. It is written in Java and has a wealth of plugins to support the building and testing of virtually any project. Jenkins supports multiple Software Configuration Management tools such as Git, Subversion, and Mercurial.This book explores and explains the many extension points and customizations that Jenkins offers its users, and teaches you how to develop your own Jenkins extensions and plugins.First, you will learn how to adapt Jenkins and leverage its abilities to empower DevOps, Continuous Integration, Continuous Deployment, and Agile projects. Next, you will find out how to reduce the cost of modern software development, increase the quality of deliveries, and thereby reduce the time to market. We will also teach you how to create your own custom plugins using Extension points.Finally, we will show you how to combine everything you learned over the course of the book into one real-world scenario.