Structured Query Language
SQL stands for Structured Query Language. SQL is a query language that provides us a way to insert, update, delete and retrieve data from a database.
SQL Introduction
By Ankit Kumar
● Published At Jan 2022
This article will discuss the introduction of the structured query language (SQL). We shall see various commands used in SQL and also how it is used.... Keep reading ..
Basic SQL
Basic SQL Commands helps in doing CRUD operations, doing aggregations, and formatting query results.
RDBMS Concepts
By Amisha Purswani
● Published At Dec 2021
This article will illustrate the basic concepts of RDBMS and commonly used terms in relational models with examples and explain the advantages and disadvantages of RDBMS.... Keep reading ..
SQL Syntax
By Anant Dhakad
● Published At Dec 2021
This blog will provide you with a quick introduction to SQL by listing all the essential SQL syntaxes.... Keep reading ..
Data Types in SQL
By Divyansh Jain
● Published At Jan 2022
In this brief article, we will learn how Data types contribute to a SQL Server, and how it is divided into sub categories.... Keep reading ..
Operators in SQL
By kashish saxena
● Published At Dec 2021
In this blog, we will learn about operators in SQL, their types, and how to implement them in SQL.... Keep reading ..
SQL Expressions
By Divyansh Jain
● Published At Jan 2022
In this brief article, we will dive deeper into SQL Expressions followed by how they add value to SQL queries to make complex calculations easy to do. ... Keep reading ..
CREATE, SELECT, and DROP Database
By Ankit Kumar
● Published At Dec 2021
The gist behind this article is to tell you more about the CREATE, SELECT, and DROP Database commands in my SQL, along with some essential questions. ... Keep reading ..
Create Table in SQL
By Shivani Kumari
● Published At Dec 2021
A table in a database collects related data organized in a table structure. In this article, you will learn to create a table in your database in SQL. ... Keep reading ..
DROP AND DELETE A TABLE IN SQL
By PRASHANT SINGH
● Published At Dec 2021
This blog is about Drop and Delete Table statements in SQL(Structured Query Language). Read this blog to know further about it.... Keep reading ..
INSERT Query
By Amisha Purswani
● Published At Dec 2021
In this blog, we’ll learn how to insert rows of data into a table in databases using SQL, we will also learn their syntax with various problems and examples.... Keep reading ..
SELECT Query
By Ankit Kumar
● Published At Dec 2021
This article will cover the concept of the SELECT statement in a structured query language (SQL). We will see numerous examples of SELECT queries. ... Keep reading ..
WHERE Clause in SQL
By Alisha Chhabra
● Published At Jan 2022
This article incorporates the usage of the Where Clause in SQL with required examples. ... Keep reading ..
AND & OR Clause
By Jainish Patel
● Published At Jan 2022
This article is about, AND clause & OR clause queries work in SQL using a demo database table.... Keep reading ..
Update and Delete Query
By Divyansh Jain
● Published At Jan 2022
We'll delve deeper into SQL Update and Delete Query in this brief article and see how they offer value to SQL queries by making complex updates simple.... Keep reading ..
LIKE Clause in SQL
By PRASHANT SINGH
● Published At Dec 2021
This blog is about the LIKE clause in SQL to check whether a character string matches a specified pattern.... Keep reading ..
TOP, LIMIT, or ROWNUM Clause
By Jainish Patel
● Published At Jan 2022
This article is about TOP, LIMIT, or ROWNUM Clause queries that apply to a database table to get the required data. ... Keep reading ..
ORDER BY Clause
By Amisha Purswani
● Published At Dec 2021
This blog will help you learn how to order records in a table from a database in a specific order like ascending or descending order. We will see different scenarios where ORDER By would be helpful in SQL (Structured Query Language). ... Keep reading ..
GROUP BY In SQL
By Ankit Kumar
● Published At Dec 2021
This article will revolve around the critical statement of SQL, i.e., GROUP BY, and we will see how to use this, along with some frequently asked questions on this.... Keep reading ..
Distinct Keyword in SQL
By Gorakhnath yadav
● Published At Dec 2021
In this blog, we will learn about the use and syntax of the distinct keyword in SQL. Read the blog to learn these concepts in detail.... Keep reading ..
Sort the result in SQL
By PRASHANT SINGH
● Published At Dec 2021
This blog is about sorting the results of tables in the database using the SQL(Structured Query Language) command. Read this blog to know further about it.... Keep reading ..
Advance SQL
Advanced SQL Commands are those which allow us to perform queries within queries, generate results by joining multiple tables, and perform operations that ensure atomicity.
Constraints
By Pakhi Garg
● Published At Jan 2022
This article will discuss constraints and types of constraints with examples in detail. ... Keep reading ..
Joins
By Jainish Patel
● Published At Jan 2022
This article is about, Types of joins in SQL and how they will apply to a database table. ... Keep reading ..
Joins-2
By Jainish Patel
● Published At Jan 2022
This article is about, Types of joins in SQL and how they will apply to a database table. ... Keep reading ..
Unions Clause
By Jainish Patel
● Published At Jan 2022
This article is about, Unions clause queries work in SQL using a demo database table. ... Keep reading ..
NULL Values
By Pakhi Garg
● Published At Jan 2022
This article will discuss what are NULL values in SQL along with examples.... Keep reading ..
Alias Syntax
By Pakhi Garg
● Published At Jan 2022
This article explains the use of aliases in SQL along with its syntax and examples. ... Keep reading ..
Indexes
By Jainish Patel
● Published At Jan 2022
In this article, we will discuss Indexes in SQL using a demo database table.... Keep reading ..
Alter Table Command
By Alisha Chhabra
● Published At Jan 2022
This blog covers the concepts of Alter Table command, a command used to add, delete or modify columns in an existing table. ... Keep reading ..
Truncate Table Command
By Pakhi Garg
● Published At Jan 2022
In this article, we will study Truncate Table Command and its examples in detail. ... Keep reading ..
Using Views
By Shivani Kumari
● Published At Jan 2022
In this article, you will learn about views SQL statements, how views are used to create virtual tables, and why views are needed.... Keep reading ..
Having Clause
By Jainish Patel
● Published At Jan 2022
This article is about Having clause query works in SQL using a demo database table.... Keep reading ..
Transactions
By Pakhi Garg
● Published At Feb 2022
This article discusses transactions and transaction control commands in SQL.... Keep reading ..
SQL Wildcard Operators
By PRASHANT SINGH
● Published At Dec 2021
This blog is about Wildcard operators in SQL, similar to the LIKE clause. It is used to check whether a character string matches a specified pattern.... Keep reading ..
Temporary Tables in SQL
By Gorakhnath yadav
● Published At Mar 2022
This blog will focus on introducing the temporary tables in SQL, creating them, and then how to delete them. ... Keep reading ..
Clone Table
By Ankit Kumar
● Published At Jan 2022
The gist behind this article is to tell you more about the Clone table commands in my SQL, along with some examples to understand the topic better.... Keep reading ..
Sub Queries
By Alisha Chhabra
● Published At Jan 2022
This article covers the concept of Sub Queries in DBMS followed by its use cases with several clauses. ... Keep reading ..
Using sequences
By Ankit Kumar
● Published At Feb 2022
This article will discuss sequences in MySQL and cover some of its relatable examples and some frequently asked questions.... Keep reading ..
Handling Duplicates
By Shivani Kumari
● Published At Jan 2022
 In this article, we will learn how to find, prevent and remove duplicates from databases and use different clauses for dealing with duplicates.... Keep reading ..
Injection
By Shivani Kumari
● Published At Jan 2022
In this article, we will learn about SQL injection attacks in databases, how they corrupt our database, and methods to avoid them. ... Keep reading ..
SQL Problems
By PRASHANT SINGH
● Published At Feb 2022
This blog introduces the Subqueries in SQL with their examples. This blog contains multiple examples to practice and understand SQL queries.... Keep reading ..
PL/SQL
In this category, we will be introducing the PLSQL, what it is? How to set up PLSQL in your system and get started with it and don't forget your first database in it. Starting with variables, conditional statements, iterative statements, continue, exit, go Label, stored procedures, and Cursors in PLSQL, we will be set wise taking individual time and looking up at these concepts and then working with some examples as well so that you all can get a good understanding of them in PLSQL. Later moving on, we will be going towards Functions in PLSQL and exception handling. After you guys have practiced enough, we will then be introducing you to triggers, package, and object-oriented concepts. Then we will be taking up some concepts like, DateTime, Transaction, Arrays Strings and Operators. We will also be giving examples and practice questions for you to learn and get hands-on on all these concepts and in the end be confident about PLSQL.
PL/SQL Introduction
By Sanjana Yadav
● Published At Jan 2022
In this post, we will cover the basic introduction of PL/SQL Language. We will learn about its features, how it is different from SQL, and its advantages over SQL. ... Keep reading ..
PL/SQL Environment Setup
By Shivani Kumari
● Published At Feb 2022
In this article, we will learn how to install Oracle database in our system and set up an Environment for PL/SQL. We will also see some useful resources to learn PL/SQL. ... Keep reading ..
PL/SQL Variables
By Sanjana Yadav
● Published At Mar 2022
In this post, we will learn about PL/SQL variables their naming rules, declaration, initialization with examples, and a hello world program in PL/SQL. ... Keep reading ..
PL/SQL Conditional statements
By Ankit Kumar
● Published At Jan 2022
This article will discuss the various conditional statements which are used in PL/SQL. We shall also see examples on each of them.... Keep reading ..
PL/SQL Iterative Statements
By Ankit Kumar
● Published At Jan 2022
This article will discuss the various iterative statements in PL/SQL viz. basic loop, for loop, while loop, and their examples. ... Keep reading ..
PL/SQL Conditional ( Continue, exit, goto)
By Ankit Kumar
● Published At Feb 2022
This article will discuss the various conditional statements in PL/SQL, like Continue, exit, goto, etc. We will also consult some FAQs related to the topic.... Keep reading ..
PL/SQL Procedures
By Shivani Kumari
● Published At Feb 2022
In this article, we will learn what PL/SQL procedures are and how and why we will use them. We will also learn about the advantages and disadvantages of using procedures.... Keep reading ..
PL/SQL Cursors
By Shivani Kumari
● Published At Feb 2022
In this article, we will learn about cursors and how to use them. We will also see different types of cursors used and their syntaxes.... Keep reading ..
PL/SQL Functions
By PRASHANT SINGH
● Published At Jan 2022
This blog introduces the concept of functions in PL/SQL, and covers how to declare, define or call the PL/SQL functions using different examples.... Keep reading ..
PL/SQL - Exception Handling
By Amisha Purswani
● Published At Feb 2022
We will learn about exception handling and its different types available in PL/SQL. Read the blog to learn more.... Keep reading ..
PL/SQL Triggers
By Alisha Chhabra
● Published At Feb 2022
This article incorporates Triggers in PL/SQL followed by the different examples in detail. ... Keep reading ..
PL/SQL Packages
By Alisha Chhabra
● Published At Mar 2022
This article discusses the Packages in PL/SQL with several examples in detail. ... Keep reading ..
PL/SQL Object Oriented
By Amisha Purswani
● Published At Feb 2022
This blog will learn about objects in PL/SQL and see various ways to manipulate the objects, like accessing, updating, and deleting objects.... Keep reading ..
PL/SQL Date and Time
By PRASHANT SINGH
● Published At Feb 2022
This blog introduces the concept of date and time in PL/SQL and covers the different types of Datetime and Interval data types with the functions used and their descriptions.... Keep reading ..
PL/SQL Transactions
By Pranay Chauhan
● Published At Mar 2022
A database or PL/SQL transaction is an atomic unit of work that may consist of one or more related SQL statements.... Keep reading ..
PL/SQL Arrays
By Alisha Chhabra
● Published At Feb 2022
This article incorporates a detailed discussion on PL/SQL arrays followed by the faqs. ... Keep reading ..
PL/SQL Strings
By Divyansh Jain
● Published At Feb 2022
In this article, we will learn in detail about PL/SQL strings and will discuss string functions and operators in-depth with suitable examples.... Keep reading ..
PL/SQL - Operators
By Amisha Purswani
● Published At Jan 2022
This blog will learn about what operators are and see various examples of arithmetic, relational, logical, and comparison operators.... Keep reading ..