TSQL for the .Net Developer

The TSQL for the .Net Developer training course will concentrate on providing the .Net Developer with the necessary knowledge to create and/or revise high performance stored procedures and ad hoc TSQL queries. It starts 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 such. This course will also provide the means to identify and resolve poorly performing queries.

Classroom sessions will be about one-fourth lecture and three-fourths demos. All PowerPoint files and TSQL demo scripts will be available to the attendee.

Course Summary

Purpose: 
Learn to use T-SQL for working with relational databases.
Audience: 
Developers with .NET experience who want to learn T-SQL to interact with relational databases.
Skill Level: 
Learning Style: 

Hands-on training is customized, instructor-led training with an in-depth presentation of a technology and its concepts, featuring such topics as Java, OOAD, and Open Source.

Hands On help
Duration: 
1 Day
Productivity Objectives: 
  • Apply best practices in creating and revising TSQL stored procedures and queries
  • Be able to analyze ineffective indexes and revise to improve performance
  • Ascertain poorly performing queries/stored procedures and improve their performance
  • Be able to analyze and research wait types affecting system performance and determine corrective actions
  • Be able to take 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:
Day 1:

  • Comprehensive review of TSQL to include table JOINs, subqueries, windows functions, views, temporary tables, stored procedures, functions
    Day 2:
  • 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
    Day 3:
  • 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)

Contact us to learn more

Not all training courses are created equal. Let the customization process begin! We'll work with you to design a custom TSQL for the .Net Developer training course that meets your specific needs.

DevelopIntelligence has been in the technical/software development learning and training industry for nearly 20 years. We’ve provided learning solutions to more than 48,000 engineers, across 220 organizations worldwide.

About Develop Intelligence
Di Clients
Need help finding the right learning solution?   Call us: 877-629-5631