academy-it-microsoft-office-vendor-training
  • academy-it-microsoft-office-vendor-training

DP-080T00 – Querying Data with Microsoft Transact-SQL

$1,640.00

About this course

This course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

Course Outline

 

 

SKU: DP-080T00 Categories: , , , Tag:

Description

Audience Profile

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator, or a database developer. It can also be useful for others peripherally involved with data or wanting to learn more about working with data such as solution architects, students and technology managers.

Course Outline

 

Enrolment

Please Fill out the following Enrolment form for your selected course

Related products

  • academy-it-microsoft-office-vendor-training
    DP-300T00A – Administering Relational Databases on Microsoft Azure
    $3,280.00

    About this course

    This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

    Course Outline

     

     

    Select options This product has multiple variants. The options may be chosen on the product page
  • academy-it-microsoft-office-vendor-training
    20742B – Identity with Windows Server 2016
    $4,100.00

    About this course

    This five-day instructor-led course teaches IT Pros how to deploy and configure Active Directory Domain Services (AD DS) in a distributed environment, how to implement Group Policy, how to perform backup and restore, and how to monitor and troubleshoot Active Directory–related issues with Windows Server 2016. Additionally, this course teaches how to deploy other Active Directory server roles such as Active Directory Federation Services (AD FS) and Active Directory Certificate Services (AD CS).

    Course Outline

    Select options This product has multiple variants. The options may be chosen on the product page
  • academy-it-microsoft-office-vendor-training
    DP-100T01 – Designing and Implementing a Data Science Solution on Azure
    $3,280.00

    About this course

    Learn how to operate machine learning solutions at cloud scale using Azure Machine Learning. This course teaches you to leverage your existing knowledge of Python and machine learning to manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring with Azure Machine Learning and MLflow.

    Course Outline

     

    Select options This product has multiple variants. The options may be chosen on the product page
  • academy-it-microsoft-office-vendor-training
    AZ-104T00 – Microsoft Azure Administrator
    $3,280.00

    About this course

    This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution.

    Course Outline

    Select options This product has multiple variants. The options may be chosen on the product page