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 read
Computer Networks - Episode 2Application Layer Protocol Agenda What basically are the function of Application Layer? What are the different types of application around the internet? Client Server Peer to Peer Sockets Vs Port HTTP DNS Application Layer Responsibilitie...May 25, 2023·3 min read
Project Design DiscussionIs this a good requirement that we are taking? 2 Types of requirements Functional - Major features of application Non-Functional - Tells what is the expectation of overall infrastructure Every service is going to be a different server altogether. W...May 25, 2023·2 min read
Project FeaturesFacts digestion from the last class The majority of the code written inside the models is generated by the sequelize CLI. We only need to make some edits and changes, such as specifying constraints and attributes using sequelize CLI commands. Repos...May 25, 2023·5 min read
Computer Networks - Episode 1Agenda for today! What is Internet Protocol Layered Architecture OSI Model TCP/IP Model Network : Group of interconnected things. Internet is a network of computers. Why do we need to connect computers? Communication Sharing Resources Ex: AWS....May 21, 2023·7 min read
REST API & Implementation | CRUDWhat are we going to do today? We are going to take our basic Node.js project setup and clone it. We are going to write our first set of CRUD APIs. We will be using the ORM to interact with the database. We will write 3-4 APIs that can help us im...May 20, 2023·8 min read
Preparing Folder Structure & Implementing ORMLibraries Express dotenv To manage environment variables inside.env file. env variable is a variable outside the program built inside the OS through some functionality. http-status-codes Detailed desc on what all ports are running in our syst...May 19, 2023·11 min read
