Author Archives: admin

key factors that cause the market to go up and down?

It is difficult to identify specific factors that influence the market as a whole. The stock market is a complex, interrelated system of large and small investors making uncoordinated decisions about a huge variety of investments. There are basic economic principles that can help explain any up and down market movements and with experience and […]

Agile – an approach

What is Agile? Agile is an iterative approach to project management and software development that helps teams deliver value to their customers with incremental delivery, instead of trying to deliver it all at once near the end, team collaboration, continual planning, and continual learning. The term “Agile” was coined in 2001 in the Agile Manifesto. […]


  Javascript is a simple programming language built into Netscape 2.0 and greater. It is integrated with and embedded in HTML. It allows greater control of web page behavior than does HTML alone.

GIT Command

Git is currently the most popular implementation of a distributed version control system.Git is a distributed version control system, meaning your local copy of code is a complete version control repository.Every time you save your work, Git creates a commit. A commit is a snapshot of all your files at a point in time. If a […]

Garbage Collection:Memory Management

Garbage collection (GC) is a form of automatic memory management. The garbage collector attempts to reclaim garbage, or memory occupied by objects that are no longer in use by the program. Garbage collection is often described as the opposite of manual memory management, which requires the programmer to specify which objects to deallocate and return to the memory system. Like other memory […]

Async And Await in C#

Synchronous: It means the execution of multiple task one after another when one task finishes another task executes and so on. Before completing one task it is not able to execute next task, that’s why synchronous is slow. e.g. If we have task a, b, c, d, e to execute it executes like a, b, c, d, e. Asynchronous: […]

Minification of CSS, Java Script and HTML

Minification means removing all unnecessary characters from source code without changing its functionality. These unnecessary characters usually include white space, new line, comments, sometimes block delimiters, removing unused code, using shorter variable and function names, which are used to add readability to the code but are not required for it to execute. Those un-needed parts add extra bytes to […]


A JOIN clause is used to combine rows from two or more tables, based on a related column between them.   Different types of join:   1. (INNER) JOIN Select records that have matching values in both tables. INNER JOIN is the same as JOIN.

SQL Case Expression

CASE is used to provide if-then-else type of logic to SQL. There are two formats, and both are used to return a result based on testing an expression.  The first is a Simple CASE expression, where we compare an expression to static values. It tests one expression against multiple values, this makes it great for transforming one […]

SQL Create View Statement

A view is the result set of a stored query on the data, which the database users can query. ·   Views can join and simplify multiple tables into a single virtual table. ·  Views can act as aggregated tables, where the database engine aggregates data (sum, average, etc.) and presents the calculated results as part of the data. · Views can […]