Comprehensive Sql Server Administration Part 1

Introduction to SQL Server, Authentications, RBAC, Database Maintenance, Disaster Recovery, and High Availability

What you'll 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

Requirements

No Prior Information Technology (I.T) Experience Is Required

Windows Personal Computer (Laptop or Desktop)

Reliable Internet Connection

Great Passion to Learn

Existing Virtual Lab Environment for Technical Hands-on Practices

Description

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.

Overview

Section 1: Introduction to Microsoft SQL Server

Lecture 1 What is SQL Server?

Lecture 2 The Evolution (Versions) of SQL Server

Lecture 3 The Editions of SQL Server

Lecture 4 The SQL Server Configuration Manager

Lecture 5 The SQL Server Management Studio

Lecture 6 Demo: SQL Server Configuration Manager

Lecture 7 Demo: SQL Server Management Studio Part 1

Lecture 8 Demo: SQL Server Management Studio Part 2

Lecture 9 SQL Server Databases

Lecture 10 Database Types

Lecture 11 System Databases (Deep Dive)

Lecture 12 Database Server Environments

Lecture 13 Demo: Database Types Part 1

Lecture 14 Demo: Database Types Part 2

Lecture 15 Demo: Database Types Part 3

Section 2: Authentications, Role-Based Access Control and Permissions

Lecture 16 Logins and Users

Lecture 17 Server Roles

Lecture 18 Database Roles

Lecture 19 Permissions

Lecture 20 Demo: Windows Login

Lecture 21 Demo: Database Roles

Lecture 22 Demo: Login Failed Error Troubleshooting

Lecture 23 Demo: Roles and Permissions

Lecture 24 Demo: Windows Active Directory Group

Lecture 25 Demo: SQL Login

Section 3: Disaster Recovery

Lecture 26 What is a Disaster?

Lecture 27 Disaster Recovery Terminologies

Lecture 28 Database Recovery Models

Lecture 29 Database Backup Part 1

Lecture 30 Database Backup Part 2

Lecture 31 Database Restore

Lecture 32 Demo: Disaster Recovery Strategies Part 1

Lecture 33 Demo: Disaster Recovery Strategies Part 2

Lecture 34 Demo: Database Backup Part 1

Lecture 35 Demo: Database Backup Part 2

Lecture 36 Demo: Database Restore Part 1

Lecture 37 Demo: Database Restore Part 2

Lecture 38 Demo: Database Restore Part 3

Lecture 39 Disaster Recovery Exercises

Section 4: Database Maintenance

Lecture 40 Database Maintenance Tasks

Lecture 41 Demo: Database Maintenance Tasks Using GUI Part 1

Lecture 42 Demo: Database Maintenance Tasks Using GUI Part 2

Lecture 43 Demo: Database Maintenance Tasks Using GUI Part 3

Lecture 44 Demo: Database Maintenance Tasks Using Ola Hallengren Part 1

Lecture 45 Demo: Database Maintenance Tasks Using Ola Hallengren Part 2

Lecture 46 Knowledge Check Exercises

Section 5: Log Shipping

Lecture 47 Introduction to High Availability

Lecture 48 Introduction to Log Shipping

Lecture 49 Log Shipping Pros and Cons

Lecture 50 Demo: Log Shipping Configuration Part 1

Lecture 51 Demo: Log Shipping Configuration Part 2

Lecture 52 Demo: Log Shipping Configuration Part 3

Lecture 53 Demo: Failover in Log Shipping Part 1

Lecture 54 Demo: Failover in Log Shipping Part 2

Section 6: Mirroring

Lecture 55 Introduction to Database Mirroring

Lecture 56 Synchronous vs Asynchronous Commit Modes

Lecture 57 Database Mirroring Pros and Cons

Lecture 58 Demo: Database Mirroring Configuration Part 1

Lecture 59 Demo: Database Mirroring Configuration Part 2

Lecture 60 Demo: Database Mirroring Configuration Part 3

Section 7: AlwaysOn Availability Group

Lecture 61 Introduction to AlwaysOn Availability Group

Lecture 62 AlwaysOn Availability Group Pros and Cons Part 1

Lecture 63 AlwaysOn Availability Group Pros and Cons Part 2

Lecture 64 AlwaysOn Availability Group Configuration Steps Part 1

Lecture 65 AlwaysOn Availability Group Configuration Steps Part 2

Lecture 66 Demo: AlwaysOn Availability Group Configuration Part 1

Lecture 67 Demo: AlwaysOn Availability Group Configuration Part 2

Lecture 68 Demo: AlwaysOn Availability Group Configuration Part 3

Lecture 69 Demo: AlwaysOn Availability Group Configuration Part 4

Lecture 70 Demo: AlwaysOn Availability Group Cluster Permission

Lecture 71 Demo: AlwaysOn Availability Group Quorum Configuration

Section 8: Replication

Lecture 72 Introduction to Replication

Lecture 73 Replication Topology

Lecture 74 Replication Backward Compatibility

Lecture 75 Replication Types

Lecture 76 Replication Agents

Lecture 77 Transactional vs Snapshot Replication

Lecture 78 Replication Pros and Cons

Lecture 79 Demo: Transactional Replication Configuration Part 1

Lecture 80 Demo: Transactional Replication Configuration Part 2

Lecture 81 Demo: Transactional Replication Configuration Part 3

Lecture 82 Demo: Transactional Replication Configuration Part 4

Lecture 83 Demo: Transactional Replication Configuration Part 5

Lecture 84 Demo: Snapshot Replication Configuration

Individuals with Technical Hands-On Abilities (Prospective Microsoft SQL Server Database Administrators),Beginner/Junior Microsoft SQL Server Database Administrators,Mid-Level/ Intermediate Microsoft SQL Server Database Administrators