Querying Data with Transact SQL online course offered by Microsoft
The Querying Data with Transact SQL is a free online course offered by Microsoft conducted by the Edx. From querying and modifying data in SQL Server or Azure SQL to programming with Transact-SQL, learn essential skills that employers need.
About this course
Timings: 4 – 5 hours per week
Self Paced
For more details, please visit: https://www.edx.org/course/querying-data-with-transact-sql-2
- Transact-SQL is an essential skill for data professionals and developers working with SQL databases.
- With this combination of expert instruction, demonstrations, and practical labs, step from your first SELECT statement through to implementing transactional programmatic logic.
- Work through multiple modules, each of which explore a key area of the Transact-SQL language, with a focus on querying and modifying data in Microsoft SQL Server or Azure SQL Database.
- The labs in this course use a sample database that can be deployed easily in Azure SQL Database, so you get hands-on experience with Transact-SQL without installing or configuring a database server.
- Create Transact-SQL SELECT queries
- Work with data types and NULL
- Query multiple tables with JOIN
- Explore set operators
- Use functions and aggregate data
- Work with subqueries and APPLY
- Use table expressions
- Group sets and pivot data
- Modify data
- Program with Transact-SQL
- Implement error handling and transactions
Timings: 4 – 5 hours per week
Self Paced
For more details, please visit: https://www.edx.org/course/querying-data-with-transact-sql-2
