SQL Server Advanced T-SQL (3 days)


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 2017, 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, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.

 CITY DATES COURSE PRICE EARLY BIRD PRICE
On-demand Please contact us

 



DAY 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
DAY 1 AT302 SQL SERVER SPATIAL DATA
Spatial Applications
Spatial Data Types
Spatial Indexing and Tuning
2012 Enhancements
LAB: SQL Server Spatial Data
DAY 1 AT303 JOINS AND SET OPERATIONS
Joins
Join Strategies
Set Operations
LAB: Joins and Set Operations
DAY 3 AT304 SUB-QUERIES
Nested and Correlated Sub-queries
Derived Tables
Common Table Expressions
LAB: Sub-queries
DAY 2 AT305 DATA MODIFICATION
Inserting, Updating, Deleting Data
Merging Data
OUTPUT Clause
SEQUENCES
LAB: Data Modification
DAY 2 AT306 TOP, APPLY AND WINDOWING FUNCTIONS
TOP
Resultset Pagination
CROSS APPLY and OUTER APPLY
Windowing Functions
LAB: TOP, APPLY and Windowing Functions
DAY 2 AT307 RANKING, PIVOTING AND GROUPING DATA
Ranking Functions
Pivoting and Unpivoting Data
Grouping Sets
LAB: Ranking, Pivoting and Grouping Data
DAY 2 AT308 WORKING WITH XML DATA
XML Basics
Storing and Retrieving XML
XQuery
Combining XML and Relational Data
LAB: Working with XML Data
DAY 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
DAY 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
DAY 3 AT311 SQL CLR INTEGRATION
SQL CLR Concepts
Implementing SQL CLR
Best practices for SQL CLR
LAB: SQL CLR Integration
DAY 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