Mastering Sql Server Rds On Aws

AWS Certified Database – Specialty

What you'll learn

How to set up and manage a SQL Server instance on Amazon RDS

How to migrate databases from on-premises to RDS

How to create and manage backups and restore points

How to use SQL Server's built-in security features

Requirements

No experience required.

Description

This course is designed to help participants master the use of SQL Server RDS on AWS. Participants will learn how to deploy, manage, and scale SQL Server databases on AWS RDS. The course covers a broad range of topics, including best practices for database migration, data security, and high availability.Participants will start by learning how to set up an RDS instance for SQL Server and how to create and manage databases. They will also learn how to optimize performance using techniques such as indexing and query store.The course will then cover how to ensure data security by implementing authentication, authorization, and encryption mechanisms. Participants will also learn how to set up backups and disaster recovery solutions.Finally, the course will cover how to achieve high availability using features such as Multi-AZ deployments and Read Replicas. Participants will also learn how to troubleshoot common issues that can arise when working with SQL Server on AWS RDS.By the end of the course, participants will have a comprehensive understanding of SQL Server RDS on AWS and the skills needed to manage databases in a cloud environment. They will also have the knowledge to optimize performance, ensure data security, and achieve high availability for their SQL Server workloads.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Getting Started with SQL Server RDS

Lecture 2 What is RDS

Lecture 3 DB instance classes

Lecture 4 RDS DB instance storage classes

Lecture 5 Regions, Availability Zones, and Local Zones

Lecture 6 Configuring AWS Command Line Interface (AWS CLI)

Lecture 7 Amazon Simple Storage Configuration

Section 3: Configuring SQL Server RDS Instance

Lecture 8 Creating a SQL Server Database Instance

Lecture 9 Installing SQL Server Management Studio (SSMS)

Lecture 10 Connecting to SQL Server RDS Instance

Lecture 11 Working with option groups

Lecture 12 Working with parameter groups

Section 4: Managing SQL Server RDS instance

Lecture 13 Stop and Start an Instance

Lecture 14 Modifying an SQL Server RDS DB instance

Lecture 15 Deleting an SQL Server DB Instance

Section 5: Database Creation & Configuration

Lecture 16 Understanding RDSADMIN Utility Database

Lecture 17 SQL Server System Databases

Lecture 18 SQL Server RDS Storage Strategies

Lecture 19 Creating Your First Database

Section 6: Securing Your SQL Server

Lecture 20 Understanding Users & Logins

Lecture 21 Configuring Instance Level Security

Lecture 22 Configuring Database Level Security

Lecture 23 SQL Server Auditing Concepts

Lecture 24 Implementing Server Level and Database Auditing

Section 7: Backing up and restoring Amazon RDS DB with Snapshots

Lecture 25 Working with backups

Lecture 26 Configuring Automated Backups

Lecture 27 Creating a DB snapshot

Lecture 28 Restoring from a DB snapshot

Lecture 29 Point-in-time recovery

Lecture 30 Deleting a DB snapshot

Section 8: Native backup and restore in SQL Server

Lecture 31 Introduction

Lecture 32 SQL Server Recovery Models

Lecture 33 Performing Native Full Backup

Lecture 34 Performing Native Differential Backup

Lecture 35 Recovering RDS Database using Native Backups

Section 9: Automating SQL Server RDS Processes

Lecture 36 SQL Server Agent

Lecture 37 AWS System State Manager

Section 10: High Availabity and Disaster Recovery

Lecture 38 Multi-AZ deployments for Amazon RDS for Microsoft SQL Server

Lecture 39 Demo: Converting RDS Instance to Multi-AZ

Section 11: Monitoring and Performance

Lecture 40 Monitoring Overview

College graduates,Database Administrators