Skip to content

Tag Archives: SQL-basics

Like in other programming languages, SQL also has certain datatypes available. A brief idea of all the datatypes are discussed below.   1. Binary Datatypes… Read More
An index is a schema object. It is used by the server to speed up the retrieval of rows by using a pointer. It can… Read More
In this article, we’ll be discussing Data Definition Language, Data Manipulation Language, Transaction Control Language, and Data Control Language.     DDL (Data Definition Language) :… Read More
Sequence is a set of integers 1, 2, 3, … that are generated and supported by some database systems to produce unique values on demand.… Read More
What are Transactions? Transactions group a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all… Read More
The SQL WITH clause was introduced by Oracle in the Oracle 9i release 2 database. The SQL WITH clause allows you to give a sub-query… Read More
Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database.… Read More
As is any programming languages comments matter a lot in SQL also. In this set we will learn about writing comments in any SQL snippet. Comments… Read More
Constraints are the rules that we can apply on the type of data in a table. That is, we can specify the limit on the… Read More
Structured Query Language is a standard Database language which is used to create, maintain and retrieve the relational database. Following are some interesting facts about… Read More

Start Your Coding Journey Now!