AWS RDS for SQL Server Online Course

AWS RDS for SQL Server Online Course

This course teaches how to deploy and manage Microsoft SQL Server on AWS RDS, a managed cloud database service. You’ll start with setting up RDS instances and managing databases, then progress to performance optimization using indexing and query stores. The course covers data security, including authentication, authorization, encryption, backups, and disaster recovery. Learn high availability strategies with Multi-AZ deployments and Read Replicas, along with troubleshooting common issues. By the end, you’ll be equipped to deploy, manage, and optimize SQL Server databases in the cloud efficiently and securely.

Who should take this Course?

This course is ideal for database administrators, cloud engineers, and IT professionals working with SQL Server or AWS. It suits anyone aiming to gain hands-on experience in cloud-based database deployment, management, and optimization. Professionals seeking skills in performance tuning, high availability, security, and disaster recovery for cloud databases will benefit significantly. Additionally, developers and system architects looking to integrate SQL Server with AWS services can enhance their expertise through this course.

What you will learn

• Deploy and manage SQL Server databases on AWS RDS
• Learn performance optimization with indexing and query store
• Implement data security authentication, authorization, and encryption
• Set up backup/disaster recovery solutions for SQL Server databases
• Achieve high availability by Multi-AZ deployments and Read Replicas
• Learn practical troubleshooting skills for common SQL Server RDS issues

Course Outline

Introduction

• Introduction

Getting Started with SQL Server RDS

• What is RDS?
• DB Instance Classes
• RDS DB Instance Storage Classes
• Regions, Availability Zones, and Local Zones
• Configuring AWS Command Line Interface (AWS CLI)
• Amazon Simple Storage Configuration

Configuring SQL Server RDS Instance

• Creating a SQL Server Database Instance
• Installing SQL Server Management Studio (SSMS)
• Connecting to SQL Server RDS Instance
• Working with Option Groups
• Working with Parameter Groups

Managing SQL Server RDS Instance

• Stop and Start an Instance
• Modifying an SQL Server RDS DB Instance
• Deleting an SQL Server DB Instance

Database Creation and Configuration

• Understanding RDSADMIN Utility Database
• SQL Server System Databases
• SQL Server RDS Storage Strategies
• Creating Your First Database

Securing Your SQL Server

• Understanding Users and Logins
• Configuring Instance-Level Security
• Configuring Database-Level Security
• SQL Server Auditing Concepts
• Implementing Server Level and Database Auditing

Backing Up and Restoring Amazon RDS DB with Snapshots

• Working with Backups
• Configuring Automated Backups
• Creating a DB Snapshot
• Restoring from a DB Snapshot
• Point-in-Time Recovery
• Deleting a DB Snapshot

Native Backup and Restore in SQL Server

• Introduction
• SQL Server Recovery Models
• Performing Native Differential Backup
• Recovering RDS Database Using Native Backups

Automating SQL Server RDS Processes

• SQL Server Agent
• Performing Native Full Backup
• AWS System State Manager

High Availability and Disaster Recovery

• Multi-AZ Deployments for Amazon RDS for Microsoft SQL Server
• Demo: Converting RDS Instance to Multi-AZ

Monitoring and Performance

• Monitoring Overview
• Monitoring with Cloud Watch
• Monitoring DB Load with Performance Insights
• Monitoring with Dynamic Management Views
• Monitoring with SQL Server Activity Monitor
• Performance Tuning with Indexes
• Detecting and Resolving Blocking with DMVs