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

 

Reviews

There are no reviews yet.

Be the first to review “55317A – Querying Microsoft SQL Server”

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

Related products

  • academy-it-microsoft-office-vendor-training
    20740C – Installation, Storage, and Compute with Windows Server 2016
    $4,100.00

    About this course

    This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, requirements, and storage and compute options that are available and applicable to Windows Server 2016.

    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
    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
    MS-700T00 – Managing Microsoft Teams
    $3,280.00

    About this course

    The Managing Microsoft Teams course is designed for persons who are aspiring to the Microsoft 365 Teams Admin role. A Microsoft Teams administrator plans, deploys, configures, and manages Microsoft Teams to focus on efficient and effective collaboration and communication in a Microsoft 365 environment. In this course, you will learn about various Teams management tools, security and compliance feature for Teams, network requirement for Teams deployment as well as different Teams settings and policies for managing collaboration and communication experience in Teams.

    Course Outline

    Select options