Azure Synapse training course | JBI Training | Remote and in | Remote | Virtual

Highlights

Query data in the lake
Create metadata objects
Secure data and manage users
Understand big data engineering
Transform data with DataFrames in Apache Spark pools with Databricks
Integrate SQL and Apache Spark pools within Azure Synapse Analytics and Databricks
Use data loading best practice
Petabyte-scale ingestion with Azure Data Factory or Azure Synapse Pipelines
Data integration
Code-free transformation at scale
Orchestrate data movement and transformation
Secure a data warehouse in Azure Synapse Analytics
Implement compliance controls for sensitive data
Design hybrid transactional and analytical processing
Configure Azure Synapse Link with Azure Cosmos DB
Query Azure Cosmos DB

Course Details

Introduction to Azure Synapse Analytics
Explore Azure Synapse serverless SQL pools capabilities
Query data in the lake using Azure Synapse serverless SQL pools
Create metadata objects in Azure Synapse serverless SQL pools
Secure data and manage users in Azure Synapse serverless SQL pools
Understand big data engineering with Apache Spark in Azure Synapse Analytics
Ingest data with Apache Spark notebooks in Azure Synapse Analytics
Transform data with DataFrames in Apache Spark Pools in Azure Synapse Analytics (databricks)
Integrate SQL and Apache Spark pools in Azure Synapse Analytics (databricks)
Use data loading best practices in Azure Synapse Analytics
Petabyte-scale ingestion with Azure Data Factory or Azure Synapse Pipelines
Data integration with Azure Data Factory or Azure Synapse Pipelines
Code-free transformation at scale with Azure Data Factory or Azure Synapse Pipelines
Orchestrate data movement and transformation in Azure Data Factory or Azure Synapse Pipelines
Secure a data warehouse in Azure Synapse Analytics
Implement compliance controls for sensitive data
Design hybrid transactional and analytical processing using Azure Synapse Analytics
Configure Azure Synapse Link with Azure Cosmos DB
Query Azure Cosmos DB with Apache Spark for Azure Synapse Analytics
Query Azure Cosmos DB with SQL serverless for Azure Synapse Analytics

Who should attend

Data and Analytics professionals who need to use Azure Synapse to accelerate time to insight across data warehouses and big data systems.

Feedback

4.8 out of 5 average

“I liked the theory element of the course which gave me a good understanding of the role of databricks and a data factory and how they could be useful on my projects.”

JS, Data analyst

“It was a very useful two days introduction to Azure and I thought the labs were really helpful to get some hands on experience using the tools. The trainer was very helpful and patient in helping with issues arising with the lab exercises.”

JM, Insights analyst

Sign up for the JBI Training newsletter to receive technology tips directly from our instructors - Analytics, AI, ML, DevOps, Web, Backend and Security.

More about this course

On our Azure Logic Apps training course, students learn how to create enterprise-grade integration solutions using Logic Apps, API Apps, the Enterprise Integration Pack, and Azure Service Bus.

At the core of the course is Logic Apps and how to use this cutting-edge technology to build integration workflows. However, Logic Apps primarily provide process orchestration and API integration. In order to build well-rounded enterprise integrations, you may desire publish-subscribe capabilities, hybrid connectivity, and VETER pipelines.

As a result, you will see how to interact with other Azure services such as Azure Service Bus, as well as on-premises systems like SQL Server, and how you can add to the out-of-the-box tools in Logic Apps with the Enterprise Integration Pack.

This course offers the full picture for developers who need to build integration solutions using the Azure platform, and gives students about 20 hours of hands-on lab time in which they will build several integration solutions.

In this course, attendees will receive live instruction from one of our expert trainers, in-classroom demonstrations, challenging hands-on labs, and an electronic copy of the presentation materials and lab guide with hands-on activities.

FAQs

JBI Training offers a full range of Microsoft AI training courses covering Microsoft Copilot (Essentials, 365 Introduction, 365 Advanced, 365 Deep Dive, and Pro), AI agent development in Copilot Studio and Microsoft 365 Copilot, AI solutions with Microsoft Foundry and Azure OpenAI, machine learning with Azure Databricks and Azure Machine Learning, C# AI development with Semantic Kernel, and Azure AI application development. Courses are available for beginners through to expert-level practitioners.

Yes. All JBI Microsoft AI training courses are available as live online instructor-led sessions. They are also available at JBI's London training centre or as onsite delivery at your organisation's premises anywhere in the UK.

No prior AI experience is required for introductory Copilot courses such as Microsoft Copilot Essentials or Microsoft Copilot 365 Introduction. These are designed for users who are new to Copilot and AI tools. Advanced and Deep Dive courses assume familiarity with Microsoft 365 and some prior Copilot usage. Developer-focused courses such as Building AI Agents with C# .NET and Semantic Kernel require software development experience.

Microsoft Copilot is an AI productivity assistant embedded in Microsoft 365 applications including Word, Excel, Teams, Outlook, and PowerPoint. Microsoft Copilot Studio is a low-code development platform that enables organisations to build custom AI agents, chatbots, and automated workflows that integrate with Microsoft 365 and other business systems. JBI offers training courses for both.

Yes. All JBI Microsoft AI training courses can be delivered as bespoke closed-group programmes for corporate teams. Content can be tailored to your organisation's Microsoft 365 licence level, existing infrastructure, team experience, and specific business objectives. JBI delivers Microsoft AI training to organisations across the UK, including teams in the public sector, financial services, and large enterprise environments.

Microsoft Fabric is a unified data analytics platform that integrates data engineering, data warehousing, data science, real-time analytics, and business intelligence capabilities into a single environment. JBI Training offers a 2-day Microsoft Fabric course covering architecture, data pipelines, Lakehouse design, and AI-powered analytics. The course is suitable for data engineers, architects, and analytics professionals working in the Microsoft ecosystem.

Azure OpenAI Service is Microsoft's cloud-hosted deployment of OpenAI models — including GPT-4, GPT-4o, and DALL-E — within the Azure platform. It offers the same model capabilities as OpenAI's public API but with Azure's enterprise security, compliance, private networking, and data residency controls. JBI's Microsoft Foundry and Azure OpenAI training courses cover building production AI solutions using these services.

Microsoft 365 Copilot requires a Microsoft 365 Business Standard, Business Premium, E3, or E5 licence plus a Copilot add-on licence. Some Copilot features are available through Copilot Pro for individual users. JBI's training courses are designed to work with the licence level your organisation has in place. Contact JBI to confirm which course best matches your current Microsoft environment.

JBI Microsoft AI training is designed for business professionals and IT users who want to improve productivity with Microsoft Copilot, developers and architects building AI applications on Azure and Microsoft Foundry, data engineers and ML practitioners using Azure Databricks or Azure Machine Learning, and teams looking to deploy custom AI agents using Copilot Studio or Semantic Kernel. Courses are available at beginner, intermediate, and advanced levels across all these roles.

JBI Training keeps its Microsoft AI course content up to date with Microsoft's ongoing product releases and updates across Copilot, Azure OpenAI, Microsoft Foundry, Semantic Kernel, and the Power Platform. Microsoft's AI ecosystem evolves rapidly — new Copilot features, model updates, and Azure AI capabilities are released frequently — and JBI's courses are reviewed and updated on a regular basis to ensure delegates are learning the most current tools, features, and best practices available.

Azure Synapse with Databricks training course

Use Azure Synapse Link to automatically move data from both operational databases and business applications without time-consuming extract, transform, and load (ETL) processes.

Public Courses

Customised Courses

Highlights

Course Details

Who should attend

Feedback

4.8 out of 5 average

Newsletter

More about this course

FAQs

Highlights

Course Details

Who should attend

Feedback

4.8 out of 5 average

Newsletter

More about this course

FAQs

What Microsoft AI training courses does JBI offer?

Are these Microsoft AI courses available online?

Do I need prior AI experience for Microsoft Copilot training?

What is the difference between Microsoft Copilot and Microsoft Copilot Studio?

Can Microsoft AI training be customised for corporate teams?

What is Microsoft Fabric and does JBI offer training?

What is Azure OpenAI and how does it differ from OpenAI?

What level of Microsoft 365 licence do I need for Copilot?

Who should attend Microsoft AI training?

How current is JBI's Microsoft AI training content?

Email this page to yourself