Blog
Library

Learn MySQL for Data Analysis Basics

Features Includes:
  • Self-paced with Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App

Course Preview Video

Description

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

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
Course Curriculum
Number of Lectures: 28 Total Duration: 01:29:10
Reviews

No Review Yet