SQL (Structured Query Language) – Transactions
A transaction is a unit of work that is performed against a database. Transactions are units or sequences of work accomplished in a logical …
Tutorials
myTechMint – Learn Online Technical Tutorials of AWS, Hadoop, Sqoop, Talend, SQL, Python, C, C++, Java, Linux, Unix, VBA, etc in Easy and Simplified Way.
SQL (Structured Query Language) – Having Clause
The HAVING Clause enables you to specify conditions that filter which group results appear in the results. The WHERE clause places conditions on the selected columns, whereas …
SQL (Structured Query Language) – Using Views
A view is nothing more than a SQL statement that is stored in the database with an associated name. A view is actually a composition …
SQL (Structured Query Language) – TRUNCATE TABLE Command
The SQL TRUNCATE TABLE command is used to delete complete data from an existing table. You can also use DROP TABLE command to delete complete table but …
SQL (Structured Query Language) – ALTER TABLE Command
The SQL ALTER TABLE command is used to add, delete or modify columns in an existing table. You should also use the ALTER TABLE command to …
SQL (Structured Query Language) – Indexes
Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in …
SQL (Structured Query Language) – Alias Syntax
You can rename a table or a column temporarily by giving another name known as Alias. The use of table aliases is to rename a table …
