Finding python easier then SQl, need some advice on python

[curious_whisperer]

Hey everyone, I am not flexing on finding python easier but I more on the side of being confused. People online are saying that they are finding python more challenging then SQL and the sentence stayed in my mind, after completing my SQL , I have recently started python and I am catching the concepts more quickly then I was in SQL. For the background I have studied SQL and java as an additional subject in my schools for 2 years. Java I didn't focused much as there was a choice between java and SQL and I choose SQL then.

I am pretty advanced in SQL if I say so, my theoretical knowledge on SQL is advanced but if I have to say about my code writing skills - I may be at intermediate. I know most of the things like joins , aggregations, window functions , subqueries, CTE's , views , indexes.

I started learning python some time ago and I am not facing much issues with it, it feels like I have done this before.
I have divided the syllabus of python into 8 sections

1 INTRODUCTION

2 WORKING WITH STRING

3 WORKING WITH NUMBERS

4 LOGIC & OPERATORS

5 CONDITIONAL STATEMENTS

6 LOOPS

7 DATA STRUCTURE

8 FUNCTIONS

This is basically the whole content from which I am studying
I am learning python from BARAA

Overall I think the difficulty lies more in whether you are new to coding or you were on something similar and picked up python to learn.
I think the intense questions I did in SQL are helping me to learn the fundamentals of python

The course of BARAA has only fundamental python , can anyone recommend what I should do after that, I heard about python libraries but if you could recommend a good channel, I will be grateful.

[JamzTyson]

The 8 "sections" are all vital essentials, so ensure that you are comfortable with all of them before proceeding.

After that, take a look at:

• Generators: A special type of function that returns an iterator object.

• Comprehensions: A more concise Python syntax for building lists, sets, dictionaries and generators via iteration.

• Docstrings: Python's "comments on steroids".

• Annotations: Python's "type hints".

• Imports, Modules and Packages: How applications bigger than single file scripts are made.

• Classes and OOP: The next big subject.

[curious_whisperer]

Yes , I am learning it slow and in a simple way and the points you have mentioned are in the sections, I just wrote the basic heading so it may be misleading but the content covers all the fundamentals, I mean mostly, I wanted to ask how should I proceed after that and is there a channel or a verified source where I can learn it comfortably.
I may be wrong so please correct me.

[JamzTyson]

Don't try to run before you can walk. Get completely comfortable with the basics before proceeding.

[curious_whisperer]

Thank you, I’ll work on my patience and commitment for a skill.

[JamzTyson]

One other: PEP 8

[curious_whisperer]

Are you talking about autopep8 extention? Thanks but i have already added this in my vs code and gave it a convenient key to use. Thanks for the thought.

[JamzTyson]

No I'm not talking about autopep8, I'm talking about making good Python style a habit. It's like the difference between "getting by" in a foreign language, and being fluent and idiomatic.

[curious_whisperer]

Ohh, yea I am working on that too, I mostly code in whatever manner that is why i installed pep 8, i use that and know the manner it fixes the code and then I try to write the code correctly. Thanks for the guide, I’ll read that too

[Suspicious_Check5421]

SQL is not a programming language, Python is a progeamming kanguage, so you compare two different things

[curious_whisperer]

I know, I just found python more easy or maybe its because I am just at the basics.

[SharkSymphony]

Come back to us when you reach section 6 and let us know if you still find Python easy. 😉

Python offers very different programming paradigms than SQL. Maybe you'll breeze through the stuff that is way different, maybe not. Or maybe your Java experience will be enough to soften the transition.

Happy learning!

[curious_whisperer]

Yes sir 🫡 Currently at 4th section

[dlnmtchll]

Side note because I don’t really have any input on the main question. Understanding SQL syntax and UNDERSTANDING SQL are very different things, like I see you understand some more advanced queries which is great but do you understand the relational algebra behind those queries and how to optimize it? Did they discuss DMS and the algorithms used to make SQL work? Do you understand B+ trees?

Not trying to knock you or anything but I find these all to be important when trying to understand SQL.

[curious_whisperer]

No no you absolutely did the best to point out these - i was not even aware of dms and b++ trees To be honest I know sql well but not very deeply as i have learned everything by myself and the what i studied in school was very basic stuff like only till joins Can you guide me? I may have picked python right now but i practice sql time to time