TOTAL: AWS Certified Database Specialty Exam Prep (DBS-C01)

The TOTAL Seminars Team brings you one of our most popular Instructors, Tom Carpenter is the Chief Technical Officer at CWNP (Certified Wireless Network Professionals). He's been in the IT industry for 25+ years, written over 20 books on IT subjects, and is also heavily involved in objectives development and exam creation in the certification industry.

Tom walks you through how Database Administrators (DBAs) move their databases to the cloud using AWS. It is helpful for anyone who deals with any aspect of databases in AWS.

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.

• Introduction 17:57

  • 1: About the Course Preview 01:16
  • 2: Introduction Preview 02:41
  • 3: AWS Certified Database - Specialty Exam Guide / Objectives Preview 03:00
  • 4: About the AWS Database Specialty Exam. Preview 03:02
  • 5: AWS Database Exam Objective Overview. Preview 07:58

• Introducing Databases 1:36:44

  • 6: Chapter 1 slides 14:00
  • 7: AWS Database – Specialty Recommended Knowledge 04:13
  • 8: Databases Defined 05:11
  • 9: Relational Databases 08:00
  • 10: Database Management System (DBMS) 09:03
  • 11: Cloud-Based vs. Local Databases 07:33
  • 12: Database Applications 06:53
  • 13: Database Access Languages 05:06
  • 14: Introducing SQL 08:51
  • 15: Reading Data with SQL 09:28
  • 16: Writing Data with SQL 05:49
  • 17: Working with Database Objects 06:37
  • 18: Quiz 06:00

• Database Services 1:10:47

  • 19: Chapter 2 slides 08:00
  • 20: AWS Database Services 05:26
  • 21: Relational Databases (Aurora, Redshift, RDS) 09:33
  • 22: Key-Value (NoSQL) Databases (DynamoDB) 06:46
  • 23: In-Memory Databases (ElastiCache) 06:15
  • 24: Document Databases (Document DB) 05:52
  • 25: Graph Databases (Neptune) 03:54
  • 26: Time Series Databases (Timestream) 02:48
  • 27: Ledger Databases (QLDB) 03:17
  • 28: Instance-Based Database Servers 05:57
  • 29: Access Control and Authentication 06:59
  • 30: Quiz 06:00

• Database Design 1:15:58

  • 31: Chapter 3 slides 08:00
  • 32: Designing Databases 06:55
  • 33: Using an ERD Tool 09:04
  • 34: Designing Database Solutions 06:32
  • 35: Designing for Performance 07:37
  • 36: Designing for Scalability 06:41
  • 37: Designing for Compliance 06:27
  • 38: Planning for Recovery 06:01
  • 39: Planning for High Availability 07:17
  • 40: Planning for Encryption 06:24
  • 41: Quiz 05:00

• Database Deployment 1:14:28

  • 42: Chapter 4 slides 04:00
  • 43: Creating RDS Databases 11:18
  • 44: Connecting to an RDS Database (MySQL Workbench) 05:34
  • 45: Creating DynamoDB Databases 07:14
  • 46: Creating RedShift Databases 07:29
  • 47: Creating DocumentDB Databases 06:30
  • 48: Creating Instance-Based Databases 04:21
  • 49: Creating Databases from the CLI 06:31
  • 50: Automation of Database Creation 07:38
  • 51: Orchestration of Database Creation 08:53
  • 52: Quiz 05:00

• Database Migration 53:09

  • 53: Chapter 5 slides 04:00
  • 54: Migration Strategies 09:00
  • 55: Preparing Data for Migration 05:41
  • 56: Preparing the Cloud to Receive Data 07:14
  • 57: Executing Data Migration 07:59
  • 58: Validating Data Migration 04:30
  • 59: Migrating using DMS 10:45
  • 60: Quiz 04:00

• Managing Databases 46:58

  • 61: Chapter 6 slides 04:00
  • 62: General Maintenance Processes 07:02
  • 63: Specific Maintenance Tasks 07:51
  • 64: Backup and Restore Strategies 06:23
  • 65: Performing an Unmanaged Database Backup 07:22
  • 66: Performing a Managed Database Backup 05:01
  • 67: Performing a Restoration 05:19
  • 68: Quiz 04:00

• Managing Databse Services 38:56

  • 69: Chapter 7 slides 03:00
  • 70: Managing RDS 07:57
  • 71: Managing DynamoDB 04:28
  • 72: Managing Redshift 05:21
  • 73: Managing Other Databases 05:50
  • 74: General Operational Environment Management 07:20
  • 75: Quiz 05:00

• Monitoring Database Solutions 57:28

  • 76: Chapter 8 slides 04:00
  • 77: Introduction to Monitoring 06:09
  • 78: AWS Alert Services 06:46
  • 79: Using CloudWatch 08:21
  • 80: Using Third-Party Monitoring Tools 05:35
  • 81: Auditing through Monitoring 03:21
  • 82: Special Security Auditing Tools 08:08
  • 83: Improving Database Performance 07:08
  • 84: Quiz 08:00

• Troubleshooting Cloud Solutions 1:00:49

  • 85: Chapter 9 slides 06:00
  • 86: Data Access Issues 09:11
  • 87: Database Availability Issues 07:54
  • 88: Database Performance Issues 05:46
  • 89: Data Corruption Issues 05:07
  • 90: Database Size Issues 06:28
  • 91: Security Issues 08:02
  • 92: General Troubleshooting Best Practices 07:21
  • 93: Quiz 05:00

What you will Learn:

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)

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. All these keep information in databases and most databased are housed in the AWS Cloud.

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.

FEATURES & BENEFITS

· Over 8 hours of content

· 9 downloadable PDFs with notes on every chapter

· 9 white paper PDFs suggested by AWS to study for the exam

· End-of-chapter quizzes to test your knowledge

· Q&A section where you can have your questions answered

· 30-day money-back guarantee

· Lifetime access

· Certificate of completion

WHAT'S COVERED?

· AWS Relational Database Service (RDS) and Aurora

· AWS DynamoDB (document database)

· AWS Database Migration Tool (migrate your existing databases into the cloud)

· AWS Key Management Service (encryption to secure your data)

· Troubleshooting database connection issues

· AWS Neptune (graph database)

· AWS Redshift (data warehousing)

The AWS Certified Database - Specialty exam domains covered are:

· Domain 1: Workload-Specific Database Design 26%

1.1 Select appropriate database services for specific types of data and workloads

1.2 Determine strategies for disaster recovery and high availability

1.3 Design database solutions for performance, compliance, and scalability

1.4 Compare the costs of database solutions

· Domain 2: Deployment and Migration 20%

2.1 Automate database solution deployments

2.2 Determine data preparation and migration strategies

2.3 Execute and validate data migration

· Domain 3: Management and Operations 18%

3.1 Determine maintenance tasks and processes

3.2 Determine backup and restore strategies

3.3 Manage the operational environment of a database solution

· Domain 4: Monitoring and Troubleshooting 18%

4.1 Determine monitoring and alerting strategies

4.2 Troubleshoot and resolve common database issues

4.3 Optimize database performance

· Domain 5: Database Security 18%

5.1 Encrypt data at rest and in transit

5.2 Evaluate auditing solutions

5.3 Determine access control and authentication mechanisms

5.4 Recognize potential security vulnerabilities within database solutions

MORE ABOUT THE AWS CERTIFIED DATABASE - SPECIALTY EXAM

· Exam code: DBS-C01

· Exam voucher cost: $300 USD

· Exam languages: English, Japanese, Korean, and Simplified Chinese

· Exam format: Multiple-choice, multiple-answer

· Number of questions: 55-65 (estimate)

· Length of exam: 180 minutes

· Passing grade: Score is from 100-1000, passing grade of 750

· AWS certifications are valid for 3 years, after which you must recertify (you get a 50% off voucher for your recertification exam from AWS)

How to take the exam:

· Sign up for a free AWS Training and Certification account***

· Once logged in, select "Schedule New Exam"

· Exam can be taken at your local Pearson-VUE testing center and is given via computer

ABOUT YOUR INSTRUCTOR

Tom Carpenter is the Chief Technical Officer at CWNP (Certified Wireless Network Professionals). He's been in the IT industry for 25+ years, written over 20 books on IT subjects, and is also heavily involved in objectives development and exam creation in the certification industry. Tom uses AWS daily to run several businesses websites and operate test labs used for content creation and management, among other things. Tom's teaching style is casual; he wants you to have fun while you learn practical applications of AWS. Join our class now and let us know how you plan to use AWS in your personal or professional life!

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

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

You need to set up a free AWS account to practice your skills

This course teaches you about developing and hosting databases on the AWS cloud.

The course is part of a AWS Administrator career path.

Currently there are no Q&As for this course. Be the first to ask a question.

Reed courses certificate of completion

Digital certificate - Included