Home|Explained Simply

Straight to the point articles covering the basic theory on various technology topics

OSI Network Layer

The third layer of the OSI model is the network layer. It is the first completely independent of the physical environment level, allowing two or more nodes to retransmit data no matter what physical network they are connected to. This permits different networks to be interconnected. The network layer finds out the easiest, shortest, and

2019-10-13T23:15:08+03:00By |Categories: Explained Simply|0 Comments

OSI Model Overview

The Open Systems Interconnection (OSI) model is a conceptual model created by the International Organization for Standardization. It provides interoperability between different communication systems using standard communication protocols. Or in simpler words, it is a logical model/representation of how the network systems are supposed to send data and communicate with each other. The model splits

2019-12-02T18:18:06+02:00By |Categories: Explained Simply|0 Comments

SQL DELETE Statement

The SQL DELETE statement is used to delete existing records in a table. DELETE FROM table_name WHERE condition; Parameters: DELETE FROM table_name  - The name of the table where records will be deleted.WHERE condition – Specifies which records should be deleted. If you omit it, all records in the table will be deleted. Example: Consider the Products

2019-09-02T22:41:53+03:00By |Categories: Explained Simply|Tags: |0 Comments

Lazy Loading

Applications often need a large amount of resources in order to run completely and without errors. However, different modules, forms, etc. of an application usually need different sets of resources to be loaded and not all of them. While all resources can be loaded at once, it would sometimes cost a lot of time to

2019-09-08T21:33:33+03:00By |Categories: Explained Simply|0 Comments

SQL WHERE Clause

The SQL WHERE clause is used to filter rows and return only those that meet the specified criteria. It is used in conjunction with the SELECT, UPDATE, DELETE, etc. statements and takes the following general form: SELECT column_name [, column_name ...] FROM table_name WHERE condition; The WHERE clause can be used along with AND, OR,

2019-09-02T22:39:50+03:00By |Categories: Explained Simply|Tags: |0 Comments

SVN – Basic Commands

Subversion, or simply SVN, is an open source file repository manager. Its purpose is to store every version of every file that has been uploaded on the main server. That way developers can track all the changes, revert to older versions of a file, compare edits and deal with mess-ups. Each developer has access to

2019-09-01T07:30:21+03:00By |Categories: Explained Simply|0 Comments

Array vs. Linked List vs. Hash Table

Array An array is a linear data structure consisting of a collection of similar data type elements, each identified by at least one index or key. The size of the array must be specified at the time of its declaration. It is fixed and cannot be resized during runtime. In the array, elements are organized

2019-06-10T22:24:21+03:00By |Categories: Explained Simply|Tags: |0 Comments

SQL UPDATE Statement

The SQL UPDATE statement modifies the data of one or more records in a table.  It has the following syntax: UPDATE table_name SET column_name = value [, column_name = value ...] [WHERE condition]; Parameters: UPDATE table_name  - The name of the table to update.SET column_name  -  Indicates which columns to modify and the values they should be

2019-08-25T11:48:17+03:00By |Categories: Explained Simply|Tags: |0 Comments