Introduction:
Table of Contents
Amazon Relational Database services are distributed relational database service by Amazon web service. It is a web service running “in the cloud “designed to simplify the setup, operation, and scaling of a relational database for use in the application. Steps are discusses to connect AWS Database using SQL Developer.
AWS Database Services:
Amazon relational database service:
AWS Aurora
Amazon DynamoDB
AWS Redshift
Amazon Elastic Cache
What is a Relational Database?
The relational database is the database that most of us are all used to. It has been around since the ’70s. a relational database is like a spreadsheet such as excel, etc. database consists of tables.
How to Connect the database using SQL developer?
To create a database instance
Sign into the aws management console and open the Amazon RDS console.
On upper- right corner of the Amazon RDS console, choose the AWS region in which you want to create the DB instance.
Navigation Pane, Choose Databases, Create a database.
In engine options, choose the engine type: MariaDB, Microsoft SQL Server, MYSQL, Oracle, PostgreSQL. Microsoft SQL server is shown.
For Edition, if you’re using MYSQL choose the DB engine edition that you want to use.
MYSQL has only one option for the edition.
In templates, choose the template that matches your use case. If we use the free tier, for learning purpose.
Learn More About IAM
To enter your master password, do the following:
- In the setting section, open credential settings.
- Clear the auto-generate a password checkbox.
- Change the master user name value and enter the same password in the master password and confirm the password.
By default, the new DB instance uses an automatically generated password for the master user.
Choose next to continue. The configure advanced settings page appears. On the Configure advanced settings page, provide additional information that Amazon RDS needs to lunch the DB instance.
Next step Choose launch DB instance.
On the final page of the wizard, choose close.
Conclusion:
AWS provides various database engines. AWS offers Oracle, Redshift, Aurora, My SQL etc. Creation of AWS Database is definitely very simple using aws console. However, connect aws database using sql developer with simple steps.