Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Last updated: Jan 24, 2022

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
This article will discuss SQL Query Execution Order with a detailed explanation.
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.
DDL (Data Definition Language) Commands EASY
In this article, we will learn about the Data Definition Language or DDL Commands. We will go through each of these commands and see their examples.
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
In this blog, we will discuss the data control language commands followed by the difference between Grant and Revoke.
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
This blog discusses the topic of the Data Dictionary, including the definition, sample example, types, needs, pros and cons.
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
In this blog, we will discuss WHERE and HAVING clauses. Then we will see the difference between WHERE and HAVING clause in SQL
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.
Difference between Relational Algebra and Relational Calculus
This article explores the differences between relational algebra and relational calculus in database management systems.
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.
SQL Minus EASY
The article will discuss the SQL minus set operator and its commands with different expressions in detail with examples.
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.