55317: Querying Microsoft SQL Server Training

Category

SQL

Rating
4.8
(4.8)
Price

$1595
Per Participant

Course Description

55317 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.


Training Exclusives

  • Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
  • Access to Microsoft Official Courseware (MOC).
  • Real-time Virtual Lab Environment.
  • Experience 24*7 Learner Support.
  • Self-paced learning and flexible schedules.

Prerequisites for this training

  • Experience working on Windows computers.

Who should attend this course?

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.

microsoft logoMicrosoft Certified Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

  • Virtual Live Training

Jun 07, 2023

9:00 am - 5:00 pm EST
Online
  • Virtual Live Training

Jun 21, 2023

9:30 am - 5:30 pm EST
Online
  • Virtual Live Training

Jul 05, 2023

9:00 am - 5:00 pm EST
Online
GTR
  • Virtual Live Training
  • Guaranteed to Run

Jul 12, 2023

9:30 am - 5:30 pm EST
Online
  • Virtual Live Training

Jul 26, 2023

9:00 am - 5:00 pm EST
Online
  • Virtual Live Training

Aug 02, 2023

9:30 am - 5:30 pm EST
Online
  • Virtual Live Training

Aug 16, 2023

9:00 am - 5:00 pm EST
Online
  • Virtual Live Training

Aug 30, 2023

9:00 am - 5:00 pm EST
Online
GTR
  • Virtual Live Training
  • Guaranteed to Run

Sep 13, 2023

9:00 am - 5:00 pm EST
Online
  • Virtual Live Training

Sep 27, 2023

9:00 am - 5:00 pm EST
Online
Request Batch

What you will learn

  • 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

Curriculum

This module explains how to use SQL Server Management Studio (SSMS) to query SQL Server databases.

Lessons

  • Lesson 1: Introduction to SSMS
  • Lesson 2: SSMS querying options
  • Lesson 3: Managing SSMS queries
  • Lab 1: Querying data with SQL Server Management Studio

  • Exercise 1: Introduction to SSMS
  • Exercise 2: SSMS querying options
  • Exercise 3: Managing SSMS queries
  • After completing this module, students will be able to:

  • Use SSMS
  • Run T-SQL scripts in SSMS
  • Manage scripts in SSMS
  • This module explains how to use Azure Data Studio to query SQL Server databases.

    Lessons

  • Lesson 1: Introduction to Azure Data Studio
  • Lesson 2: Azure Data Studio querying options
  • Lesson 3: Managing Azure Data Studio queries
  • Lab 1: Querying data with Azure Data Studio

  • Exercise 1: Introduction to Azure Data Studio
  • Exercise 2: Azure Data Studio querying options
  • Exercise 3: Managing Azure Data Studio queries
  • After completing this module, students will be able to:

  • Use Azure Data Studio tool
  • Run scripts in Azure Data Studio
  • Manage scripts in Azure Data Studio
  • This module explains how to write basic SELECT queries.

    Lessons

  • Lesson 1: Using the SELECT statement
  • Lesson 2: Working with table columns
  • Lesson 3: Working with table rows
  • Lab 1: Basic Transact-SQL Queries

  • Exercise 1: Using the SELECT statement
  • Exercise 2: Working with table columns
  • Exercise 3: Working with table rows
  • After completing this module, students will be able to:

  • Write SELECT statements
  • Filter table columns
  • Filter and sort table rows
  • This module explains how to write more complex SELECT statements and query multiple tables.

    Lessons

  • Lesson 1: Using Unions and Joins
  • Lesson 2: Using Subqueries
  • Lesson 3: Using Common Table Expressions (CTEs)
  • Lesson 4: Grouping data
  • Lab 1: Advanced Transact-SQL Queries

  • Exercise 1: Using Unions and Joins
  • Exercise 2: Using Subqueries
  • Exercise 3: Using Common Table Expressions (CTEs)
  • Exercise 4: Grouping data
  • After completing this module, students will be able to:

  • Join data from different tables
  • Use subqueries
  • Use CTEs
  • Aggregate data from one or more columns
  • This module explains how to improve the performance of database queries.

    Lessons

  • Lesson 1: Identifying performance issues
  • Lesson 2: Altering tables and queries
  • Lesson 3: Using Indexes
  • Lab 1: Optimizing Query Performance

  • Exercise 1: Identifying performance issues
  • Exercise 2: Altering tables and queries
  • Exercise 3: Using Indexes
  • After completing this module, students will be able to:

  • Identify query performance problems
  • Modify tables and queries to improve query performance
  • Use indexes to improve query performance
  • This module explains how to use Data Modification Language (DML) statements to add, change or delete data.

    Lessons

  • Lesson 1: Using INSERT
  • Lesson 2: Using UPDATE
  • Lesson 3: Using DELETE
  • Lab 1: Modifying data with INSERT, UPDATE, and DELETE

  • Exercise 1: Using INSERT
  • Exercise 2: Using UPDATE
  • Exercise 3: Using DELETE
  • After completing this module, students will be able to:

  • Use INSERT statements
  • Use UPDATE statements
  • Use DELETE statements
  • This module explains how to use XML and JSON data in a SQL Server database.

    Lessons

  • Lesson 1: Storing XML and JSON records
  • Lesson 2: Querying XML and JSON records
  • Lesson 3: Converting records to XML and JSON formats
  • Lab 1: Working with XML and JSON data

  • Exercise 1: Storing XML and JSON records
  • Exercise 2: Querying XML and JSON records
  • Exercise 3: Converting records to XML and JSON formats
  • After completing this module, students will be able to:

  • Store XML and JSON data in SQL Server
  • Query XML and JSON data
  • Convert database records to XML or JSON formats
  • This module explains how to create and use built-in and user created T-SQL programming objects in SQL Server.

    Lessons

  • Lesson 1: Using Built-in Procedures and Functions
  • Lesson 2: Creating Stored Procedures
  • Lesson 3: Creating Functions
  • Lab 1: Using Stored Procedures and Functions

  • Exercise 1: Using Built-in Procedures and Functions
  • Exercise 2: Creating Stored Procedures
  • Exercise 3: Creating Functions
  • After completing this module, students will be able to:

  • Use Built-in Procedures and Functions
  • Create stored procedures
  • Create functions
  • This module explains how to query SQL Server using non-SQL languages.

    Lessons

  • Lesson 1: Query SQL Server using sqlcmd
  • Lesson 2: Query SQL Server using PowerShell
  • Lesson 3: Query SQL Server using Python
  • Lab 1: Query SQL Server programmatically

  • Exercise 1: Query SQL Server using sqlcmd
  • Exercise 2: Query SQL Server using PowerShell
  • Exercise 3: Query SQL Server using Python
  • After completing this module, students will be able to:

  • Query SQL Server using sqlcmd
  • Query SQL Server using PowerShell
  • Query SQL Server using Python
  • This module explains how to use different methods to create permanent connections to external data sources.

    Lessons

  • Lesson 1: Using Linked Servers
  • Lesson 2: Using PolyBase
  • Lab 1: Managing External Data Sources

  • Exercise 1: Using Linked Servers
  • Exercise 2: Using PolyBase
  • Lab 2: Capstone Lab (Optional)

  • Exercise 1: Querying SQL Server database records
  • After completing this module, students will be able to:

  • Use Linked Servers
  • Use PolyBase
  • With Microtek Learning, you’ll receive:

    • Certified Instructor-led training
    • Industry Best Trainers
    • Official Training Course Student Handbook
    • Pre and Post assessments/evaluations
    • Collaboration with classmates (not available for a self-paced course)
    • Real-world knowledge activities and scenarios
    • Exam scheduling support*
    • Learn and earn program*
    • Practice Tests
    • Knowledge acquisition and exam-oriented
    • Interactive online course.
    • Support from an approved expert
    • For Government and Private pricing*

    * For more details call: +1-800-961-0337 or Email: info@microteklearning.com

    Request Call

    Our Clients

    For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.

    • 300+ enterprise clients
    • 100,000+ professionals trained
    • Service 70 of the Fortune 100
    • 96% of our clients would recommend us
    our clients

    Our Awards

    our awards
    why choose us

    REVIEWS ON OUR POPULAR COURSES

    male

    I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.

    MARTIN

    TORONTO, CANADA

    • (5)
    male

    I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.

    Prince N.

    Texas

    • (5)
    male

    I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.

    Marsh George

    Texas

    • (5)
    Accredited By
    img-55317-querying-microsoft-sql-server.jpg

    Course Details

    • Start Date: Jun 07, 2023
    • Duration: 3 Days
    • Skill Level: Intermediate
    • Enrolled: 2452
    • Price: $1595
    • Course PDF: Click Here
    side post side mode

    Talk to Learning Advisor