SQL
$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.
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:
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.
I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.
Texas
I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.
Texas
I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.
MARTIN
TORONTO, CANADA