Home > Blog > Database

Articles (132)

How to Return Pivot Table Output in MySQL
Article
How to Return Pivot Table Output in MySQL?
By Sahil Ambardar
Updated on: Apr 08, 2025
Crosstab Query in PostgreSQL Feature Image
Article
Crosstab() Query in PostgreSQL
By Sahil Ambardar
Updated on: Apr 09, 2025
Crosstab Query in PostgreSQL Feature Image
Article
LATERAL JOIN vs Subqueries in PostgreSQL 
By Sahil Ambardar
Updated on: Apr 08, 2025
Are PostgreSQL Column Names case sensitive blog
Article
Are PostgreSQL Column Names case-sensitive?
By Sahil Ambardar
Updated on: Mar 29, 2025
Explicit Join vs Implicit Join in SQL Category Image
Article
Explicit Join vs Implicit Join in SQL
By Sahil Ambardar
Updated on: Apr 01, 2025
Why is SELECT Considered Harmful in SQL blog
Article
Why is SELECT * Considered Harmful in SQL?
By Sahil Ambardar
Updated on: Mar 28, 2025
How to Parameterize an SQL Server IN Clause Category Image
Article
How to Parameterize an SQL Server IN Clause?
By Sahil Ambardar
Updated on: Mar 28, 2025
How to Use STRING AGG to Concatenate Strings in SQL Server blog
Article
How to Use STRING_AGG() to Concatenate Strings in ...
By Sahil Ambardar
Updated on: Mar 27, 2025
concat functions in sql server blog
Article
CONCAT() Function in SQL Server
By Sahil Ambardar
Updated on: Mar 27, 2025
FOR XML PATH clause in SQL Server blog
Article
FOR XML PATH clause in SQL Server 
By Sahil Ambardar
Updated on: Mar 27, 2025
SQL Server STUFF Function blog
Article
SQL Server STUFF() Function
By Sahil Ambardar
Updated on: Mar 27, 2025
How to use Python variables in SQL statement Category Image
Article
How to use Python variables in SQL statement
By Sahil Ambardar
Updated on: Mar 27, 2025
How to Select the Top Row of Each Group in SQL Category Image
Article
How to Select the Top Row of Each Group in SQL?
By Sahil Ambardar
Updated on: Apr 09, 2025
Feature 14
Article
How to Concatenate Multiple Rows into One Field in...
By Sahil Ambardar
Updated on: Mar 26, 2025
Dynamic Table Name as a Variable in SQL Server Category Image
Article
Dynamic Table Name as a Variable in SQL Server
By Sahil Ambardar
Updated on: Mar 25, 2025

Tutorials (5)

SQL Server Tutorial
Tutorial
SQL Server Tutorial – Learn SQL Server from ...
By Sahil Ambardar
Updated on: Jan 06, 2025
MySQL Tutorial
Tutorial
MySQL Tutorial – Learn MySQL from Scratch
By Sahil Ambardar
Updated on: Nov 21, 2024
SQL Programming
Tutorial
SQL Tutorial
By Sahil Ambardar
Updated on: Apr 09, 2025
Oracle DBA
Tutorial
Oracle DBA Tutorial – Learn Oracle DBA from Expe...
By Sahil Ambardar
Updated on: Feb 28, 2025
PL SQL
Tutorial
PL/SQL Tutorial – A Step-by-Step Guide for B...
By Sahil Ambardar
Updated on: Mar 05, 2025

Interview Questions (10)

SQL Query Interview Questions
Interview Question
SQL Query Interview Questions and Answers
By Sahil Ambardar
Updated on: Mar 31, 2025
DBMS Interview Questions
Interview Question
DBMS Interview Questions
By Sahil Ambardar
Updated on: Feb 21, 2025
PostgreSQL Interview Questions
Interview Question
PostgreSQL Interview Questions and Answers
By Varun Gupta
Updated on: Feb 11, 2025
SQL Server
Interview Question
SQL Server Interview Questions and Answers
By Sahil Ambardar
Updated on: Feb 04, 2025
NoSQL
Interview Question
NoSQL Interview Questions and Answers
By Sahil Ambardar
Updated on: Feb 12, 2025
MySQL
Interview Question
MySQL Interview Questions
By Sahil Ambardar
Updated on: Apr 02, 2025
DB2
Interview Question
DB2 Interview Questions and Answers
By Sahil Ambardar
Updated on: Mar 05, 2025
PL SQL
Interview Question
PL/SQL Interview Questions and Answers
By Akshay Shukla
Updated on: Feb 07, 2025
Oracle DBA
Interview Question
Oracle DBA Interview Questions and Answers
By Akshay Shukla
Updated on: Feb 10, 2025
SQL
Interview Question
SQL Interview Questions
By Kishore Kumar
Updated on: Apr 08, 2025

Webinars (0)