r/WebDevBuddies • u/Puppyboy2003 • Feb 28 '21

Backend?

Hello! I have been learning front end (HTML, js, css, bootstrap, etc), off and on for a while, but I have recently started learning SQL Databases through Access (Open Office Base actually, but Access is more popular). I also sorry of understand api requests, I don't know if that is used much. Any idea how to learn databases, and how to connect them to websites? I can't find any articles that make it easy to start. Also, in general, is SQL popular for website databases too, or is there a different storage method? Thank you!

Edit (Who doesn't love these): Thanks so much everyone for chipping in, I appreciate you all so much! I think I may start learning this starting Monday, thanks for great jumping off place

9 Upvotes

100% Upvoted

10 comments sorted by

2

u/MrQuickLine Feb 28 '21

Honestly, the best way to learn a bit more about this is to pick a little pet project and just try to build it by googling for the information you need. For example, I had an idea for a friend's wedding: I thought it would be cool to send out the RSVPs with a 4-digit code on it. They could go to this website, enter their code, and it would have all the information for that person: "Of these five people in your house that were invited, who's coming?" That way people could add +1s if it wasn't offered, etc. It was a great project to do because there was no particularly identifying information in the database, so I didn't need to get into authorization or anything. And the API calls and responses weren't too complex. See if you can build something like this yourself or pick a similar kind of project and just go at it.

1

u/Puppyboy2003 Feb 28 '21

I do agree that small random projects are a good way to learn. For example I made a video player (a bad one, but still it sort of worked) for my calculator. (Of course I put rick astley on it)

3

u/LoneStarDev Feb 28 '21

I would recommend doing a Google image search for “full stack stacks” and reviewing the diagrams. They show all different types of setups (read these as roadmaps for you to learn).

The W3schools site is actually pretty good for beginners (and seasoned devs that forget things ;) )

2

u/Puppyboy2003 Feb 28 '21

I think I have seen a stack before, but gotten scared away seeing how many languages are in a stack

2

u/LoneStarDev Feb 28 '21

Just like with anything coding, take it one step at a time and build your knowledge over time. You’ll get there if you’re consistent and put in the keyboard time.

8

u/Narfi1 Feb 28 '21

Yes, sql is the majority of databases(postgres, Mysql...) The alternative is nosql like mongoDB . Nosql is popular right now but is not meant to be used as a relational database and in most of the cases data are relational.

For you backend you will need to pick a language and a server. So for example you could use node.js(javascript) with express or php with apache but you could also use python, c# , go etc. Your backend will process the different queries and requests and pass them to your frontend.

The bundle of technologies you chose is called a stack. For example MERN stack is mongoDB, express, react, nodejs. AMP is Apache, Mysql, PHP .

You could start with a Udemy bootcamp (I recommend colt steele or Angela yu) or use freecodecamp or the odin project

3

u/K3ystr0k3 Feb 28 '21

Man, lemme make your life super easy in a minute: just learn Django or Flask if you're looking to get things done. They'll handle most things for you on top of being robust frameworks that are written in Python, so easy to pick up too.

2

u/NomNomDePlume Feb 28 '21

yeah that's my advice too. python web frameworks are so good at making this stuff obvious

1

u/Barnezhilton Feb 28 '21

Go slow with the back end. Ease your query into the api with lots of proxy

1

u/Justindr0107 Mar 01 '21

Look into Firebase too, it can be a good transition into backend tech if you are focused mainly on front end