For this week you should have completed the following foundational Database cloud components and activities described in these documents:
• “AWSEducateStarterAccount.pdf”
• “EnteringYourAWSClassRoom.pdf”
• “Starting an AWS Oracle Standard Edition RDS Instance.pdf”
• “Using SQL Developer to Connect to RDS.pdf”
To document your successful completion of these activities, please submit the following items in a word or PDF document. Additional details related to the format and the grading of the document are included below.
a. Login into your AWS Educate Account, go to this classroom and prepare a screen capture clearly showing your account status. For example, the following screen capture will satisfy this requirement with your specific classroom account status details.
Figure 1 Robertson AWS Educate Classroom Account Status
b. From the same classroom screen, click on “Account Details” and copy and paste the text results to your document that will be submitted. For example, the following text is similar what will be found in your submission:
AWS Access
Session started at: 2019-04-28T13:33:21-0700
Session to end at: 2019-04-28T16:33:21-0700
Remaining session time: 2h54m9s
Term: 23 days 09:06:38
Figure 2 Robertson AWS Educate Account Status
c. From the same classroom screen, click on “AWS Console”. Then, navigate to the RDS dashboard and show a screen capture that fully displays the Oracle RDS endpoint and Port for the RDS instance you started for this class. For example, the following screen capture would satisfy this requirement:
Figure 3 Robertson AWS Educate RDS Endpoint & Port
d. Using SQL*Developer, provide detailed screen captures demonstrating you successfully created a connection to your RDS instance and the results of you creating a simple table with at least 4 columns that includes a primary key. For example, the following screen captures would satisfy this requirement.
Note: You can use right-mouse - Properties to redisplay all of the Connection properties in SQL*Developer.
