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
- 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.
How long will this tutorial take?
Approximately 2 hours.