SQL Joins: Inner, Left, Right and Full
Relational database management systems have multiple tables interrelated to each other. Joins in SQL are used to retrieve data from various tables based on the multiple data manipulation operations. This...
Author: Sahiti Kappagantula
Bio: I have around 3+ years of experience, I am a Product enthusiast, with immense interest in Marketing. I enjoy building products from scratch and finally delivering them to the consumers by implementing product & growth strategies.
Posts by sahiti:
SQL Set Operators
LAST UPDATED: May 31, 2022, 11:40 IST
Manipulation of data often requires various operations to be done. One of the most popular operations is the Set Operation. This article will give you a detailed walkthrough of all...
Triggers in SQL
LAST UPDATED: April 29, 2022, 13:59 IST
Triggers in SQL are small procedural codes that create an impact on the database performance by executing in response to an event. In this article, on Triggers in SQL, I...
Cursors in SQL: Definition, Types and Lifecycle
LAST UPDATED: April 29, 2022, 13:12 IST
With large amounts of data stored in databases, it is of utmost importance for the users to travel through the databases. Cursors as the name suggest pinpointing the data to...
Using SQL Pivot – SQL Tutorial
LAST UPDATED: April 29, 2022, 13:00 IST
Often while handling databases, there comes a requirement to change the row-level data to columnar data. SQL Pivot is a simple function used to do the same. In this article,...
Types of Keys in Database
LAST UPDATED: July 25, 2023, 19:16 IST
In databases, keys are fundamental in maintaining data integrity and organization. They serve as unique identifiers and establish relationships between tables, enabling efficient data retrieval and manipulation. This introduction will...
SQL Functions: Aggregate and Scalar
LAST UPDATED: August 8, 2022, 11:59 IST
Introduction In this article, we will discuss SQL Functions: Aggregate and Scalar. In our ongoing series on Structured Query Language, you must have understood what SQL is and how it...
How to Create, Update, Insert and Delete SQL Views?
LAST UPDATED: July 18, 2022, 18:04 IST
Databases often have multiple tables interrelated to each other. But if a user wants to view data from multiple tables, then it gets complicated. To resolve the same, SQL Views...
Difference between SQL and NoSQL
LAST UPDATED: May 3, 2022, 10:25 IST
Databases are big containers where you can store your data. There are various types of databases used to store data in today's market. SQL and NoSQL are two popular databases...
Filtering Data with SQL
LAST UPDATED: March 29, 2022, 12:47 IST
Table of Contents Basic Filtering Data with SQLAdvanced Filtering of DataFiltering using Wildcards In this article, I am going to consider the following table to explain to you how to...