Last Update August 20, 2023
0 already enrolled

About This Course

Course Overview :

Transact-SQL (T-SQL) is Microsoft’s and Sybase’s proprietary extension to SQL. SQL, the acronym for Structured Query Language, is a standardized computer language that was originally developed by IBM for querying, altering and defining relational databases, using declarative statements. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc. and changes to the DELETE and UPDATE statements. These additional features make Transact-SQL Turing complete.

Course Content

    • Introduction to Transact-SQL and semantics
    • Types of Transact–SQL statements (DDL, DCL, TCL, DML)
    • Transact–SQL Syntax elements
    • The SQL Query editor
    • Simple SELECT statements
    • Operators
    • Ordering information
    • INSERT/UPDATE statements
    • The TOP clause
    • Aggregate functions (SUM, AVG, COUNT, MAX, MIN)
    • GROUP BY statements
    • Wildcards
    • Entity Relationship Diagrams (ERDs)
    • Join types (INNER, OUTER, CROSS, UNION)
    • Views
    • Stored procedu


  • Variables
  • Transact-SQL in the context of BI projects

Your Instructors


42 Courses
0 Reviews
1 Student
See more
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar