Home > Blog > Database

Articles (211)

Difference between INNER JOIN and OUTER JOIN in SQL Blog
Article
Difference between INNER JOIN and OUTER JOIN in SQ...
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
feature 34
Article
DateTime format to SQL format using C#
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
Feature 15
Article
Count(*) vs Count(1) in SQL Server
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
Convert timestamps with offset to datetime obj using strptime Category Image
Article
Convert timestamps with offset to datetime obj usi...
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
concat functions in sql server blog
Article
CONCAT() Function in SQL Server
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
Can We Pass Parameters to a View in SQL Category Image
Article
Can We Pass Parameters to a View in SQL?
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
How to Use BEFORE INSERT TRIGGER Category
Article
How to Use BEFORE INSERT TRIGGER with MAX(ID) for ...
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
Are PostgreSQL Column Names case sensitive blog
Article
Are PostgreSQL Column Names case-sensitive?
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
Alternative to STRING AGG in SQL category Image
Article
Alternative to STRING_AGG in SQL
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
CAP theorem blog image
Article
CAP Theorem: Explained
By Yash Vardhan Gupta
Updated on: Jan 28, 2026
How to UPDATE with JOIN in SQL Server Blog
Article
How to UPDATE with JOIN in SQL Server?
By Yash Vardhan Gupta
Updated on: Jul 20, 2025
What is an Entity in DBMS Small
Article
What is an Entity in DBMS?
By Yash Vardhan Gupta
Updated on: Jul 19, 2025
What is Micrsoft AccessSmall
Article
What is Microsoft Access?
By Yash Vardhan Gupta
Updated on: Jul 18, 2025
1
Article
Difference Between OLAP and OLTP
By Yash Vardhan Gupta
Updated on: Jul 18, 2025
ER Diagram in DBMS2
Article
ER Diagram in DBMS
By Yash Vardhan Gupta
Updated on: Jul 18, 2025

Tutorials (5)

Interview Questions (13)

Webinars (0)