70-761: Querying Data with Transact-SQL
Intermediate
20h
By: Doug Perez
Overview
In this instructor-led, online training course, students will be introduced to Transact-SQL. Students will be given a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
Modules
1. Create Transact-SQL SELECT Queries
1.1 Create Transact-SQL SELECT Queries - Part 11h 5m
1.2 Create Transact-SQL SELECT Queries - Part 21h 4m
2. Query Multiple Tables By Using Joins
2.1 Query Multiple Tables By Using Joins1h 5m
3. Implement Functions and Aggregate Data
3.1 Implement Functions and Aggregate Data1h 2m
4. Query Data by Using Subqueries and APPLY
4.1 Query Data by Using Subqueries and APPLY - Part 147 min
4.2 Query Data by Using Subqueries and APPLY - Part 258 min
4.3 Query Data by Using Subqueries and APPLY - Part 340 min
5. Query Data by Using Table Expressions
5.1 Query Data by Using Table Expressions - Part 138 min
5.2 Query Data by Using Table Expressions - Part 252 min
5.3 Query Data by Using Table Expressions - Part 315 min
6. Group and Pivot Data By Using Queries
6.1 Group and Pivot Data By Using Queries - Part 11h 5m
6.2 Group and Pivot Data By Using Queries - Part 257 min
7. Query Temporal Data and Non-Relational Data
7.1 Query Temporal Data and Non-Relational Data - Part 155 min
7.2 Query Temporal Data and Non-Relational Data - Part 226 min
7.3 Query Temporal Data and Non-Relational Data - Part 31h 17m
8. Create Database Programmability Objects by Using Transact-SQL
8.1 Create Database Programmability Objects by Using Transact-SQL - Part 11h 15m
8.2 Create Database Programmability Objects by Using Transact-SQL - Part 240 min
8.3 Create Database Programmability Objects by Using Transact-SQL - Part 336 min
9. Implement Error Handling and Transactions
9.1 Implement Error Handling and Transactions - Part 11h 1m
9.2 Implement Error Handling and Transactions - Part 251 min
10. Implement Data Types and NULLs
10.1 Implement Data Types and NULLs - Part 155 min
10.2 Implement Data Types and NULLs - Part 21h 26m
Ready to Elevate Your Team's Learning?
Talk with our sales team to see how StormWind can transform the way your organization trains and grows.
CONTACT SALES