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
How to implement Multi-AZ for high availability

Course content

13 sections • 48 lectures • 3h 32m total length

Introduction1:13

What is RDS1:42
By the end of the lecture, you will have a solid understanding of what AWS RDS is and how it can help you manage your relational databases in the cloud with ease.
DB instance classes2:18
By the end of the lecture, you will have a solid understanding of DB Instance classes in AWS RDS, and how to select the right compute and memory configuration for your database workloads.
RDS DB instance storage classes1:52
Regions, Availability Zones, and Local Zones1:12
Configuring AWS Command Line Interface (AWS CLI)4:40
Amazon Simple Storage Configuration2:22
Getting Started

Working with backups4:27
Configuring Automated Backups2:47
Creating a DB snapshot1:13
Restoring from a DB snapshot1:21
Point-in-time recovery3:21
Some actions, such as changing the recovery model of a SQL Server database, can break the sequence of logs that are used for point-in-time recovery. In some cases, Amazon RDS can detect this issue and the latest restorable time is prevented from moving forward. In other cases, such as when a SQL Server database uses the BULK_LOGGED recovery model, the break in log sequence isn't detected. It might not be possible to restore a SQL Server DB instance to a point in time if there is a break in the log sequence. For these reasons, Amazon RDS doesn't support changing the recovery model of SQL Server databases.
Deleting a DB snapshot0:45

SQL Server Agent9:31
This lecture covers how to use the SQL Server Agent service to execute and schedule administrative tasks in SQL Server. The SQL Server Agent is a Windows service that runs as a background process and performs jobs that contain one or more steps.
AWS System State Manager8:36
In this lecture, we will explore Amazon Web Services (AWS) Systems Manager, a management service that helps you automate operational tasks and ensure compliance across your infrastructure.

Multi-AZ deployments for Amazon RDS for Microsoft SQL Server3:11
In this lecture, we will explore Amazon Web Services (AWS) Relational Database Service (RDS) for Microsoft SQL Server and how to configure Multi-AZ deployments for high availability and disaster recovery. We will cover the benefits of Multi-AZ deployments, such as automatic failover and synchronous replication, and discuss how to achieve them through RDS for SQL Server.
Demo: Converting RDS Instance to Multi-AZ2:59
By the end of the lecture, you will have a solid understanding of how to convert a single AZ RDS instance to a Multi-AZ deployment and ensure high availability and disaster recovery for your database.

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.

Who this course is for:

College graduates
Database Administrators
IT Professionals

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Getting Started with SQL Server RDS6 lectures • 14min

Configuring SQL Server RDS Instance5 lectures • 21min

Managing SQL Server RDS instance3 lectures • 7min

Database Creation & Configuration4 lectures • 12min

Securing Your SQL Server5 lectures • 29min

Backing up and restoring Amazon RDS DB with Snapshots6 lectures • 14min

Native backup and restore in SQL Server5 lectures • 20min

Automating SQL Server RDS Processes2 lectures • 18min

High Availabity and Disaster Recovery2 lectures • 6min

Requirements

Description

Who this course is for: