Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 few questions (I am a beginner)
#1
Huh 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.
Quote
#2
(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/IntegratedD...vironments

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
Quote
#3
(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?

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?
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

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.
Quote
#4
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)
Quote

Top Page

Forum Jump:


Users browsing this thread: 1 Guest(s)