DEMO: Creating a Ledger using Amazon QLDB


SAA-C03 Introduction
RDS vs. EC2
RDS vs. EC2
Amazon DynamoDB
DynamoDB Accelerator
SAA-C03 Review
Start course
2h 52m

This section of the Solution Architect Associate learning path introduces you to the AWS database services relevant to the SAA-C03 exam. We then understand the service options available and learn how to select and apply AWS database services to meet specific design scenarios relevant to the Solution Architect Associate exam. 

Want more? Try a lab playground or do a Lab Challenge

Learning Objectives

  • Understand the various database services that can be used when building cloud solutions on AWS
  • Learn how to build databases using Amazon RDS, DynamoDB, Redshift, DocumentDB, Keyspaces, and QLDB
  • Learn how to create Elasticache and Neptune clusters
  • Understand AWS database costs
  • Learn about data lakes and how to build a data lake in AWS

Hello and welcome to this lecture. This is going to be a quick demonstration to show you how to set up an Amazon QLDB Ledger database. It's very quick and it's very simple. So let's take a look.

Firstly if we scroll down to the database category and select Amazon QLDB. Now before I create a new ledger I just want to show you the getting started option. So if you select on getting started on the left here, it comes with a tutorial to help you get set up for your first QLDB database. So it will show you how to create your first ledger, how to load some sample application data, how to query and modify your data, and also verify a document. So that might be something that you want to look into just to have a play with and get used to the database. However, let me show you how to create a ledger.

So if we go back to ledgers, as you can see we have none here. Select create ledger. Let's give it a name. I'll just call it MyLedger and then you can add any optional tags if you'd like to. Then simply click on create ledger. And as you can see the status is creating. That'll only take a few seconds. Okay, now you can see this is now active.

So our ledger is active. If we take a look we can see the ID, the journal size, the index storage size, and the ARN and the region, et cetera. And also in the CloudWatch metrics. But as we've only just set this up, there's no data available at the moment.

Now your ledger is created. You can then start creating tables, etc. Now if we go back to the getting started section under the sample application data you can select your ledger that you just created and load some sample data in there or you can use a manual option to create tables, indexes, etc. So let me just show you that manual option.

So if you select the link it will actually take you to some AWS documentation and it will show you the automatic option where it will pre fill your ledger with some vehicle registration data or you can select the manual option as well. So this will just guide you through on how to create tables using QLDB and populate your database.

So as you can see it's very easy to get started with QLDB and there's some great tutorials here for you as well to guide you through exactly how to set it up, run queries, modify documents, et cetera. But for this demonstration, I just wanted to show you the dashboard and how to create that initial ledger which as you can see was a very simple process. Creating the tables and queries and using all the functions of QLDB is out of scope of this fundamentals course.


Course Introduction - Amazon Redshift - DEMO: Creating an Amazon Redshift Cluster - Amazon Quantum Ledger Database (QLDB) - Amazon DocumentDB (With MongoDB Compatibility) - DEMO: Creating an Amazon DocumentDB Cluster - Amazon Keyspaces (for Apache Cassandra) - DEMO: Creating a Keyspace and Table in Amazon Keyspaces (for Apache Cassandra) - Course Summary

About the Author
Learning Paths

Stuart has been working within the IT industry for two decades covering a huge range of topic areas and technologies, from data center and network infrastructure design, to cloud architecture and implementation.

To date, Stuart has created 150+ courses relating to Cloud reaching over 180,000 students, mostly within the AWS category and with a heavy focus on security and compliance.

Stuart is a member of the AWS Community Builders Program for his contributions towards AWS.

He is AWS certified and accredited in addition to being a published author covering topics across the AWS landscape.

In January 2016 Stuart was awarded ‘Expert of the Year Award 2015’ from Experts Exchange for his knowledge share within cloud services to the community.

Stuart enjoys writing about cloud technologies and you will find many of his articles within our blog pages.