Automate SQL queries for Data Analysis and Visualization
Learn how to automate SQL queries for data analysis and visualization with Python and MySQL Database
5.00 (1 reviews)
353
students
2 hours
content
Apr 2023
last update
$13.99
regular price
What you will learn
Introduction to MySQL and the Sakila sample database.
How to set up Python with MySQL using the pymysql library.
How to create a connection to a MySQL database using SQLAlchemy.
How to execute SQL queries in Python.
How to load SQL query results into pandas DataFrames.
How to filter, sort, and aggregate data using pandas.
Joining tables in SQL and combining data from multiple sources.
Introduction to data visualization using the matplotlib library.
Creating various types of plots with matplotlib (e.g., bar charts, line charts)
Customizing plot appearance, labels, and legends in matplotlib
How to ask meaningful questions and generate insights from the data.
Working with time series data and analyzing trends over time.
How to explore correlations and relationships between variables.
Grouping and aggregating data to explore patterns and trends.
Charts
Students
Price
Rating & Reviews
Enrollment Distribution
Related Topics
5280226
udemy ID
18/04/2023
course created date
27/04/2023
course indexed date
Bot
course submited by