Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn MySQL Basics for Data Science
Rating: 3.2 out of 5(39 ratings)
574 students

Learn MySQL Basics for Data Science

Learn MySQL for Data Science and Data Mining
Created byGoh Ming Hui
Last updated 12/2018
English

What you'll learn

  • MySQL and some data mining and data warehouse

Course content

1 section • 28 lectures • 1h 29m total length

  • Installation of MySQL5:11
  • Uninstall MySQL1:58
  • Uninstall MySQL 20:38
  • Data Base11:40

    Learn how to create and use databases, show and manage tables, and load data in MySQL for data science, using employees and salaries tables.

  • Create Tables from ERD in MySQL Workbench8:47
  • Select Statement5:07
  • Select Distinct1:45
  • Select Using Operators and Conditions1:39
  • And, Or, Not3:57
  • Order By1:47
  • Insert Statement4:02
  • Check to See There is Any Null Values1:08
  • Update Statements2:59

    Learn how to update data in a MySQL table with update statements, change first and last names in place, and verify results.

  • Delete Statements1:21

    Learn how to use delete statements in MySQL to remove rows with a where clause, delete all rows, and empty a table.

  • Min Max1:04

    Learn to query a salaries table to find the minimum and maximum salaries using select statements.

  • Count Sum Avg1:41
  • LIke2:09
  • Group By1:47
  • Join Two Tables2:24
  • Join Two Tables 21:31
  • Get Frequency Table with Join and Group By3:18
  • Join and Group By Advanced3:36
  • Join 3 Tables2:50
  • Join 3 Tables 23:14

    Join three tables to analyze employee data, salaries, and job titles using MySQL basics. Explore how to query relationships across the employees, salaries, and titles tables.

  • Star Schema Basics3:30

    Learn how to join a fact table to dimension tables in a star schema to analyze sales by country and product.

  • Data Warehouse Basics2:24

    Explore data warehouse basics, including extracting, transforming, and loading data from multiple databases into a centralized warehouse. Investigate subsets of data and multi-dimensional data warehouse for decision support.

  • Data Mining Process5:37

    Explore the data mining process from business understanding to deployment, using descriptive statistics, visualizations, data cleaning, normalization, modeling, evaluation, and model deployment decisions.

  • ROLAP ROLLUP Operation2:01

Requirements

  • Computer Technology

Description

Why learn Data Analysis and Data Science?


According to SAS, the five reasons are


1. Gain problem solving skills

The ability to think analytically and approach problems in the right way is a skill that is very useful in the professional world and everyday life.


2. High demand

Data Analysts and Data Scientists are valuable. With a looming skill shortage as more and more businesses and sectors work on data, the value is going to increase.


3. Analytics is everywhere

Data is everywhere. All company has data and need to get insights from the data. Many organizations want to capitalize on data to improve their processes. It's a hugely exciting time to start a career in analytics.


4. It's only becoming more important

With the abundance of data available for all of us today, the opportunity to find and get insights from data for companies to make decisions has never been greater. The value of data analysts will go up, creating even better job opportunities.


5. A range of related skills

The great thing about being an analyst is that the field encompasses many fields such as computer science, business, and maths.  Data analysts and Data Scientists also need to know how to communicate complex information to those without expertise.


The Internet of Things is Data Science + Engineering. By learning data science, you can also go into the Internet of Things and Smart Cities.


This is the bite-size course to learn MySQL for Data Science. You will learn the select, insert, update, delete, order by, and 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 learners understand programming basics. The learner will be able to program R, Python, C, C#, and Java after the courses

Content

  1. Install MySQL

  2. Uninstall MySQL

  3. Uninstall MySQL 2

  4. Database

  5. Create Tables from ERD in MySQL Workbench

  6. Select Statement

  7. Select Distinct

  8. Select using OPerators and Conditions

  9. And Or Not

  10. Order By

  11. Insert Statement

  12. Check whether have null values

  13. Update Statements

  14. Delete Statements

  15. Min Max

  16. Count Sum Average

  17. Like

  18. Group By

  19. Join Two Tables

  20. Join Two Tables 2

  21. Get Frequency Table with Join and Group By

  22. Join and Group By advanced

  23. Join 3 Tables

  24. Join 3 Tables 2

  25. Star Schema Basics

  26. Data Warehouse Basics

  27. Data Mining Process

  28. ROLAP ROLLUP Operation

Who this course is for:

  • Beginner Data Analyst and Data Scientist interested in MySQL for Data Science

Report abuse