Training
SQL Server Advanced T-SQL
Even though it's easy to get started writing T-SQL code, there is also a lot to learn if you want to make sure that your code effectively uses the current features of the product and is easy to maintain.

This course is one of our most favourite courses and provides insights into using T-SQL effectively. Many previous course attendees have commented that they thought they knew about T-SQL and SQL Server until they attended the course. They were amazed by how much they could still learn.

The course is targeted at application developers that are generating T-SQL queries and designing SQL Server applications and also to existing SQL Server developers and DBAs.

While our courses are based on SQL Server 2016, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014. Where there are differences between versions, the differences are clearly highlighted.

City
Dates
Course Price
Early Bird Price
There isn't a public offering for this course scheduled at present but please contact us to register your interest or to request a quote for private training.
Day
Code
Module
1
AT301
Using Data Types Effectively
- Working with Numeric Types
- Working with Character Types and Collations
- Working with Date and Time Types
- Working with Other Types
- Converting Between Types
- LAB: Using Data Types Effectively
1
AT302
SQL Server Spatial Data
- Spatial Applications
- Spatial Data Types
- Spatial Indexing and Tuning
- 2012 Enhancements
- LAB: SQL Server Spatial Data
1
AT303
Joins and Set Operations
- Joins
- Join Strategies
- Set Operations
- LAB: Joins and Set Operations
1
AT304
Sub-queries
- Nested and Correlated Sub-queries
- Derived Tables
- Common Table Expressions
- LAB: Sub-queries
2
AT305
Data Modification
- Inserting, Updating, Deleting Data
- Merging Data
- OUTPUT Clause
- SEQUENCES
- LAB: Data Modification
2
AT306
TOP, APPLY and Windowing Functions
- TOP
- Resultset Pagination
- CROSS APPLY and OUTER APPLY
- Windowing Functions
- LAB: TOP, APPLY and Windowing Functions
2
AT307
Ranking, Pivoting and Grouping Data
- Ranking Functions
- Pivoting and Unpivoting Data
- Grouping Sets
- LAB: Ranking, Pivoting and Grouping Data
2
AT308
Working with XML Data
- XML Basics
- Storing and Retrieving XML
- XQuery
- Combining XML and Relational Data
- LAB: Working with XML Data
3
AT309
Full Text Indexing
- Full Text Indexing Concepts
- Implementing Full Text Indexing
- Full Text Best Practices
- SQL Server 2012 Full Text Enhancements
- Filetable
- Statistical Semantic Search
- LAB: Full Text Indexing
3
AT310
Creating Database Code Objects
- Executing Dynamic SQL
- Views, Functions and Stored Procedures
- SQL Server 2012 Built-In Function Enhancements
- DML and DDL Triggers
- Table Type and Table-Valued Parameters
- Identifying Dependencies and Metadata
- LAB: Creating Database Code Objects
3
AT311
SQL CLR Integration
- SQL CLR Concepts
- Implementing SQL CLR
- Best practices for SQL CLR
- LAB: SQL CLR Integration
3
AT312
Exception Handling
- T-SQL and Errors
- Error Handling – pre 2005
- TRY/CATCH and SQL Server 2005+
- Error Handling - 2012
- Error Handling in SQLCLR Code
- Error Handling on Clients
- LAB: Exception Handling
Phone: 1300 SQL SQL (1300 775 775) l International +61 1300 775 775 l Fax: +61 3 8676-4913
Copyright 2017 by SQL Down Under | Terms Of Use | Privacy Statement