Packt Conference : Put Generative AI to work on Oct 11-13 (Virtual)
Code: USD75OFF
Azure Synapse Analytics Cookbook
This is the code repository for Azure Synapse Analytics Cookbook, published by Packt.
Implement a limitless analytical platform using effective recipes for Azure Synapse
What is this book about?
As data warehouse management becomes increasingly integral to successful organizations, choosing and running the right solution is more important than ever. Microsoft Azure Synapse is an enterprise-grade, cloud-based data warehousing platform, and this book holds the key to using Synapse to its full potential. If you want the skills and confidence to create a robust enterprise analytical platform, this cookbook is a great place to start.
You'll learn and execute enterprise-level deployments on medium-to-large data platforms. Using the step-by-step recipes and accompanying theory covered in this book, you'll understand how to integrate various services with Synapse to make it a robust solution for all your data needs. Whether you're new to Azure Synapse or just getting started, you'll find the instructions you need to solve any problem you may face, including using Azure services for data visualization as well as for artificial intelligence (AI) and machine learning (ML) solutions.
By the end of this Azure book, you'll have the skills you need to implement an enterprise-grade analytical platform, enabling your organization to explore and manage heterogeneous data workloads and employ various data integration services to solve real-time industry problems.
This book covers the following exciting features:
- Discover the optimal approach for loading and managing data
- Work with notebooks for various tasks, including ML
- Run real-time analytics using Azure Synapse Link for Cosmos DB
- Perform exploratory data analytics using Apache Spark
- Read and write DataFrames into Parquet files using PySpark
- Create reports on various metrics for monitoring key KPIs
- Combine Power BI and Serverless for distributed analysis
- Enhance your Synapse analysis with data visualizations
If you feel this book is for you, get your copy today!
Instructions and Navigations
All of the code is organized into folders.
The code will look like the following:
SELECT name, is_auto_create_stats_on
FROM sys.databases
Following is what you need for this book: This book is for data architects, data engineers, and developers who want to learn and understand the main concepts of Azure Synapse analytics and implement them in real-world scenarios.
With the following software and hardware list you can run all code files present in the book (Chapter 1-9).
Software and Hardware List
| Chapter | Software required | OS required |
|---|---|---|
| 1-11 | An Azure subscription, SQL Server Management Studio, Power BI Desktop, and Azure Synapse Pathway | Windows 8.1+ |
We also provide a PDF file that has color images of the screenshots/diagrams used in this book. Click here to download it.
Related products
Get to Know the Author
Gaurav Agarwal is a cloud solution architect at Microsoft India Corp. Ltd, working closely with Microsoft clients on Azure data and AI, Azure ML, big data, IoT, and Power BI. He has extensive experience in architecting and transforming data solutions for the modern cloud, and expertise in building large-scale enterprise data warehouse solutions.
Meenakshi Muralidharan leads modern data platforms and is a renowned chief architect for an Indian multinational information technology services and consulting company. She has extensive experience in building large scale data platforms and applications in Microsoft Azure.
Download a free PDF
If you have already purchased a print or Kindle version of this book, you can get a DRM-free PDF version at no cost.
Simply click on the link to claim your free PDF.