Web Systems
Last updated
Last updated
If you're a backend guy, study your butt off to understand everything in this section. If you're not (mobile, front-end, etc), just review the list lightly. Pay close attention to the HTTP section.
Note: Below is stolen from .
Companies usually don't seem to want you to know the meanings of the different normal forms (1NF, 2NF, etc), but they do want you to be able to design a normalized schema. You should also know about why denormalizing your schema might sometimes be a good idea (it can speed up your reads, and it also lets you ).
. It is very important to know about these! They speed up reads for the column that they are on, but they make writes slower and increase memory requirements. They are usually implemented with .
(You can have , which are indexes on multiple columns)
.
.
There's kind of a cultural association with ORMs which makes it important to know about them: lots of old-school programmers in PHP or C# or whatever don't use them, and startups are wary of hiring people like that. It's useful to remember that ORMs protect you from SQL injection attacks.
Suppose I'm browsing Reddit at work, over HTTPS. Does HTTPS prevent my boss from seeing that I'm browsing Reddit? Does it prevent my boss from seeing what page I'm on?
How do cookies work?
Know the difference between the two.
It’s worth knowing a little bit about it. Mongo is probably the most famous NoSQL database.
If you want to learn much more about databases, read lecture notes from the .
Read all about the protocol . Some fun facts to know: How does work?
How does a web application control the caching behavior of its clients?