Share Description
In this course, you will :
- Write complex TSQL queries.
- Know the different TSQL functionalities that exist
- Write more efficient TSQL code
Syllabus :
- SQL Views
- SQL Triggers
- SQL Computed Columns
- SQL Stored Procedures
- SQL User Defined Functions (UDF)
- SQL Transactions and Error Handling
- SQL grouping functions and Ranking functions
- SQL XML data-types
- SQL Partitions
- SQL Dynamic Queries
- SQL Filestream and Free-Text Search
- SQL Geography and Geometry datatype
