Learn MySQL for Data Analysis Basics

Location
Online
Dates
Can be taken anytime
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Price
$10

Course 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

Who should take this course

Who is the target audience?

Any one who desires to learn it.

Accreditation

Course Completion Certificate

Course content

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

About Course Provider

Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.

Why Simpliv

With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.

Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.

Frequently asked questions

{{ item.question }}