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
    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
  • academy-it-microsoft-office-vendor-training
    55255A – SharePoint for Office 365 End User Training
    $2,460.00

    About this course

    This three-day instructor-led SharePoint for Office 365 End User Training class is for end users and site owners/managers new to working in a SharePoint environment in Office 365. The course teaches SharePoint basics such as working with lists and libraries, basic page customization, working with forms and managing site permissions and users.

    Course Outline

    Select options
  • academy-it-microsoft-office-vendor-training
    20744C – Securing Windows Server 2016
    $4,100.00

    About this course

    This five-day, instructor-led course teaches IT professionals how they can enhance the security of the IT infrastructure that they administer. This course begins by emphasizing the importance of assuming that network breaches have occurred already, and then teaches you how to protect administrative credentials and rights to help ensure that administrators can perform only the tasks that they need to, when they need to. This course explains how you can use auditing and the Advanced Threat Analysis feature in Windows Server 2016 to identify security issues. You will also learn how to mitigate malware threats, secure your virtualization platform, and use deployment options such as Nano server and containers to enhance security. The course also explains how you can help protect access to files by using encryption and dynamic access control, and how you can enhance your network’s security.

    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