In this article, we will discuss some of the most important SQL queries – Insert, Select, Update, Delete. Insert, Update, and delete are the data manipulation query, and Select is the data query language....
In this tutorial, we will discover the string functions in SQL. The string is a collection of characters put to use for storing multiple characters. Most of the data present around us is a...
In this tutorial we will look at the method we require to read and understand a Syntax Diagram in SQL. What are Syntax Diagrams in SQL? When we write any logical implementation there is...
In this tutorial, we will discuss the past and present versions of SQL.Let’s start!!! What is SQL and its Origin? SQL, or what we know as Structured Query Language, is the most popular language...
In this tutorial, we will understand what SQL and PL/SQL are and the use cases of each of them. We aim to understand the situations when we should put which one to use. We...
In this tutorial, we will see about the SQL Profiler. We will start from the basic definitions and then move on to the internal working and functionalities of the Profiler. Let us now try...
In this tutorial, we will look at the Packages which can be made in PL/SQL. We will be learning various reasons and the methods one can use to create the packages that are put...
In this SQL Quiz, we will try to test our knowledge of the SQL Concepts. In this Quiz, we have covered questions from almost all topics of SQL. Do not miss to attempt other...
In this tutorial, we will understand the SQL Clauses and learn about them in detail. In the previous articles, we have understood in detail specifically about some of the clauses. Here, we aim to...
In this tutorial, we will look at embedded SQL. When we talk about embedded SQL, it can be understood as small SQL queries put into high-level languages to get meaningful outputs. While embedding SQL...
