Ready to master real-world SQL queries using Python in Jupyter Notebook? In this tutorial, you’ll use Python and SQLite to explore advanced SQL techniques on a real-world e-commerce dataset. Learn how to run queries, filter data, join tables, calculate revenue, and visualize results—all inside Jupyter Notebook!
What You’ll Learn:
• SQL Aggregations (SUM, AVG, GROUP BY, HAVING)
• Multi-table JOINs (INNER, LEFT)
• Subqueries
• Python with SQLite & pandas
• Real-world data analysis and visualization
Perfect for aspiring Data Analysts, Python Developers, and SQL learners!
_________________________________________
*How to download Anaconda to use Jupyter Notebook for Python coding:*
https://youtu.be/ImhtTEfQafo?si=5yxLQ4gAe8AqbtYm
📦 *Download the SQL Database used in this project:*
👉 http://bit.ly/3YvcdAM
_________________________________________
🔔 *Don’t forget to LIKE & SUBSCRIBE for more Python & Data Analysis tutorials!*
💬 Have a question? Drop it in the comments!
💎 *Want to Buy Me A Coffee:* https://buymeacoffee.com/datageekismyname
________________________________________
*Continue your learning with Python:* https://learnpython.com/?ref=mgzmzjn
*Great Books For Mastering Data Science and Data*
*Cleaning Python For Data Analysis:* https://amzn.to/4dQUOaF
*Python Data Science Handbook:* https://amzn.to/3BV6hsk
*Hands On Machine Learning with Scikit-Learn & TensorFlow:* https://amzn.to/4h8IxRS
*Python Machine Learning by Sebastian Raschka:* https://amzn.to/401eIMU
*Modern Python Cookbook: updated:* https://amzn.to/3BV6sE0
Thank you for watching.
_______________________________________
⏳ *Timestamps* ⏳
00:00 Introduction
0:36 Opened Jupyter Notebook
00:58 Download the database file into Jupyter Notebook
01:37 Title the New Workbook In Jupyter Notebook
01:54 Step 1: Connect to a SQLite Database & import libraries
04:40 An explanation of the libraries used
05:24 Step 2: Look and review the Database Tables in Jupyter Notebook
07:06 Look at the Data structure and what kind of data it stores.
10:44 Step 3: Create a SQL query to find the top paying customers who spent the most.
14:18 Step 4: Visualize top paying customers (Bar Chart).
17:55 Step 5: Find and review the Products Not Ordered in the last 30 Days
22:28 Step 6: Create a SQL query to show the Monthly revenue by Country
26:16 Step 7: Visualize the monthly revenue by Month and country (line Plot).
29:22 Step 8: Create a Subquery to find the highest order in the store.
32:05 Step 9 Close the Database Connection
32:30 Ending statement. Thank you for watching!
_____________________________________________________________
#sqlite #sql #python #dataanlysis #jupyternotebook #sqltutorial #pythonforbeginners #datascience
Disclaimer: This content is for educational purposes only. Affiliate links may be included, and I may earn a small commission at no extra cost to you. Thank you for supporting the channel!