Querying Data with Microsoft Transact-SQL (SF)
About This Course
• Describe key capabilities and components of SQL Server.
• Describe T-SQL, sets, and predicate logic.
• Write a single table SELECT statement.
• Write a multi-table SELECT statement.
• Write SELECT statements with filtering and sorting.
• Describe how SQL Server uses data types.
• Write DML statements.
• Execute stored procedures
• Program with T-SQL
• Implement error handling
• Implement transactions
• Write queries that use built-in functions.
• Write queries that aggregate data.
• Write subqueries.
• Create and implement views and table-valued functions.
• Use set operators to combine query results.
• Use window ranking, offset and aggregate functions
• Implement pivoting and grouping sets
What You'll Learn
Leaners will learn to:
• Use the basic components of SQL Server querying tools.
• Manage data with Transact-SQL
• Query data with advanced Transact-SQL components
• Program databases by using Transact-SQL
The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.
Entry Requirements
• Basic knowledge of the Microsoft Windows operating system and its core functionality.