Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Analysis & Business Intelligence with MySQL/Python/SQL
Rating: 4.4 out of 5(3 ratings)
37 students

Data Analysis & Business Intelligence with MySQL/Python/SQL

Hands-on Data Analysis & Visualization with SQL and Python
Created byDigital Learning Academy
Last updated 3/2026
English

What you'll learn

  • Write SQL queries to explore and analyse databases with MySQL Workbench
  • Learn how to use SQL to extract, sort, filter, and group data quickly and efficiently
  • Analyse data across multiple tables with MySQL JOIN statements
  • Analyse data and perform calculations using aggregate function
  • Analyse data using subqueries
  • Analyse data using various functions
  • Analyse data using various Operators
  • Analyse and manipulate data using Python & Pandas
  • Perform data cleaning with Python
  • Visualize data with Python

Course content

8 sections • 64 lectures • 5h 47m total length

  • Introduction0:20
  • What is Data Analysis0:21
  • What is business intelligence1:21
  • What is SQL4:32
  • What is MySQL3:31
  • MySQL Installation on Macs6:58
  • MySQL Installation on Windows10:20
  • Connecting to MySQL Server2:53
  • What is MySQL Workbench6:02
  • Installing MySQL Workbench on Macs5:36
  • Basic Database Concepts9:00
  • What is a Schema4:50
  • MySQL Data Types6:56
  • Displaying MySQL Databases in MySQL Workbench2:54
  • View MySQL Database Tables using MySQL Workbench2:06
  • Overview of Data Analysis & Business Intelligence with MySQL/Python/SQL2:02

Requirements

  • MySQL Database Server is required( I'll walk you through the installation)
  • MySQL Workbench is required( I'll walk you through the installation)
  • Basic knowledge of database concepts advised

Description

SQL stands for Structured Query Language. SQL lets you access and manipulate databases.

SQL can execute queries against a database. SQL can retrieve data from a database.

Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!

MySQL is an open-source relational database management system. MySQL is currently owned by Oracle and MySQL is free and open-sourced under the terms of the GNU General Public License and available under a variety of proprietary licenses.

MySQL is  used by many database-driven web applications such as Drupal, Joomla, and WordPress.

You will learn how to write queries in SQL (specifically MySQL) that will allow us to access the data inside a database.


What is Python? Python is a computer programming language often used to build websites and software, automate tasks, and conduct data analysis.

Pandas is a fast, powerful, flexible and easy to use open source data analysis and manipulation tool,

built on top of the Python programming language.

In this course we will query, analyse and retrieve data from a MySQL Database using SQL and also analyse and manipulate pandas data frame with  Python and also visualize data. We will also be performing some data cleaning using Python.








Who this course is for:

  • Data Analysts
  • Business Intelligence Analyst
  • Data Scientist

Report abuse