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...4 min read·shubhamkhuntia.hashnode.devJun 11, 2023
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...5 min read·shubhamkhuntia.hashnode.devJun 5, 2023
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...3 min read·shubhamkhuntia.hashnode.devJun 5, 2023
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 ...6 min read·shubhamkhuntia.hashnode.devJun 5, 2023
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...4 min read·shubhamkhuntia.hashnode.devJun 3, 2023