From the course: AWS Certified Data Engineer Associate (DEA-C01) Cert Prep

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Hands-on learning: Query a database

Hands-on learning: Query a database

From the course: AWS Certified Data Engineer Associate (DEA-C01) Cert Prep

Start my 1-month free trial Buy for my team

Hands-on learning: Query a database

“

- [Instructor] In this lesson, we're going to try some SQL commands. We'll connect to our running RDS MySQL instance, create a database and some tables, and then we'll try some joins and other things. You should have already installed a MySQL database client like MySQL Workbench. If you haven't, go do that now. The first thing we need to do if you haven't done this already, is create a new MySQL connection to our database instance. To do that, we need to go over to the RDS console and get the host name, which on the console is labeled as Endpoint, for the database instance. Copy that into the clipboard, and then create a new MySQL connection by clicking on the plus sign. Put the host name where it says Hostname. Give this connection a new name. We need to change the username to admin 'cause that's what it was when we created the database. And we need to put our database password here. Just to make sure we're good let's test the connection. And we are, and we'll click OK to save our…

Contents