Mastering SQL Server RDS on AWS

Name: Mastering SQL Server RDS on AWS
Rating: 4.5 (159 reviews)

Learn Microsoft SQL Server Administration using AWS RDS from a Certified Administrator

Created byEmar Morrison, Trevoir Williams

Last updated 10/2024

English

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
Learn to administer SQL Server in AWS RDS, including creating and managing instances, configuring security and backups, and troubleshooting common issues.

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
Explore regions, availability zones, and local zones to understand fault-tolerant, low-latency cloud services and RDS resources not replicated across regions unless configured, with region switching via console or AWS CLI.
Configuring AWS Command Line Interface (AWS CLI)4:40
Learn to install, configure, and verify the AWS CLI to manage AWS services, set access keys, region, and output format, and enable automation and scripting.
Amazon Simple Storage Configuration2:22
Getting Started

Creating a SQL Server Database Instance5:44
Installing SQL Server Management Studio (SSMS)1:20
Connecting to SQL Server RDS Instance4:12
Connect to an AWS RDS SQL Server instance using its endpoint and port, enable publicly accessible access via security group inbound rules, and test with get date.
Working with option groups5:27
Working with parameter groups4:27
Manage SQL Server parameter groups to configure database parameters like memory, and apply dynamic or static changes to DB instances or multi-az clusters via the console, including maintenance window options.
Setting up your environment

Understanding Users & Logins2:06
Configuring Instance Level Security2:06
Configuring Database Level Security9:03
Learn to configure database level security in SQL Server on AWS RDS by creating database users and roles, mapping logins, and granting or revoking permissions on databases and objects.
SQL Server Auditing Concepts2:24
Create server audits and database audit specifications to log instance and database events to a designated audit destination, with groups for backup, permission changes, and granular select or execute events.
Implementing Server Level and Database Auditing13:16
Audit your SQL Server RDS instance on AWS by configuring a server and database audit that writes logs to an S3 bucket, and attach the appropriate option group.

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

Introduction0:43
Explore SQL Server native backup and restore to create full, differential, and transaction log backups for on premise databases and RDS, store to disk or S3, and restore from S3.
SQL Server Recovery Models4:56
Performing Native Full Backup6:10
Performing Native Differential Backup3:34
Learn how differential backups capture only changes since the last full backup, delivering faster backups and smaller sizes, and how to perform native differential backups with the backup procedure.
Recovering RDS Database using Native Backups4:27

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

Mastering SQL Server RDS on AWS

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: