Using Databases with Python

My cousin asked me where I would go if I wanted to learn programming all over again. This was my response.

1. Learn python:
2. https://www.codecademy.com/en/tracks/python
3. https://www.coursera.org/learn/python
4. https://www.coursera.org/learn/python-data
5. Solve challenges with Python
6. https://www.hackerrank.com/domains
7. Note: You should be able to the "Algorithms" and "Python" domains. "AI" is fun too.
8. Learn skills with Python
9. https://www.coursera.org/learn/python-databases
10. https://www.coursera.org/learn/python-network-data
11. Get ready to build something
12. Get a Github account -
13. If you have an edu email: https://education.github.com/pack
14. Star interesting projects! Search, discover, read!
15. www.reddit.com/r/Python
16. StackOverflow.com
17. Build something!!! Ideas:
18. I know you're in the financial world. Why not Computational Investing?
    1. https://www.coursera.org/learn/computational-investing
19. Python webapps are popular. Learn DJANGO (a python framework).
    1. http://gettingstartedwithdjango.com/
20. Raspberry Pi's are hackable little computers that can be scripted with python. Buy a Pi 2 and hack away! Build a robot
21. Visit Hackathons!
    1. https://mlh.io/seasons/s2015/events
22. Do TOPCODER challenges. These are some of the questions that come up in technical interviews
23. https://www.topcoder.com/challenges/?pageIndex=1
24. Something else! The possibilities are endless. Find something you want to do and do it!
25. Next steps
26. Data Science is huuuuge and it's only getting bigger. Seek out online courses for DS and do the TopCoder DS challenges.
27. Practice more on Django or Python on Pylons. Search for webdev openings.

Нові курси по Python на Coursera

Усі курси англійською + англійські субтитри!

Розпочалися (з 16.11):

Для тих, хто зовсім не знайомий з Python та програмуванням: https://www.coursera.org/learn/python

Основні структури даних (files, lists, dictionaries, tuples): https://www.coursera.org/learn/python-data/

Використання Python для доступу до web https://www.coursera.org/learn/python-network-data/

Планується запуск 14.12:

Основи мови SQL (використовуючи Python + SQLite3) https://www.coursera.org/learn/python-databases

Усі курси - це розділи книги 'Programming for Informatics: Exploring Information'

Recommended courses for using databases with Python?

So, I'm learning python using https://automatetheboringstuff.com which is pretty good. It has a section about using files which is good, but I'm looking to also learn about how to use databases with Python, which for some reason is missing there. I also checked out the MIT intro to CS but that doens't have databases either. Can anyone recommend a good Python course that includes databases? SQL or noSQL.... I found one on Coursera... but wanted to know if anyone can recommend anything from experience.

If your data currently exists as a collection of papers, I would suggest considering three things:

1. What data you want to look at.
2. How you want to digitize / input it.
3. You may wish to simply enter this into a spreadsheet for now, then transfer to a database.
4. Look into database design.

One good place to start, just for the basics, might be this course: https://www.coursera.org/learn/python-databases

It covers how to make/design databases & how to interact with them using python. Python also has good tools for data analysis.

> Are fixtures really games?

Yes, they are real games from the English Premier League.

> I can definitely help you out in terms of queries. I need some time to make up some data, unless you want to send over your database.

I have uploaded the DB to Dropbox with the changes you suggested to the schema.

> Questions: What database are you using? What courses have you tried so far? What's been the most frustrating thing?

I am using SQLite. I completed Using Databases with Python course from University of Michigan. This was a great course for the basics and there was a few practical examples that helped put some stuff together.

I had dabble in some of the codeacademy SQL courses many years ago, but they just left me confused at the time. I would possibly fair better if I returned to them now.

As I have not done massive amount of courses with SQL with Python, so my experience is limited, but I have found it frustrating that I haven't seen much beyond the basic Read, Write and Update files. What I am really finding frustrating is trying to find something that explains the building blocks of queries and how I should look to go about building them. But that might be more my fault at the moment. I will take a nose at the links that you have sent along and see what I can get from them.

EDIT: I have put together a simpler site using SQLite statements at https://github.com/spacedlevo/brewdog_untappd_app.git after following the Databases with Python course.

Preparation for Programming before Masters (liberal arts background)

Hi all -

I completed an undergrad in liberal arts but now want to move to the tech side and become a software engineer. I am considering M.S. in Computer Science programs (mainly the one with NYU Tandon) due to location and cost reasons (other suggestions welcome). I plan to use 2021 to prepare myself for a M.S. in Comp Sci and have compiled a list of courses to teach my programming. Can members here assist me by vetting this list? I understand C++ is used in a lot of programs but for now I wanted to learn Python first to dabble into the programming field. How good would these courses be in preparing me for an M.S. in Comp Sci and/or programming in general? Any revisions that you would make? Thank you

Programming for Everybody (Getting Started with Python)

Python Data Structures

Using Python to Access Web Data

Using Databases with Python

Capstone: Retrieving, Processing, and Visualizing Data with Python

Why don't you start with learning programming . It will take approximately 1-2months to reach the intermediate level. Here are the courses you can do to learn python from Coursera.org (Go serial wise do course 1 and then 2 and so on)

Course 1 https://www.coursera.org/learn/python

Course 2 https://www.coursera.org/learn/python-data

Course 3 https://www.coursera.org/learn/python-network-data

Course 4 https://www.coursera.org/learn/python-databases

Course 5 https://www.coursera.org/learn/python-data-visualization

Course 6 https://www.coursera.org/learn/learn-to-program

Course 7 https://www.coursera.org/learn/program-code

try one of these:

www.coursera.org/learn/python-crash-course

www.coursera.org/learn/python-data-analysis

www.coursera.org/learn/python-databases

www.coursera.org/learn/python-for-applied-data-science-ai