Plan and build useful machine learning systems for financial services, with full working Python code Key Features * Build machine learning systems that will be useful across the financial services industry * Discover how machine learning can solve finance industry challenges * Gain the machine learning insights and skills fintech companies value most Book Description Machine learning skills are essential for anybody working in financial data analysis. Machine Learning for Finance shows you how to build machine learning models for use in financial services organizations. It shows you how to work with all the key machine learning models, from simple regression to advanced neural networks. You will see how to use machine learning to automate manual tasks, identify and address systemic bias, and find new insights and patterns hidden in available data. Machine Learning for Finance encourages and equips you to find new ways to use data to serve an organization’s business goals. Broad in scope yet deeply practical in approach, Machine Learning for Finance will help you to apply machine learning in all parts of a financial organization’s infrastructure. If you work or plan to work in fintech, and want to gain one of the most valuable skills in the sector today, this book is for you. What you will learn * Practical machine learning for the finance sector * Build machine learning systems that support the goals of financial organizations * Think creatively about problems and how machine learning can solve them * Identify and reduce sources of bias from machine learning models * Apply machine learning to structured data, natural language, photographs, and written text related to finance * Use machine learning to detect fraud, forecast financial trends, analyze customer sentiments, and more * Implement heuristic baselines, time series, generative models, and reinforcement learning in Python, scikit-learn, Keras, and TensorFlow Who this book is for Machine Learning for Finance is for financial professionals who want to develop and apply machine learning skills, and for students entering the field. You should be comfortable with Python and the basic data science stack, such as NumPy, pandas, and Matplotlib, to get the most out of this book.

Leverage the features of Azure SQL database and become an expert in data management Key Features * Explore ways to create shards and elastic pools to scale Azure SQL databases * Automate common management tasks with PowerShell * Implement over 40 practical activities and exercises to reinforce your learning Book Description Despite being the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. This book shows you how to administer Azure SQL database to fully benefit from its wide range of features and functionality. Professional Azure SQL Database Administration begins by covering the architecture and explaining the difference between Azure SQL Database and the on-premise SQL Server to help you get comfortable with Azure SQL database. You’ll perform common tasks such as migrating, backing up, and restoring a SQL Server database to an Azure database. As you progress, you’ll study how you can save costs and manage and scale multiple SQL Databases using elastic pools. You’ll also implement a disaster recovery solution using standard and active geo-replication. Whether it is learning different techniques to monitor and tune an Azure SQL database or improving performance using in-memory technology, this book will enable you to make the most out of Azure SQL database features and functionality for data management solutions. By the end of this book, you’ll be well versed with key aspects of an Azure SQL database instance, such as migration, backup restorations, performance optimization, high availability, and disaster recovery. What you will learn * Understand Azure SQL Database configuration and pricing options * Provision a new SQL database or migrate an existing on-premise SQL Server database to Azure SQL Database * Back up and restore Azure SQL Database * Secure an Azure SQL database * Scale an Azure SQL database * Monitor and tune an Azure SQL database * Implement high availability and disaster recovery with Azure SQL Database * Automate common management tasks with PowerShell * Develop a scalable cloud solution with Azure SQL Database * Manage, maintain, and secure managed instances Who this book is for If you’re a database administrator, database developer, or an application developer interested in developing new applications or migrating existing ones with Azure SQL database, this book is for you. Prior experience of working with an on-premise SQL Server or Azure SQL database along with a basic understanding of PowerShell scripts and C# code is necessary to grasp the concepts covered in this book.

Learn advanced state-of-the-art deep learning techniques and their applications using popular Python libraries Key Features *Build a strong foundation in neural networks and deep learning with Python libraries *Explore advanced deep learning techniques and their applications across computer vision and NLP *Learn how a computer can navigate in complex environments with reinforcement learning Book Description With the surge in artificial intelligence in applications catering to both business and consumer needs, deep learning is more important than ever for meeting current and future market demands. With this book, you’ll explore deep learning, and learn how to put machine learning to use in your projects. This second edition of Python Deep Learning will get you up to speed with deep learning, deep neural networks, and how to train them with high-performance algorithms and popular Python frameworks. You’ll uncover different neural network architectures, such as convolutional networks, recurrent neural networks, long short-term memory (LSTM) networks, and capsule networks. You’ll also learn how to solve problems in the fields of computer vision, natural language processing (NLP), and speech recognition. You'll study generative model approaches such as variational autoencoders and Generative Adversarial Networks (GANs) to generate images. As you delve into newly evolved areas of reinforcement learning, you’ll gain an understanding of state-of-the-art algorithms that are the main components behind popular games Go, Atari, and Dota. By the end of the book, you will be well-versed with the theory of deep learning along with its real-world applications. What you will learn *Grasp the mathematical theory behind neural networks and deep learning processes *Investigate and resolve computer vision challenges using convolutional networks and capsule networks *Solve generative tasks using variational autoencoders and Generative Adversarial Networks *Implement complex NLP tasks using recurrent networks (LSTM and GRU) and attention models *Explore reinforcement learning and understand how agents behave in a complex environment *Get up to date with applications of deep learning in autonomous vehicles Who this book is for This book is for data science practitioners, machine learning engineers, and those interested in deep learning who have a basic foundation in machine learning and some Python programming experience. A background in mathematics and conceptual understanding of calculus and statistics will help you gain maximum benefit from this book.

A practical guide that helps you progress to using modern integration methods and leverage new cloud capability models Key Features * Design critical hybrid integration solutions for your organization * Gain in-depth knowledge of how to build cloud-native integration solutions * Leverage cognitive services to build smart cloud solutions Book Description With more enterprises adapting cloud-based and API-based solutions, application integration has become more relevant and significant than ever before. Parallelly, Serverless Integration has gained popularity, as it helps agile organizations to build integration solutions quickly without having to worry about infrastructure costs. With Microsoft Azure’s serverless offerings, such as Logic Apps, Azure Functions, API Management, Azure Event Grid and Service Bus, organizations can build powerful, secure, and scalable integration solutions with ease. The primary objective of this book is to help you to understand various serverless offerings included within Azure Integration Services, taking you through the basics and industry practices and patterns. This book starts by explaining the concepts of services such as Azure Functions, Logic Apps, and Service Bus with hands-on examples and use cases. After getting to grips with the basics, you will be introduced to API Management and building B2B solutions using Logic Apps Enterprise Integration Pack. This book will help readers to understand building hybrid integration solutions and touches upon Microsoft Cognitive Services and leveraging them in modern integration solutions. Industry practices and patterns are brought to light at appropriate opportunities while explaining various concepts. What you will learn * Learn about the design principles of Microsoft Azure Serverless Integration * Get insights into Azure Functions, Logic Apps, Azure Event Grid and Service Bus * Secure and manage your integration endpoints using Azure API Management * Build advanced B2B solutions using Logic Apps, Enterprise Integration Pack * Monitor integration solutions using tools available on the market * Discover design patterns for hybrid integration Who this book is for Serverless Integration Design Patterns with Azure is for you if you are a solution architect or integration professional aiming to build complex cloud solutions for your organization. Developers looking to build next-level hybrid or cloud solutions will also find this book useful. Prior programming knowledge is necessary.

Designing and deploying solutions using the SAP BusinessObjects Business Intelligence platform 4.2. Key Features * Get up and running with the SAP BusinessObjects Business Intelligence platform * Perform effective data analysis and visualization for actionable insights * Enhance your BI strategy by creating different types of reports and dashboards using SAP BusinessObjects Book Description The SAP BusinessObjects Business Intelligence platform is a powerful reporting and analysis tool. This book is the ideal introduction to the SAP BusinessObjects Business Intelligence platform, introducing you to its data visualization, visual analytics, reporting, and dashboarding capabilities. The book starts with an overview of the BI platform and various data sources for reporting. Then, we move on to looking at data visualization, analysis, reporting, and analytics using BusinessObjects Business Intelligence tools. You will learn about the features associated with reporting, scheduling, and distribution and learn how to deploy the platform. Toward the end, you will learn about the strategies and factors that should be considered during deployment. By the end, you will be confident working with the SAP BusinessObjects Business Intelligence platform to deliver better insights for more effective decision making. What you will learn * Work with various tools to create interactive data visualization and analysis * Query, report, and analyze with SAP Business Objects Web Intelligence * Create a report in SAP Crystal Reports for Enterprise * Visualize and manipulate data using an SAP Lumira Storyboard * Deep dive into the workings of the SAP predictive analytics tool * Deploy and configure SAP BO Intelligence platform 4.2 Who this book is for This book is for Business Intelligence professionals and existing SAP ecosystem users who want to perform effective Business Intelligence using SAP BusinessObjects.

Convert Android to a powerful pentesting platform. Key Features * Get up and running with Kali Linux NetHunter * Connect your Android device and gain full control over Windows, OSX, or Linux devices * Crack Wi-Fi passwords and gain access to devices connected over the same network collecting intellectual data Book Description Kali NetHunter is a version of the popular and powerful Kali Linux pentesting platform, designed to be installed on mobile devices. Hands-On Penetration Testing with Kali NetHunter will teach you the components of NetHunter and how to install the software. You’ll also learn about the different tools included and how to optimize and use a package, obtain desired results, perform tests, and make your environment more secure. Starting with an introduction to Kali NetHunter, you will delve into different phases of the pentesting process. This book will show you how to build your penetration testing environment and set up your lab. You will gain insight into gathering intellectual data, exploiting vulnerable areas, and gaining control over target systems. As you progress through the book, you will explore the NetHunter tools available for exploiting wired and wireless devices. You will work through new ways to deploy existing tools designed to reduce the chances of detection. In the concluding chapters, you will discover tips and best practices for integrating security hardening into your Android ecosystem. By the end of this book, you will have learned to successfully use a mobile penetration testing device based on Kali NetHunter and Android to accomplish the same tasks you would traditionally, but in a smaller and more mobile form factor. What you will learn * Choose and configure a hardware device to use Kali NetHunter * Use various tools during pentests * Understand NetHunter suite components * Discover tips to effectively use a compact mobile platform * Create your own Kali NetHunter-enabled device and configure it for optimal results * Learn to scan and gather information from a target * Explore hardware adapters for testing and auditing wireless networks and Bluetooth devices Who this book is for Hands-On Penetration Testing with Kali NetHunter is for pentesters, ethical hackers, and security professionals who want to learn to use Kali NetHunter for complete mobile penetration testing and are interested in venturing into the mobile domain. Some prior understanding of networking assessment and Kali Linux will be helpful.

Learn how to run new and old applications in Docker containers on Windows - modernizing the architecture, improving security and maximizing efficiency. Key Features * Run .NET Framework and .NET Core apps in Docker containers for efficiency, security and portability * Design distributed containerized apps, using enterprise-grade open source software from Docker Hub * Build a CI/CD pipeline with Docker, going from source to a production Docker Swarm in the cloud Book Description Docker on Windows, Second Edition teaches you all you need to know about Docker on Windows, from the 101 to running highly-available workloads in production. You’ll be guided through a Docker journey, starting with the key concepts and simple examples of .NET Framework and .NET Core apps in Docker containers on Windows. Then you’ll learn how to use Docker to modernize the architecture and development of traditional ASP.NET and SQL Server apps. The examples show you how to break up legacy monolithic applications into distributed apps and deploy them to a clustered environment in the cloud, using the exact same artifacts you use to run them locally. You’ll see how to build a CI/CD pipeline which uses Docker to compile, package, test and deploy your applications. To help you move confidently to production, you’ll learn about Docker security, and the management and support options. The book finishes with guidance on getting started with Docker in your own projects. You’ll walk through some real-world case studies for Docker implementations, from small-scale on-premises apps to very large-scale apps running on Azure. What you will learn * Understand key Docker concepts: images, containers, registries and swarms * Run Docker on Windows 10, Windows Server 2019, and in the cloud * Deploy and monitor distributed solutions across multiple Docker containers * Run containers with high availability and failover with Docker Swarm * Master security in-depth with the Docker platform, making your apps more secure * Build a Continuous Deployment pipeline, running Jenkins and Git in Docker * Debug applications running in Docker containers using Visual Studio * Plan the adoption of Docker in your organization Who this book is for If you want to modernize an old monolithic application without rewriting it, smooth the deployment to production, or move to DevOps or the cloud, then Docker is the enabler for you. This book gives you a solid grounding in Docker so you can confidently approach all of these scenarios.

Automate Windows server tasks with the powerful features of the PowerShell Language Key Features * Leverage PowerShell to automate complex Windows server tasks * Master new features such as DevOps, and containers, and speed up their performance using PowerShell * Improve PowerShell's usability, and control and manage Windows-based environments by working through exciting recipes Book Description Windows Server 2019 represents the latest version of Microsoft’s flagship server operating system. It also comes with PowerShell Version 5.1 and has a number of additional features that IT pros find useful. The book helps the reader learn how to use PowerShell and manage core roles, features, and services of Windows Server 2019. You will begin with creating a PowerShell Administrative Environment that has updated versions of PowerShell and the Windows Management Framework, updated versions of the .NET Framework, and third-party modules. Next, you will learn to use PowerShell to set up and configure Windows Server 2019 networking and also managing objects in the AD environment. You will also learn to set up a host to utilize containers and how to deploy containers. You will also be implementing different mechanisms for achieving desired state configuration along with getting well versed with Azure infrastructure and how to setup Virtual Machines, web sites, and shared files on Azure. Finally, you will be using some powerful tools you can use to diagnose and resolve issues with Windows Server 2019. By the end of the book, you will learn a lot of trips and tricks to automate your windows environment with PowerShell What you will learn * Perform key admin tasks on Windows Server 2019 * Employing best practices for writing PowerShell scripts and configuring Windows Server 2019 * Use the .NET Framework to achieve administrative scripting * Set up VMs, websites, and shared files on Azure * Report system performance using built-in cmdlets and WMI to obtain single measurements * Know the tools you can use to diagnose and resolve issues with Windows Server Who this book is for If you are a systems administrator, engineer, or an architect working with Windows Server 2016 interested in upgrading to Windows Server 2019 and automating tasks with PowerShell, then this book is for you. A basic knowledge of PowerShell is expected.

Begin writing graphical user interface(GUI) applications for building human machine interfaces with a clear understanding of key concepts of the Qt framework Key Features * Learn how to write, assemble, and build Qt application from the command line * Understand key concepts like Signals and Slots in Qt * Best practices and effective techniques for designing graphical user interfaces using Qt 5 Book Description Qt is a cross-platform application framework and widget toolkit that is used to create GUI applications that can run on different hardware and operating systems. The main aim of this book is to introduce Qt to the reader. Through the use of simple examples, we will walk you through building blocks without focusing too much on theory. Qt is a popular tool that can be used for building a variety of applications, such as web browsers, media players such as VLC, and Adobe Photoshop. Following Qt installation and setup, the book dives straight into helping you create your first application. You will be introduced to Widgets, Qt's interface building block, and the many varieties that are available for creating GUIs. Next, Qt's core concept of signals and slots are well illustrated with sufficient examples. The book further teaches you how to create custom widgets, signals and slots, and how to communicate useful information via dialog boxes. To cap everything off, you will be taken through writing applications that can connect to databases in order to persist data. By the end of the book, you should be well equipped to start creating your own Qt applications and confident enough to pick up more advanced Qt techniques and materials to hone your skills. What you will learn * Set up and configure your machine to begin developing Qt applications * Discover different widgets and layouts for constructing UIs * Understand the key concept of signals and slots * Understand how signals and slots help animate a GUI * Explore how to create customized widgets along with signals and slots * Understand how to subclass and create a custom windows application * Understand how to write applications that can talk to databases. Who this book is for Anyone trying to start development of graphical user interface application will find this book useful. One does not need prior exposure to other toolkits to understand this book. In order to learn from this book you should have basic knowledge of C++ and a good grasp of Object Oriented Programming. Familiarity with GNU/Linux will be very useful though it's not a mandatory skill.

Build complex, observable, and fault-tolerant serverless systems easily on Microsoft Azure. Key Features * Use serverless systems to help you fulfill complex requirements * Develop your knowledge of Azure Microsoft Serverless * Understand concepts with a hands-on approach and helpful examples Book Description Advanced Serverless Architectures with Microsoft Azure redefines your experience of designing serverless systems. It shows you how to tackle challenges of varying levels, not just the straightforward ones. You'll be learning how to deliver features quickly by building systems, which retain the scalability and benefits of serverless. You'll begin your journey by learning how to build a simple, completely serverless application. Then, you'll build a highly scalable solution using a queue, load messages onto the queue, and read them asynchronously. To boost your knowledge further, the book also features durable functions and ways to use them to solve errors in a complex system. You'll then learn about security by building a security solution from serverless components. Next, you’ll gain an understanding of observability and ways to leverage application insights to bring you performance benefits. As you approach the concluding chapters, you’ll explore chaos engineering and the benefits of resilience, by actively switching off a few of the functions within a complex system, submitting a request, and observing the resulting behavior. By the end of this book, you will have developed the skills you need to build and maintain increasingly complex systems that match evolving platform requirements. What you will learn * Understand what true serverless architecture is * Study how to extend and scale architectures until they become ‘complex' * Implement durable functions in your design * Improve the observability of your serverless architecture * Implement security solutions using serverless services * Learn how to ‘practise' chaos engineering in production Who this book is for Advanced Serverless Architectures with Microsoft Azure is is ideal if you want to build serverless systems with fewer outages and high performance using Azure. Familiarity with the C# syntax and Azure Functions and ARM templates will help you to benefit more from this book. Prior knowledge of basic front-end development, HTML JS, and CSS is beneficial but not essential. Some DevOps knowledge is also beneficial but not essential.

A comprehensive guide for MCSA Exam 70-740, that will help you prepare from day one to earn the valuable Microsoft Certificate Key Features * Leverage practice questions and mock tests to pass this certification with confidence * Learn to Install Windows Servers,implement high availability, and monitor server environments * Gain necessary skills to implement and configure storage and compute features Book Description MCSA: Windows Server 2016 certification is one of the most sought-after certifications for IT professionals, which includes working with Windows Server and performing administrative tasks around it. This book is aimed at the 70-740 certification and is part of Packt's three-book series on MCSA Windows Server 2016 certification, which covers Exam 70-740, Exam 70-741, and Exam 70-742. This book will cover exam objectives for the 70-740 exam, and starting from installing and configuring Windows Server 2016, Windows Server imaging and deployment to configuring and managing disks and volumes, implementing and configuring server storage and implementing Hyper-V. At the end of each chapter you will be provided test questions to revise your learnings which will boost your confidence in preparing for the actual certifications. By the end of this book, you will learn everything needed to pass the, MCSA Exam 70-740: Installation, Storage, and Compute with Windows Server 2016, certification. What you will learn * Install Windows Server 2016 * Upgrade and Migrate servers and workloads * Implement and configure server storage * Install and configure Hyper-V * Configure the virtual machine (VM) settings * Configure Hyper-V storage * Configure Hyper-V networking Who this book is for This book is ideal for system administrators interested in installing and configuring storage and compute features with Windows Sever 2016 and aiming to pass the 70-740 certification. Some experience with Windows Server in an enterprise environment is assumed.

Solve complex business problems by understanding users better, finding the right problem to solve, and building lean event-driven systems to give your customers what they really want Key Features * Apply DDD principles using modern tools such as EventStorming, Event Sourcing, and CQRS * Learn how DDD applies directly to various architectural styles such as REST, reactive systems, and microservices * Empower teams to work flexibly with improved services and decoupled interactions Book Description Developers across the world are rapidly adopting DDD principles to deliver powerful results when writing software that deals with complex business requirements. This book will guide you in involving business stakeholders when choosing the software you are planning to build for them. By figuring out the temporal nature of behavior-driven domain models, you will be able to build leaner, more agile, and modular systems. You’ll begin by uncovering domain complexity and learn how to capture the behavioral aspects of the domain language. You will then learn about EventStorming and advance to creating a new project in .NET Core 2.1; you’ll also and write some code to transfer your events from sticky notes to C#. The book will show you how to use aggregates to handle commands and produce events. As you progress, you’ll get to grips with Bounded Contexts, Context Map, Event Sourcing, and CQRS. After translating domain models into executable C# code, you will create a frontend for your application using Vue.js. In addition to this, you’ll learn how to refactor your code and cover event versioning and migration essentials. By the end of this DDD book, you will have gained the confidence to implement the DDD approach in your organization and be able to explore new techniques that complement what you’ve learned from the book. What you will learn * Discover and resolve domain complexity together with business stakeholders * Avoid common pitfalls when creating the domain model * Study the concept of Bounded Context and aggregate * Design and build temporal models based on behavior and not only data * Explore benefits and drawbacks of Event Sourcing * Get acquainted with CQRS and to-the-point read models with projections * Practice building one-way flow UI with Vue.js * Understand how a task-based UI conforms to DDD principles Who this book is for This book is for .NET developers who have an intermediate level understanding of C#, and for those who seek to deliver value, not just write code. Intermediate level of competence in JavaScript will be helpful to follow the UI chapters.

Explore practical use cases to learn everything from Linux components, and functionalities, through to hardware and software support Key Features * Gain a clear understanding of how to design a Linux environment * Learn more about the architecture of the modern Linux operating system(OS) * Understand infrastructure needs and design a high-performing computing environment Book Description It is very important to understand the flexibility of an infrastructure when designing an efficient environment. In this book, you will cover everything from Linux components and functionalities through to hardware and software support, which will help you to implement and tune effective Linux-based solutions. This book gets started with an overview of Linux design methodology. Next, you will focus on the core concepts of designing a solution. As you progress, you will gain insights into the kinds of decisions you need to make when deploying a high-performance solution using Gluster File System (GlusterFS). In the next set of chapters, the book will guide you through the technique of using Kubernetes as an orchestrator for deploying and managing containerized applications. In addition to this, you will learn how to apply and configure Kubernetes for your NGINX application. You’ll then learn how to implement an ELK stack, which is composed of Elasticsearch, Logstash, and Kibana. In the concluding chapters, you will focus on installing and configuring a Saltstack solution to manage different Linux distributions, and explore a variety of design best practices. By the end of this book, you will be well-versed with designing a high-performing computing environment for complex applications to run on. By the end of the book, you will have delved inside the most detailed technical conditions of designing a solution, and you will have also dissected every aspect in detail in order to implement and tune open source Linux-based solutions What you will learn * Study the basics of infrastructure design and the steps involved * Expand your current design portfolio with Linux-based solutions * Discover open source software-based solutions to optimize your architecture * Understand the role of high availability and fault tolerance in a resilient design * Identify the role of containers and how they improve your continuous integration and continuous deployment pipelines * Gain insights into optimizing and making resilient and highly available designs by applying industry best practices Who this book is for This intermediate-level book is for Linux system administrators, Linux support engineers, DevOps engineers, Linux consultants or any open source technology professional looking to learn or expand their knowledge in architecting, designing and implementing solutions based on Linux and open source software. Prior experience in Linux is required.

Master scala's advanced techniques to solve real-world problems in data analysis and gain valuable insights from your data Key Features * A beginner's guide for performing data analysis loaded with numerous rich, practical examples * Access to popular Scala libraries such as Breeze, Saddle for efficient data manipulation and exploratory analysis * Develop applications in Scala for real-time analysis and machine learning in Apache Spark Book Description Efficient business decisions with an accurate sense of business data helps in delivering better performance across products and services. This book helps you to leverage the popular Scala libraries and tools for performing core data analysis tasks with ease. The book begins with a quick overview of the building blocks of a standard data analysis process. You will learn to perform basic tasks like Extraction, Staging, Validation, Cleaning, and Shaping of datasets. You will later deep dive into the data exploration and visualization areas of the data analysis life cycle. You will make use of popular Scala libraries like Saddle, Breeze, Vegas, and PredictionIO for processing your datasets. You will learn statistical methods for deriving meaningful insights from data. You will also learn to create applications for Apache Spark 2.x on complex data analysis, in real-time. You will discover traditional machine learning techniques for doing data analysis. Furthermore, you will also be introduced to neural networks and deep learning from a data analysis standpoint. By the end of this book, you will be capable of handling large sets of structured and unstructured data, perform exploratory analysis, and building efficient Scala applications for discovering and delivering insights What you will learn * Techniques to determine the validity and confidence level of data * Apply quartiles and n-tiles to datasets to see how data is distributed into many buckets * Create data pipelines that combine multiple data lifecycle steps * Use built-in features to gain a deeper understanding of the data * Apply Lasso regression analysis method to your data * Compare Apache Spark API with traditional Apache Spark data analysis Who this book is for If you are a data scientist or a data analyst who wants to learn how to perform data analysis using Scala, this book is for you. All you need is knowledge of the basic fundamentals of Scala programming.

Troubleshoot query performance issues, identify anti-patterns in code, and write efficient T-SQL queries Key Features * Discover T-SQL functionalities and services that help you interact with relational databases * Understand the roles, tasks and responsibilities of a T-SQL developer * Explore solutions for carrying out database querying tasks, database administration, and troubleshooting Book Description Transact-SQL (T-SQL) is Microsoft's proprietary extension to the SQL language that is used with Microsoft SQL Server and Azure SQL Database. This book will be a useful guide to learning the art of writing efficient T-SQL code in modern SQL Server versions, as well as the Azure SQL Database. The book will get you started with query processing fundamentals to help you write powerful, performant T-SQL queries. You will then focus on query execution plans and learn how to leverage them for troubleshooting. In the later chapters, you will learn how to identify various T-SQL patterns and anti-patterns. This will help you analyze execution plans to gain insights into current performance, and determine whether or not a query is scalable. You will also learn to build diagnostic queries using dynamic management views (DMVs) and dynamic management functions (DMFs) to address various challenges in T-SQL execution. Next, you will study how to leverage the built-in tools of SQL Server to shorten the time taken to address query performance and scalability issues. In the concluding chapters, the book will guide you through implementing various features, such as Extended Events, Query Store, and Query Tuning Assistant using hands-on examples. By the end of this book, you will have the skills to determine query performance bottlenecks, avoid pitfalls, and discover the anti-patterns in use. Foreword by Conor Cunningham, Partner Architect – SQL Server and Azure SQL – Microsoft What you will learn * Use Query Store to understand and easily change query performance * Recognize and eliminate bottlenecks that lead to slow performance * Deploy quick fixes and long-term solutions to improve query performance * Implement best practices to minimize performance risk using T-SQL * Achieve optimal performance by ensuring careful query and index design * Use the latest performance optimization features in SQL Server 2017 and SQL Server 2019 * Protect query performance during upgrades to newer versions of SQL Server Who this book is for This book is for database administrators, database developers, data analysts, data scientists, and T-SQL practitioners who want to get started with writing T-SQL code and troubleshooting query performance issues, through the help of practical examples. Previous knowledge of T-SQL querying is not required to get started on this book.

A practical guide to administer, monitor and replicate your PostgreSQL 11 database Key Features * Study and apply the newly introduced features in PostgreSQL 11 * Tackle any problem in PostgreSQL 11 administration and management * Catch up on expert techniques for monitoring, fine-tuning, and securing your database Book Description PostgreSQL is a powerful, open source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 11 allows you to scale up your PostgreSQL infrastructure. This book takes a step-by-step, recipe-based approach to effective PostgreSQL administration. The book will introduce you to new features such as logical replication, native table partitioning, additional query parallelism, and much more to help you to understand and control, crash recovery and plan backups. You will learn how to tackle a variety of problems and pain points for any database administrator such as creating tables, managing views, improving performance, and securing your database. As you make steady progress, the book will draw attention to important topics such as monitoring roles, backup, and recovery of your PostgreSQL 11 database to help you understand roles and produce a summary of log files, ensuring high availability, concurrency, and replication. By the end of this book, you will have the necessary knowledge to manage your PostgreSQL 11 database efficiently. What you will learn * Troubleshoot open source PostgreSQL version 11 on various platforms * Deploy best practices for planning and designing live databases * Select and implement robust backup and recovery techniques in PostgreSQL 11 * Use pgAdmin or OmniDB to perform database administrator (DBA) tasks * Adopt efficient replication and high availability techniques in PostgreSQL * Improve the performance of your PostgreSQL solution Who this book is for This book is designed for database administrators, data architects, database developers, or anyone with an interest in planning and running live production databases using PostgreSQL 11. It is also ideal if you’re looking for hands-on solutions to any problem associated with PostgreSQL 11 administration. Some experience with handling PostgreSQL databases will be beneficial

Explore the world of neural networks by building powerful deep learning models using the R ecosystem Key Features * Get to grips with the fundamentals of deep learning and neural networks * Use R 3.5 and its libraries and APIs to build deep learning models for computer vision and text processing * Implement effective deep learning systems in R with the help of end-to-end projects Book Description Deep learning finds practical applications in several domains, while R is the preferred language for designing and deploying deep learning models. This Learning Path introduces you to the basics of deep learning and even teaches you to build a neural network model from scratch. As you make your way through the chapters, you’ll explore deep learning libraries and understand how to create deep learning models for a variety of challenges, right from anomaly detection to recommendation systems. The book will then help you cover advanced topics, such as generative adversarial networks (GANs), transfer learning, and large-scale deep learning in the cloud, in addition to model optimization, overfitting, and data augmentation. Through real-world projects, you’ll also get up to speed with training convolutional neural networks (CNNs), recurrent neural networks (RNNs), and long short-term memory networks (LSTMs) in R. By the end of this Learning Path, you’ll be well versed with deep learning and have the skills you need to implement a number of deep learning concepts in your research work or projects. This Learning Path includes content from the following Packt products: * R Deep Learning Essentials - Second Edition by F. Wiley and Mark Hodnett * R Deep Learning Projects by Yuxi (Hayden) Liu and Pablo Maldonado What you will learn * Implement credit card fraud detection with autoencoders * Train neural networks to perform handwritten digit recognition using MXNet * Reconstruct images using variational autoencoders * Explore the applications of autoencoder neural networks in clustering and dimensionality reduction * Create natural language processing (NLP) models using Keras and TensorFlow in R * Prevent models from overfitting the data to improve generalizability * Build shallow neural network prediction models Who this book is for This Learning Path is for aspiring data scientists, data analysts, machine learning developers, and deep learning enthusiasts who are well versed in machine learning concepts and are looking to explore the deep learning paradigm using R. A fundamental understanding of R programming and familiarity with the basic concepts of deep learning are necessary to get the most out of this Learning Path.

Master machine learning techniques with real-world projects that interface TensorFlow with R, H2O, MXNet, and other languages Key Features * Gain expertise in machine learning, deep learning and other techniques * Build intelligent end-to-end projects for finance, social media, and a variety of domains * Implement multi-class classification, regression, and clustering Book Description R is one of the most popular languages when it comes to exploring the mathematical side of machine learning and easily performing computational statistics. This Learning Path shows you how to leverage the R ecosystem to build efficient machine learning applications that carry out intelligent tasks within your organization. You'll tackle realistic projects such as building powerful machine learning models with ensembles to predict employee attrition. You'll explore different clustering techniques to segment customers using wholesale data and use TensorFlow and Keras-R for performing advanced computations. You’ll also be introduced to reinforcement learning along with its various use cases and models. Additionally, it shows you how some of these black-box models can be diagnosed and understood. By the end of this Learning Path, you’ll be equipped with the skills you need to deploy machine learning techniques in your own projects. This Learning Path includes content from the following Packt products: * R Machine Learning Projects by Dr. Sunil Kumar Chinnamgari * Mastering Machine Learning with R - Third Edition by Cory Lesmeister What you will learn * Develop a joke recommendation engine to recommend jokes that match users’ tastes * Build autoencoders for credit card fraud detection * Work with image recognition and convolutional neural networks * Make predictions for casino slot machine using reinforcement learning * Implement NLP techniques for sentiment analysis and customer segmentation * Produce simple and effective data visualizations for improved insights * Use NLP to extract insights for text * Implement tree-based classifiers including random forest and boosted tree Who this book is for If you are a data analyst, data scientist, or machine learning developer this is an ideal Learning Path for you. Each project will help you test your skills in implementing machine learning algorithms and techniques. A basic understanding of machine learning and working knowledge of R programming is necessary to get the most out of this Learning Path.

A comprehensive guide to building full stack applications covering frontend and server-side programming, data management, and web security Key Features * Unleash the power of React Hooks to build interactive and complex user interfaces * Build scalable full stack applications designed to meet demands of modern users * Understand how the Axios library simplifies CRUD operations Book Description React Hooks have changed the way React components are coded. They enable you to write components in a more intuitive way without using classes, which makes your code easier to read and maintain. Building on from the previous edition, this book is updated with React Hooks and the latest changes introduced in create-react-app and Spring Boot 2.1. This book starts with a brief introduction to Spring Boot. You’ll understand how to use dependency injection and work with the data access layer of Spring using Hibernate as the ORM tool. You’ll then learn how to build your own RESTful API endpoints for web applications. As you advance, the book introduces you to other Spring components, such as Spring Security to help you secure the backend. Moving on, you’ll explore React and its app development environment and components for building your frontend. Finally, you’ll create a Docker container for your application by implementing the best practices that underpin professional full stack web development. By the end of this book, you’ll be equipped with all the knowledge you need to build modern full stack applications with Spring Boot for the backend and React for the frontend. What you will learn * Create a RESTful web service with Spring Boot * Grasp the fundamentals of dependency injection and how to use it for backend development * Discover techniques for securing the backend using Spring Security * Understand how to use React for frontend programming * Benefit from the Heroku cloud server by deploying your application to it * Delve into the techniques for creating unit tests using JUnit * Explore the Material UI component library to make more user-friendly user interfaces Who this book is for If you are a Java developer familiar with Spring, but are new to building full stack applications, this is the book for you.

Understand the nitty-gritty of Cybersecurity with ease Key Features * Align your security knowledge with industry leading concepts and tools * Acquire required skills and certifications to survive the ever changing market needs * Learn from industry experts to analyse, implement, and maintain a robust environment Book Description It's not a secret that there is a huge talent gap in the cybersecurity industry. Everyone is talking about it including the prestigious Forbes Magazine, Tech Republic, CSO Online, DarkReading, and SC Magazine, among many others. Additionally, Fortune CEO's like Satya Nadella, McAfee's CEO Chris Young, Cisco's CIO Colin Seward along with organizations like ISSA, research firms like Gartner too shine light on it from time to time. This book put together all the possible information with regards to cybersecurity, why you should choose it, the need for cyber security and how can you be part of it and fill the cybersecurity talent gap bit by bit. Starting with the essential understanding of security and its needs, we will move to security domain changes and how artificial intelligence and machine learning are helping to secure systems. Later, this book will walk you through all the skills and tools that everyone who wants to work as security personal need to be aware of. Then, this book will teach readers how to think like an attacker and explore some advanced security methodologies. Lastly, this book will deep dive into how to build practice labs, explore real-world use cases and get acquainted with various cybersecurity certifications. By the end of this book, readers will be well-versed with the security domain and will be capable of making the right choices in the cybersecurity field. What you will learn * Get an overview of what cybersecurity is and learn about the various faces of cybersecurity as well as identify domain that suits you best * Plan your transition into cybersecurity in an efficient and effective way * Learn how to build upon your existing skills and experience in order to prepare for your career in cybersecurity Who this book is for This book is targeted to any IT professional who is looking to venture in to the world cyber attacks and threats. Anyone with some understanding or IT infrastructure workflow will benefit from this book. Cybersecurity experts interested in enhancing their skill set will also find this book useful.

This quick start guide will bring the readers to a basic level of understanding when it comes to the Machine Learning (ML) development lifecycle, will introduce Go ML libraries and then will exemplify common ML methods such as Classification, Regression, and Clustering Key Features * Your handy guide to building machine learning workflows in Go for real-world scenarios * Build predictive models using the popular supervised and unsupervised machine learning techniques * Learn all about deployment strategies and take your ML application from prototype to production ready Book Description Machine learning is an essential part of today's data-driven world and is extensively used across industries, including financial forecasting, robotics, and web technology. This book will teach you how to efficiently develop machine learning applications in Go. The book starts with an introduction to machine learning and its development process, explaining the types of problems that it aims to solve and the solutions it offers. It then covers setting up a frictionless Go development environment, including running Go interactively with Jupyter notebooks. Finally, common data processing techniques are introduced. The book then teaches the reader about supervised and unsupervised learning techniques through worked examples that include the implementation of evaluation metrics. These worked examples make use of the prominent open-source libraries GoML and Gonum. The book also teaches readers how to load a pre-trained model and use it to make predictions. It then moves on to the operational side of running machine learning applications: deployment, Continuous Integration, and helpful advice for effective logging and monitoring. At the end of the book, readers will learn how to set up a machine learning project for success, formulating realistic success criteria and accurately translating business requirements into technical ones. What you will learn * Understand the types of problem that machine learning solves, and the various approaches * Import, pre-process, and explore data with Go to make it ready for machine learning algorithms * Visualize data with gonum/plot and Gophernotes * Diagnose common machine learning problems, such as overfitting and underfitting * Implement supervised and unsupervised learning algorithms using Go libraries * Build a simple web service around a model and use it to make predictions Who this book is for This book is for developers and data scientists with at least beginner-level knowledge of Go, and a vague idea of what types of problem Machine Learning aims to tackle. No advanced knowledge of Go (and no theoretical understanding of the math that underpins Machine Learning) is required.