Help me understand web dev ,front end and back end

hey guys(experienced web dev ) am kinda new Bee in web development, have already completed, Responsive web design and am almost half way in JavaScript Algorithms and Data Structures.
Based on my knowledge i thought the basic skills needed to build a website is HTML CSS ,JavaScript, and SQL,PHP.
so my first question is
why is the[ Relational Database (Beta)] is pretty much below all the other curriculum…i.e(machine learning and Coding Interview Prep) and yet there not the basic, in other words why do i have to learn Coding Interview Prep before learning Relational Database (Beta).

and my other question is about PHP why is there no curriculum
talking about it, or is it not an important skills in web dev

thanks in advance for helping me understand, have a good day fox.

Required: HTML, CSS, JavaScript
Not required: SQL, PHP

Technically, all you need to build a web side is HTML. CSS and JavaScript are very helpful for anything beyond the most trivial site. There are no other languages beyond those three for frontend. There are helpful meta-languages, libraries, frameworks, etc,. but they all boil down to those three.

That is the frontend.

The backend would involve a server and probably a database. PHP and SQL are options for those. They are not the only option. FCC teaches a Node/Express for a server and Mongo/Mongoose for a DB.

why is the[ Relational Database (Beta)] is pretty much below all the other curriculum…i.e(machine learning and Coding Interview Prep ) and yet there not the basic, in other words why do i have to learn Coding Interview Prep before learning Relational Database (Beta) .

Probably because RDB stuff is beta.

and my other question is about PHP why is there no curriculum
talking about it, or is it not an important skills in web dev

Again, there are many languages you can use for a server. If you want to learn PHP, you can learn it somewhere else.

2 Likes

so it means after learning : Node/Express for a server and Mongo/Mongoose for a DB. i can pretty much build a back end without the need of PHP/SQL.

Yes, those are two options out of several. Node/Express/Mongo will serve the same function as PHP/SQL. There are some differences in how SQL and Mongo work, but they accomplish the same goal.

1 Like

thanks fam now i understand :100: