✅ MySQL 👍🏻 open-source 👍🏻 supported ⬆️ 👍🏻 easy to install 👍🏻 community 👎🏻 big data 👎🏻 limited advanced functions ✅ Oracle 👍🏻 support advanced functions 👍🏻 adequate for managin...

⭐️ common ground: methods for enhancing DB availability, reliability ✅ DB Clustering distributed database system across parallel nodes by grouping interconnected servers to work as a sing...

✅ Table Full Scan read all blocks in table to find data used for database optimization, optimizing query 👎🏻 can affect database performance if the table is big, query is complex ✅ Index R...

✅ Schema define database structure and constraints logical representation of data shows how data in DB should be stored logically attribute: characteristic of entity entity: collectio...

✅ NoSQL unrelational DB not only SQL can use query language depending on API/DB/query 👍🏻 scalability 👍🏻 availability 👍🏻 data is saved according to how application is used 👍...

✅ ORM Object Relational Mapping Map object and relational DB automatically save burden to code SQL Object oriented programming: use class Relational DB: use table thus, there ...

✅ Partitioning divide big table into small several tables 👍🏻 improve query performace data is physically divided into seperate tables but user can access the data as if it is on ...

✅ 모의면접 스터디를 신청하고 시작하게 된 계기 네트워크 지식 향상 면접 태도 개선 학습에 대한 강제성, 부담 부여 ✅ 스터디를 마무리하며 성장한 점, 느낀점 같이 공부하면 어느정도 부담이 있지만, 또 그만큼 열심히 하게 된다. 나는 함께 공부하는 습관이 어느정도 강제성도 부여해주고, 잘 맞는 것 같다. ✅ Feedba...

✅ Starvation resource management problem process priority is low process is never allocated resource priority is low: came late, takes long time… 💡 How to prioritize proc...

📌 Web application security ✅ How did you ensure the security of sensitive data in the “Aplicación Web HTTPS TLS/SSL CA: Let's encrypt Nginx use symmetric, assymetric key ✅ Can you explain how H...