Unix and Linux
SQL Server
SQL
Python
Programming C
PHP
NodeJS
MongoDB
jQuery
JavaScript
HTTP
HTML
Git
Database
Data structure and algorithm
CSS and CSS3
C ++
C #
AngularJS
25 May 2019
Subquery - SUBQUERY in SQL
SUBQUERY is a query inside another SQL query and is embedded in the WHERE clause.
Program - Page 87
Learn basic programming with C, C++, Python, JavaScript, PHP, CSS, HTML5 programming languages. You can also find tutorials on databases, SQL Server here.
25 May 2019
SEQUENCE in SQL
SEQUENCE is often used because meeting the requirements of many applications is to require each row in a table to contain a unique value similar to the primary key.
25 May 2019
Integrated terminal in SQL Operations Studio (preview)
In SQL Operations Studio (preview), you can open an integrated terminal, starting from the root of the current workspace.
25 May 2019
The LIKE command in SQL
In SQL, the LIKE command is used to compare a value with similar values by using wildcards.
25 May 2019
TOP command in SQL
In SQL, the TOP statement is used to retrieve N records or X percent records from a table.
25 May 2019
ORDER BY command in SQL
In SQL, the ORDER BY clause is used to sort data in ascending order or in descending order on one or more columns.
25 May 2019
GROUP BY command in SQL
The GROUP BY clause in SQL is used in conjunction with the SELECT statement to sort data uniformly into groups.
25 May 2019
DISTINCT keyword in SQL
The DISTINCT keyword in SQL is used in conjunction with the SELECT statement to remove all duplicate records and retrieve only records.
25 May 2019
The clause to combine JOIN data in SQL
In SQL, the JOIN clause is used to combine records from two or more tables in a Database using common values from each table.
25 May 2019
LEFT JOIN in SQL
The LEFT JOIN in SQL is the type of JOIN that returns all records from the left table and matching records from the right table.
25 May 2019
RIGHT JOIN in SQL
RIGHT JOIN in SQL is a type of JOIN that returns all records from the RIGHT side table and matching records from the LEFT side table.
25 May 2019
FULL JOIN in SQL
FULL JOIN in SQL returns all records in the left table and the table must combine and fill in that NULL values for values do not match.
25 May 2019
SELF JOIN in SQL
Each Join operation must have two tables, but there are cases where you have to perform JOIN on the same table, but you can call this JOIN operation SELF JOIN.
25 May 2019
CARTESIAN JOIN in SQL
CARTESIAN JOIN in SQL returns the Cartesian product of record sets from two or more combined tables.
25 May 2019
Create a temporary name using ALIAS in SQL
SQL ALIAS is used to create a temporary name (called an alias) for a column or table.
25 May 2019
Index (INDEX) in SQL
SQL index (INDEX) is a special lookup table that database search engines can use to quickly increase the time and performance of data retrieval.