Querying Data with Transact
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 explores 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.
Work through multiple modules, each of which explores 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.
For Whom
- Database Administrators, Database Developers, and BI professionals.
Benefits
- Construct and execute queries and sub-queries.
- Create and implement views and table-valued functions in T-SQL.
- Gain knowledge on creating and implementing joins and stored procedures.
- Transform data by implementing pivot, unpivot, rollup, and cube.
- Be able to sort and filter data, use built-in functions and table expressions.
- Acquire insights into group and aggregate data, use set operators, and pivot sets and
- Implement error handling and transactions in T-SQL.
- Create Transact-SQL SELECT queries
- Implement functions and aggregate data
- Query data by using table expressions
- Group and pivot data by using queries
- Implement error handling transactions
- Implement data types and NULLs
Prerequisites
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of relational databases.
Brochure
Coming Soon