Intro to Backend

Here is a great list of resources. First you need the absolute basics. Khan Academy's Computer Programming courses are great for this: link

Warning: wall of text

I will recommend you do, in this order,

1. Intro to HTML/CSS
2. Intro to JS
3. HTML/JS: Making webpages interactive
4. HTML/JS: Making webpages interactive with jQuery
5. Intro to SQL: Querying and managing data

Number 4 is optional. jQuery is very powerful, and a lot of people use it,but it's kind of "out of style" and considered bad practice to heavily rely on jQuery these days.

Now you know the basics of making web sites. But we need a backend to be able to save users' data and process it. I will suggest Udacity's Intro to Backend. I think you have to make a (free) account to see the course. This course teaches you the language Python. It's a great language for beginners, and is very powerful and used by companies and hobbysts alike. However, it is good to try different backend languages, so afterwards you may look around into Node.js, Ruby, C# (.NET), etc.

Now you know everything you need to make a basic web application. At this point you will be able to make OP's website and most stuff you dream up yourself.

______________________________________________________________________________________________________________

If you want to further your education and be able to work on serious projects collaborating with other developers, and potentially make it a career, you still need some refinement. For more advanced learning, your free options become limited. If you are willing to shell out some money, I can HIGHLY recommend Pluralsight. There are many great lecture series there. Udacity also has a good looking "Full Stack Web Developer Nanodegree" but Udacity is much more expensive. Other than that I don't want to go around looking for advanced resources right now, but here are topics you want to research:

Hosting. You don't want to run your website on your personal computer. You could never turn your computer off or your site would go down, and you would open yourself up to potential attackers. So you want someone to host it for you. Options include Heroku (best for beginners imo), Amazon Web Services, Microsoft Azure, etc.

Frontend frameworks. These make your life much easier on the front end part, and will replace most of what you would use jQuery for. The three big ones are Angular, React, and Vue. I would look into React or Vue as Angular has a steeper learning curve imo and most tutorials will use Typescript which is just more stuff you'll have to learn.

Backend frameworks. These make your life much easier on the back end part. For Python, Flask and Django are the big ones. For Node, Express is the big one and Hapi is another, and for Ruby the defacto is Rails.!\<

Databases. There are two types: relational and nonrelational. Read up on the difference. I would recommend Postgres for relational (MySQL as a secondary) or Mongo for nonrelational, simply because it has the most resources/tutorials online.

This looks like a promising course into the subject: https://www.udacity.com/course/intro-to-backend--ud171

Check out this github page in general to learn more: https://github.com/bmorelli25/Become-A-Full-Stack-Web-Developer/#full-stack-tutorials

What's the context? What constitutes the "basics" of SQL (or really any concept, for that matter) depends on the context.

In general, Udacity (and I'm sure other MOOCs) work well as an introduction to technical concepts. Their Intro to Relational Databases course is probably the place to start, but to reiterate my above sentiment, they also have a SQL for Data Analysis course and an Intro to Backend course, both of which go over SQL from different perspectives.

Depending on your usage, you may need to learn some coding, first, before delving directly into SQL. Those courses highlight the expected prior experience, but you'll need to determine what you need to do on your own.