Transact-SQL (T-SQL): presentation, functionalities
Basic syntax, data types
Development environment: SQL Server Management Studio, osql
SQL query analyzer
Structure of a T-SQL script SQL
reminders
Execution, debug, help / support

Workshop: Environment installation, T-SQL scripts

Data Extraction (SELECT), filter
functions T-SQL: manipulating strings, dates,
functions T-SQL aggregation
results Grouping
instructions COMPUTE, COMPUTE BY
Joins tables
Formatting results
Subqueries: derived table, expression, correlation

Workshop: Multiple extraction scripts and complex processing

Insertions, updates and deletions with T-SQL
Transactions: definition, implementation
Using triggers
Performance analysis

Workshop: Examples of T-SQL contributions to data modifications, transactions

T-SQL extensions: OUTER / CROSS APPLY, PIVOT / UNPIVOT
Exception management
Views: definition, creation / use
Stored procedures
Code security

Workshop: Implementing stored procedures, using views