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

DP-080T00A – 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

 

 

Clear
SKU: DP-080T00A 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.

At Course Completion

After completing this course, students will be able to:

  • Use SQL Server query tools
  • Write SELECT statements to retrieve columns from one or more tables
  • Sort and filter selected data
  • Use built-in functions to returned data values
  • Create groups of data and aggregate the results

Course Outline

 

Reviews

There are no reviews yet.

Be the first to review “DP-080T00A – Querying Data with Microsoft Transact-SQL”

Your email address will not be published. Required fields are marked *

Related products

  • academy-it-microsoft-office-vendor-training
    AZ-020T00A – Microsoft Azure solutions for AWS developers
    $2,460.00

    About this course

    A three-day course designed to teach AWS (Amazon Web Services) developers how to prepare end-to-end solutions in Microsoft Azure. In this course you will construct Azure App Service Web App solutions and Azure Functions, use blob or Cosmos DB storage in solutions, implement secure cloud solutions that include user authentication and authorization, implement API management, and develop event- and message-based solutions, and monitor, troubleshoot, and optimize your Azure solutions. You will learn how developers use Azure services, with additional focus on features and tasks that differ from AWS, and what that means for you as you develop applications that will be hosted by using Azure services.

    Course Outline

     

    Select options
  • academy-it-microsoft-office-vendor-training
    20743C – Upgrading Your Skills to MCSA: Windows Server 2016
    $4,100.00

    About this course

    This five-day, instructor-led course explains how to implement and configure new Windows Server 2016 features and functionality. This course is for information technology (IT) professionals who want to upgrade their technical skills from Windows Server 2008 or Windows Server 2012 to Windows Server 2016. This course presumes a high level of knowledge about previous Windows Server technologies and skills equivalent to the Microsoft Certified Solutions Associate (MCSA): Windows Server 2008 or Windows Server 2012 credential.

    This course is not a product-upgrade course, detailing considerations for migrating and upgrading students’ specific environment to Windows Server 2016. Rather, this course provides updates to students’ existing Windows Server knowledge and skills, as they pertain to Windows Server 2016.

    Course Outline

    Select options
  • academy-it-microsoft-office-vendor-training
    AI-900T00A – Microsoft Azure AI Fundamentals
    $820.00

    About this course

    This course introduces fundamentals concepts related to artificial intelligence (AI), and the services in Microsoft Azure that can be used to create AI solutions. The course is not designed to teach students to become professional data scientists or software developers, but rather to build awareness of common AI workloads and the ability to identify Azure services to support them. The course is designed as a blended learning experience that combines instructor-led training with online materials on the Microsoft Learn platform (https://azure.com/learn). The hands-on exercises in the course are based on Learn modules, and students are encouraged to use the content on Learn as reference materials to reinforce what they learn in the class and to explore topics in more depth.

    Course Outline

    Select options
  • academy-it-microsoft-office-vendor-training
    DA-100T00A – Analyzing Data with Power BI
    $3,280.00

    About this course

    This course will discuss the various methods and best practices that are in line with business and technical requirements for modelling, visualizing, and analysing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.

    Course Outline

    Select options