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