Querying Data with Microsoft Transact-SQL
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
What's Included:
- 4 Day save period
- Free 24/7 premier support
- Free instructor access
Platform Features:
- Seamless paste to virtual machine functionality
- Integrated keyboard language translation for all countries
- Integrated step-by-step instructions
- Remote classroom management for instructors & admins
- Student progress reporting
| Lab | Estimated completion time |
|---|---|
| 1. Get Started with Transact-SQL |
480 mins
|
| 2. Sort and Filter Query Results |
480 mins
|
| 3. Using Joins and Subqueries |
480 mins
|
| 4. Use Built-in Functions |
480 mins
|
| 5. Modify Data |
480 mins
|
| 6. Create queries with table expressions |
60 mins
|
| 7. Combine query results with set operators |
60 mins
|
| 8. Use window functions |
60 mins
|
| 9. Use pivoting and grouping sets |
60 mins
|
| 10. Introduction to programming with Transact-SQL |
60 mins
|
| 11. Create stored procedures and functions in Transact-SQL |
60 mins
|
| 12. Implement error handling with Transact-SQL |
60 mins
|
| 13. Implement transactions with Transact SQL |
60 mins
|
FAQ
If you are unable to place an order for Microsoft content, it may be that your account does not hold the required privileges to do so. Please ensure that you have entered a valid Partner ID in your organisation settings, so we are able to validate your TSP status and grant access accordingly.
Order information is sent via email to the registered email address of the account that was used to place the order. You will receive an order confirmation email with a PDF attachment which includes your lab access information.
If you believe you have ordered the wrong labs, please reach out to our support team.
Orders placed using a debit or credit card cannot be cancelled once they have been placed. Customers that are on monthly invoicing terms can cancel an order, assuming the product access key has not yet been issued / redeemed, up until the cut-off point. If you are unsure of your cut off point, please reach out to your account manager for further information.
If you believe you have ordered the wrong labs, please reach out to our support team.
Support can be reached at either of the following methods:
- Service desk: https://lab.support.godeploy.com
- Email: helpdesk@support.godeploy.com