Mastering SQL Server RDS on AWS

سرفصل های دوره

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

1. Introduction

1. Introduction

2. Getting Started with SQL Server RDS

1. What is RDS

2. DB instance classes

3. RDS DB instance storage classes

4. Regions, Availability Zones, and Local Zones

5. Configuring AWS Command Line Interface (AWS CLI)

6. Amazon Simple Storage Configuration

3. Configuring SQL Server RDS Instance

1. Creating a SQL Server Database Instance

2. Installing SQL Server Management Studio (SSMS)

3. Connecting to SQL Server RDS Instance

4. Working with option groups

5. Working with parameter groups

4. Managing SQL Server RDS instance

1. Stop and Start an Instance

2. Modifying an SQL Server RDS DB instance

3. Deleting an SQL Server DB Instance

5. Database Creation & Configuration

1. Understanding RDSADMIN Utility Database

2. SQL Server System Databases

3. SQL Server RDS Storage Strategies

4. Creating Your First Database

6. Securing Your SQL Server

1.1 create user.zip

1. Understanding Users & Logins

2. Configuring Instance Level Security

3. Configuring Database Level Security

4. SQL Server Auditing Concepts

5. Implementing Server Level and Database Auditing

7. Backing up and restoring Amazon RDS DB with Snapshots

1. Working with backups

2. Configuring Automated Backups

3. Creating a DB snapshot

4. Restoring from a DB snapshot

5. Point-in-time recovery

6. Deleting a DB snapshot

8. Native backup and restore in SQL Server

1. Introduction

2. SQL Server Recovery Models

3.1 back database to s3.zip

3. Performing Native Full Backup

4. Performing Native Differential Backup

5.1 back database to s3.zip

5. Recovering RDS Database using Native Backups

9. Automating SQL Server RDS Processes

1. SQL Server Agent

2.1 sytems manager create iam policy.zip

2.2 update the trust relationship.zip

2. AWS System State Manager

10. High Availabity and Disaster Recovery

1.1 check multi-az status.zip

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

2.1 Always On availability group.html

2.2 Database Mirroring.html

2. Demo Converting RDS Instance to Multi-AZ

11. Monitoring and Performance

1. Monitoring Overview

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training