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

A: This course is suitable for database professionals, software developers, and anyone interested in learning how to query and manage data in Microsoft SQL Server.

A: Participants should have a basic understanding of relational databases and SQL concepts. Familiarity with the Microsoft Windows operating system and working knowledge of Transact-SQL (T-SQL) would be beneficial but not mandatory.

A: The course covers various topics, including SQL Server architecture, data retrieval using SELECT statements, filtering and sorting data, joining tables, working with functions and aggregating data, modifying data with INSERT, UPDATE, and DELETE statements, working with views, and understanding transactions.

A: The course is typically instructor-led and includes lectures, demonstrations, hands-on lab exercises, and discussions. Participants will have access to course materials and practical exercises to reinforce their learning.

A: While this course does not directly provide a certification, it lays a solid foundation for individuals who plan to pursue Microsoft SQL Server certifications, such as the Microsoft Certified: Azure Data Fundamentals or Microsoft Certified: Data Analyst Associate.

A: Yes, this course is available online as well as in traditional classroom settings. Online courses provide flexibility and allow participants to learn at their own pace.

A: By completing this course, participants will gain a comprehensive understanding of SQL Server querying, enabling them to retrieve, manipulate, and analyze data effectively. This knowledge is essential for database professionals, developers, and analysts working with SQL Server databases.

A: While this course focuses on Microsoft SQL Server, many of the concepts and techniques taught are applicable to other relational database systems. Understanding SQL querying principles will be valuable regardless of the specific database platform being used.

A: After completing this course, participants can explore more advanced SQL Server topics, such as database administration, business intelligence, or data analysis. Microsoft offers a range of specialized courses and certifications for different SQL Server disciplines.