Querying Data with Microsoft Transact-SQL Training
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.
Duration
Target Audience
- Anyone who needs to write basic SQL or Transact-SQL queries.
- Anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer.
Skills Gained
- Use SQL Server query tools
- Write SELECT statements to retrieve columns from one or more tables
- Sort and filter selected data
- Use built-in functions to returned data values
- Create groups of data and aggregate the results
- Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE
- Introduction to Transact-SQL
- Sort and filter results in T-SQL
- Combine multiple tables with JOINs in T-SQL
- Write Subqueries in T-SQL
- Use built-in functions and GROUP BY in Transact-SQL
- Modify data with T-SQL
Partner Registration
The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.
You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.
Partner Registration
The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.
You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.
Partner Registration
The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.
You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.
Partner Registration
The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.
You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.