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.
Course Price : $1595 Per Participant
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.
Courses
Years of Experience
Global Learners
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.
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).
This module explains how to use SQL Server Management Studio (SSMS) to query SQL Server databases.
Lessons
Lab 1: Querying data with SQL Server Management Studio
After completing this module, students will be able to:
This module explains how to use Azure Data Studio to query SQL Server databases.
Lessons
Lab 1: Querying data with Azure Data Studio
After completing this module, students will be able to:
This module explains how to write basic SELECT queries.
Lessons
Lab 1: Basic Transact-SQL Queries
After completing this module, students will be able to:
This module explains how to write more complex SELECT statements and query multiple tables.
Lessons
Lab 1: Advanced Transact-SQL Queries
After completing this module, students will be able to:
This module explains how to improve the performance of database queries.
Lessons
Lab 1: Optimizing Query Performance
After completing this module, students will be able to:
This module explains how to use Data Modification Language (DML) statements to add, change or delete data.
Lessons
Lab 1: Modifying data with INSERT, UPDATE, and DELETE
After completing this module, students will be able to:
This module explains how to use XML and JSON data in a SQL Server database.
Lessons
Lab 1: Working with XML and JSON data
After completing this module, students will be able to:
This module explains how to create and use built-in and user created T-SQL programming objects in SQL Server.
Lessons
Lab 1: Using Stored Procedures and Functions
After completing this module, students will be able to:
This module explains how to query SQL Server using non-SQL languages.
Lessons
Lab 1: Query SQL Server programmatically
After completing this module, students will be able to:
This module explains how to use different methods to create permanent connections to external data sources.
Lessons
Lab 1: Managing External Data Sources
Lab 2: Capstone Lab (Optional)
After completing this module, students will be able to:
©2023 Microtek Learning – All Rights Reserved