Mastering SQL Server RDS on AWS

Focused View

Emar Morrison,Trevoir Williams

2:19:45

115 View

1. Introduction

1. Introduction.mp4

01:13

2. Getting Started with SQL Server RDS

1. What is RDS.mp4

01:42

2. DB instance classes.mp4

02:18

3. RDS DB instance storage classes.mp4

01:52

4. Regions, Availability Zones, and Local Zones.mp4

01:12

5. Configuring AWS Command Line Interface (AWS CLI).mp4

01:29

6. Amazon Simple Storage Configuration.mp4

02:22

3. Configuring SQL Server RDS Instance

1. Creating a SQL Server Database Instance.mp4

05:44

2. Installing SQL Server Management Studio (SSMS).mp4

01:20

3. Connecting to SQL Server RDS Instance.mp4

04:12

4. Working with option groups.mp4

05:27

5. Working with parameter groups.mp4

04:27

4. Managing SQL Server RDS instance

1. Stop and Start an Instance.mp4

01:30

2. Modifying an SQL Server RDS DB instance.mp4

04:35

3. Deleting an SQL Server DB Instance.mp4

00:54

5. Database Creation & Configuration

1. Understanding RDSADMIN Utility Database.mp4

01:13

2. SQL Server System Databases.mp4

02:59

3. SQL Server RDS Storage Strategies.mp4

03:19

4. Creating Your First Database.mp4

04:07

6. Securing Your SQL Server

1.1 create user.zip

1. Understanding Users & Logins.mp4

02:06

2. Configuring Instance Level Security.mp4

02:06

3. Configuring Database Level Security.mp4

09:03

4. SQL Server Auditing Concepts.mp4

02:24

5. Implementing Server Level and Database Auditing.mp4

13:16

7. Backing up and restoring Amazon RDS DB with Snapshots

1. Working with backups.mp4

04:27

2. Configuring Automated Backups.mp4

02:47

3. Creating a DB snapshot.mp4

01:13

4. Restoring from a DB snapshot.mp4

01:21

5. Point-in-time recovery.mp4

03:21

6. Deleting a DB snapshot.mp4

00:45

8. Native backup and restore in SQL Server

1. Introduction.mp4

00:43

2. SQL Server Recovery Models.mp4

04:56

3.1 back database to s3.zip

3. Performing Native Full Backup.mp4

06:10

4. Performing Native Differential Backup.mp4

03:34

5.1 back database to s3.zip

5. Recovering RDS Database using Native Backups.mp4

04:27

9. Automating SQL Server RDS Processes

1. SQL Server Agent.mp4

09:31

2.1 sytems manager create iam policy.zip

2.2 update the trust relationship.zip

2. AWS System State Manager.mp4

08:36

10. High Availabity and Disaster Recovery

1.1 check multi-az status.zip

1. Multi-AZ deployments for Amazon RDS for Microsoft SQL Server.mp4

03:11

2.1 Always On availability group.html

2.2 Database Mirroring.html

2. Demo Converting RDS Instance to Multi-AZ.mp4

02:59

11. Monitoring and Performance

1. Monitoring Overview.mp4

00:54

Description

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

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

Who is this for?

College graduates

Database Administrators

IT Professionals

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Emar J. Morrison is a 30-year-old investor with a love for personal finance and investment. For the past four years, he has been investing in the stock market. In 2016, he bought his first stocks with little idea what he was doing. He was, nevertheless, completely enthralled, and he buried himself in it.He read a lot of books and researched investors like RULE 1 Investing’s Phil Town, Peter Lynch, Michael Lee-Chin, and, of course, Warren Buffet over the next few years. He has read George S. Clason’s The Richest Man in Babylon, Benjamin Graham’s The Intelligent Investor, Money Master The Game, and Tony Robbins’ The Unshakable.

Trevoir Williams

Instructor's Courses

Trevoir Williams is a passionate software and system engineer with a strong drive to share the best of his knowledge with students around the globe. His educational achievements include a Master’s degree in Computer Science (major in Software Development) and several Microsoft Azure Certifications.His impressive work experience includes software consulting, software engineering, database development, cloud system, and server administration, lecturing, and he’s also a musician!Trevoir enjoys teaching IT and development skills and guides students in gaining the latest knowledge with practical application in the modern industry.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.