Mastering SQL Server for Database Developers
Course Summary
Training level | SQL Server Master Courses |
Duration | 5 days / 40 Hours |
Delivery method | In Class |
Level | 400 |
Language | Bulgarian/English |
List price | 950 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
Reserving a seat does not imply any obligations for payment