Overview
- Covers Delta Lake and Data Lakehouse as intrinsic parts of Azure Synapse Analytics
- Includes use cases and reference architecture for Synapse Analytics
- Presents Synapse SQL best practices
- Provides details of Synapse SQL and Synapse Spark architecture and their main components
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (10 chapters)
Keywords
About this book
The book begins with an introduction to core data and analytics concepts followed by an understanding of traditional/legacy data warehouse, modern data warehouse, and the most modern data lakehouse. You will go through the introduction and background of Azure Synapse Analytics along with its main features and key service capabilities. Core architecture is discussed, along with Synapse SQL. You will learn its main features and how to create a dedicated Synapse SQL pool and analyze your big data using Serverless Synapse SQL Pool. You also will learn Synapse Spark and Synapse Pipelines, with examples. And you will learn Synapse Workspace and Synapse Studio followed by Synapse Link and its features. You will go through use cases in Azure Synapse and understand the reference architecture for Synapse Analytics.
After reading this book, you will be able to work with Azure Synapse Analytics and understand its architecture, main components, features, and capabilities.
What You Will Learn
- Understand core data and analytics concepts and data lakehouse concepts
- Be familiar with overall Azure Synapse architecture and its main components
- Be familiar with Synapse SQL and Synapse Spark architecture components
- Work with integrated Apache Spark (aka Synapse Spark) and Synapse SQL engines
- Understand Synapse Workspace, Synapse Studio, and Synapse Pipeline
- Study reference architecture and use cases
Who This Book Is For
Azure data analysts, data engineers, data scientists, and solutions architects
Authors and Affiliations
About the author
He has worked on various technologies, including Visual Basic, SQL Server, SharePoint Technologies, .NET MVC, O365, Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure Data Lake Storage Gen1/Gen2, Azure SQL Data Warehouse, Power BI, Spark SQL, Scala, Delta Lake, Azure Machine Learning, Azure Information Protection, Azure .NET SDK, Azure DevOps, and more.
He holds multiple Azure certifications that include Microsoft Certified Azure Solutions Architect Expert, Microsoft Certified Azure Data Engineer Associate, Microsoft Certified Azure Data Scientist Associate, and Microsoft Certified Azure Data Analyst Associate.
Bhadresh has worked as Solutions Architect on a large-scale Azure Data Lake implementation project as well as on a data transformation project and on large-scale customized content management systems. He has also worked as Technical Reviewer for the book Data Science using Azure, prior to authoring this book.
Bibliographic Information
Book Title: Beginning Azure Synapse Analytics
Book Subtitle: Transition from Data Warehouse to Data Lakehouse
Authors: Bhadresh Shiyal
DOI: https://doi.org/10.1007/978-1-4842-7061-5
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Bhadresh Shiyal 2021
Softcover ISBN: 978-1-4842-7060-8Published: 17 June 2021
eBook ISBN: 978-1-4842-7061-5Published: 16 June 2021
Edition Number: 1
Number of Pages: XXII, 249
Number of Illustrations: 66 b/w illustrations
Topics: Microsoft and .NET, Big Data