Plan, build, deploy, and monitor data solutions on Azure KEY FEATURES ● Work with PostgreSQL, MySQL, and CosmosDB databases on Microsoft Azure. ● Work with whole data architecture, leverage Azure Storage, Azure Synapse, and Azure Data Lake. ● Data integration strategies with Azure Data Factory and Data Bricks. DESCRIPTION 'Hands-On Azure Data Platform' helps readers get a fundamental understanding of the Database, Data Warehouse, and Data Lake and their management on the Azure Data Platform. The book describes how to work efficiently with Relational and Non-Relational Databases, Azure Synapse Analytics, and Azure Data Lake. The readers will use Azure Databricks and Azure Data Factory to experience data processing and transformation. The book delves deeply into topics like continuous integration, continuous delivery, and the use of Azure DevOps. The book focuses on the integration of Azure DevOps with CI/CD pipelines for data ops solutions. The book teaches readers how to migrate data from an on-premises system or another cloud service provider to Azure. After reading the book, readers will develop end-to-end data solutions using the Azure data platform. Additionally, data engineers and ETL developers can streamline their ETL operations using various efficient Azure services. WHAT YOU WILL LEARN ● In-depth knowledge of the principles of the data warehouse and the data lake. ● Acquaint yourself with Azure Storage Files, Blobs, and Queues. ● Create relational databases on the Azure platform using SQL, PostgreSQL, and MySQL. ● With Cosmos DB, you can create extremely scalable databases and data warehouses. ● Utilize Azure Databricks and Data Factory to develop data integration solutions. WHO THIS BOOK IS FOR This book is designed for big data engineers, data architects, and cloud engineers who want to understand how to use the Azure Data Platform to build enterprise-grade solutions. Learning about databases and the Azure Data Platform would be helpful but not necessary. TABLE OF CONTENTS 1. Getting Started with the Azure Data Platform 2. Working with Relational Databases on Azure 3. Working with Azure Synapse Analytics 4. Working with Azure Data Lake 5. Working with Azure Cosmos DB 6. Working with Azure Databricks 7. Working with Azure Data Factory 8. DevOps with the Azure Data Platform 9. Planning and Migrating On-Premises Azure Workloads to the Azure Data platform 10. Design and Implement Data Solutions on Azure

Discover and apply the Azure platform's most powerful data solutions Cloud technologies are advancing at an accelerating pace, supplanting traditional relational and data warehouse storage solutions with novel, high-value alternatives. Now, three pioneering Azure Data consultants offer an expert introduction to the relational, non-relational, and data warehouse solutions offered by the Azure platform. Drawing on their extensive experience helping organizations get more value from the Microsoft Data Platform, the authors guide you through decision-making, implementation, operations, security, and more. Throughout, step-by-step tutorials and hands-on exercises prepare you to succeed, even if you have no cloud data experience. Three leading experts in Microsoft Azure Data Solutions show how to: Master essential concepts of data storage and processing in cloud environments Handle the changing responsibilities of data engineers moving to the cloud Get started with Azure data storage accounts and other data facilities Walk through implementing relational and non-relational data stores in Azure Secure data using the least-permissions principle, Azure Active Directory, role-based access control, and other methods Develop efficient Azure batch processing and streaming solutions Monitor Azure SQL databases, blob storage, data lakes, Azure Synapse Analytics, and Cosmos DB Optimize Azure data solutions by solving problems with storage, management, and service interactions About This Book For data engineers, systems engineers, IT managers, developers, database administrators, cloud architects, and other IT professionals Requires little or no knowledge about Azure tools and services for data analysis

Explore and work with various Microsoft Azure services for real-time Data Analytics KEY FEATURESÊ Understanding what Azure can do with your data Understanding the analytics services offered by Azure Understand how data can be transformed to generate more data Understand what is done after a Machine Learning model is builtÊ Go through some Data Analytics real-world use cases ÊÊ DESCRIPTIONÊ Data is the key input for Analytics. Building and implementing data platforms such as Data Lakes, modern Data Marts, and Analytics at scale require the right cloud platform that Azure provides through its services. The book starts by sharing how analytics has evolved and continues to evolve. Following the introduction, you will deep dive into ingestion technologies. You will learn about Data processing services in Azure. You will next learn about what is meant by a Data Lake and understand how Azure Data Lake Storage is used for analytical workloads. You will then learn about critical services that will provide actual Machine Learning capabilities in Azure. The book also talks about Azure Data Catalog for cataloging, Azure AD for Access Management, Web Apps and PowerApps for cloud web applications, Cognitive services for Speech, Vision, Search and Language, Azure VM for computing and Data Science VMs, Functions as serverless computing, Kubernetes and Containers as deployment options. Towards the end, the book discusses two use cases on Analytics. WHAT WILL YOU LEARNÊÊ Explore and work with various Azure services Orchestrate and ingest data using Azure Data Factory Learn how to use Azure Stream Analytics Get to know more about Synapse Analytics and its features Learn how to use Azure Analysis Services and its functionalities Ê WHO THIS BOOK IS FORÊ This book is for anyone who has basic to intermediate knowledge of cloud and analytics concepts and wants to use Microsoft Azure for Data Analytics. This book will also benefit Data Scientists who want to use Azure for Machine Learning. Ê TABLE OF CONTENTSÊÊ 1. Ê Data and its power 2. Ê Evolution of Analytics and its Types 3. Ê Internet of Things 4. Ê AI and ML 5. Ê Why cloud 6. Ê What are a data lake and a modern datamart 7. Ê Introduction to Azure services 8. Ê Types of data 9. Ê Azure Data Factory 10. Stream Analytics 11. Azure Data Lake Store and Azure Storage 12. Cosmos DB 13.Ê Synapse Analytics 14.Ê Azure Databricks 15.Ê Azure Analysis Services 16.Ê Power BI 17.Ê Azure Machine Learning 18.Ê Sample Architectures and synergies - Real-Time and Batch 19.Ê Azure Data Catalog 20.Ê Azure Active Directory 21.Ê Azure Webapps 22.Ê Power apps 23.Ê Time Series Insights 24.Ê Azure Cognitive Services 25.Ê Azure Logicapps 26.Ê Azure VM 27.Ê Azure Functions 28.Ê Azure Containers 29.Ê Azure KubernetesÊ Service 30.Ê Use Case 1 31.Ê Use Case 2

Leverage the power of Microsoft Azure Data Factory v2 to build hybrid data solutions Key Features Combine the power of Azure Data Factory v2 and SQL Server Integration Services Design and enhance performance and scalability of a modern ETL hybrid solution Interact with the loaded data in data warehouse and data lake using Power BI Book Description ETL is one of the essential techniques in data processing. Given data is everywhere, ETL will always be the vital process to handle data from different sources. Hands-On Data Warehousing with Azure Data Factory starts with the basic concepts of data warehousing and ETL process. You will learn how Azure Data Factory and SSIS can be used to understand the key components of an ETL solution. You will go through different services offered by Azure that can be used by ADF and SSIS, such as Azure Data Lake Analytics, Machine Learning and Databrick’s Spark with the help of practical examples. You will explore how to design and implement ETL hybrid solutions using different integration services with a step-by-step approach. Once you get to grips with all this, you will use Power BI to interact with data coming from different sources in order to reveal valuable insights. By the end of this book, you will not only learn how to build your own ETL solutions but also address the key challenges that are faced while building them. What you will learn Understand the key components of an ETL solution using Azure Data Factory and Integration Services Design the architecture of a modern ETL hybrid solution Implement ETL solutions for both on-premises and Azure data Improve the performance and scalability of your ETL solution Gain thorough knowledge of new capabilities and features added to Azure Data Factory and Integration Services Who this book is for This book is for you if you are a software professional who develops and implements ETL solutions using Microsoft SQL Server or Azure cloud. It will be an added advantage if you are a software engineer, DW/ETL architect, or ETL developer, and know how to create a new ETL implementation or enhance an existing one with ADF or SSIS.

This book provides a detailed walk-through of Microsoft's Azure Data Studio, which represents a paradigm shift from Microsoft, encompassing the company's recent commitment to open-source, multi-platform, and highly extensible software. This book demonstrates that Azure Data Studio (ADS) is a complete 'software platform', enabling database professionals to: - Dramatically improve, simplify, and accelerate daily tasks- Take advantage of Jupyter Notebooks, and share via GitHub- Easily Support both Microsoft and non-Microsoft platforms- Seamlessly work with data in the Cloud, and On-Premise- Collaborate more easily with internal as well as external clients- Add Extensions to customize and add functionality to ADSThis book also reveals that ADS goes well beyond just the SQL query language. In fact, ADS provides an amazing language fusion of SQL, PowerShell, Python and more for a deeply integrated development environment. Whether you are a SQL Developer, Data Engineer, DBA, or other Data Professional this book will give you head-start with this new and exciting developer platform from Microsoft.

Implement machine learning, cognitive services, and artificial intelligence solutions by leveraging Azure cloud technologies Key FeaturesLearn advanced concepts in Azure ML and the Cortana Intelligence Suite architectureExplore ML Server using SQL Server and HDInsight capabilitiesImplement various tools in Azure to build and deploy machine learning modelsBook Description Implementing Machine learning (ML) and Artificial Intelligence (AI) in the cloud had not been possible earlier due to the lack of processing power and storage. However, Azure has created ML and AI services that are easy to implement in the cloud. Hands-On Machine Learning with Azure teaches you how to perform advanced ML projects in the cloud in a cost-effective way. The book begins by covering the benefits of ML and AI in the cloud. You will then explore Microsoft’s Team Data Science Process to establish a repeatable process for successful AI development and implementation. You will also gain an understanding of AI technologies available in Azure and the Cognitive Services APIs to integrate them into bot applications. This book lets you explore prebuilt templates with Azure Machine Learning Studio and build a model using canned algorithms that can be deployed as web services. The book then takes you through a preconfigured series of virtual machines in Azure targeted at AI development scenarios. You will get to grips with the ML Server and its capabilities in SQL and HDInsight. In the concluding chapters, you’ll integrate patterns with other non-AI services in Azure. By the end of this book, you will be fully equipped to implement smart cognitive actions in your models. What you will learnDiscover the benefits of leveraging the cloud for ML and AIUse Cognitive Services APIs to build intelligent botsBuild a model using canned algorithms from Microsoft and deploy it as a web serviceDeploy virtual machines in AI development scenariosApply R, Python, SQL Server, and Spark in AzureBuild and deploy deep learning solutions with CNTK, MMLSpark, and TensorFlowImplement model retraining in IoT, Streaming, and Blockchain solutionsExplore best practices for integrating ML and AI functions with ADLA and logic appsWho this book is for If you are a data scientist or developer familiar with Azure ML and cognitive services and want to create smart models and make sense of data in the cloud, this book is for you. You’ll also find this book useful if you want to bring powerful machine learning services into your cloud applications. Some experience with data manipulation and processing, using languages like SQL, Python, and R, will aid in understanding the concepts covered in this book

Build a data platform to the industry-leading standards set by Microsoft’s own infrastructure. Summary In Data Engineering on Azure you will learn how to: Pick the right Azure services for different data scenarios Manage data inventory Implement production quality data modeling, analytics, and machine learning workloads Handle data governance Using DevOps to increase reliability Ingesting, storing, and distributing data Apply best practices for compliance and access control Data Engineering on Azure reveals the data management patterns and techniques that support Microsoft’s own massive data infrastructure. Author Vlad Riscutia, a data engineer at Microsoft, teaches you to bring an engineering rigor to your data platform and ensure that your data prototypes function just as well under the pressures of production. You'll implement common data modeling patterns, stand up cloud-native data platforms on Azure, and get to grips with DevOps for both analytics and machine learning. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the technology Build secure, stable data platforms that can scale to loads of any size. When a project moves from the lab into production, you need confidence that it can stand up to real-world challenges. This book teaches you to design and implement cloud-based data infrastructure that you can easily monitor, scale, and modify. About the book In Data Engineering on Azure you’ll learn the skills you need to build and maintain big data platforms in massive enterprises. This invaluable guide includes clear, practical guidance for setting up infrastructure, orchestration, workloads, and governance. As you go, you’ll set up efficient machine learning pipelines, and then master time-saving automation and DevOps solutions. The Azure-based examples are easy to reproduce on other cloud platforms. What's inside Data inventory and data governance Assure data quality, compliance, and distribution Build automated pipelines to increase reliability Ingest, store, and distribute data Production-quality data modeling, analytics, and machine learning About the reader For data engineers familiar with cloud computing and DevOps. About the author Vlad Riscutia is a software architect at Microsoft. Table of Contents 1 Introduction PART 1 INFRASTRUCTURE 2 Storage 3 DevOps 4 Orchestration PART 2 WORKLOADS 5 Processing 6 Analytics 7 Machine learning PART 3 GOVERNANCE 8 Metadata 9 Data quality 10 Compliance 11 Distributing data