55317A - Querying Microsoft SQL Server Courseware
55317A is the updated version of the retired legacy Microsoft Official Curriculum (MOC) course 20461. This 3-day instructor-led 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. New content has been added to help administrators leverage new Machine Learning features in SQL Server. Students will run T-SQL, Python and R queries on SQL Server databases. 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 SQL Server database tools. 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 Azure Data Studio Use Data Virtualization Use PolyBase Use Azure Synapse Link Course Details Module 1: Querying data with SQL Server Management Studio Module 2: Querying data with Azure Data Studio Module 3: Basic Transact-SQL Queries Module 4: Advanced Transact-SQL Queries Module 5: Optimizing Query Performance Module 6: Modifying data with INSERT, UPDATE, DELETE and MERGE Module 7: Working with XML and JSON data Module 8: Using Stored Procedures and Functions Module 9: Query SQL Server programmatically Module 10: Managing External Data Sources