강의

멘토링

커뮤니티

Data Science

/

Data Analysis

MySQL Master Course for Data Analysts and IT Engineers!

A must-have subject for aspiring developers and those looking to get a job in big data!!

(3.5) 2 reviews

34 learners

Level Basic

Course period Unlimited

  • moduai
MySQL
MySQL
SQL
SQL
Big Data
Big Data
NoSQL
NoSQL
Tableau
Tableau
MySQL
MySQL
SQL
SQL
Big Data
Big Data
NoSQL
NoSQL
Tableau
Tableau

What you will gain after the course

  • MySQL

  • SQL

  • DB

  • Database

  • Query

  • query

  • data

  • data

  • visualization

  • MongoDB

  • Tableau

  • Tableau

MySQL for everyone, MySQL online courses just like at universities!!

From MySQL databases to visualizations,
Everything for Databases (DB)

In this lecture!

Create databases, upload data - add/delete/download - program - analyze - visualize using MySQL Workbench !

If you've ever had these concerns, pay attention!

'I guess I need to know how to handle data, which is an essential skill these days. Shouldn't I learn database (DB) queries ?'
Welcome! This is a hands-on SQL course where you can learn SQL by coding with just a mouse click.

Anyone interested in data science and artificial intelligence (students, job seekers, anyone)

Anyone who wants to extract, store, delete, and analyze data using SQL databases

Anyone who wants to learn about NoSQL databases and Tableau data visualization

  • ✅ Create and manage simple databases using MySQL Workbench and database tools.
  • ✅ You can perform data visualization using Tableau.
  • ✅ You can perform unstructured database management using NoSQL, Studio3, and MongoDB.
  • ✅ You can integrate two tools: MySQL and Tableau/Python/Reactjs.

What you learn
Check it out.

Anyone can learn it easily if they just follow along.

It is structured so that you can learn the content easily and naturally by following the instructor and entering the code one by one.

It barely covers complex theories or mathematical content!

It is structured around beginner to intermediate level hands-on practice and uses MySQL Workbench, Tableau, Studio3T, and MongoDB.

Who created this course

This thousand

Thinking, "I want to do something fun and engaging in life," I went to London in 2016 to study data science. After returning to Korea, I worked in planning and consulting at an artificial intelligence company.

As an instructor, I'm deeply interested in my students' jobs, aptitudes, career paths, interests, hobbies, and aspirations. I will help you discover your inner path and achieve career success! I will provide the best lectures in line with this calling!

History

  • (Former) Samsung Multicampus Instructor
  • (Former) Lecturer at Kookmin University's Software Convergence Graduate School
  • (Former) System construction and planning consultant
  • Master's degree in Data Science from University College London
  • Bachelor's degree in Materials Science and Engineering from Seoul National University

Q&A 💬

Q. What should I do if an error occurs while coding?

Just look at the last line of the error message and search for the error code and message on STACKOVERFLOW.COM or Google!

Q. Where is MySQL used?

MySQL is a data storage tool for businesses, schools, and public institutions. SQL, the language used to manipulate MySQL, is a legacy language dating back to the 1970s, and most databases heavily rely on SQL. Data science and data analysis require data extraction from databases, and SQL and MySQL are often used for this purpose.

Q. What is NoSQL?

While MySQL is a table-like data structure with fixed width and height, NoSQL is a free-form data structure with an uneven number of columns. It takes the form of JSON, XML, etc.

💾 Guide to Practice and Learning Materials

  • You will need a PC capable of running MySQL Workbench 8.0.
  • Requires MySQL Workbench Community Edition (free) or Studio3T (student version).
  • We provide students with sample data (.csv) and SQL query statement files (.sql).

📢 Please check before taking the class

  • This course requires a general level of computer skills.
  • You can improve your skills by coding by hand and avoiding using CTRL+C/V as much as possible!
  • The copyright of lectures and learning materials belongs to the instructor.
    (Everyone's AI, 846-58-00784, last updated: May 15, 2024)
  • thank you

Recommended for
these people

Who is this course right for?

  • People interested in data science and artificial intelligence

  • Anyone who wants to become a developer

  • Non-IT major

  • Job seeker

  • Students, including college/graduate students

  • Office worker

  • SQLD test takers, Big Data Analysis Engineer test takers

Hello
This is

Instructor Lee Cheon

I have performed planning and consulting duties at an AI company and the Korea Broadcast Advertising Corporation.

As an instructor, I have a deep interest in your job roles, aptitudes, career paths, enjoyment, interests, and what you aspire to achieve,

I will help you find your inner path, achieve your career goals, and succeed!!

I faithfully provide the best lectures in accordance with my calling!!

(Former) Multicampus Instructor

(Former) Instructor at Kookmin University Graduate School of Software

(Former) Instructor at Gwangju Institute of Science and Technology (GIST) Artificial Intelligence Graduate School

(Former) IT System Construction & Planning Consultant

MSc in Data Science, University of London

Bachelor of Science in Materials Science and Engineering, Seoul National University




Curriculum

All

81 lectures ∙ (5hr 10min)

Course Materials:

Lecture resources
    Published: 
    Last updated: 

    Reviews

    All

    2 reviews

    3.5

    2 reviews

    • moduai님의 프로필 이미지
      moduai

      Reviews 1

      Average Rating 5.0

      5

      10% enrolled

      Dear students, thank you for taking the 'MySQL Short Course for Data Analysts and IT Engineers!'!! Please give us a detailed evaluation for the instructor's lecture evaluation and future lecture development. Please write without hesitation, without hesitation, and in detail!!😊

      • scp00003144님의 프로필 이미지
        scp00003144

        Reviews 1

        Average Rating 2.0

        2

        100% enrolled

        Shouldn't there have been no technical or procedural errors, apart from the lecture content? Currently, the next lecture is not available at all, or is it a technical error? It doesn't play. Section 5: Mutual Join Section 9: All Request for resolution

        • moduai
          Instructor

          Hello? Thank you for taking 'Everyone's MySQL'. We apologize for any inconvenience caused to you, and we have immediately corrected the error you mentioned. If you have any further questions, please leave them as they are now. We will repay you with a great lecture. Thank you!! :)

      $15.40

      Similar courses

      Explore other courses in the same field!