Study Learn Grow
Learn MySQL for Data Analysis Basics

Learn MySQL for Data Analysis Basics

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.

Overview

About this Course
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

Course Information

Computer Knowledge
Basic coding knowledge

What you will learn
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

Beginner Data Analyst and Data Scientist interested in MySQL for Data Science

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs