How To Become A SQL Server Cloud Architect on AWS

Course Curriculum

Chapter 1: Getting Our Heads in the Cloud. It Will Soon Be The New Normal.

Lecture 1: Course Introduction. What Will We Be Doing and Is It Right For You?

Lecture 2: Services We Will Be Talking About In This Course.

Lecture 3: What Is a Cloud Computing? Let's Define it Before We Look At Amazon's Take.

Lecture 4: Amazon AWS Overview. AWS Stands For Amazon Web Services. Everything is a Service

Lecture 5: Amazon RDS Overview. RDS Stands For Relational Database Services.

Lecture 6: Summary. Let's Wrap Up What We've Learned About the Cloud and AWS.

Lecture 7: Errata. The User Guides For AWS Are Living Documents.

Chapter 2: Cloud Preparation. Let's Create Our AWS Account.

Lecture 1: Download Course Material Here.

Lecture 2: Creating an Account in the AWS Free Tier. There is one Caveat You Should Know.

Lecture 3: Monitoring Our Cost. How Much Do We Owe?

Lecture 4: Summary. Let's Wrap Up What We've Learned About the Cloud and AWS.

Chapter 3: Amazon AWS Services We Need to Know Before We Begin With RDS

Lecture 1: The Two Approaches To Putting SQL Sever in The Cloud.

Lecture 2: What is EC2? It's One of The Core Services Amazon's Provides. Let's have a look.

Lecture 3: Creating A SQL Server Instance Inside of EC2.

Lecture 4: What's a Virtual Private Cloud? Let's Get A 1000 Foot View of VPCs.

Lecture 5: Summary. Let's Wrap Up What We've Learned About Other AWS Services.

Chapter 4: Stepping Through Every Database Option For An RDS Instance.

Lecture 1: Blueprint for Spinning Up Our Instance in RDS.

Lecture 2: Instance Specifications – Our First Three Options

Lecture 3: Instance Specifications – Our Fourth Option is DB Classes

Lecture 4: Instance Specification – Our Fifth Option is About Availability Zones

Lecture 5: Instance Specification – Our Sixth Option is About Storage Selection

Lecture 6: Instance Specification – Our Seventh Option is Database Settings

Lecture 7: What is SSL? Our Next Option Will Deal With Security So Let's Set The Backdrop

Lecture 8: Our Eighth Option Will Deal With Database Parameters

Lecture 9: The Ninth And Final Option is Backups.

Lecture 10: Limits For SQL Server Databases. There Are Some Big Ones. Pay Attention Here.

Lecture 11: Cloud VS Local. A Simple IO Test Before You Move Your Database to The Cloud

Lecture 12: Summary. Let's Wrap Up What We've Learned About RDS.

Chapter 5: Creating Various RDS Instances. It's Time To Get Our Hands Dirty.

Lecture 1: Create A Highly Available RDS Instance and Fail it Over

Lecture 2: Using Snapshots. Creating, Restoring and Renaming. A Snapshot is a Backup.

Lecture 3: Vertically Scale An Instance With the Click of A Button

Lecture 4: Monitoring Our Instances With ClouldWatch. This is Amazon's Perfmon.

Lecture 5: Summary. Let's Wrap Up Creating A RDS Instance.

Chapter 6: Moving AdventureWorks to the Cloud

Lecture 1: Moving AdventureWorks To The Cloud. The "Recommended" Approach

Lecture 2: Moving AdventureWorks To The Cloud. My Recommend Way.

Lecture 3: Scripting Logins From On Premise To Our Cloud. This Will Work For All Servers.

Lecture 4: Summary. Let's Wrap Up What Our Schema and Data Migration Tools.

Chapter 7: Conclusion

Lecture 1: Interview Questions Specific to AWS and RDS.

Lecture 2: Congratulations and Thank You