Type and hit enter to Search
×

Querying Microsoft SQL Server

  • 4.8(45,337 Rating)

Course Overview

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.

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

  • 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

Schedule Dates

Querying Microsoft SQL Server
08 July 2024 - 10 July 2024
Querying Microsoft SQL Server
08 October 2024 - 10 October 2024
Querying Microsoft SQL Server
08 January 2025 - 10 January 2025
Querying Microsoft SQL Server
08 April 2025 - 10 April 2025

Course Content

  • Introduction to SSMS
  • SSMS querying options
  • Managing SSMS queries

  • Introduction to Azure Data Studio
  • Azure Data Studio querying options
  • Managing Azure Data Studio queries

  • Using the SELECT statement
  • Working with table columns
  • Working with table rows

  • Using Unions and Joins
  • Using Subqueries
  • Using Common Table Expressions (CTEs)
  • Grouping data

  • Identifying performance issues
  • Altering tables and queries
  • Using Indexes

  • Using INSERT
  • Using UPDATE
  • Using DELETE

FAQs

No FAQs Found
Start learning with 15.8k students around the world.
  • 3.3k
    Courses
  • 100+
    Certified Instructors
  • 99.9%
    Success Rate
Open chat
Hello
How Can We Help You?