Online SQL Server Training Courses
We can scale your SQL Servers and your workload but we can’t scale ourselves! Although our Immersion Events are extremely popular, and in high demand, we can’t spend all year traveling and teaching, and we can’t come to everyone’s favorite location, so we have to limit the number of Immersion Events that we can do. By gradually recording our collective SQL knowledge for you to access online, we create a scalable way to get really good SQL Server training to all the people across the world who want it. This also makes a great complement to our Immersion Events, but doesn’t replace the in-person learning experience.
We’re not talking about recording our Immersion Events – those will remain an in-person, intense, learning experience for those who want them. We’re also not moving away from our Immersion Events. Instead we’re allowing those who cannot afford the time, travel, or cost of an Immersion Event to benefit from our knowledge. And for those who do attend our Immersion Events, for that unique experience, the online training will complement and enhance the classroom learning.
We partner with our good friends at Pluralsight to provide you with the best online SQL Server training at the most affordable prices. Pluralsight subscriptions start from as little as US$29/month, for over 6,000 developer and IT Pro courses!
Details of how to sign up with Pluralsight are here.
We plan to add 10+ new courses each year, bringing a huge amount of relevant, practical information within easy reach around the world.
Below are the SQLskills online training courses that are available, based on various job roles and interests.
All Roles: Career Growth
DBA/Systems Admin: Installation, Configuration, and Hardware
- SQL Server: Installing and Configuring SQL Server 2016
- SQL Server: Upgrading and Migrating to SQL Server 2016
- SQL Server 2012: Installation and Configuration
- SQL Server: Virtualization
- SQL Server: Improving Storage Subsystem Performance
- SQL Server: Consolidation Tactics and Best Practices
- SQL Server: Understanding and Using Azure SQL Database
- SQL Server: Implementing a Hybrid Cloud Solution in Azure
- SQL Server: Evaluating and Sizing Hardware
- Understanding Server Hardware
- SQL Server 2017: Diagnosing Configuration Issues with DMVs
- SQL Server 2017: Diagnosing Performance Issues with DMVs
- Azure SQL Database: Diagnosing Performance Issues with DMVs
DBA: General
- SQL Server: Database Creation, Configuration, and Alteration
- SQL Server: Index Fragmentation Internals, Analysis, and Solutions
- SQL Server: Logging, Recovery, and the Transaction Log
- SQL Server: Maintenance Plans
- SQL Server: Myths and Misconceptions
- SQL Server: Understanding and Using DBCC Commands
DBA: High Availability and Disaster Recovery
- SQL Server: Understanding and Performing Backups
- SQL Server: Detecting and Correcting Database Corruption
- SQL Server: Advanced Corruption Recovery Techniques
- SQL Server: Transactional Replication Fundamentals
- SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping
- SQL Server: Understanding, Configuring, and Troubleshooting Database Mirroring
Developer/Architect: Writing T-SQL
- SQL Server: Transact-SQL Basic Data Retrieval
- SQL Server: Transact-SQL Basic Data Modification
- SQL Server: Transact-SQL Error Handling
- SQL Server: Indexing for Performance
- SQL Server 2012: Nonclustered Columnstore Indexes
- SQL Server: Common Table Expressions
- SQL Server: Temporary Objects
Developer/Architect: General
- SQL Server: Why Physical Database Design Matters
- SQL Server: Indexing for Performance
- SQL Server: Analyzing Query Performance for Developers
- SQL Server: Building Simple Asynchronous Applications
- SQL Server: Building Multi-instance Asynchronous Applications
- SQL Server: Change Data Capture
- Scaling SQL Server 2012 – Part 1
- Scaling SQL Server 2012 and 2014 – Part 2
- Developing and Deploying SQL Server ISV Applications
- Supporting SQL Server ISV Applications
All Roles: Performance Monitoring
- SQL Server: Benchmarking and Baselining
- SQL Server: Performance Troubleshooting Using Wait Statistics
- SQL Server: Using SentryOne Plan Explorer (NEW in 2019!)
- SQL Server: Introduction to Query Store
- SQL Server: Analyzing Query Performance for Developers
- SQL Server: Replacing Profiler with Extended Events
- SQL Server: Introduction to Extended Events
- SQL Server: Advanced Extended Events
- SQL Server: Collecting and Analyzing Trace Data
- SQL Server DMV Diagnostic Queries: Part 1
- SQL Server DMV Diagnostic Queries: Part 2
- SQL Server DMV Diagnostic Queries: Part 3
- SQL Server 2017: Diagnosing Performance Issues with DMVs (NEW in 2019!)
- Azure SQL Database: Diagnosing Performance Issues with DMVs (NEW in 2019!)
All Roles: General Performance Tuning
- SQL Server: Why Physical Database Design Matters
- SQL Server: Indexing for Performance
- SQL Server: Optimizing Ad Hoc Statement Performance
- SQL Server: Optimizing Stored Procedure Performance
- SQL Server: Optimizing Stored Procedure Performance – Part 2
- SQL Server: Deadlock Analysis and Prevention
- SQL Server 2017: Diagnosing Performance Issues with DMVs (NEW in 2019!)
- Azure SQL Database: Diagnosing Performance Issues with DMVs (NEW in 2019!)
All Roles: Query Plan Analysis and Tuning
- SQL Server: Query Plan Analysis
- SQL Server: Introduction to Query Store
- SQL Server: Using SentryOne Plan Explorer (NEW in 2019!)
- SQL Server: Analyzing Query Performance for Developers
- SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database
- SQL Server: Common Performance Issue Patterns
- SQL Server: Common Query Tuning Problems and Solutions – Part 1
- SQL Server: Common Query Tuning Problems and Solutions – Part 2
- SQL Server: Troubleshooting Query Plan Quality Issues