Learn MySQL Basics for Data Science
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.
Content
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
FAQs About "Learn MySQL Basics for Data Science"
About
Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.
CONTACT
SOCIAL NETWORK
