Course Introduction

This course is a super-fast introduction to learning about key concepts of MySQL and setting it up for app development.

What will I learn?

This course will help you understand the key features of MySQL, when and how to use them and helps create a foundation upon which more advanced concepts can be learned.

Introduction to MySQL
Installation and setup
What is a data warehouse?
OLAP vs OLTP
Schemas,DDL and DML Statements
Constraints in MySQL
Functions in MySQL
Joins in MySQL
Set Operations in MySQL
Nested Queries
Rank Functions in MySQL
Triggers in MySQL
Indexing
Backup and Restore

What do I need to take this tutorial?

A browser and Docker (optionally for running locally)

However, be assured that everything you do via the browser in this tutorial can be done via code, can be version controlled and can work with any programming language you choose on the server-side.

We've kept this course light on developer workflows and environment choices so that you can focus on the key concepts and go on to set up your favorite tools and workflows.