Structured Query Language

Difference between join and subquery MEDIUM

4 upvotes

Sql Join is a mechanism used to combine data from two or more tables based on a related column or set of columns, whereas subqueries are used to retrieve data based on the results of another query.

Author Sinki Kumari

0 upvotes

PIVOT and UNPIVOT in SQL MEDIUM

This article covers the concept of PIVOT and UNPIVOT operators in SQL.

Author 3053_Jatin

0 upvotes

Basic SQL

Basic SQL Commands helps in doing CRUD operations, doing aggregations, and formatting query results.

Basic SQL Commands and Queries EASY

This article demonstrates SQL Commands and the list of database queries & statements.

Author Aditya kumar

3 upvotes

SQL CAST() Function MEDIUM

In SQL, the cast function is used for converting a value of one data type to another.

Author shruti_f97c

0 upvotes

Difference between Primary Key and Foreign Key MEDIUM

In this article, you will get a brief introduction to the primary and foreign keys, their syntax and implementation, and the difference between primary and foreign keys.

Author Sinki Kumari

0 upvotes

Difference between Unique and Primary Key EASY

In this article, we will discuss the difference between a Unique Key and a Primary Key. We will also learn about their properties.

Author AkshatAggarwal

1 upvote

SQL Syntax

This blog will provide you with a quick introduction to SQL by listing all the essential SQL syntaxes.

Author Anant Dhakad

1 upvote

SQL Query Execution Order MEDIUM

SQL query execution order means optimizing search results from the database or where the query clauses are checked according to the need/requirement.

Author yuvatimankar

0 upvotes

Data Types in SQL

In this brief article, we will learn how Data types contribute to a SQL Server, and how it is divided into sub categories.

In this blog, we will learn SQL Cross Join. We will learn about why it is used, syntax, parameters, and examples.

1 upvote

SQL Cross Join EASY

Author Rahul Singh

0 upvotes

Difference between CHAR and VARCHAR EASY

CHAR and VARCHAR are SQL data types used for storing character strings. CHAR has a fixed length, while VARCHAR has a variable length. Understanding the difference between CHAR and VARCHAR is crucial for efficient database design.

Author Rishabhnsingh

0 upvotes

Operators in SQL

In this blog, we will learn about operators in SQL, their types, and how to implement them in SQL.

Author Kashish Saxena

1 upvote

SQL Expressions

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.

The CHARINDEX function is crucial in SQL Server for searching a specific substring within a given string, starting from a designated position.

1 upvote

Charindex SQL EASY

Author Rinki Deka

0 upvotes

Delete Query in SQL EASY

In this blog, we will learn about Delete Query in SQL. We will understand its core concepts, its usage, and much more for better understanding.

Author Pallavi singh

0 upvotes

Equi Join in SQL EASY

In this article, we'll talk about EQUI JOIN and its various components in detail, like its syntax, examples, and how it differs from other types of JOINs.

Author Sanjana kumari

0 upvotes

Difference between Grant and Revoke EASY

This article discusses differences between grant and revoke with syntax and examples. Also, see the frequently asked questions.

Author Akanksha Burnwal

0 upvotes

CREATE, SELECT, and DROP Database EASY

This blog will discuss the topic CREATE, SELECT and DROP Database in detail, including the definition of the database and many more.

Author Sagar Mishra

1 upvote

Data Dictionary in DBMS EASY

A data dictionary is a group of names, attributes, and definitions of data elements being used in a database.

Author Ravi Khorwal

0 upvotes

Difference Between Table and View EASY

This article explains the table, view, and the difference between a table and a view in a relational database.

Author Pallavi singh

0 upvotes

DROP AND DELETE A TABLE IN SQL

This blog is about Drop and Delete Table statements in SQL(Structured Query Language). Read this blog to know further about it.

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.

1 upvote

INSERT Query

In this blog, we will learn about Inner Join. We will understand its core concepts, syntax, and learn about parameters and much more for better understanding.

1 upvote

Inner Join EASY

Author Riya Singh

0 upvotes

Multivalued Dependency EASY

In this blog, we will learn about Multivalued Dependency. We will understand its core concepts, its usage, advantages, and much more for better understanding.

Author Ravi Khorwal

0 upvotes

SQL Insert Multiple Rows EASY

In this article, you will learn about the insert command, different ways to perform SQL insert multiple rows, and the benefits of SQL insert multiple rows.

Author Muskan Sharma

0 upvotes

SELECT Query

This article will cover the concept of the SELECT statement in a structured query language (SQL). We will see numerous examples of SELECT queries.

Delete Duplicate Records in SQL EASY

0 upvotes

In this article, you will learn to what are the different ways to delete duplicate records in SQL, like using distinct keywords and many more.

Author Muskan Sharma

0 upvotes

SQL Server DATEADD() Function EASY

This blog will discuss SQL Server DATEADD() function with information about its parameters and return type along with some examples with code implementations.

Author Aayush Sharma

0 upvotes

DATEDIFF() in SQL Server EASY

This blog will discuss DATEDIFF() in SQL Server with information about its parameters and return type along with some examples and their code explanations.

Author Aayush Sharma

0 upvotes

SQL Right Join EASY

In this blog, we will learn about sql right join. We will understand its core concepts,and learn about its advantages, disadvantages and much more for better understanding.

Author Rinki Deka

0 upvotes

Difference Between Where and Having Clause in SQL EASY

The Difference between Where and Having Clause is WHERE and HAVING clauses in SQL are both used to filter rows in a query, but they operate at different stages of query processing and are used for different purposes.

Author Shivani Singh

0 upvotes

AND & OR Clause MEDIUM

In this article, we will analyze how to use the AND cluse & OR clauses in sql commands of DBMS query.

Author Rasha Abdul Khader

0 upvotes

Update and Delete Query

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.

This blog is about the LIKE clause in SQL to check whether a character string matches a specified pattern.

0 upvotes

LIKE Clause in SQL

Difference between DROP and TRUNCATE in SQL EASY

2 upvotes

This article covers the differences between DROP and TRUNCATE commands in SQL. We will also see how to implement SQL's DROP and TRUNCATE commands.

Author Nidhi Kumari

0 upvotes

TOP, LIMIT, or ROWNUM Clause

This article is about TOP, LIMIT, or ROWNUM Clause queries that apply to a database table to get the required data.

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).

0 upvotes

ORDER BY Clause

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.

1 upvote

GROUP BY In SQL

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.

1 upvote

Distinct Keyword in SQL

Author Gorakhnath yadav

1 upvote

Sort the result in SQL

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.

In this article, we will discuss about the SQL Functions, their types, and a detailed description of each of these functions.

0 upvotes

SQL Functions EASY

Author Yukti Kumari

1 upvote

RANK() Function in SQL Server EASY

This blog will discuss the basics of the rank function in SQL along with its types which are RANK(), ROW_NUMBER(), DENSE_RANK(), and NTILE function.

Author Shivani Singh

0 upvotes

What is the Difference Between Unique and Distinct EASY

This article covers the differences between unique and distinct keywords in SQL, along with some frequently asked questions.

Author Abhiyodaya Pandey

0 upvotes

Which SQL Keyword is used to Retrieve a Maximum Value? MEDIUM

In this article, you will grasp the idea of which SQL keyword is used to retrieve a maximum value or the largest value of a table.

Author Nidhi Kumari

1 upvote

DUAL Table in SQL EASY

DUAL is a one-row, one-column built-in table in Oracle Database. It is used to hold the results of a SELECT statement that are otherwise not stored or used.

Author Komal

1 upvote

TCL Commands in SQL EASY

In this blog, we will discuss the Transactions and the Transaction Control Language. We will also look into various types of TCL Commands in SQL and their examples.

Author Komal

0 upvotes

CRUD Operations in SQL EASY

In this blog, we will discuss about CRUD(Create, Read, Update, and Delete) Operations in SQL. We discuss them with the help of examples.

Author mishrashriCodes

0 upvotes

How to Use Regex in SQL MEDIUM

This article will teach us how to use Regex in SQL. We will learn its advantages, use cases, application architecture, etc.

Author juhipathak

0 upvotes

Cartesian Join in SQL EASY

With this article, learn about Cartesian Join in SQL, its syntax, practical examples with code and output, best practices, etc.

Author sanchit0160

0 upvotes

SQL ALTER TABLE Statement EASY

This article discusses the alter command in sql along with examples. It also explains the use case of alter command in sql.

Set Operators in SQL EASY

1 upvote

In this article, you will learn about the syntax and practical applications of various set operators that are present in SQL.

Author Vasu Bansal

0 upvotes

How to Rename Column Name in SQL? EASY

This article will discuss how to rename a column name in SQL, along with the help of appropriate code syntaxes and examples.

Author Ravi Khorwal

0 upvotes

How to Change Column Name in SQL? EASY

We will learn about SQL and how to change column names in SQL with various examples for better understanding.

Author RAGHAV ANUSHA

0 upvotes

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 MEDIUM

This article will discuss constraints and types of constraints with examples in detail.

In this article, we will discuss the not null method Sql in detail.

0 upvotes

SQL NOT NULL EASY

Author siddharth sharma

0 upvotes

Joins

This article is about, Types of joins in SQL and how they will apply to a database table.

SQL aliases are temporary names assigned to database tables or columns to simplify query construction. This blog will discuss the topic of Try Catch in Javascript, including the definition, syntax, flow chart, and sample examples.

0 upvotes

SQL Aliases EASY

DECODE() function is often used to perform conditional logic within queries. It replaces values based on specified conditions. Read on to learn more about Decode function.

0 upvotes

Decode in SQL MEDIUM

Exploring the SQL Cartesian Join EASY

0 upvotes

This article will discuss Cartesian Product in SQL, how to implement a Cartesian product in SQL, and use cases and limitations of Cartesian products in SQL.

Author Vidhi Sareen

0 upvotes

DATEPART in SQL MEDIUM

In this blog, we will learn about datepart in SQL. We will also write queries for a better understanding of the topics.

SURROGATE Key in SQL EASY

0 upvotes

In this blog, we will learn about surrogate key in SQL. We will also create a table using Surrogate Key in SQL.

This article is about, Types of joins in SQL and how they will apply to a database table.

0 upvotes

Joins-2

Self join in SQL is a type of inner join. It is a special type of join that is used to combine the table with itself.

0 upvotes

Self Join in SQL EASY

Author mishrashriCodes

0 upvotes

NOT IN Operator in the SQL Query EASY

In this blog, we will understand NOT IN Operator in the SQL Query . We will also work on a few queries for a better understanding of the topic.

Difference between Inner join and Outer join in SQL

0 upvotes

This article will cover the inner join and outer join briefly and the difference between inner join and outer join based on various parameters.

Author Shiva

0 upvotes

Equi Join and Non-Equi Join in SQL MEDIUM

This article will discuss Equi Join and Non-Equi Join in SQL, their syntax and examples.

Author Pallavi singh

0 upvotes

Difference Between Equi Join and Natural Join EASY

This blog will discuss the difference between equi join and natural join in detail, including the definition, syntax, and example.

Author Gaurav Gandhi

0 upvotes

LIMIT in SQL EASY

In this blog, we will learn about limit in SQL. We will also go through queries for better understanding.

In this blog, we will learn about LPAD in SQL. We will understand why and how to use the LPAD function in SQL. We will also write queries for better understanding.

0 upvotes

LPAD in SQL EASY

is SQL Case Sensitive EASY

0 upvotes

In this blog, we will understand whether SQL is a case-sensitive language or not. We will also work on a few queries for a better understanding of the topic.

This article is about, Unions clause queries work in SQL using a demo database table.

0 upvotes

Unions Clause

This article will discuss what are NULL values in SQL along with examples.

0 upvotes

NULL Values

Trunc Function in SQL EASY

0 upvotes

In this blog, we will learn about Trunc Function in SQL. We will write its syntax, implementation and code for better understanding.

In this blog, we will learn about SQL enum. We will further explore the use, syntax, and implementation of SQL enum. We will also perform queries for better understanding.

0 upvotes

What is SQL ENUM EASY

In this blog, we will learn about the SQL NULLIF function. We will also learn about its syntax and discuss some examples for better understanding.

0 upvotes

SQL NULLIF EASY

Author kanishk11

0 upvotes

MySQL ISNULL EASY

This article covers the concept of ISNULL Function in MySQL with different examples and queries along with some alternatives of this Function.

Author Priyanshu Grover

0 upvotes

ROW_NUMBER Function in SQL EASY

The ROW_NUMBER function in SQL assigns a unique sequential integer to each row within a specified partition, aiding in result set organization and analysis for effective data retrieval.

In this article, we will discuss Indexes in SQL using a demo database table.

0 upvotes

Indexes

In this blog, we will discuss about sql except. We will also learn how to use sql except and learn sql except through performing query.

0 upvotes

SQL EXCEPT EASY

This blog covers the concepts of Alter Table command, a command used to add, delete or modify columns in an existing table.

0 upvotes

Alter Table Command

ALTER vs UPDATE Command EASY

0 upvotes

This article will discuss ALTER vs UPDATE command. We will learn the primary difference between these commands with syntax and examples.

Author sanchit0160

0 upvotes

Truncate Table Command

In this article, we will study Truncate Table Command and its examples in detail.

Difference between RANK and DENSE_RANK EASY

0 upvotes

We will discuss what are RANK and DENSE_RANK Functions in SQL. And also, what is the key difference between the RANK and DENSE_RANK Functions in SQL .

Author Nikunj Goel

0 upvotes

Using Views

In this article, you will learn about views SQL statements, how views are used to create virtual tables, and why views are needed.

This article discusses transactions and transaction control commands in SQL.

1 upvote

Transactions

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.

0 upvotes

SQL Wildcard Operators

This article will discuss the various Date functions in SQL with their implementation.

1 upvote

Date functions in SQL

Author apoorv007

0 upvotes

Clone Table

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.

This article covers the concept of Sub Queries in DBMS followed by its use cases with several clauses.

1 upvote

Sub Queries

This article will discuss sequences in MySQL and cover some of its relatable examples and some frequently asked questions.

0 upvotes

Using sequences

In this article, we will learn how to find, prevent and remove duplicates from databases and use different clauses for dealing with duplicates.

1 upvote

Handling Duplicates

In this article, we will learn about SQL injection attacks in databases, how they corrupt our database, and methods to avoid them.

1 upvote

Injection

COALESCE() Function in SQL MEDIUM

1 upvote

COALESCE() is a SQL function used to return the first non-null value from a list of expressions. It helps manage NULL values efficiently. Read on to learn more!

Author Ashish Sharma

0 upvotes

SQL Problems

This blog introduces the Subqueries in SQL with their examples. This blog contains multiple examples to practice and understand SQL queries.

Difference Between Function and Procedure MEDIUM

1 upvote

In this article, we will discuss about functions and procedures in SQL, and we will see their implementation and their differences.

Author Akshay Parashar

0 upvotes

Difference Between Function and Procedure MEDIUM

In this article, we will discuss about functions and procedures in SQL, and we will see their implementation and their differences.

Author simransri

1 upvote

SQL Triggers MEDIUM

In this article, we will learn about the triggers in SQL along with syntax, advantages, and disadvantages.

Author Nilesh Kumar

0 upvotes

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

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.

Author Sanjana Yadav

0 upvotes

PL/SQL Environment Setup

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.

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.

1 upvote

PL/SQL Variables

Author Sanjana Yadav

0 upvotes

PL/SQL Conditional statements

This article will discuss the various conditional statements which are used in PL/SQL. We shall also see examples on each of them.

PL/SQL Iterative Statements

1 upvote

This article will discuss the various iterative statements in PL/SQL viz. basic loop, for loop, while loop, and their examples.

PL/SQL Conditional ( Continue, exit, goto)

1 upvote

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.

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.

1 upvote

PL/SQL Procedures

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.

2 upvotes

PL/SQL Cursors

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.

1 upvote

PL/SQL Functions

PL/SQL - Exception Handling

1 upvote

We will learn about exception handling and its different types available in PL/SQL. Read the blog to learn more.

Triggers in SQL Server MEDIUM

1 upvote

SQL Triggers are stored programs/procedures, which are automatically executed or fired when some events occur.

This article discusses the Packages in PL/SQL with several examples in detail.

1 upvote

PL/SQL Packages

This blog will learn about objects in PL/SQL and see various ways to manipulate the objects, like accessing, updating, and deleting objects.

0 upvotes

PL/SQL Object Oriented

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.

1 upvote

PL/SQL Date and Time

A database or PL/SQL transaction is an atomic unit of work that may consist of one or more related SQL statements.

2 upvotes

PL/SQL Transactions

Author Pranay Chauhan

0 upvotes

PL/SQL Strings

In this article, we will learn in detail about PL/SQL strings and will discuss string functions and operators in-depth with suitable examples.

This blog will learn about what operators are and see various examples of arithmetic, relational, logical, and comparison operators.

0 upvotes

PL/SQL - Operators