Leverage powerful features of the SQL Server and watch your infrastructure transform into a high-performing, reliable network of systems. Key Features * Explore more than 20 real-world use cases to understand SQL Server features * Get to grips with the SQL Server Always On technology * Learn how to choose HA and DR topologies for your system Book Description Professional SQL Server High Availability and Disaster Recovery explains the high availability and disaster recovery technologies available in SQL Server: Replication, AlwaysOn, and Log Shipping. You’ll learn what they are, how to monitor them, and how to troubleshoot any related problems. You will be introduced to the availability groups of AlwaysOn and learn how to configure them to extend your database mirroring. Through this book, you will be able to explore the technical implementations of high availability and disaster recovery technologies that you can use when you create a highly available infrastructure, including hybrid topologies. By the end of the book, you’ll be equipped with all that you need to know to develop robust and high performance infrastructure. What you will learn * Configure and troubleshoot Replication, AlwaysOn, and Log Shipping * Study the best practices to implement HA and DR solutions * Design HA and DR topologies for the SQL Server and study how to choose a topology for your environment * Use T-SQL to configure replication, AlwaysOn, and log shipping * Migrate from On-Premise SQL Server to Azure SQL Database * Manage and maintain AlwaysOn availability groups for extended database mirroring Who this book is for Professional SQL Server High Availability and Disaster Recovery is for you if you are a database administrator or database developer who wants to improve the performance of your production environment. Prior experience of working with SQL Server will help you get the most out of this book.

Create advanced data and integrated solutions using Azure Event Grid, functions, and containers Key Features * Get familiar with the different design patterns available in Microsoft Azure * Develop Azure cloud architecture and a pipeline management system * Get to know the security best practices for your Azure deployment Book Description Over the years, Azure cloud services have grown quickly, and the number of organizations adopting Azure for their cloud services is also gradually increasing. Leading industry giants are finding that Azure fulfills their extensive cloud requirements. Azure for Architects – Second Edition starts with an extensive introduction to major designing and architectural aspects available with Azure. These design patterns focus on different aspects of the cloud, such as high availability, security, and scalability. Gradually, we move on to other aspects, such as ARM template modular design and deployments. This is the age of microservices and serverless is the preferred implementation mechanism for them. This book covers the entire serverless stack available in Azure including Azure Event Grid, Azure Functions, and Azure Logic Apps. New and advance features like durable functions are discussed at length. A complete integration solution using these serverless technologies is also part of the book. A complete chapter discusses all possible options related to containers in Azure including Azure Kubernetes services, Azure Container Instances and Registry, and Web App for Containers. Data management and integration is an integral part of this book that discusses options for implementing OLTP solutions using Azure SQL, Big Data solutions using Azure Data factory and Data Lake Storage, eventing solutions using stream analytics, and Event Hubs. This book will provide insights into Azure governance features such as tagging, RBAC, cost management, and policies. By the end of this book, you will be able to develop a full-?edged Azure cloud solution that is Enterprise class and future-ready. What you will learn * Create an end-to-end integration solution using Azure Serverless Stack * Learn Big Data solutions and OLTP–based applications on Azure * Understand DevOps implementations using Azure DevOps * Architect solutions comprised of multiple resources in Azure * Develop modular ARM templates * Develop Governance on Azure using locks, RBAC, policies, tags and cost * Learn ways to build data solutions on Azure * Understand the various options related to containers including Azure Kubernetes Services Who this book is for If you are Cloud Architects, DevOps Engineers, or developers who want to learn key architectural aspects of the Azure Cloud platform, then this book is for you. Prior basic knowledge of the Azure Cloud platform is good to have.

Design, develop, and deploy innovative forensic solutions using Python Key Features * Discover how to develop Python scripts for effective digital forensic analysis * Master the skills of parsing complex data structures with Python libraries * Solve forensic challenges through the development of practical Python scripts Book Description Digital forensics plays an integral role in solving complex cybercrimes and helping organizations make sense of cybersecurity incidents. This second edition of Learning Python for Forensics illustrates how Python can be used to support these digital investigations and permits the examiner to automate the parsing of forensic artifacts to spend more time examining actionable data. The second edition of Learning Python for Forensics will illustrate how to develop Python scripts using an iterative design. Further, it demonstrates how to leverage the various built-in and community-sourced forensics scripts and libraries available for Python today. This book will help strengthen your analysis skills and efficiency as you creatively solve real-world problems through instruction-based tutorials. By the end of this book, you will build a collection of Python scripts capable of investigating an array of forensic artifacts and master the skills of extracting metadata and parsing complex data structures into actionable reports. Most importantly, you will have developed a foundation upon which to build as you continue to learn Python and enhance your efficacy as an investigator. What you will learn * Learn how to develop Python scripts to solve complex forensic problems * Build scripts using an iterative design * Design code to accommodate present and future hurdles * Leverage built-in and community-sourced libraries * Understand the best practices in forensic programming * Learn how to transform raw data into customized reports and visualizations * Create forensic frameworks to automate analysis of multiple forensic artifacts * Conduct effective and efficient investigations through programmatic processing Who this book is for If you are a forensics student, hobbyist, or professional seeking to increase your understanding in forensics through the use of a programming language, then Learning Python for Forensics is for you. You are not required to have previous experience in programming to learn and master the content within this book. This material, created by forensic professionals, was written with a unique perspective and understanding for examiners who wish to learn programming.

Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL Key Features * Explore the new and advanced features of MySQL 8.0 * Use advanced techniques to optimize MySQL performance * Create MySQL-based applications for your enterprise with the help of practical examples Book Description Advanced MySQL 8 teaches you to enhance your existing database infrastructure and build various tools to improve your enterprise applications and overall website performance. The book starts with the new and exciting MySQL 8.0 features and how to utilize them for maximum efficiency. As you make your way through the chapters, you will learn to optimize MySQL performance using indexes and advanced data query techniques for large queries. You will also discover MySQL Server 8.0 settings and work with the MySQL data dictionary to boost the performance of your database. In the concluding chapters, you will cover MySQL 8.0 Group Replication, which will enable you to create elastic, highly available, and fault-tolerant replication topologies. You will also explore backup and recovery techniques for your databases and understand important tips and tricks to help your critical data reach its full potential. By the end of this book, you’ll have learned about new MySQL 8.0 security features that allow a database administrator (DBA) to simplify user management and increase the security of their multi-user environments. What you will learn * Explore new and exciting features of MySQL 8.0 * Analyze and optimize large MySQL queries * Understand MySQL Server 8.0 settings * Master the deployment of Group Replication and use it in an InnoDB cluster * Monitor large distributed databases * Discover different types of backups and recovery methods for your databases * Explore tips to help your critical data reach its full potential Who this book is for Advanced MySQL 8 is for database administrators, data architects, and database developers who want to dive deeper into building advanced database applications in the MySQL environment.

Create distributed applications with clever design patterns to solve complex problems Key Features * Set up and run distributed algorithms on a cluster using Dask and PySpark * Master skills to accurately implement concurrency in your code * Gain practical experience of Python design patterns with real-world examples Book Description This Learning Path shows you how to leverage the power of both native and third-party Python libraries for building robust and responsive applications. You will learn about profilers and reactive programming, concurrency and parallelism, as well as tools for making your apps quick and efficient. You will discover how to write code for parallel architectures using TensorFlow and Theano, and use a cluster of computers for large-scale computations using technologies such as Dask and PySpark. With the knowledge of how Python design patterns work, you will be able to clone objects, secure interfaces, dynamically choose algorithms, and accomplish much more in high performance computing. By the end of this Learning Path, you will have the skills and confidence to build engaging models that quickly offer efficient solutions to your problems. This Learning Path includes content from the following Packt products: * Python High Performance - Second Edition by Gabriele Lanaro * Mastering Concurrency in Python by Quan Nguyen * Mastering Python Design Patterns by Sakis Kasampalis What you will learn * Use NumPy and pandas to import and manipulate datasets * Achieve native performance with Cython and Numba * Write asynchronous code using asyncio and RxPy * Design highly scalable programs with application scaffolding * Explore abstract methods to maintain data consistency * Clone objects using the prototype pattern * Use the adapter pattern to make incompatible interfaces compatible * Employ the strategy pattern to dynamically choose an algorithm Who this book is for This Learning Path is specially designed for Python developers who want to build high-performance applications and learn about single core and multi-core programming, distributed concurrency, and Python design patterns. Some experience with Python programming language will help you get the most out of this Learning Path.

Integrate Redux with React and other front-end JavaScript frameworks efficiently and manage application states effectively Key Features * Get better at building web applications with state management using Redux * Learn the fundamentals of Redux to structure your app more efficiently * This guide will teach you develop complex apps that would be easier to maintain Book Description Starting with a detailed overview of Redux, we will follow the test-driven development (TDD) approach to develop single-page applications. We will set up JEST for testing and use JEST to test React, Redux, Redux-Sage, Reducers, and other components. We will then add important middleware and set up immutableJS in our application. We will use common data structures such as Map, List, Set, and OrderedList from the immutableJS framework. We will then add user interfaces using ReactJS, Redux-Form, and Ant Design. We will explore the use of react-router-dom and its functions. We will create a list of routes that we will need in order to create our application, and explore routing on the server site and create the required routes for our application. We will then debug our application and integrate Redux Dev tools. We will then set up our API server and create the API required for our application. We will dive into a modern approach to structuring our server site components in terms of Model, Controller, Helper functions, and utilities functions. We will explore the use of NodeJS with Express to build the REST API components. Finally, we will venture into the possibilities of extending the application for further research, including deployment and optimization. What you will learn * Follow the test-driven development (TDD) approach to develop a single-page application * Add important middleware, such as Redux store middleware, redux-saga middleware, and language middleware, to your application * Understand how to use immutableJS in your application * Build interactive components using ReactJS * Configure react-router-redux and explore the differences between react-router-dom and react-router-redux * Use Redux Dev tools to debug your application * Set up our API server and create the API required for our application Who this book is for This book is meant for JavaScript developers interesting in learning state management and building easy to maintain web applications.

Build, design and improve advanced business intelligence solutions using Tableau’s latest features, including Tableau Prep, Tableau Hyper, and Tableau Server Key Features * Master new features in Tableau 2019.1 to solve real-world analytics challenges * Perform Geo-Spatial Analytics, Time Series Analysis, and self-service analytics using real-life examples * Build and publish dashboards and explore storytelling using Python and MATLAB integration support Book Description Tableau is one of the leading business intelligence (BI) tools used to solve BI and analytics challenges. With this book, you will master Tableau's features and offerings in various paradigms of the BI domain. This book is also the second edition of the popular Mastering Tableau series, with new features, examples, and updated code. The book covers essential Tableau concepts and its advanced functionalities. Using Tableau Hyper and Tableau Prep, you’ll be able to handle and prepare data easily. You’ll gear up to perform complex joins, spatial joins, union, and data blending tasks using practical examples. Following this, you’ll learn how to perform data densification to make displaying granular data easier. Next, you’ll explore expert-level examples to help you with advanced calculations, mapping, and visual design using various Tableau extensions. With the help of examples, you’ll also learn about improving dashboard performance, connecting Tableau Server, and understanding data visualizations. In the final chapters, you’ll cover advanced use cases such as Self-Service Analytics, Time Series Analytics, and Geo-Spatial Analytics, and learn to connect Tableau to R, Python, and MATLAB. By the end of this book, you’ll have mastered the advanced offerings of Tableau and be able to tackle common and not-so-common challenges faced in the BI domain. What you will learn * Get up to speed with various Tableau components * Master data preparation techniques using Tableau Prep * Discover how to use Tableau to create a PowerPoint-like presentation * Understand different Tableau visualization techniques and dashboard designs * Interact with the Tableau server to understand its architecture and functionalities * Study advanced visualizations and dashboard creation techniques * Brush up on powerful Self-Service Analytics, Time Series Analytics, and Geo-Spatial Analytics Who this book is for This book is designed for business analysts, BI professionals and data analysts who want to master Tableau to solve a range of data science and business intelligence problems. The book is ideal if you have a good understanding of Tableau and want to take your skills to the next level.

Design interactive graphics and visuals for your data-driven applications using the popular open-source Chart.js data visualization library. Key Features * Harness the power of JavaScript, HTML, and CSS to create interactive visualizations * Display quantitative information efficiently in the form of attractive charts by using Chart.js * A practical guide for creating data-driven applications using open-source JavaScript library Book Description Chart.js is a free, open-source data visualization library, maintained by an active community of developers in GitHub, where it rates as the second most popular data visualization library. If you want to quickly create responsive Web-based data visualizations for the Web, Chart.js is a great choice. This book guides the reader through dozens of practical examples, complete with code you can run and modify as you wish. It is a practical hands-on introduction to Chart.js. If you have basic knowledge of HTML, CSS and JavaScript you can learn to create beautiful interactive Web Canvas-based visualizations for your data using Chart.js. This book will help you set up Chart.js in a Web page and show how to create each one of the eight Chart.js chart types. You will also learn how to configure most properties that override Chart’s default styles and behaviors. Practical applications of Chart.js are exemplified using real data files obtained from public data portals. You will learn how to load, parse, filter and select the data you wish to display from those files. You will also learn how to create visualizations that reveal patterns in the data. This book is based on Chart.js version 2.7.3 and ES2015 JavaScript. By the end of the book, you will be able to create beautiful, efficient and interactive data visualizations for the Web using Chart.js. What you will learn * Learn how to create interactive and responsive data visualizations using Chart.js * Learn how to create Canvas-based graphics without Canvas programming * Create composite charts and configure animated data updates and transitions * Efficiently display quantitative information using bar and line charts, scatterplots, and pie charts * Learn how to load, parse, and filter external files in JSON and CSV formats * Understand the benefits of using a data visualization framework Who this book is for The ideal target audience of this book includes web developers and designers, data journalists, data scientists and artists who wish to create interactive data visualizations for the Web. Basic knowledge of HTML, CSS, and JavaScript is required. No Canvas knowledge is necessary.

Start empowering users and protecting corporate data, while managing identities and access with Microsoft Azure in different environments Key Features * Understand how to identify and manage business drivers during transitions * Explore Microsoft Identity and Access Management as a Service (IDaaS) solution * Over 40 playbooks to support your learning process with practical guidelines Book Description Microsoft Azure and its Identity and access management are at the heart of Microsoft's software as service products, including Office 365, Dynamics CRM, and Enterprise Mobility Management. It is crucial to master Microsoft Azure in order to be able to work with the Microsoft Cloud effectively. You’ll begin by identifying the benefits of Microsoft Azure in the field of identity and access management. Working through the functionality of identity and access management as a service, you will get a full overview of the Microsoft strategy. Understanding identity synchronization will help you to provide a well-managed identity. Project scenarios and examples will enable you to understand, troubleshoot, and develop on essential authentication protocols and publishing scenarios. Finally, you will acquire a thorough understanding of Microsoft Information protection technologies. What you will learn * Apply technical descriptions to your business needs and deployments * Manage cloud-only, simple, and complex hybrid environments * Apply correct and efficient monitoring and identity protection strategies * Design and deploy custom Identity and access management solutions * Build a complete identity and access management life cycle * Understand authentication and application publishing mechanisms * Use and understand the most crucial identity synchronization scenarios * Implement a suitable information protection strategy Who this book is for This book is a perfect companion for developers, cyber security specialists, system and security engineers, IT consultants/architects, and system administrators who are looking for perfectly up–to-date hybrid and cloud-only scenarios. You should have some understanding of security solutions, Active Directory, access privileges/rights, and authentication methods. Programming knowledge is not required but can be helpful for using PowerShell or working with APIs to customize your solutions.

Harness the power of Python objects and data structures to implement algorithms for analyzing your data and efficiently extracting information Key Features * Turn your designs into working software by learning the Python syntax * Write robust code with a solid understanding of Python data structures * Understand when to use the functional or the OOP approach Book Description This Learning Path helps you get comfortable with the world of Python. It starts with a thorough and practical introduction to Python. You’ll quickly start writing programs, building websites, and working with data by harnessing Python's renowned data science libraries. With the power of linked lists, binary searches, and sorting algorithms, you'll easily create complex data structures, such as graphs, stacks, and queues. After understanding cooperative inheritance, you'll expertly raise, handle, and manipulate exceptions. You will effortlessly integrate the object-oriented and not-so-object-oriented aspects of Python, and create maintainable applications using higher level design patterns. Once you’ve covered core topics, you’ll understand the joy of unit testing and just how easy it is to create unit tests. By the end of this Learning Path, you will have built components that are easy to understand, debug, and can be used across different applications. This Learning Path includes content from the following Packt products: * Learn Python Programming - Second Edition by Fabrizio Romano * Python Data Structures and Algorithms by Benjamin Baka * Python 3 Object-Oriented Programming by Dusty Phillips What you will learn * Use data structures and control flow to write code * Use functions to bundle together a sequence of instructions * Implement objects in Python by creating classes and defining methods * Design public interfaces using abstraction, encapsulation and information hiding * Raise, define, and manipulate exceptions using special error objects * Create bulletproof and reliable software by writing unit tests * Learn the common programming patterns and algorithms used in Python Who this book is for If you are relatively new to coding and want to write scripts or programs to accomplish tasks using Python, or if you are an object-oriented programmer for other languages and seeking a leg up in the world of Python, then this Learning Path is for you. Though not essential, it will help you to have basic knowledge of programming and OOP.

Simplify your ETL processes with these hands-on data hygiene tips, tricks, and best practices. Key Features * Focus on the basics of data wrangling * Study various ways to extract the most out of your data in less time * Boost your learning curve with bonus topics like random data generation and data integrity checks Book Description For data to be useful and meaningful, it must be curated and refined. Data Wrangling with Python teaches you the core ideas behind these processes and equips you with knowledge of the most popular tools and techniques in the domain. The book starts with the absolute basics of Python, focusing mainly on data structures. It then delves into the fundamental tools of data wrangling like NumPy and Pandas libraries. You’ll explore useful insights into why you should stay away from traditional ways of data cleaning, as done in other languages, and take advantage of the specialized pre-built routines in Python. This combination of Python tips and tricks will also demonstrate how to use the same Python backend and extract/transform data from an array of sources including the Internet, large database vaults, and Excel financial tables. To help you prepare for more challenging scenarios, you’ll cover how to handle missing or wrong data, and reformat it based on the requirements from the downstream analytics tool. The book will further help you grasp concepts through real-world examples and datasets. By the end of this book, you will be confident in using a diverse array of sources to extract, clean, transform, and format your data efficiently. What you will learn * Use and manipulate complex and simple data structures * Harness the full potential of DataFrames and numpy.array at run time * Perform web scraping with BeautifulSoup4 and html5lib * Execute advanced string search and manipulation with RegEX * Handle outliers and perform data imputation with Pandas * Use descriptive statistics and plotting techniques * Practice data wrangling and modeling using data generation techniques Who this book is for Data Wrangling with Python is designed for developers, data analysts, and business analysts who are keen to pursue a career as a full-fledged data scientist or analytics expert. Although, this book is for beginners, prior working knowledge of Python is necessary to easily grasp the concepts covered here. It will also help to have rudimentary knowledge of relational database and SQL.

Implement neural network architectures by building them from scratch for multiple real-world applications. Key Features * From scratch, build multiple neural network architectures such as CNN, RNN, LSTM in Keras * Discover tips and tricks for designing a robust neural network to solve real-world problems * Graduate from understanding the working details of neural networks and master the art of fine-tuning them Book Description This book will take you from the basics of neural networks to advanced implementations of architectures using a recipe-based approach. We will learn about how neural networks work and the impact of various hyper parameters on a network's accuracy along with leveraging neural networks for structured and unstructured data. Later, we will learn how to classify and detect objects in images. We will also learn to use transfer learning for multiple applications, including a self-driving car using Convolutional Neural Networks. We will generate images while leveraging GANs and also by performing image encoding. Additionally, we will perform text analysis using word vector based techniques. Later, we will use Recurrent Neural Networks and LSTM to implement chatbot and Machine Translation systems. Finally, you will learn about transcribing images, audio, and generating captions and also use Deep Q-learning to build an agent that plays Space Invaders game. By the end of this book, you will have developed the skills to choose and customize multiple neural network architectures for various deep learning problems you might encounter. What you will learn * Build multiple advanced neural network architectures from scratch * Explore transfer learning to perform object detection and classification * Build self-driving car applications using instance and semantic segmentation * Understand data encoding for image, text and recommender systems * Implement text analysis using sequence-to-sequence learning * Leverage a combination of CNN and RNN to perform end-to-end learning * Build agents to play games using deep Q-learning Who this book is for This intermediate-level book targets beginners and intermediate-level machine learning practitioners and data scientists who have just started their journey with neural networks. This book is for those who are looking for resources to help them navigate through the various neural network architectures; you'll build multiple architectures, with concomitant case studies ordered by the complexity of the problem. A basic understanding of Python programming and a familiarity with basic machine learning are all you need to get started with this book.