Parth Guptatechnical-philosphy.hashnode.dev·Dec 20, 2024Database System Concepts and ArchitecturePre-requisite To understand the content of this blog, it's important to have a basic understanding of a database management system (DBMS). You can study that from here. Contents of this blog A basic client/server DBMS Architecture Data Models, Sche...60 readsDBMS
Akshay Anilkumarakshaystechjournal.hashnode.dev·Dec 18, 2024Mastering Database Management Systems (DBMS)In the world of technology, managing and organizing data efficiently is crucial. Database Management Systems (DBMS) are the backbone of modern applications, allowing seamless data storage, retrieval, and manipulation. In this blog, we’ll explore the ...DBMS
Data & Devrvats20.hashnode.dev·Dec 16, 202418 Useful Applications of SQL: A Comprehensive Exploration of Database Management and Analysis## Introduction Structured Query Language (SQL) is a powerful tool that extends far beyond simple data retrieval. Its versatility makes it an essential technology across numerous domains, from business intelligence to scientific research. This compre...SQL seriesSQL
Data & Devrvats20.hashnode.dev·Dec 11, 2024Mastering Oracle Database: A Comprehensive GuideOracle SQL is a powerful, declarative language used for managing relational databases in Oracle databases (e.g., Oracle 11g, 12c). It provides a wide range of features for querying, manipulating, and analyzing data. With its robust capabilities, Orac...SQL
Samana Butool Mirzafrom-procrastination-to-progress.hashnode.dev·Dec 11, 2024Navigating Databases: From SQL to NoSQLHey Folks! In the world of development, understanding which database system to use for a project can make a huge difference in performance, scalability, and flexibility. As a developer who’s worked extensively with both SQL Server and MongoDB, I’ve e...SQL
Data & Devrvats20.hashnode.dev·Dec 9, 2024Mastering Database Performance: 10 Key Query Optimization TechniquesOptimizing query performance is a crucial aspect of database design and maintenance. Here are ten effective techniques to improve query performance, along with explanations, use cases, and code samples. 1. Indexing Indexing allows the database system...SQL seriesSQL
Data & Devrvats20.hashnode.dev·Dec 3, 2024Mastering PostgreSQL: From Basics to Advanced TopicsOverview PostgreSQL is a powerful open-source relational database management system (RDBMS) that provides features like advanced query capabilities, transactional support, and efficient storage. It is widely used in enterprise-level applications for ...SQL seriesPostgreSQL
Suriyasuriyaofficial.hashnode.dev·Dec 1, 2024Postgres Vs MySQLBelow these are some commands to start server and login to terminal client in macOS and DDLs OperationPostgreSQL CommandMySQL Equivalent Start the serverpt_ctl -D /path/to/data startsudo /usr/local/mysql/support-files/mysql.server start Stop ...Database SystemsPostgreSQL
Nitish singhsinghnitish.hashnode.dev·Nov 19, 2024Understanding Database Management SystemsHey everyone, Welcome back to another Article. Today, we are going through the definition of a Database Management System (DBMS), its types, features, and real-life applications. A Database Management System is a software tool that helps users to m...DBMS
Ankur sainiankur0213.hashnode.dev·Nov 17, 2024SQL Unleashed: Mastering Data with Precision and PowerThis sounds odd when i say that i am a Backend Developer with no knowledge of SQL database. But it true when i start learning MERN tech stack i had learn MongoDB for tech stack and have to start working on MongoDB. Which follow NoSQL architecture. Bu...#slq
