Learn MySQL For Data Analysis Basics

Visit Tutorial Page ( Report)


This is the bite size course to learn MySQL for Data Science. You will learn the select, insert, update, delete, order by, group by statements in SQL language. You will learn some data warehouse, star schema, use MySQL Workbench to create Star Schema, and data mining process, and OLAP Rollup.

Basic knowledge

  • Computer Knowledge
  • Basic coding knowledge

What will you learn


  • Install MySQL
  • Uninstall MySQL
  • Uninstall MySQL 2
  • Database
  • Create Tables from ERD in MySQL Workbench
  • Select Statement
  • Select Distinct
  • Select using Operators and Conditions
  • And Or Not
  • Order By
  • Insert Statement
  • Check whether have null values
  • Update Statements
  • Delete Statements
  • Min Max
  • Count Sum Average
  • Like
  • Group By
  • Join Two Tables
  • Join Two Tables 2
  • Get Frequency Table with Join and Group By
  • Join and Group By advanced
  • Join 3 Tables
  • Join 3 Tables 2
  • Star Schema Basics
  • Data Warehouse Basics
  • Data Mining Process
  • ROLAP ROLLUP Operation

To continue: https://www.simpliv.com/mysql/learn-mysql-for-data-analysis-basics

No sub-Tutorials exists in this Tutorial.
Write Your Review