AAshifur Rahaman·Nov 27, 2025SQL Server Data Integrity & ConstraintsData Integrity ensures that the data in your database is accurate, consistent, and adheres to business rules. Constraints are the database objects that enforce these rules at the lowest level, preventing invalid data entry regardless of the applicati...5 min read·sqlinsights.hashnode.dev
GGanesh Rama Hegde·Oct 28, 2025Chapter 6 - Coding the first Use case (Data layer)We coded the domain layer classes in the earlier chapter. Now we need to write the classes of data layer so that the use case becomes more meaningful in nature. The GetArtUseCase will fetch the list of Art objects from the local Room database. This i...6 min read·androidavatar.hashnode.dev
KKrishal Karna·Aug 14, 2025Introduction to Databases and MySQLUnderstand essential database concepts including Data, DBMS, software, Primary Key, and other fundamentals. Perfect for beginners, students, and for all8 min read·completesql.hashnode.dev
YYash Sakhareliya·Jul 15, 2025Understanding SQL Table Relationships And KeysLearn SQL table relationships: primary and foreign keys, One-to-One, One-to-Many, Many-to-One, and Many-to-Many with examples3 min read·learn-pgsql.hashnode.dev
JJayRam Nai·May 11, 2025Fixing Non-Incrementing Primary Key in PostgreSQLFacing a duplicate key error in PostgreSQL? Learn why auto-increment (SERIAL) primary keys stop working and how to fix sequence issues using simple command.1 min read·jramnai.hashnode.dev
GGanesh Rama Hegde·Apr 5, 20252. Tables, Entities, and RDBMSIn a database design design we are discuss these three important topics - Tables, Entities and RDBMS. You may ask why ? Aren’t you digressing from the topic ? I would like to say that we would be using these concepts as the building blocks of our des...4 min read·vedicschema.hashnode.dev
GGanesh Rama Hegde·Apr 5, 20251. Databases, Database Design and SQLIn today’s modern digital world dominated by Artificial Intelligence and Machine Learning, data is the new fuel. Data is at the core of every application - from fitness apps, healthcare and e-commerce to banking and social media. We use databases to ...3 min read·vedicschema.hashnode.dev
GGanesh Rama Hegde·Apr 5, 20253. SQL (Structured Query Language) - Part 1What is SQL ? SQL (Structured Query Language) is the standard language used to create, read, update, and delete data in a relational database. Why is SQL important ? It allows us to communicate with the database and manage data effectively. Types of ...4 min read·vedicschema.hashnode.dev
UUtkarsh·Sep 23, 2024UUID or Auto Increment Integer: Best Primary Key for your DBExploring the advantages and trade-offs between UUIDs and auto-increment integers as primary keys in database design.7 min read·blogs.utkarshrajput.com
RRicardo Ribeiro·Jun 5, 2024Coletando ids do banco de dados (.NET x SQL SERVER)Criando um método que facilite o manejo das chaves do banco dentro do Visual Studio2 min read·kaitozr.hashnode.dev