This badge was issued to Jayasurya Pilli on 03 May 2013.
- Type Learning
- Level Advanced
- Time Days
- Cost Paid
SQLskills IEPTO1 - SQL Server 2012
Issued by
SQLskills
This badge shows attendance of the SQLskills Immersion Event on Performance Tuning and Optimization – Part 1. This course gives you a wealth of practical optimization techniques. Topics covered: optimal database creation, data and log internals / maintenance, logging / recovery, indexing for performance, locking / blocking, isolation levels, versioning, index fragmentation, and statistics creation / maintenance. IEPTO1 creates a solid database foundation for performance.
- Type Learning
- Level Advanced
- Time Days
- Cost Paid
Skills
- Architectural Overview Of SQL Server And Components
- Controlling And Setting Appropriate SQL Server Isolation Levels
- Creating Effective SQL Server Databases
- Creating Effective SQL Server Indexes For Performance
- Managing SQL Server Index Fragmentation
- SQL Server Database Structures
- SQL Server Index Internals
- SQL Server Internals
- SQL Server Locking
- SQL Server Logging And Recovery
- SQL Server Tempdb Management
- Troubleshooting And Configuring Compatibility And Cardinality Estimation Models
- Troubleshooting And Maintaining SQL Server Statistics