Library

Course: Learn MySQL for Data Analysis Basics

Learn MySQL for Data Analysis Basics

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
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
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
Curriculum
Number of Lectures: 28
Total Duration: 01:29:10
Content
  • 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  
Reviews (0)