How did you learn web design and development(front and back -end)?

I am a computer science student and I have a bit of advice for you. Last year I decided to try to learn how to use Django since I was already familiar with Python. It went terribly. I got really hung up on doing everything properly and being a total perfectionist ("If I don't do this right the first time, the website won't work at all" style thinking). As a result, my progress was very slow and I didn't get far. This year I took a web development class where I spent the first part of the semester doing Ruby projects to become familiar with the language and then used Ruby on Rails for a final project.

I would highly recommend jumping into either Rails or Django (I think in the future I will use Django but it doesn't really matter) and using a tutorial to implement your own project. I followed this while making a completely different website but using the tutorial sections to implement what I needed.

As for the database, I think this will be unpopular to say but don't worry about how efficient or redundant your database is. At least not at first. As long as you don't have production data in it, the database is quite easy to modify. Maybe draw up a schema you think is an effective model, make the database, and if you need to change it that's quite easy. Like I said, I stalled trying to make my database perfect on the first try, not understanding that I could just change it later.

I'm not I'm understanding what you mean by "dynamic databases" but remember that tables typically model a data type, not membership to a single set so creating and dropping tables frequently isn't a common practice and definitely not efficient.

To summarize: you get good at things by practicing so start practicing.

/r/compsci Thread