SQLskills IETLB - SQL Server 2019
Issued by
SQLskills
This badge shows attendance of the SQLskills Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning. IETLB gives database developers insight into how this all works in Microsoft SQL Server (since it's NOT the same in all RDBMSes). Developers that know this can make a huge difference to performance, concurrency, and even database manageability / logging.
- Type Learning
- Level Advanced
- Time Days
- Cost Paid
Skills
- Analyze Existing Locks On A Busy SQL Server System
- Appropriate Use And Control Of SQL Server Isolation Levels
- Appropriate Use And Control Of SQL Server Versioning
- Architectural Overview Of SQL Server And Components
- Controlling And Setting Appropriate SQL Server Isolation Levels
- Control Management And Maintenance Around Possible Schema Lock Problems In SQL Server
- Creating Effective SQL Server Databases
- Designing And Writing Effective Transactional Logic In SQL Server
- SQL Server Database Structures
- SQL Server Development Best Practices For Batches
- SQL Server Development Best Practices For Error Handling
- SQL Server Development Best Practices For Transactions
- SQL Server Internals
- SQL Server Locking
- Troubleshooting SQL Server Blocking Problems
- Understand And Control Lock Escalation In SQL Server
- Understanding The Anatomy Of A Transaction In SQL Server
- Understand The Tradeoffs Between Statement Accuracy And Data Concurrency In SQL Server