The Introduction to TSQL training course begins by concentrating on the TSQL SELECT statement: its syntax, usage, and performance tuning. Next, students will learn a basic level of understanding to be able to write, understand, and performance tune complex queries. While the focus will primarily concentrate on the SELECT statement, the course will conclude with the data modification statements (UPDATE, DELETE, INSERT).
Classroom sessions will be about one-fourth lecture and three-fourths demos. The course material is derived from Itzik Ben-Gan's book: T-SQL FUNDAMENTALS THIRD EDITION (about $40 from Amazon). Although not required, the students are advised to purchase and read the book prior to taking the course. The course will not cover or touch on SQL Agent, SSIS, SSAS, or Report Services.
Purpose
|
Learn the syntax and concepts of TSQL. |
Audience
|
Developers with basic SQL and SQL Server Knowledge who want to learn TSQL. |
Role
| Software Developer - System Administrator - Web Developer |
Skill Level
| Introduction |
Style
| Hack-a-thon - Learning Spikes - Workshops |
Duration
| 3 Days |
Related Technologies
| .NET | SQL |
Productivity Objectives
- Demonstrate the TSQL SELECT statement syntax and usage.
- Analyze and script all table joins (inner and outer).
- Identify and implement subqueries (correlated and non-correlated).
- Analyze, script, and understand TSQL performance tuning.