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

55317A – Querying Microsoft SQL Server

$2,460.00

About this course

55317A is the updated version of the retired legacy MOC course 20461. This three-day course teaches students how to use basic Transact-SQL statements and other languages to query modern editions of Microsoft SQL Server and Azure SQL Server. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. By using demonstrations and hands-on labs, attendees will learn to perform these tasks using SQL Server, Azure Data Studio, and other database tools.

Course Outline

 

Clear
SKU: 55317A Categories: , , , , , Tag:

Description

Audience Profile

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. Report writers, business analysts, application developers and SQL users who want to familiarize themselves with SQL Server will also benefit from this material.

At Course Completion

After completing this course, students will be able to:

  • Query, sort and filter data in database tables
  • Query external data sources
  • Query SQL Server and Azure SQL Server programmatically
  • Optimize query performance
  • Modify data using Transact-SQL
  • Work with XML and JSON formatted data
  • Use stored procedures and functions
  • Use SQL Server tools like SSMS and Azure Data Studio
  • Use Linked Servers
  • Use PolyBase

Prerequisites

Experience working on Windows computers.

Course Outline

 

Related products

  • academy-it-microsoft-office-vendor-training
    AZ-900T00 – Microsoft Azure Fundamentals
    $820.00

    About this course

    This course will provide foundational level knowledge on cloud concepts; core Azure services; and Azure management and governance features and tools.

    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
    AZ-400T00 – Designing and Implementing Microsoft DevOps Solutions
    $3,280.00

    About this course

    This course provides the knowledge and skills to design and implement DevOps processes and practices. Students will learn how to plan for DevOps, use source control, scale Git for an enterprise, consolidate artifacts, design a dependency management strategy, manage secrets, implement continuous integration, implement a container build strategy, design a release strategy, set up a release management workflow, implement a deployment pattern, and optimize feedback mechanisms.

    Course Outline

     

    Select options
  • 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