Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com

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.
SQL CAST() Function MEDIUM
In SQL, the cast function is used for converting a value of one data type to another.
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.
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.
SQL Syntax
This blog will provide you with a quick introduction to SQL by listing all the essential SQL syntaxes.
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.
Unique Key in SQL EASY
In this blog, we will learn about unique key in SQL. We will understand its core concepts, its usage, and much more for better understanding.
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.
Grant Command in SQL EASY
In this blog, we will learn about Grant Command in SQL. We will learn about its characteristics, features, and much more for better understanding.
SQL Cross Join EASY
In this blog, we will learn SQL Cross Join. We will learn about why it is used, syntax, parameters, and examples.
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.
Operators in SQL
In this blog, we will learn about operators in SQL, their types, and how to implement them in SQL.
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.
Charindex SQL EASY
The CHARINDEX function is crucial in SQL Server for searching a specific substring within a given string, starting from a designated position.
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.
Difference between Grant and Revoke EASY
This article discusses differences between grant and revoke with syntax and examples. Also, see the frequently asked questions.
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.
Data Dictionary in DBMS EASY
A data dictionary is a group of names, attributes, and definitions of data elements being used in a database.
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.
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.
INSERT Query
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.
Inner Join EASY
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.
Bulk Insert in SQL EASY
This blog will discuss Bulk Insert in SQL with its syntax, parameters, and return type, along with some examples with suitable code explanations.
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.
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.
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.
How to Find Duplicate Records in SQL EASY
To Find the Duplicate Values in SQL, first, let us create a sample table of a company containing duplicate records.
Delete Duplicate Records in SQL EASY
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.
Difference between VARCHAR and NVARCHAR EASY
In this article, we will discuss the difference between VARCHAR and NVARCHAR along with their examples.
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.
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.
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.
Difference between DDL and DML in SQL EASY
Difference between DDL and DML: DDL deals with the structure of a database, defining schema elements. DML focuses on data manipulation, handling queries, insertions, updates, and deletions within the database.
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.
AND & OR Clause MEDIUM
In this article, we will analyze how to use the AND cluse & OR clauses in sql commands of DBMS query.
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.
LIKE Clause in SQL
This blog is about the LIKE clause in SQL to check whether a character string matches a specified pattern.
Difference between DROP and TRUNCATE in SQL EASY
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.
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.
ORDER BY Clause
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).
GROUP BY In SQL
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.
Distinct Keyword 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.
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.
DESC Command in SQL MEDIUM
DESC command is in the "ORDER BY" clause to sort the result of queries in descending order. In this blog, we will learn about the DESC command in SQL.
SQL Functions EASY
In this article, we will discuss about the SQL Functions, their types, and a detailed description of each of these functions.
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.
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.
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.
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.
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
What are the DCL Commands in SQL? MEDIUM
This article gives a detailed overview of the dcl commands in sql, followed by their types and 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.
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.
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.
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.
SQL Drop Column EASY
In this blog, we will learn about SQL drop column. We will learn its syntax and also discuss some examples to understand it better.
Set Operators in SQL EASY
In this article, you will learn about the syntax and practical applications of various set operators that are present in SQL.
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.
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.

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.
SQL NOT NULL EASY
In this article, we will discuss the not null method Sql in detail.
Joins
This article is about, Types of joins in SQL and how they will apply to a database table.
SQL Aliases EASY
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.
Decode in SQL MEDIUM
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.
Exploring the SQL Cartesian Join EASY
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.
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
In this blog, we will learn about surrogate key in SQL. We will also create a table using Surrogate Key in SQL.
Joins-2
This article is about, Types of joins in SQL and how they will apply to a database table.
Natural Join in SQL EASY
In this blog, we will explore natural join. We will understand natural join by performing queries on multiple tables.
Self Join in SQL EASY
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.
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
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.
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.
LIMIT in SQL EASY
In this blog, we will learn about limit in SQL. We will also go through queries for better understanding.
SQL Outer Join EASY
JOIN in DBMS is an operation that connects two or more database tables based on matching columns. It establishes a relationship between the tables.
LPAD in SQL EASY
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.
is SQL Case Sensitive EASY
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.
Unions Clause
This article is about, Unions clause queries work in SQL using a demo database table.
NULL Values
This article will discuss what are NULL values in SQL along with examples.
Trunc Function in SQL EASY
In this blog, we will learn about Trunc Function in SQL. We will write its syntax, implementation and code for better understanding.
What is SQL ENUM EASY
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.
SQL NULLIF 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.
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.
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.
Indexes
In this article, we will discuss Indexes in SQL using a demo database table.
SQL EXCEPT EASY
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.
Alter Table Command
This blog covers the concepts of Alter Table command, a command used to add, delete or modify columns in an existing table.
Author Alisha
0 upvotes
ALTER vs UPDATE Command EASY
This article will discuss ALTER vs UPDATE command. We will learn the primary difference between these commands with syntax and examples.
Truncate Table Command
In this article, we will study Truncate Table Command and its examples in detail.
Difference between RANK and DENSE_RANK EASY
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 .
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.
Transactions
This article discusses transactions and transaction control commands in SQL.
SQL Wildcard Operators
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.
Date functions in SQL
This article will discuss the various Date functions in SQL with their implementation.
Temporary Tables in SQL EASY
This blog will focus on introducing the temporary tables in SQL, creating them, and then how to delete them.
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.
Sub Queries
This article covers the concept of Sub Queries in DBMS followed by its use cases with several clauses.
Author Alisha
0 upvotes
Using sequences
This article will discuss sequences in MySQL and cover some of its relatable examples and some frequently asked questions.
Handling Duplicates
 In this article, we will learn how to find, prevent and remove duplicates from databases and use different clauses for dealing with duplicates.
Injection
In this article, we will learn about SQL injection attacks in databases, how they corrupt our database, and methods to avoid them.
COALESCE() Function in SQL MEDIUM
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!
SQL Problems
This blog introduces the Subqueries in SQL with their examples. This blog contains multiple examples to practice and understand SQL queries.
MOD() function in SQL EASY
The MOD() function in SQL returns the remainder of a division operation. Useful for tasks involving cyclic operations or data partitioning. Enhance precision and efficiency in your database queries.
Author Sajid
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.
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.
SQL Triggers MEDIUM
In this article, we will learn about the triggers in SQL along with syntax, advantages, and disadvantages.

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.
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.
PL/SQL Variables
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.
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
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)
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.
PL/SQL Procedures
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.
PL/SQL Cursors
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.
PL/SQL Functions
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.
PL/SQL - Exception Handling
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
SQL Triggers are stored programs/procedures, which are automatically executed or fired when some events occur.
PL/SQL Packages
This article discusses the Packages in PL/SQL with several examples in detail.
Author Alisha
0 upvotes
PL/SQL Object Oriented
This blog will learn about objects in PL/SQL and see various ways to manipulate the objects, like accessing, updating, and deleting objects.
PL/SQL Date and Time
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.
PL/SQL Transactions
A database or PL/SQL transaction is an atomic unit of work that may consist of one or more related SQL statements.
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.
PL/SQL - Operators
This blog will learn about what operators are and see various examples of arithmetic, relational, logical, and comparison operators.