- Learning Path Libraries: This path is only available in the libraries listed. To access this path, purchase a license for the corresponding library.
- Data
Query Data with T-SQL from SQL Server
This learning path is actively in production. More content will be added to this page as it gets published and becomes available in the library. The planned content for this path includes the following: - Query Data with T-SQL (video course) - Join and Combine Data with T-SQL (video course) - Filter and Sort Data with T-SQL (video course) - Group and Aggregate Data with T-SQL (video course) - Modify Data with T-SQL (video course) - Query Non-traditional Data with T-SQL (video course) - Write Reliable and Reusable T-SQL Code (video course) - Query Data with T-SQL from SQL Server (Skill IQ)
Transact-SQL (T-SQL) is Microsoft's extenstion of SQL, used to query, shape, and modify data within SQL Server. This learning path teaches you how to use T-SQL to perform a variety of actions within SQL Server databases, including retrieving and filtering data, grouping and aggregating data, and safely updating data. After watching the content in this path, you'll have the skills to write reliable T-SQL code for data analysis tasks.
Content in this path
Query Data with T-SQL from SQL Server
Watch the following courses to get started.
- How to query data with T-SQL
- How to join and combine data with T-SQL
- How to group and aggregate data with T-SQL
- How to modify data with T-SQL
- How to query non-traditional data with T-SQL
- How to write reliable and reusable T-SQL code
- Learners interested in this content should have a solid understanding of general database concepts and terminology, including familiarity with tables, rows, and columns. Learners will also benefit from basic programming knowledge, especially in SQL, but this is not required.
- Microsoft SQL Server
- SQL
- Relational databases
- Data analysis