55317: Querying Microsoft SQL Server Training

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