--- title: "#databasemanagement articles | Hashnode" description: "Explore 161 articles tagged #databasemanagement on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/databasemanagement" --- Tag # #databasemanagement 161 posts · 72 followers [Database Insights](https://hashnode.com/@databaseinsights) · [Jul 31](https://hashnode.com/posts/automating-the-mundane-5-database-tasks-every-growing-it-team-should-stop-doing-manually/6a6ce4f71201e0039d710995) ### [Automating the Mundane: 5 Database Tasks Every Growing IT Team Should Stop Doing Manually](https://databaseinsights.hashnode.dev/automating-the-mundane-5-database-tasks-every-growing-it-team-should-stop-doing-manually?utm_source=hashnode&utm_medium=feed) Discover five database tasks IT teams should automate to reduce risk, save time, and help DBAs focus on higher-value work. 7 min read · [databaseinsights.hashnode.dev](https://databaseinsights.hashnode.dev/automating-the-mundane-5-database-tasks-every-growing-it-team-should-stop-doing-manually?utm_source=hashnode&utm_medium=feed) [Sandeep Choudhary](https://hashnode.com/@sandeepc) · [Jun 28](https://hashnode.com/posts/database-sharding-strategies-for-horizontal-data-partitioning/6a40d5437b2e284b58210554) ### [Database Sharding - Strategies for Horizontal Data Partitioning](https://sandeepc.hashnode.dev/database-sharding-strategies-for-horizontal-data-partitioning?utm_source=hashnode&utm_medium=feed) Explore effective database sharding strategies to achieve horizontal data partitioning, enhance scalability, and improve performance for large-scale applications. 8 min read · [sandeepc.hashnode.dev](https://sandeepc.hashnode.dev/database-sharding-strategies-for-horizontal-data-partitioning?utm_source=hashnode&utm_medium=feed) [Sandeep Choudhary](https://hashnode.com/@sandeepc) · [Apr 29](https://hashnode.com/posts/sql-vs-nosql-a-framework-for-choosing-the-right-database/69f1a24dad6e531c726d4cb4) ### [SQL vs NoSQL: A framework for choosing the right database](https://sandeepc.hashnode.dev/sql-vs-nosql-a-framework-for-choosing-the-right-database?utm_source=hashnode&utm_medium=feed) Unsure whether to pick SQL or NoSQL for your next project? This guide provides a clear framework to help you choose the right database. 6 min read · [sandeepc.hashnode.dev](https://sandeepc.hashnode.dev/sql-vs-nosql-a-framework-for-choosing-the-right-database?utm_source=hashnode&utm_medium=feed) [Prajwal M](https://hashnode.com/@Glitchguy00) · [Apr 25](https://hashnode.com/posts/foreign-keys-views-and-the-real-problem-database-boundaries/69ec675a5a627d8e521f02c7) ### [Foreign Keys, Views, and the Real Problem: Database Boundaries](https://glitch-guy0.hashnode.dev/foreign-keys-views-and-the-real-problem-database-boundaries?utm_source=hashnode&utm_medium=feed) Why this blog exists This blog is not theory — it’s a reflection of how my understanding evolved while dealing with a real system. I started with frustration: Foreign keys made migrations painful Vie 4 min read · [glitch-guy0.hashnode.dev](https://glitch-guy0.hashnode.dev/foreign-keys-views-and-the-real-problem-database-boundaries?utm_source=hashnode&utm_medium=feed) [Kanchan Nath](https://hashnode.com/@kanchan-nath) · [Mar 15](https://hashnode.com/posts/relational-databases/69b69be1f4eb2f8b04665e06) ### [Relational Databases](https://kanchannath.hashnode.dev/relational-databases?utm_source=hashnode&utm_medium=feed) Relational Databases 3 min read · [kanchannath.hashnode.dev](https://kanchannath.hashnode.dev/relational-databases?utm_source=hashnode&utm_medium=feed) [Payal Porwal](https://hashnode.com/@PayalPorwal) · [Feb 25](https://hashnode.com/posts/day-36-money-tracker-filtering-sorting-pagination-validation-frontend/699eeb7307208e46d793c33e) ### [Day 36 – Money Tracker (Filtering, Sorting, Pagination, Validation, Frontend)](https://codeswithpayal.hashnode.dev/day-36-money-tracker-filtering-sorting-pagination-validation-frontend?utm_source=hashnode&utm_medium=feed) Build a Scalable Money Tracker: UI + Node/MySQL for Filtering, Sorting & Pagination 6 min read · [codeswithpayal.hashnode.dev](https://codeswithpayal.hashnode.dev/day-36-money-tracker-filtering-sorting-pagination-validation-frontend?utm_source=hashnode&utm_medium=feed) [Payal Porwal](https://hashnode.com/@PayalPorwal) · [Feb 24](https://hashnode.com/posts/master-the-top-sql-queries-clear-explanations-practical-examples/699dac5276cf0888f4aef4d4) ### [Master the Top SQL Queries: Clear Explanations + Practical Examples](https://codeswithpayal.hashnode.dev/master-the-top-sql-queries-clear-explanations-practical-examples?utm_source=hashnode&utm_medium=feed) 1️⃣ SELECT (Basic Data Fetching) 🔹 What it does: Fetch data from a table. 🔹 Syntax: SELECT column1, column2 FROM table\_name; 🔹 Example: SELECT name, salary FROM employees; 🔹 Use Case: Showing u 5 min read · [codeswithpayal.hashnode.dev](https://codeswithpayal.hashnode.dev/master-the-top-sql-queries-clear-explanations-practical-examples?utm_source=hashnode&utm_medium=feed) [Payal Porwal](https://hashnode.com/@PayalPorwal) · [Feb 24](https://hashnode.com/posts/day-35-complete-crud-with-mysql-node-js-express/699daa4324b09570d2fecf93) ### [Day 35 – Complete CRUD with MySQL (Node.js + Express)](https://codeswithpayal.hashnode.dev/day-35-complete-crud-with-mysql-node-js-express?utm_source=hashnode&utm_medium=feed) Mini Project Start: 💰 Money Tracker Day 35 Goal By the end of Day 35, students will be able to: ✅ Perform complete CRUD with MySQL✅ Create Update & Delete APIs✅ Handle errors properly (best practice 6 min read · [codeswithpayal.hashnode.dev](https://codeswithpayal.hashnode.dev/day-35-complete-crud-with-mysql-node-js-express?utm_source=hashnode&utm_medium=feed) [GetPochi](https://hashnode.com/@getpochi) · [Feb 24](https://hashnode.com/posts/a-safe-way-to-let-coding-agents-interact-with-your-database-without-prod-write-access/699d3669cf5def0f6ad47a5e) ### [A safe way to let coding agents interact with your database (without prod write access)](https://getpochi.hashnode.dev/a-safe-way-to-let-coding-agents-interact-with-your-database-without-prod-write-access?utm_source=hashnode&utm_medium=feed) This tutorial demonstrates how to grant database access in Pochi without exposing production credentials or enabling uncontrolled writes. 15 min read · [getpochi.hashnode.dev](https://getpochi.hashnode.dev/a-safe-way-to-let-coding-agents-interact-with-your-database-without-prod-write-access?utm_source=hashnode&utm_medium=feed) [Payal Porwal](https://hashnode.com/@PayalPorwal) · [Feb 17](https://hashnode.com/posts/day-33-sql-queries-and-real-crud-using-phpmyadmin/699461a62a831e6596f6403d) ### [Day 33 – SQL Queries & Real CRUD Using phpMyAdmin](https://codeswithpayal.hashnode.dev/day-33-sql-queries-and-real-crud-using-phpmyadmin?utm_source=hashnode&utm_medium=feed) Learn SQL basics and CRUD operations with phpMyAdmin, and prepare to connect MySQL with Node.js. Master essential database skills today 4 min read · [codeswithpayal.hashnode.dev](https://codeswithpayal.hashnode.dev/day-33-sql-queries-and-real-crud-using-phpmyadmin?utm_source=hashnode&utm_medium=feed)