sql

How To Use Sequelize with Node.js and SQL

In this blog post, we’ll guide you through the process of building a blog application using Node.js, SQLite, and Sequelize. We’ll cover setting up the server, defining API endpoints for blog posts, and implementing step-by-step …

How To Use SQLite with Node.js

Using SQLite in Node.js with Real-World Examples SQLite is a popular open-source, serverless, and self-contained SQL database engine that is used in a wide range of applications, including mobile apps, desktop software, and web…

Mastering Advanced Features of DbContext in Entity Framework

Mastering Advanced Features of DbContext in Entity Framework Entity Framework’s DbContext serves as a bridge between your application and the database. While it provides the basic CRUD operations, there are several advanced fe…

Convert column to row without using unpivot operator

In this post, I will show you how to convert column to row in SQL. For this post, I am going to use the following table which has three column stu_name,sibject and marks SELECT stu_name , MAX ( CASE WHEN subjec…

Load More
That is All