TSQL

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

res

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