2. DBMS - Joins CheatSheetTypes of Joins The ANSI SQL standard defines five types of joins that we’ll discuss. Cross Join : In this case, we pick the first row of Table A and match it with every row of Table B. Inner Join : In case of an inner join, a condition, or multiple...Jun 11, 2023 · 4 min readshubhamkhuntia.hashnode.dev
Sequelize ORM One to Many and Internal FunctionsBefore we start implementing our flights resource, we need to add 1 more resource i.e airport resource. Every flight is going to be belonging to some departure airport & some arrival airport. To do that we will make an airport resource. Every airport...Jun 5, 2023 · 5 min readshubhamkhuntia.hashnode.dev
Implementing Flight ServiceThe 1st service that we are going to straightaway target is going to be our flight search service. where we will not just be able to create flights but also search flights. We can filter them based on multiple criteria's. The aircraft that is actuall...Jun 5, 2023 · 3 min readshubhamkhuntia.hashnode.dev
Computer Networks - Episode 3(Most IMP from interview perspective) Agenda HTTP DNS ipv4 & ipv6 NAT TCP HandShake TCP vs UDP HTTP (Hypertext Transfer Protocol) It was a protocol to allow transfer of hypertext. Hypertext: documents which are specifying some information ...Jun 5, 2023 · 6 min readshubhamkhuntia.hashnode.dev
1. DBMS-Basic SQL CheatSheetBasic SQL SHOW DATABASES; USE mysql; SHOW CREATE DATABASE mysql; SHOW TABLES; DESCRIBE user; SHOW CREATE TABLE servers; SHOW COLUMNS FROM servers; CREATE DATABASE CREATE DATABASE MovieIndustry; CREATE DATABASE IF NOT EXISTS MovieIndustry; SH...Jun 3, 2023 · 4 min readshubhamkhuntia.hashnode.dev