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".