55317B Querying Microsoft SQL Server 2025
This three-day beginner course teaches students how to use Transact-SQL and other languages to query Microsoft SQL Server 2025 and Azure SQL Database. Using demonstrations and hands-on labs, students will master core querying skills, performance optimization, and semi-structured or vector data handling. This course serves as the foundation for all SQL Server-related disciplines including Database Administration, Database Development, and Business Intelligence. The material will focus on modern and updated features and tools used when working with SQL Server.
What's included?
-
10 Modules
-
10 Reviews
-
10 Labs
Audience
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 instructor-led 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 Visual Studio Code
• Use Data Virtualization
• Use PolyBase
• Use Azure Synapse Link
Course Lessons
Guaranteed Security using one of the most advanced encrypted systems on the market.
The information in this page is being processed and encrypted securely using industry-leading encryption and fraud prevention tools.