- Type Learning
- Level Advanced
- Time Months
- Cost Paid
SQLskills Blackbelt - SQL Server 2019
Issued by
SQLskills
This demanding badge is only achieved after attending SEVEN deeply technical courses focused on Microsoft SQL Server. In total, these courses provide over 155 hour of content and demonstrations. Additionally, each course comes with self-paced labs and self-study resources, requiring additional time for proficiency. Please review each "earning criteria" page listed below for the courses required and the full feature list covered. It's impressive; truly an incredible achievement!
- Type Learning
- Level Advanced
- Time Months
- Cost Paid
Skills
- Administration And Scheduling: Azure Automation | Elastic Agent | PowerShell
- Analyzing And Troubleshooting SQL Server Deadlocks
- Analyzing Query Performance
- Appropriate Use Of Query Store For Analyzing Query Quality
- Architectural Overview Of SQL Server And Components
- Configuring Compatibility And Cardinality Estimation Models
- Controlling And Setting Appropriate SQL Server Isolation Levels
- Creating Effective SQL Server Databases
- Creating Effective SQL Server Indexes For Performance
- Deploying A Failover Clustered Instance (FCI) For SQL Server
- Detecting And Resolving Various Common Performance Issues And Patterns
- Differentiating Between Caching And Statistics Problems And Solving Them Appropriately
- Effectively Using Dynamic Management Views (DMVs) For Troubleshooting
- Failover Clustering Solutions
- Installation And Configuration Of Microsoft SQL Server
- Knowledge Of I/O Concepts And I/O Subsystems For SQL Server
- Knowledge Of SQLOS Scheduling And CPU Performance Tuning
- Leverage Additional Azure Services With Azure Analysis Services
- Leverage Additional Azure Services With Azure Data Factory
- Leverage Additional Azure Services With Azure Data Warehouse
- Leverage Additional Azure Services With Hyper-Scale
- Leverage Additional Azure Services With Power BI
- Managing SQL Server Index Fragmentation
- Microsoft SQL Azure
- Microsoft SQL Server Administration
- Microsoft SQL Server Troubleshooting
- Optimizing Procedural Code And Resolving Parameter Sensitivity Problems
- Planning And Migrating To Azure SQL Database
- Planning And Migrating To Azure Virtual Machines
- Protect And Monitor Data Assets With Azure Security
- Resolving Statement Execution Caching Problems
- 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 Maintaining SQL Server Statistics
- Troubleshooting Compatibility And Cardinality Estimation Models
- Understanding Azure Managed Instance
- Understanding Azure SQL Database And How It Differs From On-premises SQL Server
- Understanding Differences Between: On-premises | Azure SQL Database | Managed Instance
- Understanding The Technical And Business Benefits Of Leveraging Azure VMs
- Using Extended Events For Extracting And Analyzing SQL Server Activity Efficiently
- Using Wait Statistics For Troubleshooting