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.

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.

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.

Build state-of-the-art web applications quickly and efficiently using Flask and related technologies with Python 3 Key Features * Updated to Flask 1.0.3 and Python 3.7 with coverage of Microservices * Get the most out of the powerful Flask framework and maintain the flexibility of your design choices * Write cleaner and maintainable code with the help of sample apps Book Description Flask, the lightweight Python web framework, is popular due to its powerful modular design that lets you build scalable web apps. With this recipe-based guide, you’ll explore modern solutions and best practices for Flask web development. Updated to the latest version of Flask and Python 3, this second edition of Flask Framework Cookbook moves away from some of the old and obsolete libraries and introduces recipes on bleeding edge technologies. You’ll discover different ways of using Flask to create, deploy, and manage microservices. This Flask Python book starts by covering the different configurations that a Flask application can make use of, and then helps you work with templates and learn about the ORM and view layers. You’ll also be able to write an admin interface and get to grips with debugging and logging errors. Finally, you’ll grasp a variety of deployment and post-deployment techniques for platforms such as Apache, Tornado, and Heroku. By the end of this book, you’ll have gained all the knowledge you need to write Flask applications in the best possible way and scale them using standard industry practices. What you will learn * Explore web application development in Flask, right from installation to post-deployment stages * Make use of advanced templating and data modeling techniques * Discover effective debugging, logging, and error handling techniques in Flask * Integrate Flask with different technologies such as Redis, Sentry, and MongoDB * Deploy and package Flask applications with Docker and Kubernetes * Design scalable microservice architecture using AWS LambdaContinuous integration and Continuous deployment Who this book is for If you are a web developer who wants to learn more about developing scalable and production-ready applications in Flask, this is the book for you. You’ll also find this book useful if you are already aware of Flask's major extensions and want to use them for better application development. Basic Python programming experience along with basic understanding of Flask is assumed.

Develop technical skills and expertise to automate AWS networking tasks Key Features * A fast paced guide that will help you pass the exam with confidence * Learn advanced skill sets to build effective AWS networking solutions * Enhance your AWS skills with practice exercises and mock tests Book Description Amazon has recently come up a with specialty certifications which validates a particular user's expertise that he/she would want to build a career in. Since the Cloud market now demands of AWS networking skills this becomes the most wanted certification to upheld ones industry portfolio. This book would be your ideal companion to getting skilled with complex and creative networking solutions. Cloud practitioners or associate-level certified individuals interested in validating advanced skills in networking can opt for this practical guide. This book will include topics that will help you design and implement AWS and hybrid IT network architectures along with some network automation tasks. You will also delve deep into topics that will help you design and maintain network architecture for all AWS services. Like most of our certification guides this book will also follow a unique approach of testing your learning with chapter-level practice exercises and certification-based mock tests. The exam mock tests will help you gauge whether you are ready to take the certification exam or not. This book will also be an advanced guide for networking professionals to enhance their networking skills and get certified. By the end of this book, you will be all equipped with AWS networking concepts and techniques and will have mastered core architectural best practices. What you will learn * Formulate solution plans and provide guidance on AWS architecture best practices * Design and deploy scalable, highly available, and fault-tolerant systems on AWS * Identify the tools required to replicate an on-premises network in AWS * Analyze the access and egress of data to and from AWS * Select the appropriate AWS service based on data, compute, database, or security requirements * Estimate AWS costs and identify cost control mechanisms Who this book is for If you are a system administrator, or a network engineer interested in getting certified with an advanced Cloud networking certification then this book is for you. Prior experience in Cloud administration and networking would be necessary.

Design and create neural networks with deep learning and artificial intelligence principles using OpenAI Gym, TensorFlow, and Keras Key Features * Explore neural network architecture and understand how it functions * Learn algorithms to solve common problems using back propagation and perceptrons * Understand how to apply neural networks to applications with the help of useful illustrations Book Description Neural networks play a very important role in deep learning and artificial intelligence (AI), with applications in a wide variety of domains, right from medical diagnosis, to financial forecasting, and even machine diagnostics. Hands-On Neural Networks is designed to guide you through learning about neural networks in a practical way. The book will get you started by giving you a brief introduction to perceptron networks. You will then gain insights into machine learning and also understand what the future of AI could look like. Next, you will study how embeddings can be used to process textual data and the role of long short-term memory networks (LSTMs) in helping you solve common natural language processing (NLP) problems. The later chapters will demonstrate how you can implement advanced concepts including transfer learning, generative adversarial networks (GANs), autoencoders, and reinforcement learning. Finally, you can look forward to further content on the latest advancements in the field of neural networks. By the end of this book, you will have the skills you need to build, train, and optimize your own neural network model that can be used to provide predictable solutions. What you will learn * Learn how to train a network by using backpropagation * Discover how to load and transform images for use in neural networks * Study how neural networks can be applied to a varied set of applications * Solve common challenges faced in neural network development * Understand the transfer learning concept to solve tasks using Keras and Visual Geometry Group (VGG) network * Get up to speed with advanced and complex deep learning concepts like LSTMs and NLP * Explore innovative algorithms like GANs and deep reinforcement learning Who this book is for If you are interested in artificial intelligence and deep learning and want to further your skills, then this intermediate-level book is for you. Some knowledge of statistics will help you get the most out of this book.

Gain useful insights to help you efficiently build, test, and migrate customized solutions on Business Central cloud and on-premise platforms Key Features * Explore enhanced functionalities and development best practices in Business Central * Develop powerful Business Central projects using the AL language * Master the new Business Central with easy-to-follow recipes Book Description Microsoft Dynamics 365 Business Central is a complete business management solution that can help you streamline business processes, connect individual departments in your company, and enhance customer interactions. Ok. That first part was really professional sounding, right? Now, let’s get into what this cookbook is going to do for you: put simply, it’s going to help you get things done. This book will help you get to grips with the latest development features and tools for building applications using Business Central. You’ll find recipes that will guide you in developing and testing applications that can be deployed to the cloud or on-premises. For the old-schoolers out there, you’ll also learn how to take your existing Dynamics NAV customizations and move them to the new AL language platform. Also, if you haven’t figured it out already, we’re going to be using very normal language throughout the book to keep things light. After all, developing applications is fun, so why not have fun learning as well! What you will learn * Build and deploy Business Central applications * Use the cloud or local sandbox for application development * Customize and extend your base Business Central application * Create external applications that connect to Business Central * Create automated tests and debug your applications * Connect to external web services from Business Central Who this book is for This book is for Dynamics developers and administrators who want to become efficient in developing and deploying applications in Business Central. Basic knowledge and understanding of Dynamics application development and administration is assumed.