few questions (I am a beginner) - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: General (https://python-forum.io/forum-1.html) +--- Forum: News and Discussions (https://python-forum.io/forum-31.html) +--- Thread: few questions (I am a beginner) (/thread-21390.html) |
few questions (I am a beginner) - eeps24 - Sep-27-2019 I am very new to python and having a hard time understanding some basic things. Can anyone please help me with the following? Can you please answer my questions in the same format? Thank you 1. Am I correct in saying python is a multi purpose language in that it can help build websites, app development and query databases? 2. Can python be used to query a SQL database? How about a NoSQL database? 3. Do I need to have very good math/statistical background in order to code with python? 4. Whats the name of the tool in which I would create my python code? Example, I would use TOAD/Oracle developer to query a Oracle database. What would I use for python? I am mostly interested in learning python to query databases/build reports. RE: few questions (I am a beginner) - buran - Sep-27-2019 (Sep-27-2019, 01:39 PM)eeps24 Wrote: 1. Am I correct in saying python is a multi purpose language in that it can help build websites, app development and query databases?you can use python for all of the above and many more... (Sep-27-2019, 01:39 PM)eeps24 Wrote: 2. Can python be used to query a SQL database? How about a NoSQL database?yes on both counts. Popular database providers have python bindings/connectors already developed. Do you have specific SQL/No-SQL DB in mind? (Sep-27-2019, 01:39 PM)eeps24 Wrote: 3. Do I need to have very good math/statistical background in order to code with python?My personal opinion is that math skills/math mindset is always an advantage in life :-) Even more in fileds like programming/computer science, etc. At the same time python is considered very beginner-friendly and is often selected as language of choice for introduction to programming (Sep-27-2019, 01:39 PM)eeps24 Wrote: 4. Whats the name of the tool in which I would create my python code? Example, I would use TOAD/Oracle developer to query a Oracle database. What would I use for python? You can use even simplest textprocessing application like Notepad to write code. Of course full-fledged IDE is better and comes with many useful features. List of python IDEs: https://wiki.python.org/moin/IntegratedDevelopmentEnvironments My personal preference is VSCode for a full IDE (Sep-27-2019, 01:39 PM)eeps24 Wrote: I am mostly interested in learning python to query databases/build reports.Definitely give it a try. Even if you decide to expand further and take on new language(s) in the future RE: few questions (I am a beginner) - eeps24 - Sep-27-2019 (Sep-27-2019, 01:39 PM)eeps24 Wrote: 2. Can python be used to query a SQL database? How about a NoSQL database? For SQL, Microsoft SQL and Oracle. For NoSql, any flavor really but I guess if I had to pick how about mongoDB. (Sep-27-2019, 01:39 PM)eeps24 Wrote: 3. Do I need to have very good math/statistical background in order to code with python? Of course math is always an advantage, but my question is, do I "need" to have these advance math skills to code? Thank you for your reply, huge help. RE: few questions (I am a beginner) - buran - Sep-27-2019 All of the mentioned DBs have [own specific] python bindings available. And for SQL-kind you can also use sqlalchemy (I didn't mention it, but it allows to connect to different DB engines) You definitely don't need advance math skills. That's why I said math skills are advantage (i.e. not requirement) |