DP-080 Querying Data with Microsoft Transact-SQL
Start: 11.05.2026
Ende: 10.09.2026
Microsoft Transact-SQL gezielt einsetzen: Daten effizient abfragen, strukturieren und analysieren. Mit praktischen Methoden, aktuellen Techniken und verständlichen Beispielen. Für alle, die Daten sicher beherrschen und modern arbeiten wollen.
Inhalte: Arbeiten mit SELECT-Abfragen und Filterlogik.
Sortieren, Gruppieren und Aggregieren von Daten.
Joins und relationale Verknüpfungen.
Unterabfragen und Ausdruckslogik.
Basiswissen zu Views und gespeicherten Abfragen.
Performance-Grundlagen und saubere Syntax.
Sortieren, Gruppieren und Aggregieren von Daten.
Joins und relationale Verknüpfungen.
Unterabfragen und Ausdruckslogik.
Basiswissen zu Views und gespeicherten Abfragen.
Performance-Grundlagen und saubere Syntax.
Ansprechpartner: Frank Opitz
Kurstitel: DP-080 Querying Data with Microsoft Transact-SQL
Abschluss: Microsoft Applied Skills
Förderung: BGS - Bildungsgutschein
Unterrichtsstunden: 40 Std. / Woche
Durchführungsart: Vollzeit
Anwesenheit: Hybrid (gemischt)
Zielgruppe: Bildungshungrige
Voraussetzung: Grundverständnis von Datenbanken und tabellarischen Datenstrukturen.
NH CLC Dortmund GmbH & Co. KG
Stockholmer Allee 30c
44269 Dortmund
Weitere Kurse aus der Kategorie "IT / Telekommunikation" dieses Anbieters:
- CertNexus Artificial Intelligence for Business Professionals (AIBIZ)
- CertNexus Certified Artificial Intelligence Practitioner (CAIP)
- CertNexus Certified Data Science Practitioner (CDSP)
- CertNexus Making ChatGPT and Generative AI Work for You (GenAIBIZ)
- ChatGPT for Developer
- ChatGPT for Managers
- ChatGPT for Prospective Email Writing
- ChatGPT for Sales Professionals
- ChatGPT with Excel
- Prompt Engineering for ChatGPT
- CompTIA SecAI+ Certification
- EC-Council Artificial Intelligence Essentials (AI|E)
- EC-Council Certified AI Program Manager (C|AIPM)
- EC-Council Certified Offensive AI Security Professional (C|OASP)
- EC-Council Certified Responsible AI Governance & Ethics (C|RAGE)
- Artificial Intelligence Compliance Professional
- BCS Artificial Intelligence Essentials
- BCS Artificial Intelligence Foundation
- BCS Generative Artificial Intelligence Award
- BCS Machine Learning Award
- GH-300 GitHub Copilot
- GH-500 GitHub Advanced Security
- GH-900 GitHub Foundations
- AB-730 Transform business workflows with generative AI
- AB-731 Drive AI transformation in your organization
- SC-5006 Get started with Microsoft Copilot for Security
- Introduction to Python
- Python for Data Science
- Python for Machine Learning
- AI+ Agent™
- AI+ Architect™
- AI+ Context Engineering™
- AI+ Data Agent™
- AI+ Data™
- AI+ Developer™
- AI+ Engineer™
- AI+ Foundation™
- AI+ Prompt Engineer Level 1™
- AI+ Prompt Engineer Level 2™
- AI+ Quantum™
- AI+ Robotics™
- AB-100 Architecting agentic AI business solutions
- AI-102 Designing and Implementing a Microsoft Azure AI Solution
- AI-300 Operationalize machine learning and generative AI solutions
- AI-900 Microsoft Azure AI Grundlagen
- AI-901 Introduction to AI in Azure
- AI-3003 Build a natural language processing solution with Azure AI Services
- AI-3008 Extract insights from visual data on Azure
- AI-3016 Develop copilots with Azure AI Studio
- AI-3019 Build AI Apps with Azure Database for PostgreSQL
- AI-3022 Implement AI Skills in Azure AI Search
- AI-3025 Work smarter with AI
- AI-3026 Develop AI agents on Azure
- DP-100 Designing and Implementing a Data Science Solution on Azure
- DP-300 Administering Microsoft Azure SQL Solutions
- DP-420 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB
- DP-600 Microsoft Fabric Analytics Engineer
- DP-601 Implementing a Lakehouse with Microsoft Fabric
- DP-602 Implement a Data Warehouse with Microsoft Fabric
- DP-603 Implementing Real Time Analytics with Microsoft Fabric
- DP-604 Implement a data science and machine learning solution for AI with Microsoft Fabric
- DP-605 Develop dynamic reports with Microsoft Power BI
- DP-700 Microsoft Fabric Data Engineer
- DP-900 Microsoft Azure Daten Grundlagen
- DP-3001 Migrate SQL Server workload to Azure SQL
- DP-3011 Implementing a Data Analytics Solution with Azure Databricks
- DP-3014 Implementing a Machine Learning solution with Azure Databricks
- DP-3015 Getting Started with Cosmos DB NoSQL Development
- DP-3020 Develop data-driven applications with Azure SQL Database
- DP-3021 Configure and migrate to Azure Database for PostgreSQL
- PL-300 Microsoft Power BI Data Analyst
- Certified Information Systems Security Professional Architecture (CISSP-ISSAP)
- Certified Secure Software Lifecycle Professional (CSSLP)
- Linux Professional Institute Certification (LPIC-3) - 303 Security
- MD-102 Microsoft 365 Endpoint Administrator
- MS-102 Microsoft 365 Administrator
- MS-500 Microsoft 365 Sicherheitsadministration
- SC-5001 Configure SIEM security operations using Microsoft Sentinel
- SC-5002 Secure Azure services and workloads with Microsoft Defender for Cloud regulatory compliance controls
- SC-5003 Implement information protection and data loss prevention by using Microsoft Purview
- SC-5004 Defend against cyberthreats with Microsoft Defender XDR
- SC-5007 Implement retention, eDiscovery, and Communication compliance in Microsoft Purview
- SC-5008 Configure and manage entitlement with Microsoft Entra ID
- AI+ Ethical Hacker™
- AI+ Security Compliance™
- AI+ Security Level 1™
- AI+ Security Level 2™
- AI+ Security Level 3™
- Bitcoin+ Security™
- CertNexus CyberSAFE (CBS)
- CertNexus Certified CyberSec First Responder (CFR)
- CertNexus Certified Cyber Secure Coder (CSC)
- Implementing and Administering Cisco Solutions (CCNA)
- Implementing and Operating Cisco® Security Core Technologies (SCOR)
- Implementing Automation for Cisco® Security Solutions (SAUI)
- Securing Email with Cisco Email Security Appliance (SESA)
- Implementing and Configuring Cisco Identity Services Engine (SISE)
- Implementing Secure Solutions with Virtual Private Networks (SVPN)
- Securing the Web with Cisco Web Security Appliance (SWSA)
- CompTIA Advanced Security Practitioner Certification (CASP+)
- CompTIA Cybersecurity Analyst Certification (CySA+)
- CompTIA Penetration Testing Certification (PenTest+)
- DP-3011 Implementing a Data Analytics Solution with Azure Databricks
- CompTIA Security+ Certification
- CompTIA SecurityX Certification
- EC-Council Certified Chief Information Security Officer (C|CISO)
- EC-Council Certified Ethical Hacker (CEH)
- EC-Council Certified Incident Handler (E|CIH)
- DP-3014 Implementing a Machine Learning solution with Azure Databricks
- EC-Council Certified Penetration Testing Professional (C|PENT)
- FortiAnalyzer Administrator (ANLZR-ADMN)
- FortiGate Administrator (FGT-ADM)
- Certified Information Systems Auditor (CISA)
- Certified Information Security Manager® (CISM)
- Certified in Risk and Information Systems Control (CRISC)
- Certified Cloud Security Professional (CCSP)
- Certified Information Systems Security Professional (CISSP)
- Systems Security Certified Practitioner (SSCP)
- CompTIA Linux+ Certification
- SC-100 Microsoft Cybersecurity Architect
- SC-200 Microsoft Security Operations Analyst
- SC-300 Microsoft Identity and Access Administrator
- SC-400 Microsoft Information Protection and Compliance Administrator
- SC-401 Administering Information Protection and Compliance in Microsoft 365
- SC-900 Microsoft Security, Compliance, and Identity Fundamentals
- AZ-500 Microsoft Azure Security Technologies
- DevOps Foundation
- DevOps Master
- DevOps Professional
- AZ-204 Developing Solutions for Microsoft Azure
- AZ-400 Designing and Implementing Microsoft DevOps Solutions
- AZ-2001 Implement security through a pipeline using Azure DevOps
- AZ-2003 Deploy cloud-native apps using Azure Container Apps
- AZ-2005 Develop AI agents using Azure OpenAI and the Semantic Kernel SDK
- AZ-2006 Automate Azure Load Testing by using GitHub Actions
- AZ-2007 Accelerate app development by using GitHub Copilot
- AZ-2008 DevOps Foundations: The Core Principles and Practices
- AZ-2010 Designing and Implementing Platform Engineering
- AI+ Cloud™
- Advanced Developing on AWS
- Architecting on AWS
- AWS Certified Developer - Associate
- AWS Certified Solutions Architect - Associate
- AWS Cloud Practitioner Essentials
- Big Data on AWS
- Developing on AWS
- CWS-215 Citrix Virtual Apps and Desktops 7 Administration On-Premises and In Citrix Cloud
- CWS-415 Citrix Virtual Apps and Desktops 7 Architect Design Solutions
- CXD-252 Moving to the Citrix Virtual Apps and Desktops Service on Citrix Cloud with Microsoft Azure
- CompTIA Cloud+ Certification
- CompTIA Cloud Essentials+ Certification
- EXIN® Cloud Computing Foundation
- AZ-104 Microsoft Azure Administrator
- DP-3014 Implementing a Machine Learning solution with Azure Databricks
- AZ-305 Designing Microsoft Azure Infrastructure Solutions
- DP-3015 Getting Started with Cosmos DB NoSQL Development
- AZ-700 Designing and Implementing Microsoft Azure Networking Solutions
- AZ-800 Verwalten der Windows-Server Hybrid Kerninfrastruktur
- AZ-801 Konfiguration von Windows Server Hybrid Advanced Services
- AZ-900 Microsoft Azure Grundlagen
- AZ-1002 Configure secure access to your workloads using networking with Azure Virtual Network
- AZ-1003 Secure storage for Azure Files and Azure Blob Storage
- AZ-1004 Deploy and configure Azure Monitor
- AZ-1007 Deploy and administer Linux virtual machines on Azure
- AZ-1008 Administer Active Directory Domain Services
- DP-3020 Develop data-driven applications with Azure SQL Database
- DP-3021 Configure and migrate to Azure Database for PostgreSQL
- DP-3028 Implement Generative AI engineering with Azure Databricks
- DP-3029 Work smarter with Copilot in Microsoft Fabric
- PL-100 Microsoft Power Platform App Maker
- AZ-2008 DevOps Foundations The Core Principles and Practices
- PL-200 Microsoft Power Platform Functional Consultant
- PL-300 Microsoft Power BI Data Analyst
- PL-900 Microsoft Power Platform Grundlagen
- MS-700 Managing Microsoft Teams
- MS-721 Collaboration Communications Systems Engineer
- AI+ Agile Project Management Fundamentals™
- PL-7001 Create and Manage Canvas Apps with Power Apps
- PL-7002 Create and Manage Automated Processes by using Power Automate
- PL-7003 Create and Manage Model-Driven Apps with Power Apps and Dataverse
- PL-7008 Create and Extend Custom Copilots in Microsoft Copilot Studio
- 55265 Microsoft® PowerApps
- 55268 Microsoft Power Automate for End Users
- Introduction to Python
- Python for Data Science
- Tableau Fundamentals
- Tableau Desktop Part 1
Für die hier gezeigten Inhalte ist der Anbieter NH CLC Dortmund GmbH & Co. KG verantwortlich.