--- title: "Abdelrahman Mohamed Elsheikh (@abdelrahman-mohamed) | Hashnode" description: "Backend Engineering. Read the latest articles by Abdelrahman Mohamed Elsheikh on Hashnode." url: "https://hashnode.com/@abdelrahman-mohamed" --- @abdelrahman-mohamed # Abdelrahman Mohamed Elsheikh @abdelrahman-mohamed · Joined February 2023 Backend Engineering [Website](https://amelsheikh.tech/) ### [HTTP QUERY Method](https://abd-elrahman.hashnode.dev/http-query-method?utm_source=hashnode&utm_medium=feed) What problem was there? Querying using traditional GET requests with a large number of filters in the URL sometimes hits the browser/server character limit. In addition to limited expressiveness, eve 3 min read · [abd-elrahman.hashnode.dev](https://abd-elrahman.hashnode.dev/http-query-method?utm_source=hashnode&utm_medium=feed) [Jul 10](https://hashnode.com/posts/http-query-method/6a513a0f0736b5556e3e9d43) ### [Backend Communication Design Patterns](https://abd-elrahman.hashnode.dev/backend-communication-design-patterns?utm_source=hashnode&utm_medium=feed) 0) 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... 5 min read · [abd-elrahman.hashnode.dev](https://abd-elrahman.hashnode.dev/backend-communication-design-patterns?utm_source=hashnode&utm_medium=feed) [Jul 5, 2024](https://hashnode.com/posts/backend-communication-design-patterns/668816182f5220b56d39d66b) ### [Indexing in databases](https://abd-elrahman.hashnode.dev/indexing-in-databases?utm_source=hashnode&utm_medium=feed) Creating 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... 2 min read · [abd-elrahman.hashnode.dev](https://abd-elrahman.hashnode.dev/indexing-in-databases?utm_source=hashnode&utm_medium=feed) [Mar 10, 2024](https://hashnode.com/posts/indexing-in-databases/65ee3477c3919ccb8924e4fe) ### [Views in Relational Databases](https://abd-elrahman.hashnode.dev/views-in-relational-databases?utm_source=hashnode&utm_medium=feed) Views 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... 3 min read · [abd-elrahman.hashnode.dev](https://abd-elrahman.hashnode.dev/views-in-relational-databases?utm_source=hashnode&utm_medium=feed) [Mar 10, 2024](https://hashnode.com/posts/views-in-relational-databases/65ee339cc9c482e29c6826e8) ### [MySQL Shell Commands](https://abd-elrahman.hashnode.dev/mysql-shell-commands?utm_source=hashnode&utm_medium=feed) Entering 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... 1 min read · [abd-elrahman.hashnode.dev](https://abd-elrahman.hashnode.dev/mysql-shell-commands?utm_source=hashnode&utm_medium=feed) [Mar 7, 2024](https://hashnode.com/posts/mysql-shell-commands/65ea488318254fa3203312de)