TECH - Articles

SQL Overview
SQL RDBMS Concept
SQL Syntax
SQL Data Type
SQL Create Database
SQL Drop Database
SQL Show Database
SQL Use Database
SQL Create Table
SQL Desc Table
SQL Create Table Like
SQL Drop Table
SQL Insert Into
SQL Select Table
SQL Where Condition
SQL Update Table
SQL Delete Table
SQL Operators
SQL AND & OR Operator
SQL Distinct
SQL Order BY
SQL Group By
SQL Like Clause
SQL In Clause
SQL Between Clause
SQL Joins
SQL Inner Join
SQL Left Join
SQL Right Join
SQL Full Join
SQL Self Join
SQL Cartesian Join
SQL Union Clause
SQL Null & Not Null Operator
SQL Aliases
SQL Top Clause
SQL Having Clause
SQL Using Views
SQL Select Into
SQL Insert Into Select
SQL Alter Table
SQL Truncate Table
SQL Primary Key
SQL Foreign Key
SQL Unique Key
SQL Indexes
SQL Expressions
SQL Wildcards
SQL Check Constraint
SQL Default Constraint
SQL Temporary Table
SQL Clone Table
SQL Sub Queries
SQL Auto Increment
SQL Null Function
SQL Functions
SQL AVG Function
SQL COUNT Function
SQL FIRST Function
SQL LAST Function
SQL MAX Function
SQL SUM Function
SQL UCASE Function
SQL LCASE Function
SQL MID Function
SQL LEN Function
SQL SQRT Function
SQL NOW Function
Linked List Insertion Implementation in Javascript
SQL DATEDIFF Function
Linux and Unix Sort Command
Linux and Unix Uniq Command
MYSQL Overview
MYSQL RDBMS Concept
MYSQL Data Types
MYSQL Syntax
Mysql Create Database
MYSQL Drop Database
MYSQL Show Database
MYSQL Use Database
MYSQL Create Table
MYSQL Desc Table
MYSQL Create Table Like
MYSQL Drop Table
MYSQL Insert Into
MYSQL Select Table
MYSQL Where Condition
MYSQL Update Table
MYSQL Delete Table
MYSQL Operators
MYSQL And & Or Operator
MYSQL Distinct
MYSQL Order By
MYSQL Group By
MYSQL Like Clause
MYSQL In Clause
MYSQL Between Clause
MYSQL Joins
MYSQL Inner Join
MYSQL Left Join
MYSQL Right Join
MYSQL Full Join
MYSQL Self Join
MYSQL Cartesian Join
Linux and Unix MV Command
Linux and Unix RM Command
Linux and Unix Tail Command
Linux and Unix Cat Command
Linux and Unix Chgrp Command
Linux and Unix Chown Command
Linux and Unix Chmod Command
Linux and Unix CP Command
Linux and Unix SCP Command
Linux and Unix LS Command
Linux and Unix Head Command
Linux and Unix Shutdown Command
Linux and Unix Reboot Command
Linux and Unix Uptime Command
Linux and Unix Free Command
Linux and Unix More Command
Stack Basic Implementation in Javascript
Queue Basic Implementation in Javascript
Write a method to generate binary numbers from 1 to n
Command Query Separation (CQS) in C#
Infix To Postfix Conversion Using Stack in Javascript
How to Add Comparison Feature in Replace in C-Sharp
Minimum number of bracket reversals needed to make an expression balanced
Evaluate Postfix Expressions Using Stack In Javascript
MYSQL Union Clause
MYSQL Null & Not Null Operator
MYSQL Aliases
MYSQL Limit Clause
MYSQL Having Clause
MYSQL Using Views
MYSQL Select Into
MYSQL Insert Into Select
MYSQL Alter Table
MYSQL Truncate Table
MYSQL Primary Key
MYSQL Foreign Key
MYSQL Unique Key
MYSQL Indexes
MYSQL Expressions
MYSQL Wildcards
MYSQL Default Constraint
MYSQL Temporary Table
MYSQL Clone Table
MYSQL Sub Queries
MYSQL Auto Increment
MYSQL Null Function
MYSQL Functions
MYSQL AVG Function
MYSQL COUNT Function
MYSQL FIRST Function
MYSQL LAST Function
MYSQL MAX Function
MYSQL SUM Function
MYSQL UCASE Function
MYSQL LCASE Function
MYSQL MID Function
MYSQL LEN Function
MYSQL SQRT Function
MYSQL NOW Function
Linked List Introduction
Linked List Delete Node By Postion in Javascript
Linked List Delete Node By Key in Javascript
Linked List Size or Count in Javascript
Linked List Node Swapping Implementation in Javascript
Binary Search Tree Insert node Implementation in Javascript
Binary Search Tree Search a Node Implementation in Javascript
Enlisting servers connected to mysql machine
What can be the maximum number of rows in a MYSQL Database Table?
ASP.NET Web API — Part 1
Knuth–Morris–Pratt Algorithm for Pattern Matching Implementation in Javascript
Find Amit's hostel name using hostel_list and student_list MYSQL database tables
How to use ninject dependency injection in mvc
Incorrect table definition there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Calculate nth Highest salary of an employee
Find the name of the hostel which has second highest capacity from hostel_list table
MYSQL Dump - How to take mysql dump or export mysql data
MYSQL difference between count(*) and count(column_name)
Web Server vs Application Server Difference Explained
How to solve IE/Edge CORS error ?
301 Page redirect, misunderstanding I had.
How to setup angular2 in visual studio ide
Building Blocks of Angular2
Determine Operating System type using Java