When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Comprehensive SQL Server Administration Part 1
Introduction to SQL Server, Authentications, RBAC, Database Maintenance, Disaster Recovery, and High Availability
This Course Includes
udemy
0 (0 reviews )
12 total hours 
english
Online - Self Paced
course
Udemy
About Comprehensive SQL Server Administration Part 1
Dive into the world of SQL Server with our comprehensive course designed for existing and prospective Microsoft SQL Server Database Administrators. Whether you're a beginner, junior, or intermediate-level Database Administrator, this course equips you with essential skills and knowledge to excel in the field. You'll gain a solid foundation in SQL Server architecture and functionality, and learn critical topics such as authentications, database maintenance, disaster recovery, and high availability (Log Shipping, Mirroring, AlwaysOn Availability Group, and Replication).
This course is rich in technical hands-on demonstrations to enhance your comprehension of the material, and it includes numerous practice exercises to reinforce your learning. You'll also find a wealth of typical interview questions to help you prepare for job interviews and knowledge checks. Designed to help you break into the IT field or switch roles within the industry, this course ensures you are well-prepared for your career.
This engaging course is perfect for those with a passion for technical hands-on activities and aims to provide a solid foundation in SQL Server administration.
Prerequisite to this course is a virtual lab, with setup videos available in my first course (Comprehensive SQL Server Administration Lab Setup). Trainees with an existing lab can skip the first course and proceed with this course.
What You Will Learn?
- Microsoft SQL Server, Versions, Editions, Database Types, Configuration Manager and Management Studio.
- Authentication Types, Role-Based Access Control (Server and Database Roles) and the Principle of Least Privilege.
- Industry Standard Disaster Recovery Strategies Using RPO, RTO and SLA.
- Database Maintenance Tasks (Database Backup, Index Maintenance, Statistics Update and Database Integrity Check).
- High Availability Solutions such as Log Shipping, Mirroring, AlwaysOn Availability Group and Replication.