Opleidingen
56.767
resultaten
Developing Databases using SQL Server
Utrecht
di 24 nov. 2026
Learn the essentials to implementing databases with SQL Server
As a developer you learn how to implement a Microsoft SQL Server database. The course focuses on hans on experience with all common database objects and concepts. You learn how to create tables and other objects like views, functions, stored procedures and triggers. This training also includes indexing, execution plans, concurrency and using constraint for data integrity.
After completing this course, you will be able to:
- Design and Implement Tables, Views, Stored Procedures, User Defined Functions and Triggers
- Ensure Data Integrity through Constraints
- Describe, implement and optimize indexes, including Columnstore indexes
- Understand and implement concurrency in SQL Server
AI-Boosted: Students are encouraged to explore the use of AI tools (such as copilot) to avoid repetitive tasks and accelerate understanding of complex concepts.
- Introduction Database Development
- Design and Implement Tables
- Ensure Data Integrity through Constraints
- Describe indexes, including Columnstore indexes
- Understand, monitor and optimize Query Execution Plans and Statistics
- Design and Implement Views
- Design and Implement Stored Procedures
- Design and Implem…
€2.415
Klassikaal
max 12
3 dagen
Dimensional Modeling
Utrecht
ma 16 nov. 2026
en 1 andere data
Implement Dimensional Models for Business Intelligence
The course Dimensional Modeling, based on Ralph Kimball's ideas and guidelines, provides you with the skills necessary to effectively apply dimensional modeling techniques for Business Intelligence solutions.
You learn to design dimension and fact tables and to track history in order to meet the reporting, analysis, flexibility and performance requirements of the Business Intelligence environment.
- Introduction to Data Warehousing & Data Platforms
- Principles of Dimensional Modeling
- Time, Product and Customer Dimensions
- Fact Tables
- Multiple Fact Tables and Aggregate Tables
- History Tracking (Slowly Changing Dimensions)
- Recursive Relationships
- Data Population, Data Quality and Tools
- Trends in Data Modeling & Data Platforms
€1.610
Klassikaal
max 12
2 dagen
Docker Fundamentals
Utrecht
ma 12 okt. 2026
en 2 andere data
Package your app in a container with Docker
Docker is a platform that enables developers and administrators to package an application inside a container. Using a
container to ship your application helps to guarantee behavior of your application does not change across different
environments. This can be a great benefit to your work as a system administrator, but only when you have a solid
understanding of the docker platform.
After a short intro on containerization in general and your first docker commands, this course will teach you how to
build your own containers and package your application inside. Topics discussed are automating container creation,
working with a registry for distribution and composing complex applications with Docker Compose.
- Introduction to containerization with Docker
- Containers vs images
- Automated building of Images
- Working with Docker hub and registries
- Multi container application composition
€1.610
Klassikaal
max 12
2 dagen
Implementing a Machine Learning solution with Azure Databricks (DP-3014)
Learn to train, tune and manage machine learning models with Azure Databricks
Azure Databricks is a cloud-scale platform for data analytics and machine learning. Data scientists and machine learning engineers can use Azure Databricks to implement machine learning solutions at scale.
- Provision an Azure Databricks workspace.
- Identify core workloads and personas for Azure Databricks.
- Describe key concepts of an Azure Databricks solution.
- Describe key elements of the Apache Spark architecture.
- Create and configure a Spark cluster.
- Describe use cases for Spark.
- Use Spark to process and analyze data stored in files.
- Use Spark to visualize data.
- Prepare data for machine learning
- Train a machine learning model
- Evaluate a machine learning model
- Use MLflow to log parameters, metrics, and other details from experiment runs.
- Use MLflow to manage and deploy trained models.
- Use the Hyperopt library to optimize hyperparameters.
- Distribute hyperparameter tuning across multiple worker nodes.
- Use the AutoML user interface in Azure Databricks
- Use the AutoML API in Azure Databricks
- Train a deep learning model in Azure Databricks
- Distribute deep learning training by using the Horovod library
€805
Klassikaal
max 12
1 dag
Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB (DP-420)
Learn how to create application using the SQL API and SDK for Azure Cosmos DB
This course teaches developers how to create application using the SQL API and SDK for Azure Cosmos DB. Students will learn how to write efficient queries, create indexing policies, manage and provisioned resources, and perform common operations with the SDK.
Audience Profile
Software engineers tasked with authoring cloud-native solutions that leverage Azure Cosmos DB SQL API and its various SDKs. They are familiar with C#, Python, Java, or JavaScript. They also have experience writing code that interacts with a SQL or NoSQL database platform.
Skills gained
- Create and configure Azure Cosmos DB SQL API account, database, and container
- Use the .NET SDK to manage resources and perform operations
- Perform queries of varying complexity
- Design a data modeling and partitioning strategy
- Optimize queries and indexes based on characteristics of an application
- Use the Azure Resource Manager to manage accounts and resources with CLI or JSON and Bicep templates
This course prepares for exam Exam DP-420: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB. This entitle you to Microsoft Certified: Azure Cosmos DB Developer Specialt…
€3.220
Klassikaal
max 12
4 dagen
Microsoft Fabric Analytics Engineer (DP-600)
Design, transform, and serve analysis-ready data at scale
This course covers how to prepare, enrich, and serve data for analysis by consumers such as data analysts, report developers, and AI agents. The course focuses on designing dimensional models and transforming data by using dataflows, notebooks, and T-SQL across lakehouses, warehouses, and eventhouses in Microsoft Fabric. The course also covers building and optimizing semantic models, managing the analytics development lifecycle, and enforcing security and governance across data assets.
Audience Profile
This course is intended for data professionals with experience in data modeling, transformation, and analytics. Learners should have prior experience translating business requirements into analytical measures by using Structured Query Language (SQL) or Data Analysis Expressions (DAX). Experience building semantic models and reports in Power BI is recommended. Familiarity with Kusto Query Language (KQL) and Python is also helpful but not required.
Certification
This course also helps you prepare for the Associate exam DP-600 (Microsoft Certified: Fabric Analytics Engineer Associate)
- Identify the key characteristics of OneLake, lakehouses, warehouses, and eventhouses …
€2.900
Klassikaal
max 12
4 dagen
Implementing a Lakehouse with Microsoft Fabric (DP-601)
Learn to work with lakehouses in Microsoft Fabric
This course is designed to build your foundational skills in data engineering on Microsoft Fabric, focusing on the Lakehouse concept. This course will explore the powerful capabilities of Apache Spark for distributed data processing and the essential techniques for efficient data management, versioning, and reliability by working with Delta Lake tables. This course will also explore data ingestion and orchestration using Dataflows Gen2 and Data Factory pipelines.
This course includes a combination of lectures and hands-on exercises that will prepare you to work with lakehouses in Microsoft Fabric.
Audience Profile
The primary audience for this course is data professionals who are familiar with data modeling, extraction, and analytics. It is designed for professionals who are interested in gaining knowledge about Lakehouse architecture, the Microsoft Fabric platform, and how to enable end-to-end analytics using these technologies.
- Introduction to end-to-end analytics using Microsoft Fabric
- Get started with lakehouses in Microsoft Fabric
- Use Apache Spark in Microsoft Fabric
- Work with Delta Lake tables in Microsoft Fabric
- Ingest Data with Dataflows Gen2 i…
€725
Klassikaal
max 12
1 dag
Implement a Data Warehouse with Microsoft Fabric (DP-602)
Load, Query, Monitor and Secure a Data Warehouse in Microsoft Fabric
Explore the data warehousing process and learn how to load, monitor, secure, and query a warehouse in Microsoft Fabric.
- Describe data warehouses in Fabric.
- Understand a data warehouse vs a data Lakehouse.
- Work with data warehouses in Fabric.
- Create and manage fact tables and dimensions within a data warehouse.
- Learn different strategies to load data into a data warehouse in Microsoft Fabric.
- Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.
- Learn how to load data in a warehouse using T-SQL.
- Learn how to load and transform data with dataflow (Gen 2).
- Use SQL query editor to query a data warehouse.
- Explore how visual query editor works.
- Learn how to connect and query a data warehouse using SQL Server Management Studio.
- Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
- Monitor current activity in the data warehouse with dynamic management views.
- Monitor querying trends with query insights views.
- Learn the concepts of securing a data warehouse in Microsoft Fabric.
- Learn how to implement dynamic data masking to obscure sensitive information.
- Learn how to configure ro…
€805
Klassikaal
max 12
1 dag
Implement Real-Time Intelligence with Microsoft Fabric (DP-603)
Learn to use Eventstreams, KQL databases, Real-Time Dasboards and Data Activator
In this course, you will be exposed to various ways to:
- Source streaming data sources into Microsoft Fabric
- Use real time Eventstream in Microsoft Fabric
- Query data in a KQL database in Microsoft Fabric
- Create real time dashboards in Microsoft Fabric
- Describe Real-Time Intelligence in Microsoft Fabric.
- Create eventhouse databases and tables using KQL database.
- Describe Real-Time hub in Microsoft Fabric.
- Use KQL to query tables and create querysets.
- Establish source and destinations in Eventstream.
- View the data in-flight in eventstream items.
- Capture, transform, and route data using Eventstream.
- Use basic syntax and of Kusto Query Language (KQL).
- Understand the basics of the Queryset canvas.
- Describe how to execute T-SQL queries in the Queryset canvas.
- Describe how to convert T-SQL queries into KQL queries.
- Create a Real-Time Dashboard in Microsoft Fabric.
- Understand some of its advanced features.
- Apply some best practices for effective use.
- Have hands-on experience in a lab exercise.
- Understand Data Activator.
- Understand triggers, conditions, and actions in Data Activator.
- Get data from Power BI …
€805
Klassikaal
max 12
1 dag
Implement a data science and machine learning solution for AI with Microsoft Fabric (DP-604)
Learn to explore and preprocess data, then train, track and deploy models using Microsoft Fabric
Explore the data science process and learn how to train machine learning models to accomplish artificial intelligence in Microsoft Fabric.
- Understand the data science process
- Train models with notebooks in Microsoft Fabric
- Track model training metrics with MLflow and experiments
- Load data and perform initial data exploration.
- Gain knowledge about different types of data distributions.
- Understand the concept of missing data, and strategies to handle missing data effectively.
- Visualize data using various data visualization techniques and libraries.
- Learn Data Wrangler features, and its role in the data science workflow.
- Perform different types of preprocessing operations in data science.
- Learn how to handle missing values, and imputation strategies.
- Use one-hot encoding and other techniques to convert categorical data into a format suitable for machine learning algorithms.
- Train machine learning models with open-source frameworks
- Train models with notebooks in Microsoft Fabric
- Track model training metrics with MLflow and experiments in Microsoft Fabric
- Save a model in the Microsoft Fabric workspace
- Prepare a dataset f…
€805
Klassikaal
max 12
1 dag