The Fast Track Introduction to MySQL on RDS
4.1 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
60 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Fast Track Introduction to MySQL on RDS to your Wishlist.

Add to Wishlist

The Fast Track Introduction to MySQL on RDS

Get up to Speed with MySQL Administration On RDS
4.1 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
60 students enrolled
Created by Mike West
Last updated 6/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 6 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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.
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 33 Lectures Collapse All 33 Lectures 01:30:53
+
Introduction
6 Lectures 10:34

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

Preview 01:26

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

This lecture discusses this course. 

Preview 02:02

What is RDS? 

Let's find out. 

Preview 01:53

RDS is a managed service. 

What exactly does that mean? 

Let's find out what's managed. 

Preview 01:58

What's included when we spin up our instance? 

Let's find out. 

Preview 02:41

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

Summary
00:34

Quiz
5 questions
+
Setting Up MySQL On Premise
9 Lectures 34:24

Let's find MySQL and download it. 

We will need the Windows Installer before we can install the product. 

Demo: Download MySQL
02:26

There are a few caveats to the install. 

It's not as simple as click, click, click. 

Let's walk through it now. 

Demo: Installing MySQL on Windows
07:46

Let's create a local connection to MySQL via Workbench

Demo: Creating a Connection with MySQL Workbench 6.3
02:37

We can't connect to MySQL. 

Let's find out why and how to remedy that. 

Demo: Troubleshooting Can't Connect
02:45

MySQL on Windows has one difference versus MySQL on the other platforms supported. 

Let's find out what that is. 

Demo: The MySQL Service Account
03:41

Let's look at some information on Managing our MySQL Instance. 

Demo: MySQL Management Information
05:54

Let's create an ERD. 

Demo: Reverse Engineer Database Model
06:03

Let's cover some of the section nomenclature. 

Terminology
00:48

Let's highlight what we've covered in this section. 

Summary
02:24

Quiz
10 questions
+
Setting Up MySQL on RDS
7 Lectures 22:21

We have three storage options for our databases. 

Let's talk about them in this lecture. 

What are Our Storage Options?
02:34

Demo: Creating Our First MySQL RDS Instance: DB Settings
04:37

Demo: Creating Our First MySQL RDS Instance: Advanced Settings
04:31

Demo: Connecting to Our MySQL RDS Instance from On Premise
03:49

Demo: Moving MySQL Data from On Premise to RDS
03:16

Demo: Creating a DB Parameter Group
02:11

Summary
01:23

Quiz
20 questions
+
MySQL Administration on RDS
10 Lectures 23:25

Let's walk through backing up and restoring in this lecture. 

Demo: Backing Up and Restoring Snapshots
04:22

Creating a read replica is ver straightforward. 

Let's create one in this lecture. 

Demo: Creating a Read Replica
02:27

The metrics built into RDS give us everything we need to monitor a DB instance. 

Demo: Monitoring Our Instances With ClouldWatch
02:26

Let's add some more horsepower in this lesson. 

Demo: Scale Instance Vertically
01:23

Renaming an instance is easy but there are a few caveats. 

Demo: Renaming a DB Instance
01:12

Having your data replicated to multiple data centers is a great idea for real world prod boxes. 

Let's see how easy that is. 

Demo: Setting Up RDS Multi-AZ
05:40

Let's alter our parameter group to keep our cache warm. 

Demo: Enable InnoDB Cache Warming on RDS for MySQL
00:56

Let's add an even to keep the buffer pool from cooling down in an outage. 

Demo: Dump and Load Buffer Pool on Demand for RDS on MySQL
02:00

Let's speed up our disk subsystem. 

Demo: Setting innodb_flush_log_at_trx_commit on RDS for MySQL
01:43

Summary
01:16

Quiz
10 questions
+
Conclusion
1 Lecture 00:18
Final Thoughts and Thank You
00:18
About the Instructor
Mike West
4.2 Average rating
1,671 Reviews
29,225 Students
32 Courses
SQL Server Evangelist

I've been a production SQL Server DBA most of my career.

I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.

Experience, education and passion

I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.

Certifications

Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).

Personal

Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.