AWS Database Design Course

This course defines relational databases, describes the database options AWS provides, and details how to determine which is best for specific applications

1 hour, 10 minutes

Course description

In this course, the different types of databases available in AWS are described, starting with basics of relational databases and moving on to hosting, scaling and securing databases, and then diving into specifics on using Aurora, RedShift and DynamoDB in AWS.

Syllabus

Data security policies

Video - 00:07:00
It would be remiss to discuss database design without addressing policies. We discussed security in general earlier and now will will explain why policies are important.
DynamoDB

Video - 00:10:00
DynamoDB is a database solution used frequently for data stream capture and small, fast reads and writes. This episode introduces DynamoDB.
Redshift

Video - 00:08:00
When you need a data warehouse solution, Redshift may be the answer. A custom-built database solution offered in AWS, Redshift works well on massive data stores and allows you to analyze it quickly.
Aurora

Video - 00:06:00
The AWS Aurora relational database is the OLTP database solution unique to AWS. In this episode you will learn about Aurora and its features and capabilities.
Database security

Video - 00:08:00
When implementing databases, it is important to consider security. Databases store data, and data may be sensitive at varying levels. In this episode, database security is explored.
Scalability solutions

Video - 00:05:00
How do you grow a database when it's not keeping up with the workload? AWS offers different scalability solutions and they are presented in this episode to assist the architect in selecting the best option.
High availability solutions

Video - 00:06:00
Availability means that a resource is there when you need it and where you need it. With databases, this is of ultimate importance. In this episode you will explore the high availability solutions for databases in AWS.
Database hosting methods

Video - 00:05:00
You can host databases in AWS in two primary ways. One method is managed more by AWS and the other is managed more by your organization. This episode helps you understand the pros and cons of each.
Relational databases

Video - 00:08:00
Understanding the capabilities of relational databases is the starting point to architecting a good AWS database implementation. This episode provides the fundamental concepts and terminology of relational databases.
Database types

Video - 00:08:00
AWS supports several different database types. Varying applications have varying database type requirements. When you understand these types, you can select the best database service for your design.

Meet the author

Mike Meyers

Mike Meyers, affectionately called the "Alpha Geek," is the industry's leading authority on CompTIA certifications. He is the president and co-founder of Total Seminars, LLC, a provider of PC and network repair seminars, books, videos and courseware for thousands of organizations throughout the world. Mike has been involved in the computer and network repair industry since 1987 as a technician, instructor, author, consultant and speaker. He has sold over a million IT and certification books, including the best-selling CompTIA A+ Certification All-in-One Exam Guide and CompTIA Network+ Certification All-in-One Exam Guide. He has personally taught thousands of students, including U.S. senators, U.S. Supreme Court Justices, members of the United Nation, every branch of the U.S. Armed Forces, many branches of the Department of Justice, hundreds of corporate clients and academic students at every level.
Learn More

Unlock 7 days of free training

  • 1,400+ hands-on courses and labs
  • Certification practice exams
  • Skill assessments
Start a Free Trial

Plans & pricing

Infosec Skills Personal

$299 / year

Buy Now 7-Day Free Trial
  • 190+ role-guided learning paths (e.g., Ethical Hacking, Threat Hunting)
  • 100s of hands-on labs in cloud-hosted cyber ranges
  • Custom certification practice exams (e.g., CISSP, Security+)
  • Skill assessments
  • Infosec peer community support

Infosec Skills Teams

$799 per license / year

Book a Meeting
  • Team administration and reporting
  • Dedicated client success manager
  • Single sign-on (SSO)
    Easily authenticate and manage your learners by connecting to any identity provider that supports the SAML 2.0 standard.
  • Integrations via API
    Retrieve training performance and engagement metrics and integrate learner data into your existing LMS or HRS.
  • 190+ role-guided learning paths and assessments (e.g., Incident Response)
  • 100s of hands-on labs in cloud-hosted cyber ranges
  • Create and assign custom learning paths
  • Custom certification practice exams (e.g., CISSP, CISA)
  • Optional upgrade: Guarantee team certification with live boot camps

Learn about scholarships and financing with

Affirm logo

Award-winning training you can trust