Learn MySQL for Data Analysis Basics

Content 28 lectures 01:29:10 Install MySQL Uninstall MySQL Uninstall MySQL 2 Database Create Tables from ERD from MySQL Workbench Select Statement Select Distinct Select using OPerators and WHERE clause And, Or, Not Order By Insert Statements Check Whether have Null Values Update Statement Delete Statements Min Max Count, Avg, Sum 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 Claue Content 28 lectures 01:29:10 Install MySQL Uninstall MySQL Uninstall MySQL 2 Database Create Tables from ERD from MySQL Workbench Select Statement Select Distinct Select using OPerators and WHERE clause And, Or, Not Order By Insert Statements Check Whether have Null Values Update Statement Delete Statements Min Max Count, Avg, Sum 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 Claue Install MySQL Install MySQL Install MySQL Install MySQL Uninstall MySQL Uninstall MySQL Uninstall MySQL Uninstall MySQL Uninstall MySQL 2 Uninstall MySQL 2 Uninstall MySQL 2 Uninstall MySQL 2 Database Database Database Database Create Tables from ERD from MySQL Workbench Create Tables from ERD from MySQL Workbench Create Tables from ERD from MySQL Workbench Create Tables from ERD from MySQL Workbench Select Statement Select Statement Select Statement Select Statement Select Distinct Select Distinct Select Distinct Select Distinct Select using OPerators and WHERE clause Select using OPerators and WHERE clause Select using OPerators and WHERE clause Select using OPerators and WHERE clause And, Or, Not And, Or, Not And, Or, Not And, Or, Not Order By Order By Order By Order By Insert Statements Insert Statements Insert Statements Insert Statements Check Whether have Null Values Check Whether have Null Values Check Whether have Null Values Check Whether have Null Values Update Statement Update Statement Update Statement Update Statement Delete Statements Delete Statements Delete Statements Delete Statements Min Max Min Max Min Max Min Max Count, Avg, Sum Count, Avg, Sum Count, Avg, Sum Count, Avg, Sum Like Like Like Like Group By Group By Group By Group By Join Two Tables Join Two Tables Join Two Tables Join Two Tables Join Two Tables 2 Join Two Tables 2 Join Two Tables 2 Join Two Tables 2 Get Frequency Table with Join and Group By Get Frequency Table with Join and Group By Get Frequency Table with Join and Group By Get Frequency Table with Join and Group By JOin and Group By Advanced JOin and Group By Advanced JOin and Group By Advanced JOin and Group By Advanced Join 3 Tables Join 3 Tables Join 3 Tables Join 3 Tables Join 3 Tables 2 Join 3 Tables 2 Join 3 Tables 2 Join 3 Tables 2 Star Schema Basics Star Schema Basics Star Schema Basics Star Schema Basics Data Warehouse Basics Data Warehouse Basics Data Warehouse Basics Data Warehouse Basics Data Mining Process Data Mining Process Data Mining Process Data Mining Process ROLAP Rollup Claue ROLAP Rollup Claue ROLAP Rollup Claue ROLAP Rollup Claue