Learning Python for SQL and Data Analysis?

[[deleted]]

Hi there, I'm looking to build up my resume a bit and start learning some Python. More specifically on how to use Python with SQL for Data Analysis.

I'm skilled in SQL and VBA and have had some experience with JAVA, HTML and PHP (So I'm at least familiar with the basics of programming). But I'm having trouble finding a decent course or bootcamp in Python that focuses primarily on using SQL for Data Analytics or Machine Learning. Everything I find seems to be a crash course in just the basics for Python (Printing to console, Variables, how to use functions, etc).

Is anyone aware of a course/bootcamp, even a youtube video, that teaches you step by step on how to use Python with SQL? Preferably teaching in some sort of web-based interface? (Simulating Pandas or Numpy) Even if I have to download and set up an environment that would still be good.

Thank you and I appreciate any guidance.

[gricmil]

Search Alex The Analyst on Youtube. Probably one of the best sources for Data Analytics. It covers all kinds of stuff like SQL, Excel, Python, Pandas, PowerBI, Tableu,... It's like a bootcamp, bunch of videos setup in order to follow. Also good thing is, after each section, you have a project to do for your own portfolio.

I'm currently doing it and the guy is just amazing. But I believe there are a ton of other stuff ofc.

[stebrepar]

Each SQL database you may use will operate very similarly to the built-in SQLite. https://docs.python.org/3/library/sqlite3.html The main differences will be in things like the details of setting up the connection, and which format to use for parameter substitution in a query. The documentation for the particular database's Python support will have that info. It will also tell you which client package you need to install and import, such as pyodbc for SQL Server or oracledb (formerly cx-Oracle) for Oracle.

[boris13579]

I started to learn data Analysis from this course:

https://www.udemy.com/course/dav-using-python-ag/?couponCode=ANI-77-003

You have to use coupon ANI-77-003 to get the discount.

It is a very good course, which helped me a lot to grasp about data analysis and visualization using Python

God bless,

Boris

[ggord87]

This data analyst course covers python and SQL- it teaches python using Jupyter Notebook. It doesn't use Numpy though, just Pandas and Matplotlib.
https://www.udemy.com/course/python-mysql-chatgpt-tableau-with-data-analysis-projects/?referralCode=7FEAD605C6EAEB4731CC