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

Last updated: Jan 24, 2022

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.

Author Pakhi Garg

0 upvotes

SQL NOT NULL EASY

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

Author siddharth sharma

0 upvotes

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

Author Jainish Patel

0 upvotes

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.

Author Gunjan Batra

0 upvotes

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.

Author Gunjan Batra

0 upvotes

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.

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.

Author Gunjan Batra

0 upvotes

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.

Author Gunjan Batra

0 upvotes

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

Author Jainish Patel

0 upvotes

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.

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.

Author Gunjan Batra

0 upvotes

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.

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.

Author Gunjan Batra

0 upvotes

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.

Author Gunjan Batra

0 upvotes

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.

Author Gunjan Batra

0 upvotes

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

Author Jainish Patel

0 upvotes

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

Author Pakhi Garg

0 upvotes

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.

Author Gunjan Batra

0 upvotes

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.

Author Gunjan Batra

0 upvotes

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.

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.

Author Gunjan Batra

0 upvotes

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

Author Jainish Patel

0 upvotes

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.

Author Gunjan Batra

0 upvotes

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.

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.

Author sanchit0160

0 upvotes

Truncate Table Command

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

Author Pakhi Garg

0 upvotes

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 .

Author Nikunj Goel

0 upvotes

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

Author Shivani Kumari

1 upvote

This article discusses transactions and transaction control commands in SQL.

Author Pakhi Garg

0 upvotes

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.

Author PRASHANT SINGH

1 upvote

Date functions in SQL

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

Author apoorv007

0 upvotes

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.

Author Ankit Kumar

1 upvote

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

0 upvotes

Using sequences

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

Author Ankit Kumar

1 upvote

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.

Author Shivani Kumari

1 upvote

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

Author Shivani Kumari

1 upvote

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!

Author Ashish Sharma

0 upvotes

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

Author PRASHANT SINGH

1 upvote

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