- Course
- Core Tech
Getting Started with SQL Server Administration
You’ve inherited a SQL Server instance and need to get your bearings fast. This course will teach you how to connect, explore, and confidently perform essential administrative tasks using real tools and real data.
What you'll learn
Many enterprise environments rely on SQL Server, yet new admins are often dropped into the deep end without proper guidance. In this course, Getting Started with SQL Server Administration, you’ll gain the ability to connect to and manage SQL Server using real tools in practical scenarios. First, you’ll explore how to connect to SQL Server instances using SQL Server Management Studio and Visual Studio Code with the MSSQL extension. Next, you’ll discover how to navigate server architecture, manage objects, and execute essential Transact-SQL (T-SQL) commands. Finally, you’ll learn how to configure services, troubleshoot connectivity, and run admin scripts using PowerShell 7. When you’re finished with this course, you’ll have the skills and confidence to begin administering SQL Server in an enterprise environment - whether on-prem, hybrid, or in the cloud.
Table of contents
About the author
Tim Warner is a Microsoft Most Valuable Professional (MVP) and Microsoft Certified Trainer (since 1997) with nearly three decades of experience as an IT professional and technical educator.