Home > Blog > Database

Articles (211)

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
blog 39
Article
What is DBMS? (Database Management System)
By Yash Vardhan Gupta
Updated on: Jan 16, 2026
TRUNCATE TABLE in SQL Category Image
Article
TRUNCATE TABLE in SQL
By Yash Vardhan Gupta
Updated on: Dec 18, 2025
Sql nolock blog
Article
SQL NOLOCK: Working, Risks, and Safer Alternatives
By Garima Hansa
Updated on: Dec 16, 2025
SQL Logical Operators Blog
Article
Logical Operators in SQL 
By Yash Vardhan Gupta
Updated on: Dec 15, 2025
SQL regex blog
Article
SQL Regular Expression 
By Yash Vardhan Gupta
Updated on: Dec 15, 2025
what is file organization in dbms blog image 1
Article
File Organization in DBMS
By Yash Vardhan Gupta
Updated on: Dec 15, 2025
Attributes in DBMS blog
Article
Attributes in DBMS 
By Yash Vardhan Gupta
Updated on: Dec 08, 2025

Tutorials (5)

Interview Questions (13)

Webinars (0)