From the course: Amazon Web Services: Data Analytics
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Query RDS with ANSI SQL - Amazon Web Services (AWS) Tutorial
From the course: Amazon Web Services: Data Analytics
Query RDS with ANSI SQL
- [Narrator] Now that we have set up an RDS relational database MySQL cluster, we're going to work with data in it. In order to do that, we need to set up and test an RDS client, then we need to create and load a database, and finally we need to write and execute ANSI SQL queries. So here we are in the console, and we can see that we've got one RDS DB instance. We don't have a cluster because we're just using a dev instance, so if we click on instance, the name is demo, and we scroll down, we can see we have the connection information here. I'm going to copy the end point, and I've installed a trial version of a premium client. There's many different clients you can use. I just find this client, which is called NaviCat, to be really useful with Amazon, because as you'll see when I add a connection, it's native for not only Amazon, but the other clouds and you can have multiple types of database systems here. So, we're working with RDS for MySQL. So, let's call this demo RDS. And let's…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Setup for AWS analytics7m 29s
-
(Locked)
Query Athena using SQL query on S35m 44s
-
(Locked)
Query DynamoDB for NoSQL7m 19s
-
(Locked)
Set up Kinesis for input streams9m 17s
-
(Locked)
Query Kinesis Analytics8m 38s
-
(Locked)
Query CloudSearch and Elasticsearch5m 17s
-
(Locked)
Query AWS IoT7m 27s
-
(Locked)
Set up EMR, RDS, and Redshift3m 49s
-
(Locked)
Query RDS with ANSI SQL3m 38s
-
(Locked)
Query Redshift for RDBMS8m 36s
-
(Locked)
Query Redshift Spectrum2m 25s
-
(Locked)
Query EMR with Apache Spark5m 5s
-
-
-
-