This is the second course in a two-part series on database fundamentals for AWS. This course explores four different AWS database services — Amazon Redshift, Amazon QLDB, Amazon DocumentDB, and Amazon Keyspaces — and the differences between them. As well as getting a theoretical understanding of these, you will also watch guided demonstrations from the AWS platform showing you how to use each database service.
If you have any feedback relating to this course, please feel free to share your thoughts with us at support@cloudacademy.com. The first course in this two-part series covers Amazon RDS, Amazon DynamoDB, Amazon ElastiCache, and Amazon Neptune. If you're looking for more information on these AWS database services, you can find that course here.
Learning Objectives
- Obtain a solid understanding of the following Amazon database services: Redshift, Quantum Ledger Database (QLDB), DocumentDB, and Keyspaces.
- Create an Amazon Redshift cluster
- Create a ledger using Amazon QLDB
- Create an Amazon DocumentDB cluster
- Create a keyspace and table in Amazon Keyspaces for Apache Cassandra
Intended Audience
- Individuals responsible for designing, operating, and optimizing AWS database solutions
- Anyone preparing to take the AWS Certified Database Specialty exam
Prerequisites
To get the most out of this course, you should have a basic understanding of database architectures and the AWS global infrastructure. For more information on this, please see our existing blog post here. You should also have a general understanding of the principles behind different EC2 Instance families.
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.
Lectures
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
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.