Requirements

No Database, SQL, or MySQL experience needed! Complete beginners to MySQL are welcome.
All you need is a working computer for this course; PC, Mac, and Linux users are all welcome.
No previous programming language experience required, but it won't hurt :)

Description

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.

Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. The Ultimate MySQL Bootcamp introduces you to a solid foundation in databases in a way that's both informative and engaging. Yes, that's right, it's possible to make an engaging course on databases.

In this course, you will:

Learn the ins and outs of SQL syntax

Generate reports using sales and user data

Analyze data using Aggregate Functions

Run complex queries using MySQL logical operators and string functions

Write all the common SQL joins

Work with large datasets containing thousands of entries

Build a web app using MySQL and NodeJS

Design and implement complex database schemas

Learn to navigate the treacherous world of storing dates and times

Clone the database structure of a photo sharing social network

Write jаvascript code to generate fake data sets

And more!