Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 25 Minute(s)
Language
English
Taught by
Mike West
Rating
Course Overview
Moving Your SQL Server to The Cloud
This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.
This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.
This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.
Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.
As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.
There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.
The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.
Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.
Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.
ENROLL NOW!!. Let's Get Started
Course Content
- 7 section(s)
- 39 lecture(s)
- Section 1 Getting Our Heads in the Cloud. It Will Soon Be The New Normal.
- Section 2 Cloud Preparation. Let's Create Our AWS Account.
- Section 3 Amazon AWS Services We Need to Know Before We Begin With RDS
- Section 4 Stepping Through Every Database Option For An RDS Instance.
- Section 5 Creating Various RDS Instances. It's Time To Get Our Hands Dirty.
- Section 6 Moving AdventureWorks to the Cloud
- Section 7 Conclusion
What You’ll Learn
- This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud, You will be Architecting SQL Server Instances Using RDS. , As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.
Skills covered in this course
Reviews
-
AAnonymized User
This course is awesome for newbies to AWS RDS. Course was last updated on 2015 and there have been so many changes within RDS. It would be even more helpful if course is updated.
-
FFumani Mthembi
this has sealed my understanding about where I fit into the bigger picture as a data analyst..cloud we go!!!.. great course
-
GGregory Gornic
Very outdated, but they only SQL Server on ADS option available at this time. Needs to be updated.
-
KKishore Balaji
Acronyms and explanation can be more clear. Also this seems old version. Now when I surf AWS, I can see lot more new and I would be more happy if new version gets released. Like this is 2015 last updated and I bought this course in 2019 which almost 4 years older video.
