- Learning Path Libraries: This path is only available in the libraries listed. To access this path, purchase a license for the corresponding library.
- Data
Querying Data with T-SQL from SQL Server
This path is currently outdated and undergoing revisions. This path will be retired once revisions are complete. Please visit the new Query and Modify Data with T-SQL from SQL Server path for the most up-to-date content.
T-SQL is Microsoft's implementation of SQL (Structured Query Language) used to query and manage data in the SQL Server relational database. This skill will teach you how to use T-SQL to query data from SQL Server.
Content in this path
Beginner
Learn to use the SELECT statement, along with JOINs and WHERE clauses, to create organized projections of data stored in SQL Server.
Intermediate
Advanced
Create SQL Server database objects, such as functions and stored procedures, to capture reusable query logic.
- Querying data with the SELECT statement
- Filtering data with the WHERE clause
- Combining data with JOINs
- Aggregating data
- Inserting, updating, and deleting data
- Relational database literacy
- Relational databases (PostgreSQL
- MariaDB
- OracleDB)
- Database administration
- Database development
- Business Intelligence Platforms like Tableau
- Power BI
- Database use in web development