Comprehensive Sql Server Administration Part 2

Database Design, Migration, Patching, Upgrade, Concurrency, Transparent Data Encryption, and Dynamic Data Masking

What you'll learn

Database Migration Methodologies and Suitability for Business Requirements

Database Refresh, SQL Server Patching, SQL Server Upgrade, and Move Database Files

Database Security Technologies such as Transparent Data Encryption and Dynamic Data Masking

Database and Datawarehouse Design Architecture (Normalization, Denormalization, Data Types, and Constraints)

Concurrency in SQL Server (ACID Principle and Isolation Levels)

Indexes, their Structure, Components and Maintenance (Reorganize/Rebuild)

Requirements

Completed Comprehensive SQL Server Administration Part 1 Or Have Prior Knowledge of the Concepts

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 database design, migration, patching, upgrade, concurrency, isolation levels, transparent data encryption (TDE), and dynamic data masking.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: Database Migration (On-Prem to On-Prem)

Lecture 1 Introduction to Database Migration

Lecture 2 Backup and Restore

Lecture 3 Demo: Backup and Restore

Lecture 4 Detach and Attach

Lecture 5 Demo: Detach and Attach Part 1

Lecture 6 Demo: Detach and Attach Part 2

Lecture 7 Copy Database

Lecture 8 Demo: Copy Database

Lecture 9 Import and Export Data Wizard

Lecture 10 Demo: Import and Export Data Wizard Part 1

Lecture 11 Demo: Import and Export Data Wizard Part 2

Section 2: Database Migration (On-Prem to Microsoft Azure)

Lecture 12 Introduction to Microsoft Azure

Lecture 13 Demo: Create Microsoft Azure Account

Lecture 14 Demo: Microsoft Azure Subscription (Free-Trial)

Lecture 15 Demo: Azure SQL Deployment Options

Lecture 16 Demo: Create Azure SQL Database

Lecture 17 Demo: Connect to Azure SQL Database

Lecture 18 Demo: Create Azure SQL Managed Instance

Lecture 19 Demo: Migration to Azure SQL Database Using Deploy Data Wizard

Lecture 20 Demo: Migration to Azure SQL Database Using Data-Tier Application (.BACPAC)

Lecture 21 Demo: Migration From Azure SQL Database Using Data-Tier Application (.BACPAC)

Section 3: Database Migration Using Data Migration Assistant

Lecture 22 Data Migration Assistant (DMA) Installation

Lecture 23 Database Migration Using DMA Part 1

Lecture 24 Database Migration Using DMA Part 2

Lecture 25 Database Migration Using DMA Part 3

Section 4: Database Migration Using PowerShell

Lecture 26 Introduction to PowerShell Dbatools Module

Lecture 27 Installing PowerShell Dbatools Module

Lecture 28 Overview of PowerShell Dbatools Module

Lecture 29 Database Migration Using PowerShell Dbatools Module

Lecture 30 Instance Migration Using PowerShell Dbatools Module

Section 5: Database Refresh

Lecture 31 Introduction to Database Refresh

Lecture 32 Database Refresh Steps Part 1

Lecture 33 Database Refresh Steps Part 2

Lecture 34 Demo: Database Refresh Part 1

Lecture 35 Demo: Database Refresh Part 2

Section 6: SQL Server Patching

Lecture 36 Introduction to SQL Server Patching

Lecture 37 Service Packs and Cumulative Updates

Lecture 38 Cumulative Updates Download

Lecture 39 SQL Server Patching Steps

Lecture 40 Demo: SQL Server Patching Part 1

Lecture 41 Demo: SQL Server Patching Part 2

Lecture 42 Demo: SQL Server Patching Part 3

Section 7: SQL Server Upgrade

Lecture 43 Introduction to SQL Server Upgrade

Lecture 44 SQL Server Upgrade Steps

Lecture 45 Demo: SQL Server Upgrade Part 1

Lecture 46 Demo: SQL Server Upgrade Part 2

Section 8: Database Files Movement

Lecture 47 How to Move Database Files

Lecture 48 Demo: Move User Database Files Part 1

Lecture 49 Demo Move User Database Files Part 2

Lecture 50 Demo: Move System Database Files Part 1

Lecture 51 Demo: Move System Database Files Part 2

Section 9: Database Security: Transparent Data Encryption

Lecture 52 Introduction to Transparent Data Encryption

Lecture 53 Database Encryption Steps

Lecture 54 Demo Database Encryption

Lecture 55 Encryption Verification

Lecture 56 Demo: Encrypted Database Restore Part 1

Lecture 57 Demo: Encrypted Database Restore Part 2

Lecture 58 Database Decryption

Lecture 59 Encryption in AlwaysOn AG

Section 10: Database Security: Dynamic Data Masking

Lecture 60 Introduction to Dynamic Data Masking

Lecture 61 Demo: Dynamic Data Masking Part 1

Lecture 62 Demo: Dynamic Data Masking Part 2

Lecture 63 Other Database Security Methodologies

Section 11: Database and Datawarehouse Design

Lecture 64 Introduction to Database Design

Lecture 65 Normalization

Lecture 66 Benefits of Normalization

Lecture 67 Real-life Application of Normalization Part 1

Lecture 68 Real-life Application of Normalization Part 2

Lecture 69 Data Types

Lecture 70 Constraints Part 1

Lecture 71 Constraints Part 2

Lecture 72 Demo: Constraints Part 1

Lecture 73 Demo: Constraints Part 2

Section 12: Concurrency

Lecture 74 Introduction to Concurrency

Lecture 75 Read Types Part 1

Lecture 76 Read Types Part 2

Lecture 77 Transaction Isolation Levels Part 1

Lecture 78 Transaction Isolation Levels Part 2

Lecture 79 Transaction Isolation Levels vs Read Types

Lecture 80 Snapshot Isolation Level

Lecture 81 Demo: Transaction Isolation Levels

Section 13: Indexes

Lecture 82 Introduction to Indexes

Lecture 83 The Balanced (B)-Tree Structure

Lecture 84 Index Concepts

Lecture 85 Index Components

Lecture 86 Index Maintenance

Lecture 87 Index Reorganize

Lecture 88 Index Rebuild

Lecture 89 Demo: Indexes Part 1

Lecture 90 Demo: Indexes Part 2

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