Building Your First Data Lakehouse Using Azure Synapse Analytics from Pluralsight

In this course, you will learn about Azure Synapse Analytics & its integrated services - Workspace, Dedicated SQL, Apache Spark, Serverless SQL, Pipelines, Synapse Link to Cosmos DB, Power BI - and how it can be used to build a Data Lakehouse.

Data Lakehouse is an architecture that intends to bring the best of Data Warehouses and Data Lakes together. It helps to put together a common platform to handle huge volumes of data, process data faster, and serve multiple use cases. In this course, Building Your First Data Lakehouse Using Azure Synapse Analytics, you'll learn to use Azure Synapse Analytics. It is a totally new product that brings together data integration, enterprise data warehousing, and big data analytics together. It is a set of multiple, well-integrated, Azure Data Services - Workspace, Dedicated SQL Pool, Apache Spark Pool, Serverless SQL, Synapse Pipelines, Synapse Link to Cosmos DB, integrated Power BI workspace, and much more. First, you'll learn how to set up the Synapse workspace by bringing in multiple data sources. Next, you'll discover how to explore the data and how to work with Dedicated SQL Pool, and Apache Spark Pool to extract and transform the data. Finally, you'll explore how to ingest, transform, and orchestrate data using Synapse Pipelines, use a Serverless SQL Pool to build a logical data model, and use connected services to Synapse. By the end of this course, you'll have knowledge and skills to use Synapse Link for Cosmos DB, and the integrated Power BI experience to help to build an end-to-end Data Lakehouse.

What's inside

Syllabus

Course Overview

Getting Started with Data Lakehouse and Azure Synapse Analytics

Working with Dedicated SQL Pool

Transforming Data with Synapse Spark Pool

Ingesting, Transforming, and Orchestrating with Synapse Pipelines

Querying Data Using Serverless SQL Pool

Connecting Services with Azure Synapse Analytics

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops skills in analytics, data science, data warehousing, data lakehouses

Develops knowledge of Apache Spark, Serverless SQL, Synapse Link, Pipelines

Teaches knowledge and skills in a new product, Azure Synapse Analytics

Taught by the instructor Mohit Batra, who is recognized for work in data science

Explores data lakehouses, introducing a standard in industry

Requires experience with data platforms and SQL

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Building Your First Data Lakehouse Using Azure Synapse Analytics with these activities:

Review Azure Synapse Analytics Concepts

Show steps

Refreshes foundational knowledge on Azure Synapse Analytics concepts, enhancing understanding before the course.

Browse courses on Azure Synapse Analytics

Show steps

Review the course description and syllabus
Read introductory articles on Azure Synapse Analytics
Summarize the key concepts of Azure Synapse Analytics

Organize and Review Course Materials

Show steps

Strengthens understanding by ensuring students have organized and accessible course materials, enabling effective review and reinforcement of concepts.

Browse courses on Azure Synapse Analytics

Show steps

Download and gather all course materials
Create a system for organizing and storing materials
Review materials regularly to reinforce learning

Practice SQL Queries in Azure Synapse Analytics

Show steps

Refines SQL skills and familiarizes students with the Azure Synapse Analytics environment, improving their ability to query data effectively.

Browse courses on SQL

Show steps

Create a free Azure Synapse Analytics account
Import sample data into your Azure Synapse Analytics workspace
Practice writing SQL queries to retrieve and manipulate data

Six other activities

Expand to see all activities and additional details

Show all nine activities

Follow Tutorials on Azure Synapse Analytics Features

Show steps

Complements course material by exposing students to external resources, broadening their understanding of Azure Synapse Analytics features and applications.

Browse courses on Azure Synapse Analytics

Show steps

Identify specific Azure Synapse Analytics features to explore
Search for and select relevant tutorials
Follow the tutorials and complete the exercises

Follow Data Lake Analytics Tutorials

Show steps

Supplemental tutorials provide additional hands-on practice to reinforce course concepts.

Browse courses on Data Lakehouse

Show steps

Identify relevant tutorials
Complete tutorials step-by-step
Apply learnings to course assignments

Participate in Azure Synapse Analytics Study Group

Show steps

Promotes peer learning, enhances understanding through group discussions, and provides opportunities to clarify concepts among students.

Browse courses on Azure Synapse Analytics

Show steps

Join or create an Azure Synapse Analytics study group
Discuss course material, share knowledge, and work on projects together
Attend study group meetings regularly

Create a Blog Post on Azure Synapse Analytics Use Cases

Show steps

Enhances understanding of Azure Synapse Analytics applications and reinforces course concepts by requiring students to articulate and explain use cases in a written format.

Browse courses on Azure Synapse Analytics

Show steps

Research different use cases of Azure Synapse Analytics
Choose a specific use case and gather relevant information
Write a blog post that explains the use case, its benefits, and how Azure Synapse Analytics can be used to implement it

Develop a Data Lakehouse Solution Using Azure Synapse Analytics

Show steps

Provides hands-on experience in designing and implementing a comprehensive data lakehouse solution, solidifying course concepts and preparing students for real-world challenges.

Browse courses on Azure Synapse Analytics

Show steps

Define the project scope and objectives
Design the data lakehouse architecture using Azure Synapse Analytics services
Implement the data lakehouse solution
Evaluate and iterate on the solution

Contribute to an Azure Synapse Analytics Open Source Project

Show steps

Provides practical experience in applying Azure Synapse Analytics skills, contributes to the open source community, and enhances understanding by engaging in real-world problem-solving.

Browse courses on Azure Synapse Analytics

Show steps

Identify an Azure Synapse Analytics open source project to contribute to
Review the project's documentation and codebase
Make a contribution to the project

Career center

Learners who complete Building Your First Data Lakehouse Using Azure Synapse Analytics will develop knowledge and skills that may be useful to these careers:

Data Warehouse Developer

Data Warehouse Developers build and manage data warehouses, which are large repositories of data used for reporting and analysis. In this course, you will learn about Azure Synapse Analytics, a platform that brings together data integration, enterprise data warehousing, and big data analytics. This knowledge will provide you with the skills needed to succeed as a Data Warehouse Developer.

See salaries and explore the career path for Data Warehouse Developer

Data Engineer

Data Engineers design, build, and maintain the infrastructure and pipelines that store, process, and analyze data. With this course, you will learn about data integration, enterprise data warehousing, and big data analytics, which are the vital components of data engineering. Gaining these essential skills and knowledge will lay a foundation for your success in this role.

See salaries and explore the career path for Data Engineer

Data Analyst

Data Analysts collect, clean, and analyze data to identify trends and patterns. This course will enhance your data analysis skills by teaching you how to use Azure Synapse Analytics, a platform that combines data integration, enterprise data warehousing, and big data analytics. With this knowledge, you will be able to extract valuable insights from data, making you a more effective Data Analyst.

See salaries and explore the career path for Data Analyst

Data Scientist

Data Scientists use scientific methods, processes, algorithms, and systems to extract knowledge and insights from data. This course will help you build a foundation for a career in Data Science by providing you with a comprehensive understanding of Azure Synapse Analytics, a platform that brings together data integration, enterprise data warehousing, and big data analytics.

See salaries and explore the career path for Data Scientist

Data Architect

Data Architects design and build data systems that meet the specific needs of an organization. This course will equip you with the knowledge and skills needed to succeed in this role by teaching you about Azure Synapse Analytics, a platform that combines data integration, enterprise data warehousing, and big data analytics. With this understanding, you will be able to design and implement data systems that are efficient, scalable, and secure.

See salaries and explore the career path for Data Architect

Business Intelligence Analyst

Business Intelligence Analysts use data to help businesses make better decisions. This course will provide you with the skills and knowledge needed to succeed in this role by teaching you about Azure Synapse Analytics, a platform that brings together data integration, enterprise data warehousing, and big data analytics. With this understanding, you will be able to extract valuable insights from data and communicate them effectively to stakeholders.

See salaries and explore the career path for Business Intelligence Analyst

ETL Developer

ETL Developers design and build data pipelines that extract, transform, and load data from various sources into a data warehouse or other target system. This course will provide you with the skills and knowledge needed to succeed in this role by teaching you about Azure Synapse Analytics, a platform that combines data integration, enterprise data warehousing, and big data analytics. With this understanding, you will be able to design and build data pipelines that are efficient, scalable, and reliable.

See salaries and explore the career path for ETL Developer

Database Administrator

Database Administrators manage and maintain databases, ensuring that they are available, reliable, and secure. This course will provide you with the skills and knowledge needed to succeed in this role by teaching you about Azure Synapse Analytics, a platform that combines data integration, enterprise data warehousing, and big data analytics. With this understanding, you will be able to manage and maintain databases effectively, ensuring that they meet the needs of the organization.

See salaries and explore the career path for Database Administrator

Data Integration Engineer

Data Integration Engineers design and build systems that integrate data from multiple sources into a single, unified view. This course will provide you with the skills and knowledge needed to succeed in this role by teaching you about Azure Synapse Analytics, a platform that combines data integration, enterprise data warehousing, and big data analytics.

See salaries and explore the career path for Data Integration Engineer

Data Management Consultant

Data Management Consultants help organizations improve their data management practices. This course may provide you with some of the skills and knowledge needed to succeed in this role by teaching you about Azure Synapse Analytics, a platform that combines data integration, enterprise data warehousing, and big data analytics.

See salaries and explore the career path for Data Management Consultant

IT Architect

IT Architects design and build the infrastructure and systems that support an organization's IT needs. This course may provide you with some of the skills and knowledge needed to succeed in this role by teaching you about Azure Synapse Analytics, a platform that combines data integration, enterprise data warehousing, and big data analytics.

See salaries and explore the career path for IT Architect

Software Engineer

Software Engineers design, develop, and maintain software applications. This course may provide you with some of the skills and knowledge needed to succeed in this role by teaching you about Azure Synapse Analytics, a platform that combines data integration, enterprise data warehousing, and big data analytics.

See salaries and explore the career path for Software Engineer

Systems Analyst

Systems Analysts design, implement, and maintain computer systems, including hardware, software, and networks. This course may provide you with some of the skills and knowledge needed to succeed in this role by teaching you about Azure Synapse Analytics, a platform that combines data integration, enterprise data warehousing, and big data analytics.

See salaries and explore the career path for Systems Analyst

Cloud Engineer

Cloud Engineers design, build, and maintain cloud-based systems. This course may provide you with some of the skills and knowledge needed to succeed in this role by teaching you about Azure Synapse Analytics, a platform that combines data integration, enterprise data warehousing, and big data analytics.

See salaries and explore the career path for Cloud Engineer

Network Engineer

Network Engineers design, build, and maintain computer networks. This course may provide you with some of the skills and knowledge needed to succeed in this role by teaching you about Azure Synapse Analytics, a platform that combines data integration, enterprise data warehousing, and big data analytics.

See salaries and explore the career path for Network Engineer

Building Your First Data Lakehouse Using Azure Synapse Analytics

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses