AMAbdelrahman Mohamed Elsheikhinabd-elrahman.hashnode.dev·Jul 5, 2024 · 5 min readBackend Communication Design Patterns0) Request - Response This is the very basic model that when the client (initiates the communication) usually sends a request to the server for getting something or performing an action and the server responds with the required files/data. ProsC...00
AMAbdelrahman Mohamed Elsheikhinabd-elrahman.hashnode.dev·Mar 10, 2024 · 2 min readIndexing in databasesCreating an index denotes taking the column data and storing it in another index column our data is stored on disks as we all know, so file systems is the topic we are talking about now Pages (a way for how to store the data on hard disk) data is abo...00
AMAbdelrahman Mohamed Elsheikhinabd-elrahman.hashnode.dev·Mar 10, 2024 · 3 min readViews in Relational DatabasesViews are about providing a customized, filtered representation of the data Simple View in MySQL simple views are virtual tables taking no space on physical hard disks. syntax in MySQL: create view lvl_300_stds as select * from students where level_i...00
AMAbdelrahman Mohamed Elsheikhinabd-elrahman.hashnode.dev·Mar 7, 2024 · 1 min readMySQL Shell CommandsEntering the SQL mode \sql connecting with a certain user \connect root@localhost using a specific database use new_db; creating a new user and adding a password for him. create user ali@localhost identified by '123pass' DCL (Data Control Languag...00
AMAbdelrahman Mohamed Elsheikhinabd-elrahman.hashnode.dev·Mar 7, 2024 · 4 min readTransaction 4 Read Phenomena and Isolation LevelsTransactions A Transaction is a sequence of one or more SQL statements executed as a single unit of work. A transaction represents a logical unit of work that is either fully completed or fully rolled back to its previous state if any part of it fail...00
