Tag Archives: SQL

10 Best SQL Books You Need to Read in 2022

Structured Query Language (SQL) is the standard query language for relational databases. Developed by Donald D. Chamberlin and Raymond F. Boyce at IBM, SQL is used to access, retrieve, manipulate, and manage records in relational databases. With databases being the backbone of many businesses and companies, learning SQL will help you pursue a successful career. Through this article,… Read More »

10 Most Valuable SQL Server Certifications in 2021

SQL stands for Structured Query Language, which is pronounced “S-Q-L” or “See-Quel” in some cases. The SQL language is the industry standard for working with relational databases. Inserting, searching, updating, and deleting database records are all possible with SQL. A Microsoft SQL server can do a variety of different tasks, including database optimization and maintenance. The following is… Read More »

SQL Transaction

If there is a group of SQL commands performed on a database to manipulate the stored data, then all those commands can be treated as a single unit called a transaction. In simple word, we can say that a transaction is a group of SQL queries, and transaction handles all those queries as a single unit. SQL Transaction… Read More »

SQL SEQUENCES

In SQL a Sequence is defined as a Database object which is generally used to generate an integer sequence. In Database tables, Sequences often used to populate the numeric primary key column. However, this can also be done using the AUTO_INCREMENT constraint, but Sequences give more flexibility, and here we can define the integer sequence in a different… Read More »

SQL Sub Queries

In SQL if we write a query inside another query, then it would be considered as a nested, inner query, and subquery. Generally, these subqueries applied using the SQL WHERE clause. SQL Sub Queries Subqueries are basically used to set a condition expression, that’s why the subquery executes before the main query. The data sets returned by the… Read More »

SQL Temporary Tables

Some Relational Database Management Systems(RDBMS), support temporary tables. A Temporary Table is similar to the normal tables present in the Database, like the normal table the temporary table support all the SQL commands, the only difference is the temporary table get deleted as soon as the session of the user or table gets ended. SQL Temporary Tables Temporary… Read More »

SQL Having Clause

Like the WHERE clause HAVING clause is used to put a condition on a statement, in SQL we can not use the WHERE statement with aggregated statements such as GROUP BY, so there we use the HAVING clause to set a condition. SQL Having Clause In sort HAVING is a replace of WHERE clause for the GROUP BY… Read More »