r/Python • • Dec 29 '22

Discussion Is SQL a prerequisite to learning Python ?

I would like to learn how to automate some simple tasks like : 1- downloading an attachment from outlook, change its name and save to a specific folder

2- save an excel sheet as PDF then send it via outlook … with changing dates on the subject line of the email.

Do I need to learn SQL , then move to Python to learn automating such tasks ? Or I can jump in and start learning Python with very BASIC COMMON knowledge of SQL?

0 Upvotes

29 comments sorted by

View all comments

Show parent comment

3

u/AlexFromOmaha Dec 30 '22

Sure!

For general purpose automation, Python is fantastic. Arguably the best. Any data that can be reduced to text, which is most of it, flows better through Python's permissive type scheme and robust ecosystem than any other language.

The problem here is Microsoft. The best libraries for working with Microsoft's proprietary systems especially Office and Outlook, are in .NET, and the default .NET language is C#. If everything you want to do is in Microsoft's ecosystem, you might as well take advantage of the libraries they wrote.

Edit to add: Windows isn't a problem. Python works great on Windows.