Implementing SQL Server on Amazon RDS
A guide for database administrators to implement SQL Server on Amazon RDS.
Course info
Rating
Level
Intermediate
Updated
Oct 19, 2015
Duration
2h 20m
Table of contents
What Is Amazon RDS?
Introducing Amazon RDS
2m
What Is Database as a Service?
5m
The Business Value of RDS
1m
Module Summary
2m
Building Your SQL Server on Amazon RDS
What's in This Module?
1m
Planning Your Deployment
2m
Pricing and Instance Choices
4m
Storage and Networking
8m
Demo: Create Your SQL Server on RDS through the AWS Console
6m
Configuring Your SQL Server in RDS
3m
Demo: Configure Your SQL Server in RDS through the AWS Console
5m
Demo: Configure SQL Server in RDS through the AWS Command Line
3m
Module Summary
1m
Connecting and Managing SQL Server on Amazon RDS
What's in This Module?
1m
Connecting to SQL in RDS
3m
Demo: Verify Network Connectivity
3m
Demo: Connecting with SSMS and Excel
2m
The RDS Admin User
2m
Demo: Working as RDS Admin
3m
Working with the SQL Agent
1m
Demo: SQL Agent Functionality in RDS
3m
Viewing SQL Server Logs in RDS
2m
Demo: Viewing SQL Logs on the AWS Web Console
2m
Demo: Viewing SQL Logs through SQL Commands
2m
Module Summary
1m
Moving Data in and Out of SQL Server on RDS
What's in This Module?
1m
Tools to Move Data
3m
Demo: Scripting Your Database
5m
Which Tool to Use
1m
Demo: Moving Data with the Import/Export Wizard
3m
Demo: Moving Data with the BCP Utility
3m
SQL Database Migration Wizard
1m
Demo: Migrate Using the SQL Database Migration Wizard
4m
Module Summary
1m
Configuring Backups and High Availability
What's in This Module?
1m
Backup Settings and Cost
3m
Restore and Recovery Models
2m
Demo: Verify and Modify Backup Settings
4m
Demo: Restoring to a Point in Time
3m
Working with RDS Snapshots
3m
Demo: Creating a Snapshot of Your SQL Server
2m
Demo: Restoring Your SQL Server from a Snapshot
3m
SQL Server Multi-AZ Deployment
3m
Demo: Enabling Multi-AZ Deployment
3m
Demo: Failing over a Multi-AZ deployment
2m
Module Summary
1m
Known Service Limitations
Description
Course info
Rating
Level
Intermediate
Updated
Oct 19, 2015
Duration
2h 20m
Description
Amazon is one of the biggest providers of cloud computing in the world. Part of their offering is the database cloud service known as Amazon RDS. In this course, we'll cover what these service can do, the option and configuration choices for SQL Server, and the differences from the on-premises SQL Server that you already know.
About the author
About the author
Warner is a SQL Server Certified Master, MVP, and Principal Consultant at Pythian. He manages clients in many industries and leads a talented team that maintains and innovates with their data solutions. When he's not working in Ottawa, Ontario, he can be found in his home country of Costa Rica.
More from the author
More courses by Warner Chaves