Mastering SQL Server for Database Developers

Course Summary

Training levelSQL Server Master Courses
Duration5 days / 40 Hours
Delivery methodIn Class
List price950 Euro VAT Excl.

Click Tabs for Detailed info

The class teaches students tips and tricks for writing highly efficient, performant and scalable stored procedures, batches, transactions. Participants will be shown how to properly code functions, joins, sub-queries, Ccse statements, and grouping facilities. They will learn how to change their code and use specific code constructs to get the best performance and scalability. Attendees will see some untraditional techniques and usage of statements in order to get the optimal code execution. Additionally, students will learn the root causes of locking, the role of properly written search arguments, index optimizations, and stored procedure parameterization issues. They will understand how to avoid specific pitfalls in logical database design, how to write effective code and avoid code problems, how to design an optimal data loading using minimally logged operations. They will be aware of upcoming technologies in new versions.

  • Database Developers who are willing to gain deeper knowledge and understanding of the technology
  • .NET developers who are responsible for database design and server side development
  • Gain a mastering level of experience and knowledge in T-SQL
  • Make proper decision which constructs and features to use to program specific cases, which one to avoid and how to architect an effective data access layer
  • Have a deep understanding of how the code executes in order to avoid sending bad code to the database
  • Design proper scalable and performant database programming layer

Module 1: SQL Server Architecture Overview and Tools

Module 2: Data and Index structures

Module 3: Complex T-SQL statements

Module 4: Query Execution and Query Plans

Module 5: T-SQL Programming Objects

Module 6: Transactions and lock management

Module 7: InMemory OLTP

Module 8: Loading and deleting data in large tables

Module 9: Security for Devs

Next planned dates:

Trainer: Ivan Donev


Reserve your seat

Subscribe me to your mailing list

Reserving a seat does not imply any obligations for payment

Next training starts in:
Stay tuned for the next training date