Online course - Learn MySQL Basics for Data Science by Udemy

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.

You can look at the following courses to get SVBook Advanced Certificate in Software Development

SVBook Advanced Certificate in Software Development are given to people who have completed the following courses:

- Create Your Calculator: Learn R Programming Basics Fast
- Create Your Calculator: Learn Python Programming Basics Fast
- Create Your Calculator: Learn C Programming Basics Fast
- Create Your Calculator: Learn C# Programming Basics Fast
- Create Your Calculator: Learn Java Programming Basics Fast
- Create Your WebBrowser: Learn C# Fundamentals Practically

and passed a 50 questions Exam. The six courses are created to help learner understand about programming basics. Learner will be able program R, Python, C, C#, Java after the courses

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

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

Learn MySQL Basics for Data Science

Course overview

Description

Similar courses