Skip to content

Contact sales

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

TSQL for the .Net Developer

Course Summary

The TSQL for the .Net Developer training course begins by concentrating on providing the necessary knowledge to create and/or revise high performance stored procedures and ad-hoc TSQL queries. Next, the course continues with a quick review of TSQL and immediately jumps into tips and techniques for writing effective store procedures and TSQL queries and how to test each. The course concludes by providing the means to identify and resolve poorly performing queries.

Classroom sessions will be about one-fourth lecture and three-fourths demos.

Purpose
 Learn to use T-SQL for working with relational databases.
Audience
 Developers with .NET experience who want to learn TSQL to interact with relational databases.
Role
Software Developer - Web Developer
Skill Level
Intermediate
Style
Workshops
Duration
1 Day
Related Technologies
.NET | SQL

 

Productivity Objectives
  • Apply best practices in creating and revising TSQL stored procedures and queries.
  • Analyze ineffective indexes and revise to improve performance.
  • Identify poorly performing queries/stored procedures and improve their performance.
  • Analyze and research wait types affecting system performance and determine corrective actions.
  • Apply action when confronted with "The system is running slow".

What You'll Learn:

In the TSQL for the .Net Developer training course, you'll learn:
  • Comprehensive review of TSQL to include table JOINs, subqueries, windows functions, views, temporary tables, stored procedures, functions
  • Transactions and concurrency
  • Blocking/Deadlocks how to analyze
  • Deep dive into Indexes and their effect on query performance
    • Understand and how to revise non-clustered indexes for improved query performance
    • Missing indexes
    • Unused indexes
  • In-memory tables (when and how to implement and their effect on performance)
  • Strategies for writing effective performing stored procedures and queries
  • How to respond to "The system is running slow!"
  • Wait Types: How to analyze and improve performance
  • Techniques for performance enhancing TSQL
  • 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.