Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Introduction to TSQL

Course Summary

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.

What You'll Learn:

In the Introduction to TSQL training course, you'll learn:
  • Database fundamentals, introduction to Management Studio
  • SELECT syntax, processing order, Single Table Queries
  • TOP filter, predicates, operators, functions
  • JOINs (Cross joins, ANSI-92 syntax, inner joins, outer joins)
  • Indexes (Clustered, Nonclustered, Unique, Composite, Covering)
  • Subqueries, table expressions, view performance
  • SET Operators, Windows functions, pivoting data, grouping sets
  • Data modification (Insert, Update, Delete)
  • Temporal tables
  • In-memory tables
  • Complete review of SELECT statement
  • Transactions and concurrency
  • Variables, Batches, temporary table, stored procedures, functions, error handling
  • Performance tools, sample performance tuning (demos)
real world content

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
expert practitioners

Expert Practitioners

Industry experts that bring their battle scars into the classroom.
experiential learning

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
tailored outlines

Tailored Outlines

One-size-fits-all doesn't apply to training teams. That's where we come in!
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By filling out this form and clicking submit, you acknowledge our privacy policy.