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.

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

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.

Author Divyansh Jain

1 upvote

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.

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.

Author Divyansh Jain

1 upvote

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.

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.

Author PRASHANT SINGH

1 upvote

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.

Author Purswani Dineshkumar

1 upvote

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.

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

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

Author Ankit Kumar

0 upvotes

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.

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

Author kanishk11

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.

Author Divyansh Jain

0 upvotes

LIKE Clause in SQL

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

Author PRASHANT SINGH

2 upvotes

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.

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.

Author Jainish Patel

0 upvotes

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

Author Purswani Dineshkumar

1 upvote

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.

Author Ankit Kumar

1 upvote

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.

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.

Author PRASHANT SINGH

0 upvotes

SQL Functions EASY

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

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.

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.

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.

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.

1 upvote

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.

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