Creating Your First Database on Amazon RDS: A Beginner’s Guide

Rafli Putra
4 min readOct 1, 2023

--

Amazon RDS x PostgreSQL

Welcome to the world of databases! Databases are the backbone of many applications and websites, allowing us to store, organize, and retrieve information efficiently. In this beginner-friendly guide, we’ll walk you through the process of creating your very first database using Amazon RDS (Relational Database Service). You don’t need any prior experience — we’ll start from the very basics.

Before we dive into creating databases on Amazon RDS, let’s understand what they are. A database is like a digital filing cabinet, where you can store all kinds of information — from customer details to product inventories. At the core of a database are tables, which are like spreadsheets. Each table contains rows and columns. Think of a table as a way to organize specific types of data.

For instance, imagine you’re building a pet store application. You could have one table to store information about your customers, another for pet products, and so on. Rows in a table represent individual records (e.g., one customer or one product), while columns define what kind of data is stored (e.g., name, age, breed, price).

Understanding this fundamental concept is crucial as it forms the basis for all database operations. Don’t worry if it sounds a bit abstract at the moment; I will illustrate everything with practical examples.

Databases come in various flavors, each suited to different needs. The focus of this guide is on using Amazon RDS, which is a cloud-based service for creating relational databases. Relational databases, like those offered by Amazon RDS, use tables and a structured approach to data. This is ideal for applications where data relationships need to be well-maintained, such as e-commerce sites or financial applications.

In the next sections, I will take you through the steps to set up your first database on Amazon RDS. Let’s get started!

Before I embark on the journey of creating your first database on Amazon RDS, there are a few prerequisites you need to ensure are in place. These prerequisites will help you make the most of this guide and have a smooth learning experience. Don’t worry; they’re straightforward, and I will guide you through each one.

Prerequisites:

  1. Registered Amazon Web Services (AWS) Account

To use Amazon RDS, you’ll need an AWS account. If you already have one, great! If not, you can sign up for an AWS account for free on the AWS website. This account will be the gateway to accessing and managing Amazon RDS.

Now that we have our prerequisites in place, it’s time to create your first PostgreSQL database on Amazon RDS. Follow these steps carefully:

Step 1: Log in to AWS Management Console

Sign In Page

Step 2: Navigate to Amazon RDS

  • Once logged in, you’ll see the AWS Management Console dashboard.
  • In the “Find services” search bar at the top, type “RDS” and select “Amazon RDS” from the search results. This will take you to the Amazon RDS dashboard.
Find Services Search Bar

Step 3: Launch a New Database Instance

  • On the Amazon RDS dashboard, locate and click the “Create Database” button.

Step 4: Select a Database Engine

  • In the “Engine options” section, select “PostgreSQL”.
  • This choice is important because we’re creating a PostgreSQL database for our pet store application.

Step 5: Choose a Use Case

  • Scroll down and find the “Use case” section. Select the use case that best describes your database. For our pet store, you can choose “Free Tier” to keep it cost-effective. Click “Next.”

Step 6: Specify DB Details

  • In the “DB details” section, provide the following information:
  • DB Creation Method: Easy Create
  • Engine Options: PostgreSQL
  • DB Instance Size: Free Tier
  • DB instance identifier: Enter a unique name for your database. Let’s use “petstore-db” as the identifier.
  • Master username and password: Create a master username and password for your database. Remember these, as you’ll need them to connect to the database.
  • In the “Additonal configuration” section, you’ll find the “Initial database name” field. Enter “petstore” (or any name you chose in Step 6) as the initial database name.
  • For this beginner’s guide, you can skip the advanced settings by scroll to the bottom and select “Create database”.

Step 7: Wait for Database Creation

  • Your database is now being created. This process may take a few minutes. You can monitor the progress on the Amazon RDS dashboard.

Step 8: Database Created

  • Once the database creation is complete, you’ll see it listed on the Amazon RDS dashboard.

Congratulations! You’ve successfully created your first PostgreSQL database named “petstore-db” on Amazon RDS. This database will be the foundation for your pet store application. In the next steps, we’ll explore how to connect to it and start working with your data.

Stay tuned for the next part of our guide where we’ll cover connecting to the database and performing basic operations.

Source:

https://www.stitchdata.com/integrations/harvest/amazon-rds-postgresql/

--

--