|Explained Simply

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

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

Time Complexity Of Algorithms

Algorithms are ubiquitous and are used in almost every aspect of our lives. Choosing the right algorithm for performing a specific task is no trivial matter. In the best case scenario, the algorithm not only performs its job, but it does it using the least amount of resources. The most relevant resources when it comes

2019-06-18T05:53:51+03:00By |Categories: Explained Simply|Tags: |0 Comments

SQL SELECT Statement

What is SQL SELECT statement? The SQL SELECT statement is used to fetch data from a database table which returns the data in the form of a result table. These result tables are called result sets. Basic syntax SELECT column1, column2, column3 FROM table_name; The query contains two keywords - SELECT and FROM. The SELECT

2019-07-09T22:16:28+03:00By |Categories: Explained Simply|Tags: |0 Comments

SQL INSERT Statement

The SQL INSERT INTO statement is used to add new records to a database. INSERT INTO table_name (column_name [, column_name...]) VALUES (value [, value…]); Parameters: INSERT INTO table_name  - The name of the table where a new row will be inserted.column_name  -  Indicates the column names where the data will be added. VALUES value – Specifies

2019-07-16T05:08:03+03:00By |Categories: Explained Simply|Tags: |0 Comments

Basic Authentication With Nginx

Basic authentication with Nginx requires an installation of Nginx and htpasswd. We have to create a password file with users and passwords and add this file to Nginx. The password file The first step is the creation of a password file with htpasswd tool using the following command: htpasswd -c .htpasswd user The flag -c

2019-05-26T23:28:35+03:00By |Categories: Explained Simply|0 Comments