By Simpliv
Online
Can be taken anytime
Professional Training Course
Yes (Details)
English
$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.