-
Course
- Data
Getting Started with Your First SQL Server Instance
This course will teach you the basics of SQL Server architecture, installation, tools, and configuration in order to help you understand SQL Server administration.
What you'll learn
At the core of SQL Server is a thorough knowledge of database administration. In this course, Getting Started with Your First SQL Server Instance, you’ll learn the basics of installing and configuring SQL Server 2017. First, you’ll learn SQL Server history and architecture. Next, you’ll explore how to install SQL Server 2017. Then, you’ll discover how to use the SQL Server Tools. Finally, you’ll discover how to do basic SQL Server configuration. When you’re finished with this course, you’ll have a basic knowledge of SQL Server that will help you move forward in your understanding of database administration.
Table of contents
- Overview | 41s
- Configuration Manager - Services | 6m 36s
- Configuration Manager - Networking | 4m 37s
- SSMS - Open and Connect | 4m 22s
- SSMS - Instance Properties | 4m 39s
- SSMS - Databases | 6m 44s
- SSMS - Security | 3m 7s
- SSMS - Maintenance Plans | 1m 46s
- SSMS - Errorlogs and Database Mail | 2m
- SSMS - SQL Agent and Jobs | 2m 9s
- SSMS - More Options | 39s
About the author
Kevin Hill is a career SQL Server DBA living in Dallas, TX. His specialties include HA/DR, Best Practice configuration, Performance tuning and teaching new and accidental DBAs. Kevin can be reached on Twitter @Kevin3NF
More Courses by Kevin