AWS Certified Database Specialty Exam Prep (DBS-C01)

The ONLY full video course on the site! Study for the newest AWS exam today!

Created by Total Seminars, Last Updated 23-Jul-2020, Language:English

What Will I Get ?

The purpose of each AWS Database service
All aspects of databases including design, migration, deployment, maintenance, security, monitoring, and disaster recovery
Automation and orchestration of databases using the GUI and command-line interface
Relational databases (RDS), in-memory databases (ElastiCache), key-value (NoSQL) databases (DynamoDB), document databases (DocumentDB), graph databases (Neptune), time series databases (Timestream), and ledger databases (QLDB)
Database Management Systems (DBMS)
Database access language (SQL)

Requirements

AWS recommends a minimum of 5 years of experience with common database technologies
AWS recommends at least 2 years of hands-on experience working on AWS
AWS recommends experience and expertise working with on-premises and AWS Cloud-based relational and NoSQL databases
Internet access is preferred, as well as setting up a free AWS account to practice your skills

Description

AWS has come out with a BRAND NEW certification exam called the AWS Certified Database - Specialty (DBS-C01). The exam was created specifically for those who are interested in the database aspects of AWS.

Do you know how data has radically changed the landscape of everything in the cloud, the Internet, and your lives? If you've ever seen the "Customers also bought" tag on Amazon (that lead you to buy that super cool Bluetooth-enabled R2-D2), or used the databases in your company to better understand where the best places are to invest your profits, or simply used the contacts function of your phone to store all the important information about the people in your lives, you know how crucial data is.

Although this course is designed with Database Administrators (DBAs) in mind, it is helpful for anyone who deals with any aspect of databases in AWS. This exam covers everything from the AWS Relational Database Service (RDS) to NoSQL databases (DynamoDB) to the AWS Database Migration Tool. It focuses on various aspects, such as design, migration, deployment, maintenance, security, monitoring, and disaster recovery.

Who this course is for:

Anyone who wants to pass the AWS Certified Database - Specialty exam
Anyone who is interested in AWS's database services and wants to learn more

Course Content

Introducing Databases

13 Lectures 01:19:18
- Introduction
  
  Preview
  
  00:02:40
- Course Resources
- AWS Database – Specialty Recommended Knowledge
  
  Preview
  
  00:04:12
- Databases Defined
  
  00:05:10
- Relational Databases
  
  Preview
  
  00:07:59
- Database Management System (DBMS)
  
  Preview
  
  00:09:03
- Cloud-Based vs. Local Databases
  
  00:07:33
- Database Applications
  
  00:06:53
- Database Access Languages
  
  00:05:06
- Introducing SQL
  
  00:08:51
- Reading Data with SQL
  
  00:09:27
- Writing Data with SQL
  
  00:05:48
- Working with Database Objects
  
  00:06:36
Database Services

10 Lectures 00:56:41
- AWS Database Services
  
  Preview
  
  00:05:26
- Relational Databases (Aurora, Redshift, RDS)
  
  Preview
  
  00:09:32
- Key-Value (NoSQL) Databases (DynamoDB)
  
  00:06:45
- In-Memory Databases (ElastiCache)
  
  00:06:14
- Document Databases (Document DB)
  
  00:05:51
- Graph Databases (Neptune)
  
  00:03:53
- Time Series Databases (Timestream)
  
  00:02:48
- Ledger Databases (QLDB)
  
  00:03:16
- Instance-Based Database Servers
  
  00:05:57
- Access Control and Authentication
  
  00:06:59
Database Design

9 Lectures 01:02:55
- Designing Databases
  
  00:06:54
- Using an ERD Tool
  
  00:09:04
- Designing Database Solutions
  
  00:06:31
- Designing for Performance
  
  00:07:37
- Designing for Scalability
  
  00:06:41
- Designing for Compliance
  
  00:06:27
- Planning for Recovery
  
  00:06:00
- Planning for High Availability
  
  00:07:17
- Planning for Encryption
  
  00:06:24
Database Deployment

9 Lectures 01:05:25
- Creating RDS Databases
  
  00:11:17
- Connecting to an RDS Database (MySQL Workbench)
  
  00:05:33
- Creating DynamoDB Databases
  
  00:07:14
- Creating RedShift Databases
  
  00:07:29
- Creating DocumentDB Databases
  
  00:06:30
- Creating Instance-Based Databases
  
  00:04:21
- Creating Databases from the CLI
  
  00:06:30
- Automation of Database Creation
  
  00:07:38
- Orchestration of Database Creation
  
  00:08:53
Database Migration

6 Lectures 00:45:06
- Migration Strategies
  
  00:09:00
- Preparing Data for Migration
  
  00:05:40
- Preparing the Cloud to Receive Data
  
  00:07:13
- Executing Data Migration
  
  00:07:58
- Validating Data Migration
  
  00:04:30
- Migrating using DMS
  
  00:10:45
Managing Databases

6 Lectures 00:38:56
- General Maintenance Processes
  
  00:07:02
- Specific Maintenance Tasks
  
  00:07:50
- Backup and Restore Strategies
  
  00:06:22
- Performing an Unmanaged Database Backup
  
  00:07:22
- Performing a Managed Database Backup
  
  00:05:01
- Performing a Restoration
  
  00:05:19
Managing Database Services

5 Lectures 00:30:52
- Managing RDS
  
  00:07:56
- Managing DynamoDB
  
  00:04:27
- Managing Redshift
  
  00:05:20
- Managing Other Databases
  
  00:05:50
- General Operational Environment Management
  
  00:07:19
Monitoring Database Solutions

7 Lectures 00:45:26
- Introduction to Monitoring
  
  00:06:09
- AWS Alert Services
  
  00:06:46
- Using CloudWatch
  
  00:08:21
- Using Third-Party Monitoring Tools
  
  00:05:35
- Auditing through Monitoring
  
  00:03:21
- Special Security Auditing Tools
  
  00:08:07
- Improving Database Performance
  
  00:07:07
Troubleshooting Database Solutions

7 Lectures 00:49:46
- Data Access Issues
  
  00:09:11
- Database Availability Issues
  
  00:07:53
- Database Performance Issues
  
  00:05:46
- Data Corruption Issues
  
  00:05:06
- Database Size Issues
  
  00:06:27
- Security Issues
  
  00:08:02
- General Troubleshooting Best Practices
  
  00:07:21

Total Seminars

Total Seminars provides certification training services and training materials to thousands of schools, corporations, and government agencies including the United Nations, the FBI and all branches of the Department of Defense.

Total Seminars produces the #1 selling CompTIA A+ and Network+ Certification books with over 1 million books in print.

Total Seminars has created a number of “Best-Selling” video courses by Mike Meyers and the Total Seminars team of Instructors. They also develop supplemental materials such as the TotalTester certification practice tests and TotalSims lab simulations to support your certification preparation. These are available on the Total Seminars web site, www.totalsem.com.