Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
The Fast Track Introduction to MySQL on RDS
Rating: 4.0 out of 5(32 ratings)
200 students

The Fast Track Introduction to MySQL on RDS

Get up to Speed with MySQL Administration On RDS
Created byMike West
Last updated 6/2016
English

What you'll learn

  • Be able to create and administrate a MySQL RDS Instance.
  • You'll learn how to migrate schema and data to an RDS MySQL Instance.
  • The course was designed for DBAs and developers who want to get up to speed with MySQL on RDS as quickly as possible.
  • You'll also learn some best practices specific to MySQL on RDS.

Course content

5 sections33 lectures1h 30m total length
  • What We Will Be Learning in This Course1:26

    Let's take a minute to find out what this course is about. 

  • Is this Course Right For You?2:02

    I want you to take my courses but I honestly want to make sure it's right for you. 

    This lecture discusses this course. 

  • The Relational Database Engines of RDS1:53

    What is RDS? 

    Let's find out. 

  • What Aspects of RDS are Managed?1:58

    RDS is a managed service. 

    What exactly does that mean? 

    Let's find out what's managed. 

  • What Do I Get When I Sign Up for RDS?2:41

    What's included when we spin up our instance? 

    Let's find out. 

  • Summary0:33

    Let's highlight what we've learned in this section

  • Quiz

Requirements

  • You will need an AWS account.
  • You'll need MySQL. In the course I'll be showing you how to install MySQL on a windows box.

Description

Reviews from Related Courses: 

Great course for a beginner and also to brush up on. I'm an 8yr. accidental DBA and got something out of this course and will take it back to the company. -- JD Mulliken

This is a great course about Azure SQL Database. -- G. Begna

All videos are filmed in 1080 and all audio is crystal clear!!

Note: The first ten minutes of every course is free. Please take a moment to watch all the free content. This will help you become familiar with how the instructor will teach the rest of the course. 

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud.

Relational databases are complex. In all of my introductory courses I want to give you a high level look at the product. This isn't a deep dive course. This is a... "ahhh, that's where I backup my database or limit the user connections." This is a... "ahhh, that's how I install MySQL on Windows" course.

MySQL is a full-featured relational database management system (RDBMS) that competes with the likes of Oracle DB and Microsoft’s SQL Server. The RDS cloud implementation is a full featured MySQL RDMS. 

The basic building block of Amazon RDS is the DB instance. A DB instance is an isolated database environment in the cloud.  A DB instance can contain multiple user-created databases, and you can access it by using the same tools and applications that you use with a stand-alone database instance.

Databases hold structured data. It’s important to understand the difference between structured and unstructured data. MySQL is a relational database. The data we place in relational database has structure because we define how the data is to be stored using data types.  

In the relational database, we model data like products, categories, tags, etc., using tables. A table contains columns and rows. It is like a spreadsheet. 

Because we deal with a large amount of data, we need a way to define the databases, tables, views, stored procedures and other objects process data more effectively.

Thank you for your interest in “The Fast Track Introduction to MySQL on RDS.

See you in the course!!


Who this course is for:

  • You should have a working knowledge of cloud technologies specific to AWS.
  • This is a beginners course but knowledge of MySQL and AWS would be beneficial.