In this video, I am demonstrating a few common wait types in SQL Server.
You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code).
If you wish to practice a SQL concept step-by-step, try SQLMaestros Hands-On-Labs. (Get access to hundreds of lab documents on SQL Server, Azure, Analytics, BI, Machine Learning, etc)
If you are looking for advanced SQL Server & MS Data Platform Training (in-person & online), explore SQLMaestros.