Course Highlights
  • Developed Transact-SQL SELECT queries
  • Engaged with data types and NULL
  • Query multiple tables with JOIN
  • Explored set operators
  • Engaged in functions and aggregate data
  • Engaged with subqueries and APPLY
  • Applied table expressions
  • Collaborated with group sets and pivot data
Skills you will learn!
Curriculum

11 Topics
Introduction to Transact-SQL
Querying Tables with SELECT
Querying Multiple Tables with JOIN
Using Set Operators
Using Functions and Aggregating Data
Using Subqueries and APPLY
Using Table Expressions
Grouping Sets and Pivoting Data
Modifying Data
Programming with Transact-SQL
Error Handling and Transactions.

  Write a Review

Data Query with Transact-SQL with Python

Go to Paid Course