Amuthasathya Rajendiranmysqlbasics.hashnode.dev·Jan 2, 2025Data Base Management SystemsData Base Management System is a software that is used to store and fetch information stored in the database. DBMS allows us to perform various operations on the data like creation, reading, updating, deletion etc. DBMS can also be used by the user t...MySQL BasicsDatabases
Amuthasathya Rajendiranmysqlbasics.hashnode.dev·Jan 1, 2025What is a database?A database is an organized collection of data. It is organized in such a way that the data can be easily managed and accessed. Data can be organized in the form of tables, with rows and columns. Indices can be used to make the retrieval of data easie...MySQL BasicsSQL
Amuthasathya Rajendiranmysqlbasics.hashnode.dev·Dec 31, 2024MySQL and SQL - What is the difference?Structured Query Language or SQL is the language used when we talk to databases. Queries are the commands that interact with the database. MySQL vs SQL MySQL is a database management system, unlike SQL which is a language. There are different databas...MySQL BasicsSQL
Zephaniahzephaniah.hashnode.dev·Dec 30, 2024Welcome to the Database Party! - An Introduction to the world of databases.Have you ever scrolled through Netflix, overwhelmed by choices, wishing there was a way to find the perfect movie instantly? Imagine that struggle on a much bigger scale. That's the daily life of businesses without databases! In this first episode of...1 likeDatabases
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...80 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...26 readsSQL
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