Transact-SQL (T-SQL) Skills Booster (2 days)
TSQ-52: Practical skills booster Transact SQL (T-SQL) training for existing SQL Server T-SQL developers or users who wish to take their existing T-SQL skills to the next level.
|pricing | more Transact SQL training|
This practical, workshop-style, Transact-SQL (T-SQL) training course is for existing SQL Server T-SQL developers or users who wish to take their existing T-SQL skills to the next level. The course is highly practical in nature. Attendees learn by doing at their own individual pace and the focus throughout is on coding T-SQL by hand. The 'T-SQL Basics Checkup' section at the start of the course is mandatory (attendees must demonstrate their basic skills before progressing to the workshop section of the course). All other listed topics are prioritised by the attendee on a 'Pick and Choose' basis (the tutor may suggest an ideal order of working). On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are made available online for each attendee.
Introductory level Transact-SQL (T-SQL) skills are required as a prerequisite for this course.
T-SQL Basics Checkup
- Ways of Solving the Problem
- Finding the Error
- Dealing with Common Traps
- Operator Precedence Traps
- When is a NOT not a NOT?
- Ready for the Filtering Challenge?
- An Inner Joins Checkup
- Aggregates and Grouping up to Scratch?
- What About Dates?
- Ready for the Basic Skills Challenge?
Beyond the Inner Join
- Self Joins
- Embracing Outer Joins: Left, Right and Full
- Making use of Cross Joins
- Ensuring Subqueries Work Every Time
- Working with Correlated Subqueries
- Subqueries in SELECT
- Using Common table Expressions (CTEs)
- Testing for existence with EXISTS
Resolving T-SQL Data Type Issues
- Know Your T-SQL Data Types
- Which T=SQL Data Type Is It?
- Common T-SQL Data Type Traps
- Converting T-SQL Data Types: Numbers and Strings
- Converting Dates and Strings
- Common Date Issues
- Dealing with NULL Checkup
Specific T-SQL Techniques
- Using T-SQL Views to Simplify your Work
- T-SQL Set Operations: UNION, INTERSECT and EXCEPT
- Ranking Results with RANK(), PERCENT_RANK() and DENSE_RANK()
Some Advanced T-SQL Techniques
- Creating Running Totals, Averages and Counts
- Creating Date Sequences
- Creating Numeric Sequences
- Filling in Missing Values
- Creating Calendar Tables
- Selecting Random Rows
- Selecting Every nth Row
- Handling Duplicates
- Locating Extreme Values
- Working with Hierarchies
- Pivoting Data
"Excellent course, would recommend to colleagues. The tutor did an excellent job of bringing alive what would otherwise have been quite a dry subject matter!"
Senior Account Manager
"I can honestly say that there was nothing in the course that was not useful. It was truly informative and I feel I know a lot more now."
"All of the course was useful, although I have worked with SQL a lot I was always told that there's a certain way for things to be done, but never knew why. I am leaving the course with a full understanding around the reasoning of certain actions."